Re: [GENERAL] Search Path vs Synonyms

2009-07-24 Thread Matthew Seaborn
: Matthew Seaborn Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Search Path vs Synonyms On Fri, Jul 24, 2009 at 09:38, Matthew Seaborn wrote: > Ah, I am actually using EnterpriseDB (a commercial 'fork' of PSQL) which does > have synonyms. For support on EnterpriseDB yo

Re: [GENERAL] Search Path vs Synonyms

2009-07-24 Thread Magnus Hagander
On Fri, Jul 24, 2009 at 09:38, Matthew Seaborn wrote: > Ah, I am actually using EnterpriseDB (a commercial 'fork' of PSQL) which does > have synonyms. For support on EnterpriseDB you should contact EnterpriseDB, not the PostgreSQL community. We can only answer about the opensource product. > Is

Re: [GENERAL] Search Path vs Synonyms

2009-07-24 Thread John R Pierce
Matthew Seaborn wrote: Ah, I am actually using EnterpriseDB (a commercial 'fork' of PSQL) which does have synonyms. then you likely will get more help from EnterpriseDB's technical support, as only they are really familiar with their proprietary and commercial product. -- Sent via pg

Re: [GENERAL] Search Path vs Synonyms

2009-07-24 Thread Matthew Seaborn
orn; pgsql-general@postgresql.org Subject: RE: [GENERAL] Search Path vs Synonyms Matthew Seaborn wrote: > Given the situation where a user connecting to the database > needs access to two separate schemas: the primary schema > which contains the data they will be updating and a second >

Re: [GENERAL] Search Path vs Synonyms

2009-07-23 Thread Albe Laurenz
Matthew Seaborn wrote: > Given the situation where a user connecting to the database > needs access to two separate schemas: the primary schema > which contains the data they will be updating and a second > schema which contains read-only reference data, used by many > users, that will be using