From: James Neville <james.neville@babcockbrown.com>
To: pgsql-admin@postgresql.org
Subject: Re: Resolved - Missing Schema
Date: Wed, 14 Jan 2004 18:35:05 +0000
Message-ID: <40058BD9.3040705@babcockbrown.com> (raw)
In-Reply-To: <200401141919.17404.peter_e@gmx.net>
References: <40056DB9.70502@babcockbrown.com>
<200401141812.32538.peter_e@gmx.net>
<4005795C.40100@babcockbrown.com>
<200401141919.17404.peter_e@gmx.net>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: james.neville@babcockbrown.com
Subject: Re: Resolved - Missing Schema
In-Reply-To: <40058BD9.3040705@babcockbrown.com>
References: <40056DB9.70502@babcockbrown.com> <200401141812.32538.peter_e@gmx.net> <4005795C.40100@babcockbrown.com> <200401141919.17404.peter_e@gmx.net> <40058BD9.3040705@babcockbrown.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox