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@bluetooth.com>
Sent: 27/08/05 07:03:02
To: "pgsql-odbc@postgresql.org"<pgsql-odbc@postgresql.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.



Thanks a lot. This driver will be a life-saver!



Austin Foxley

Developer

Bluetooth SIG, Inc.




---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match