Received: from www-uk-05.digiserve.com ([195.97.231.11]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f32H4GK14839 for ; Mon, 2 Apr 2001 13:04:16 -0400 (EDT) (envelope-from dev@archonet.com) Received: from mainbox.archonet.com (mwynhau.demon.co.uk [193.237.186.96]) by www-uk-05.digiserve.com (8.9.1/8.9.1) with ESMTP id SAA27385; Mon, 2 Apr 2001 18:05:09 +0100 (BST) Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id B49E42A2E3; Mon, 2 Apr 2001 17:38:46 +0100 (BST) Message-ID: <007601c0bb93$62b83580$1001a8c0@archonet.com> From: "Richard Huxton" To: "Najm Hashmi" , "pgsql" References: <3AC9DC44.6401BB40@mondo-live.com> Subject: Re: Error:TypeCreate: type links already defined Date: Mon, 2 Apr 2001 17:38:02 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200104/13 X-Sequence-Number: 2352 From: "Najm Hashmi" > Hi all, I have posted my question since last Thurday and noone has answered it > yet. My problems is that I droped a table using pgaccess from pg_class. Now > If I try to create that table I get the following error: TypeCreate: type > links already defined. > Could some one help me out here. > Regards Need more information Najm - obivously PG is trying to create a type "links" and failing - do you have anything called "links" in your table definition or the rest of your database? Perhaps look in the pg_types table: select oid,* from pg_types where typname like 'lin%'; Don't go deleting it without knowing what it is though. If your table is called "links" I'd guess it's fine to delete it, but I'd take a backup first anyway. - Richard Huxton