Re: Resolved - Missing Schema

From: James Neville <james(dot)neville(at)babcockbrown(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Resolved - Missing Schema
Date: 2004-01-14 18:35:05
Message-ID: 40058BD9.3040705@babcockbrown.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Peter Eisentraut wrote:

>You don't need to create any tables, just schemas.
>

Thanks for the help Peter, i've since resolved the problem.
The production install was in fact, 7.2.3, not 7.3.2 as I stated
earlier, my bad.

It appears that PG only started supporting schemas since 7.3.x.
I was assumming that schema names were stored in a system table
somewhere, which, upon further research, are not. My bad.
Never make assumptions :)

Been messing around with 7.4.1 since (as said i'm due an update). Its
long overdue.
Now to find a JDBC driver that lets me set Auto Commit off without
raising exceptions.

But that, as they say, is a different story.....

Cheers,
James.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-01-14 19:22:31 Re: Missing Schema
Previous Message Rajesh Kumar Mallah 2004-01-14 18:26:14 Re: Are there programs to graph database schema?