Re: [HACKERS] Proposal: IMPORT FOREIGN SCHEMA statement.

2014-02-21 Thread Ronan Dunklau
> Who says that the OIDs are the same on the local and the remove postgres > instance? For user-defined types, that's certainly not going to be true... That's why the the result is casted as regtype[], and parsed as such. The oid is not transmitted over the wire, but set by regtype_in. > > Al

Re: [HACKERS] Proposal: IMPORT FOREIGN SCHEMA statement.

2014-02-21 Thread Florian Pflug
On Feb21, 2014, at 12:09 , Ronan Dunklau wrote: >> I havent had a look at the patch yet since I dont have a nice editor right >> now, but how do you handle inter operability between datatypes? >> Specifically, how do you handle those datatypes which have a different name >> from the PostgreSQL nam

Re: [HACKERS] Proposal: IMPORT FOREIGN SCHEMA statement.

2014-02-21 Thread Atri Sharma
On Fri, Feb 21, 2014 at 4:56 PM, Ronan Dunklau wrote: > Le vendredi 21 février 2014 16:45:20 Atri Sharma a écrit : > > On Fri, Feb 21, 2014 at 4:39 PM, Ronan Dunklau > wrote: > > > > I havent had a look at the patch yet since I dont have a nice editor > > > > > > right > > > > > > > now, but how d

Re: [HACKERS] Proposal: IMPORT FOREIGN SCHEMA statement.

2014-02-21 Thread Ronan Dunklau
Le vendredi 21 février 2014 16:45:20 Atri Sharma a écrit : > On Fri, Feb 21, 2014 at 4:39 PM, Ronan Dunklau wrote: > > > I havent had a look at the patch yet since I dont have a nice editor > > > > right > > > > > now, but how do you handle inter operability between datatypes? > > > Specifically

Re: [HACKERS] Proposal: IMPORT FOREIGN SCHEMA statement.

2014-02-21 Thread Atri Sharma
On Fri, Feb 21, 2014 at 4:39 PM, Ronan Dunklau wrote: > > I havent had a look at the patch yet since I dont have a nice editor > right > > now, but how do you handle inter operability between datatypes? > > Specifically, how do you handle those datatypes which have a different > name > > from the

Re: [HACKERS] Proposal: IMPORT FOREIGN SCHEMA statement.

2014-02-21 Thread Ronan Dunklau
> I havent had a look at the patch yet since I dont have a nice editor right > now, but how do you handle inter operability between datatypes? > Specifically, how do you handle those datatypes which have a different name > from the PostgreSQL name for them and/or are stored in a different manner?

Re: [HACKERS] Proposal: IMPORT FOREIGN SCHEMA statement.

2014-02-21 Thread Atri Sharma
On Fri, Feb 21, 2014 at 4:01 PM, Ronan Dunklau wrote: > Hello, > > The SQL-MED specification defines the IMPORT FOREIGN SCHEMA statement. > > This adds discoverability to foreign servers. The structure of the > statement > as I understand it is simple enough: > > IMPORT FOREIGN SCHEMA remote_schem

[HACKERS] Proposal: IMPORT FOREIGN SCHEMA statement.

2014-02-21 Thread Ronan Dunklau
Hello, The SQL-MED specification defines the IMPORT FOREIGN SCHEMA statement. This adds discoverability to foreign servers. The structure of the statement as I understand it is simple enough: IMPORT FOREIGN SCHEMA remote_schema FROM SERVER some_server [ (LIMIT TO | EXCEPT) table_list ] INTO loca