It would probably be very useful to turn on query logging in PostgreSQL
to see what exactly the ODBC layer is attempting to do. In the meantime,
you can certainly create a postgres schema. If you want to do this via
psql:
psql -c 'create schema postgres; grant all on schema postgres to public' databasename
On Mon, Jan 30, 2006 at 12:53:12PM -0500, chris preston wrote:
> Hello all,
> I have setup a fedora 4 box with Postgress 8.0.6 (with Schemas). The
> problem is that by windows odbc driver that i have setup shows me the tables
> but when i double click to display the fields i get a message
>
> Connectivity error. Error while executing the query,ERROR: schemas
> "postgress" does not exist
>
> When I go into phppgadmin i see a schema but it has the name of public. i am
> thinking that i need to add a new schema wiht the name postgres or can i
> delete it. if i can delete it how do you do that... i am using php and it
> connects fine to the database but something is wrong with odbc
>
> what am i doing wrong .....HELP
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461