X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A8886D1B4BE for ; Wed, 14 Jan 2004 18:45:55 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 79328-09 for ; Wed, 14 Jan 2004 14:45:25 -0400 (AST) Received: from clientmail2.amicus.com (clientmail2.amicus.com [208.134.137.26]) by svr1.postgresql.org (Postfix) with ESMTP id 83983D1DA7E for ; Wed, 14 Jan 2004 14:45:23 -0400 (AST) Received: from alcatraz.babcockbrown.com (alcatraz.babcockbrown.com [208.1.254.2]) by clientmail2.amicus.com (8.12.6/8.12.6) with ESMTP id i0EIjMTZ015288 for ; Wed, 14 Jan 2004 12:45:22 -0600 Received: from tiburon.us.babcockbrown.com (tiburon.babcockbrown.com [208.1.254.14]) by alcatraz.babcockbrown.com (8.12.10/8.12.10) with ESMTP id i0EIZHkl009910 for ; Wed, 14 Jan 2004 10:35:17 -0800 (PST) Received: from cracker.eu.babcockbrown.com (localhost [127.0.0.1]) by tiburon.us.babcockbrown.com (8.12.9/8.12.9) with ESMTP id i0EIhcA6013608 for ; Wed, 14 Jan 2004 10:43:38 -0800 (PST) Received: from babcockbrown.com by cracker.eu.babcockbrown.com (8.9.3+Sun/SMI-SVR4) id SAA13019; Wed, 14 Jan 2004 18:46:14 GMT Message-ID: <40058BD9.3040705@babcockbrown.com> Date: Wed, 14 Jan 2004 18:35:05 +0000 From: James Neville User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Resolved - Missing Schema References: <40056DB9.70502@babcockbrown.com> <200401141812.32538.peter_e@gmx.net> <4005795C.40100@babcockbrown.com> <200401141919.17404.peter_e@gmx.net> In-Reply-To: <200401141919.17404.peter_e@gmx.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-RAVMilter-Version: 8.4.3(snapshot 20030212) (clientmail2.amicus.com) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/125 X-Sequence-Number: 11988 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.