Re: [GENERAL] pg_restore order and check constraints

2013-06-23 Thread Alban Hertroys
On Jun 24, 2013, at 3:47, Moshe Jacobson wrote: > On Sun, Jun 23, 2013 at 5:04 PM, Martín Marqués > wrote: > Is it possible to see the function? > > Yes -- It checks that the given vendor has the given vendor_type by calling > fn_get_vendor_types_by_vendor(), which gets its data from another

Re: [GENERAL] pg_restore order and check constraints

2013-06-23 Thread Moshe Jacobson
On Sun, Jun 23, 2013 at 5:04 PM, Martín Marqués wrote: > Is it possible to see the function? Yes -- It checks that the given vendor has the given vendor_type by calling fn_get_vendor_types_by_vendor(), which gets its data from another table, tb_vendor_vendor_type (a join table between tb_vendor

Re: [GENERAL] pg_restore order and check constraints

2013-06-23 Thread Martín Marqués
El 23/06/13 13:34, Moshe Jacobson escribió: Hi, I recently added a check constraint onto a table in my database, that uses a stored procedure to check one of the inserted columns against the data of another table. Is it possible to see the function? I know that this is stretching the limit o

[GENERAL] pg_restore order and check constraints

2013-06-23 Thread Moshe Jacobson
Hi, I recently added a check constraint onto a table in my database, that uses a stored procedure to check one of the inserted columns against the data of another table. I know that this is stretching the limit of what a check constraint is meant to be, but is there a way, short of editing the pg