pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: Error:TypeCreate: type links already defined
2+ messages / 2 participants
[nested] [flat]

* Error:TypeCreate: type links already defined
@ 2001-04-03 14:20 Najm Hashmi <najm@mondo-live.com>
  2001-04-02 16:38 ` Re: Error:TypeCreate: type links already defined Richard Huxton <dev@archonet.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Najm Hashmi @ 2001-04-03 14:20 UTC (permalink / raw)
  To: pgsql-sql

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

Attachments:

najm.vcf (text/x-vcard, 183B) download begin:vcard n:Hashmi;Najm x-mozilla-html:FALSE org:Mondo-Live.com;www.flipr.com adr:;;;;;; version:2.1 email;internet:najm@mondo-live.com x-mozilla-cpt:;6144 fn:Najm Hashmi end:vcard
^ permalink raw reply [nested|flat] 2+ messages in thread

* Re: Error:TypeCreate: type links already defined
  2001-04-03 14:20 Error:TypeCreate: type links already defined Najm Hashmi <najm@mondo-live.com>
@ 2001-04-02 16:38 ` Richard Huxton <dev@archonet.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Richard Huxton @ 2001-04-02 16:38 UTC (permalink / raw)
  To: Najm Hashmi <najm@mondo-live.com>; pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-04-03 14:20 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-04-03 14:20 Error:TypeCreate: type links already defined Najm Hashmi <najm@mondo-live.com>
2001-04-02 16:38 ` Richard Huxton <dev@archonet.com>

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