Обсуждение: QUERY : RE: Four art Names

Поиск
Список
Период
Сортировка

QUERY : RE: Four art Names

От
"Bazil Roshan"
Дата:

Please Dave can you provide more inputs on why 4 part names cannot be supported on PGSQL.

 

--Rosh

 

 

---- Message from Dave

The fix was to stop the driver incorrectly reporting we support 4 part names, which we definitely do not, and most likely never will (because of the way a single backend connects to a single database).
 
Regards, Dave
 
-----Original Message-----
From: "Austin Foxley"<afoxley ( at ) bluetooth ( dot ) com>
Sent: 27/08/05 07:03:02
To: "pgsql-odbc ( at ) postgresql ( dot ) org"<pgsql-odbc ( at ) postgresql ( dot ) org>
Subject: [ODBC] Four part names
 
I've noticed that the current release of the driver doesn't support four
part names. According to some earlier postings earlier this month, it
sounds like Dave might have fixed this, but there has been no release
since his commit. 
 
 
 
Can someone confirm whether this indeed has been fixed as I can't get
the current CVS to work.
 
 
 
I've been able to use MSSQL to create a linked server through this
driver, and have been able to do simple selects with OPENQUERY, but to
really make this usable, four part name support would be really nice.

 

Re: QUERY : RE: Four art Names

От
"Dave Page"
Дата:
 

From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Bazil Roshan
Sent: 07 October 2005 13:10
To: pgsql-odbc@postgresql.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

Re: QUERY : RE: Four art Names

От
"Dave Page"
Дата:
Please use the mailing lists and not private email.

> -----Original Message-----
> From: Prasad [mailto:prasad@ownmail.com]
> Sent: 10 October 2005 13:38
> To: Dave Page
> Subject: Re: [ODBC] QUERY : RE: Four art Names
>
> Hi Dave,
>
> Thank you for the reply.
>
> As I understand from your reply, Catalog name in the query
> will result in an error from Posgres server.
>
> 1. So is it possible to modify the ODBC driver code so that
> when a request comes, the catalog name is discarded and the
> request modified so that the server is able to service it.

Not without re-implementing the PostgreSQL parser in the driver and then
modifying it do do what is required. And that's not gonna happen just to
work around a Microsoft bug.

> 2. If the answer to above is in the affirmative, would you
> please provide pointers for the same.
>
> 3. Can the OLE DB driver be modified in any way so that Four
> Part naming will work?

Probably not for the same reasons but you will need to ask someone who
knows about the oledb driver that question.

Regards, Dave