| From: | Rod Taylor <rbt(at)zort(dot)ca> |
|---|---|
| To: | Marc Lavergne <mlavergne-pub(at)richlava(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: CREATE SYNONYM suggestions |
| Date: | 2002-07-24 11:23:36 |
| Message-ID: | 1027509818.50045.4.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, 2002-07-24 at 02:22, Marc Lavergne wrote:
> I have a need for relation synonyms in PostgreSQL. I don't see it in
> 7.2.1 but the catalog seems to be able to support it more or less.
>
> Here's what I intend to do:
>
> 1) Create a duplicate record in pg_class for the base table information
> but with the relname set to the synonym name.
This will eventually cause a problem when the file oid changes and the
old one gets removed. Cluster is one of those commands that will do
that.
Other than that, any table changes won't be propagated -- but you
already mentioned that.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2002-07-24 14:49:20 | Re: partial index on system indexes? |
| Previous Message | Darko Prenosil | 2002-07-24 10:43:27 | Re: [GENERAL] Access Two Databases |