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