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




view thread (2+ messages)  latest in thread

Message-ID: <007601c0bb93$62b83580$1001a8c0@archonet.com>
Permalink:  ../007601c0bb93$62b83580$1001a8c0@archonet.com/
Also on:    postgresql.org/message-id/007601c0bb93$62b83580$1001a8c0@archonet.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-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