On Wednesday 04 March 2009 16:34:54 Joshua Tolley wrote: > Way back in this thread[1] one of the arguments against allowing > some version of CREATE SYNONYM was that we couldn't create a synonym for > an object in a remote database. Will the SQL/MED work make this sort of > thing a possibility?
The idea is that SQL/MED will create objects known as foreign tables that represent remote resources but work locally like a normal table. So in some sense, SQL/MED already creates a local synonym-type thing for remote resources anyway, so there is no need to create a separate synonym in the Oracle sense on top of that. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers