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