From: Richard Huxton <dev@archonet.com>
To: Najm Hashmi <najm@mondo-live.com>
To: pgsql <pgsql-sql@postgresql.org>
Subject: Re: Error:TypeCreate: type links already defined
Date: Mon, 2 Apr 2001 17:38:02 +0100
Message-ID: <007601c0bb93$62b83580$1001a8c0@archonet.com> (raw)
References: <3AC9DC44.6401BB40@mondo-live.com>
From: "Najm Hashmi" <najm@mondo-live.com>
> 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
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-sql@postgresql.org
Cc: dev@archonet.com, najm@mondo-live.com
Subject: Re: Error:TypeCreate: type links already defined
In-Reply-To: <007601c0bb93$62b83580$1001a8c0@archonet.com>
References: <3AC9DC44.6401BB40@mondo-live.com> <007601c0bb93$62b83580$1001a8c0@archonet.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