Re: IMPORT FOREIGN SCHEMA statement - Mailing list pgsql-hackers

From Tom Lane
Subject Re: IMPORT FOREIGN SCHEMA statement
Date
Msg-id 13743.1404949020@sss.pgh.pa.us
Whole thread Raw
In response to Re: IMPORT FOREIGN SCHEMA statement  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Another thing ...

The SQL-MED standard says that "IMPORT FOREIGN SCHEMA ... LIMIT TO (a,b,c)"
should throw an error if not all of a,b,c exist as tables in the remote
server.  It's rather sloppily worded, though, such that it's not clear
whether an error is also expected for "EXCEPT (a,b,c)" when not all of
those names exist.  It seems to me that the whole thing is badly thought
out and it would be better not to complain for nonexistent names in either
type of list.  The use of "LIMIT" seems to me to imply that the list is
a filter, not an exact set of names that must be present.

Comments?
        regards, tom lane



pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Minmax indexes
Next
From: Peter Geoghegan
Date:
Subject: Re: things I learned from working on memory allocation