Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group