Thread: Inverse Constraints

Inverse Constraints

From

Andrae Muys

Date:

14 October 2003, 04:44:06

I am very new to postgresql and would like to express my appreciation 
for the wonderful work you have done with pgadminIII.

One feature I would like to find is the ability to list all the 
constraints that refer to a given table or column.

Is this feature present in pgadmin?  If it isn't what would be involved 
in adding it, and I would like to propose it as a possible future 
enhancement.

In the meantime I am using the following query, any advice refining this 
query will be much appreciated.

SELECT
pgc.relname as contTable, pgr.relname as reftable, pct.*
FROM
pg_catalog.pg_constraint pct, pg_catalog.pg_class pgc, 
pg_catalog.pg_class pgr
WHERE
pct.contype='f' and pgc.oid = pct.conrelid and pgr.oid = pct.confrelid

Andrae Muys

Re: Inverse Constraints

From

Andreas Pflug

Date:

14 October 2003, 08:42:21

Andrae Muys wrote:

> I am very new to postgresql and would like to express my appreciation 
> for the wonderful work you have done with pgadminIII.

Thanks!

>
> One feature I would like to find is the ability to list all the 
> constraints that refer to a given table or column.



This would be probably quite useful, I've put it on the TODO list.

Regards,

Re: Inverse Constraints

From

"Dave Page"

Date:

14 October 2003, 08:45:01


> -----Original Message-----
> From: Andreas Pflug [mailto:pgadmin@pse-consulting.de]
> Sent: 14 October 2003 09:42
> To: Andrae Muys
> Cc: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Inverse Constraints
>
> >
> > One feature I would like to find is the ability to list all the
> > constraints that refer to a given table or column.
>
>
>
> This would be probably quite useful, I've put it on the TODO list.

Frank added a dependency/dependee tree to pga2 that offers similar
functionality. I was toying with adding similar to pga3...

Regards, Dave.