Joe Abbate <j...@freedomcircle.com> writes:
> I'm using this to validate a tool I'm building and I get an error on the
> following query:
> autodoc=> SELECT conname::regclass FROM pg_constraint
> autodoc-> WHERE contype = 'u';
> ERROR: relation "product_product_code_key" does not exist
Ummm ... pg_constraint.conname contains a constraint name, not a table
name, so casting it to regclass is highly likely to fail. This hasn't
got anything to do with search_path AFAICS, it's just a thinko.
Depending on what it is that you're hoping to do, any of conrelid,
confrelid, or conindid might be what you're after. All of those columns
would contain pg_class OIDs that could usefully be cast to regclass.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
