HI Tom,
On 03/18/2011 12:42 AM, Joe Abbate wrote:
For my immediate needs, the query was actually the target of a NOT IN
subquery of a query against pg_index (trying to exclude tuples of
indexes for UNIQUE constraints) and I've solved that by using conrelid
in the subquery (and indrelid in the
Hi Tom,
On 03/18/2011 12:17 AM, Tom Lane wrote:
Joe Abbate 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_ke
Joe Abbate 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.con
Hi,
I'm using the autodoc regression database available at
http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/autodoc/autodoc/regressdatabase.sql?rev=1.2&content-type=text/x-cvsweb-markup
This has several schemas that have cross-schema foreign key constraints
such as the following:
autodoc=> \d pr
