Does TZConnection respect the schema settings of PostgreSQL?

The official tester's forum for ZeosLib 7.1. Ask for help, post proposals or solutions.
vfclists
Fresh Boarder
Fresh Boarder
Posts: 15
Joined: 30.10.2007, 00:07

Does TZConnection respect the schema settings of PostgreSQL?

Postby vfclists » 24.02.2016, 07:38

I am using the TZConnection from Zeoslib and although I set the schema in the connection, when I run a query it seems to revert to the PUBLIC schema. Unless I prefix tablenames with the schema name like

Code: Select all

select schemaname.tablename from schema
the queries don't work

Are schemas properly supported by Zeoslib?

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1701
Joined: 31.03.2011, 22:38

Re: Does TZConnection respect the schema settings of PostgreSQL?

Postby EgonHugeist » 24.02.2016, 08:40

First of all switch to 7.2 to be on same band width.
And accordingly your question:

Yes of course we do and this is our default syntax. We also add the catalog like <catalog>.<schema>.<tablename>

Postgre uses case-sensitive identifiers. IS "PUBLIC" realy the name of the schema or is it "public"? Work case sensitive..
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image


Return to “ZeosLib 7.1 stable Forum”

Who is online

Users browsing this forum: No registered users and 1 guest