From: | Jasen Betts <jasen(at)xnet(dot)co(dot)nz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Do we want SYNONYMS? |
Date: | 2010-12-13 10:03:07 |
Message-ID: | ie4r0r$scs$7@reversiblemaps.ath.cx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 2010-12-07, Andy Colson <andy(at)squeakycode(dot)net> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jasen Betts | 2010-12-13 10:14:59 | Re: encode(bytea_value, 'escape') in PostgreSQL 9.0 |
Previous Message | hubert depesz lubaczewski | 2010-12-13 10:01:02 | Re: Urgent -- High memory usage on PostgreSQL server |