Re: FW: Schema with Postgress 8.1

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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461