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 [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
