Thread: URGENT: schema mess
Hello guys, I have the following problem: My Delphi application connect to PostgreSQL via ADO and ODBC driver. I have properly set the ODBC data source and everything was working file while all my tables where in public schema. I decided to group my tables in different schemas. So I created additional schema "system" and moved the few tables there. After that I updated the "search_path" variable to pg_catalog, public, system. But when I try to select something from table system.sec_users I receive empty recordset. If I try the same SQL from EMS PostgreSQL Manager or the console application psql - it returns me what it should. Where is the problem ? ----------------------------- MP3 player APACER 256MB - Само за 99 лв. http://best.bg/stock.asp?cat_id=737&id=3789
With Delphi use Zeosdbo instead of ODBC. It just seems to work. Ben "Ivan Petrov" <ipp@mail.bg> wrote in message news:1112528563.1ed75f13f56d9@mail.bg... > > Hello guys, > > I have the following problem: > > My Delphi application connect to PostgreSQL via ADO and > ODBC driver. I have properly set the ODBC data source and > everything was working file while all my tables where in > public schema. > > I decided to group my tables in different schemas. So I > created additional schema "system" and moved the few tables > there. After that I updated the "search_path" variable to > pg_catalog, public, system. But when I try to select > something from table system.sec_users I receive empty > recordset. If I try the same SQL from EMS PostgreSQL > Manager or the console application psql - it returns me > what it should. > > Where is the problem ? > > ----------------------------- > > MP3 player APACER 256MB - ���� �� 99 ��. > http://best.bg/stock.asp?cat_id=737&id=3789 > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org >