pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Re: Error:TypeCreate: type links already defined 2+ messages / 2 participants [nested] [flat]
* Re: Error:TypeCreate: type links already defined @ 2001-04-02 16:38 Richard Huxton <dev@archonet.com> parent: Najm Hashmi <najm@mondo-live.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
* Error:TypeCreate: type links already defined @ 2001-04-03 14:20 Najm Hashmi <najm@mondo-live.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:^ permalink raw reply [nested|flat] 2+ messages in threadnajm.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
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