Re: [HACKERS] CREATE SYNONYM suggestions

2002-07-24 Thread Marc Lavergne
I thought that it might involve more than met the eye. I'm resisting the "view" approach since, like my bad kludge, it locks down the table definition and as a result doesn't provide a very effective synonym mechanism. I'm looking into the commands/view.c as a basis for introducing the concep

Re: [HACKERS] CREATE SYNONYM suggestions

2002-07-24 Thread Tom Lane
Marc Lavergne <[EMAIL PROTECTED]> writes: > 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 wi

Re: [HACKERS] CREATE SYNONYM suggestions

2002-07-24 Thread Rod Taylor
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 informati

[HACKERS] CREATE SYNONYM suggestions

2002-07-23 Thread Marc Lavergne
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. 2) Duplicat