Skip site navigation (1) Skip section navigation (2)

Re: URGENT: schema mess

From: "Ben Trewern" <ben(dot)trewern(at)_nospam_mowlem(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: URGENT: schema mess
Date: 2005-04-19 12:40:23
Message-ID: d42u2t$1oeo$ (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
With Delphi use Zeosdbo instead of ODBC.  It just seems to work.


"Ivan Petrov" <ipp(at)mail(dot)bg> wrote in message 
>  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 .
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?

In response to

pgsql-odbc by date

Next:From: Philippe LangDate: 2005-04-19 13:24:34
Subject: Re: Bound column and serial datatype question
Previous:From: lothar.behrensDate: 2005-04-19 10:52:11
Subject: Bound column and serial datatype question

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group