pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.





Message-ID: <40058BD9.3040705@babcockbrown.com>
Permalink:  ../40058BD9.3040705@babcockbrown.com/
Also on:    postgresql.org/message-id/40058BD9.3040705@babcockbrown.com

 · 

reply

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