Schema with Postgress 8.1

From: "chris preston" <chris(at)thetrafalgartravel(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Schema with Postgress 8.1
Date: 2006-01-30 15:04:44
Message-ID: ABEJIBKKFOPFKOHJJMLFKEFJCHAA.chris@thetrafalgartravel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2006-01-30 15:16:50 Re: wrong objects order using pg_dump
Previous Message Jaime Casanova 2006-01-30 14:46:03 Re: wrong objects order using pg_dump