Re: FW: Schema with Postgress 8.1 - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: FW: Schema with Postgress 8.1
Date
Msg-id 20060131210039.GB95850@pervasive.com
Whole thread Raw
In response to FW: Schema with Postgress 8.1  ("chris preston" <chris@thetrafalgartravel.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: help with locked table(s)/transactions(s)
Next
From: "P. Scott DeVos"
Date:
Subject: Re: plpython error logs