[GENERAL] How to retrieve the comment for a constraint?

2005-03-24 Thread Wolfgang Drotschmann
Hallo all, using at least PostgreSQL 7.4.2, one can use the command COMMENT ON CONSTRAINT ON ; to document a constraint defined via CONSTRAINT ... in the context of a table. Now, imagine you know the name of a constraint or all of them for a given table, e.g. destilled via SELEC

[GENERAL] Checking of constraints via subqueries?

2005-02-17 Thread Wolfgang Drotschmann
Hallo all, in part VI (the reference), the online manual for 8.0.1 states for command CREATE DOMAIN for parameter CHECK (expression) that currently "...CHECK expressions cannot contain subqueries nor refer to variables other than VALUE." So, is this an item for the TODO list? I can't find i

Re: [GENERAL] Checking of constraints via subqueries?

2005-02-18 Thread Wolfgang Drotschmann
Michael Fuhr wrote: On Thu, Feb 17, 2005 at 07:31:42PM +0100, Martijn van Oosterhout wrote: On Thu, Feb 17, 2005 at 11:03:58AM -0700, Michael Fuhr wrote: In experiments I've defined a domain's CHECK expression to call a function that makes queries. It worked in simple tests; I don't know if it'll