| From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
|---|---|
| To: | "Bazil Roshan" <bazil_f(at)persistent(dot)co(dot)in>, <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Re: QUERY : RE: Four art Names |
| Date: | 2005-10-07 12:37:42 |
| Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E4CC326C@ratbert.vale-housing.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
________________________________
From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Bazil Roshan
Sent: 07 October 2005 13:10
To: pgsql-odbc(at)postgresql(dot)org
Subject: [ODBC] QUERY : RE: Four art Names
Please Dave can you provide more inputs on why 4 part names
cannot be supported on PGSQL.
Because a four pat name is formed from
<DatabaseName>.<CatalogName>.<SchemaName>.<TableName>
and as PostgreSQL doesn't have any concept of catalogs, your can't give
them a name (because apps that autogenerate queries might try to use
it). According to the Microsoft docs though, you can use
<DatabaseName>..<SchemaName>.<TableName>
(note the double dot). If any of their products don't like that though
you'll need to take it up with them.
Regards Dave
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Herbert | 2005-10-07 13:48:40 | Re: CVS Moved |
| Previous Message | Bazil Roshan | 2005-10-07 12:10:27 | QUERY : RE: Four art Names |