On 2010-12-07, Andy Colson <andy@xxxxxxxxxxxxxxx> wrote: > I think it covers parts. In both you can create an alias to a table, > both of which you can fire off insert/update/delete. I assume in PG you > could have different permissions for the table and the alias, which I > assume you can do in oracle. > > If we pretend oracle and PG both have the same thing as a schema, and > using PG's definition of schema: > > I assume in oracle you can "create table synonym schemaA.bob for > schemaB.tablex" > > And I assume you could do the same in PG. > > However beyond that, I dont know what oracle supports that we'd need. They want synonyms for functions, but as far as I can see the same can be achieved with minimal extra work by creating a new LANGUAGE SQL function that calls the original. CREATE FUNCTION newschema.newname( atype ... ) RETURNS rtype AS ' select oldschema.oldname ( $1 ... ) ' LANGUAGE SQL; with apropriare values for the lowercase bits and elipsis. -- ââ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
