relation_expr vs. qualified_name

Started by Christopher Kings-Lynnealmost 22 years ago2 messages
#1Christopher Kings-Lynne
chriskl@familyhealth.com.au

How come half the ALTER TABLE statements use relation_expr and half use
qualified_name?

Is one more correct now?

Chris

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Christopher Kings-Lynne (#1)
Re: relation_expr vs. qualified_name

Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:

How come half the ALTER TABLE statements use relation_expr and half use
qualified_name?

relation_expr allows specification of "foo *" and "ONLY foo", and is
appropriate for ALTER commands that can recurse to child tables.
qualified_name is appropriate for the ones that are inherently
nonrecursive.

I'm entirely prepared to believe that some of them are misclassified in
the grammar ... you see any problems?

regards, tom lane