On Fri, 21 Apr 2006, Andrus wrote:
> > ... and there doesn't appear (for
> > non-match partial constraints) seem to be a special case for the
> > referenced row coming back into existance as far as I can tell either.
>
> > Or, if you're willing to patch, I think a first order approximation of
> >
> ... and there doesn't appear (for
> non-match partial constraints) seem to be a special case for the
> referenced row coming back into existance as far as I can tell either.
> Or, if you're willing to patch, I think a first order approximation of
> what you want might be to remove the special ca
On Thu, 20 Apr 2006, Stephan Szabo wrote:
> On Thu, 20 Apr 2006, Andrus wrote:
>
> > I want to replace ( delete and insert) records in master table .
> > I delete and insert record with same primary key.
> > I want that foreign key records are not deleted.
> >
> > I tried
> >
> > begin;
> > create
On Thu, 20 Apr 2006, Andrus wrote:
> I want to replace ( delete and insert) records in master table .
> I delete and insert record with same primary key.
> I want that foreign key records are not deleted.
>
> I tried
>
> begin;
> create temp table t1 ( pk integer primary key );
> insert into t1 va
> I did so, and for a table named 'country' the following SQL statements
> were produced:
>
> -- Disable triggers
> UPDATE pg_catalog.pg_class SET reltriggers = 0 WHERE oid =
> 'country'::pg_catalog.regclass;
>
> /* COPY command goes here to bulk load table data. */
>
> -- Enable triggers
> UPDA
Andrus wrote:
Is there any generic way to turn off foreign key constraints before delete
command in transaction ?
From TFM: "--disable-triggers
This option is only relevant when performing a data-only restore. It
instructs pg_restore to execute commands to temporarily disable triggers
on the
I want to replace ( delete and insert) records in master table .
I delete and insert record with same primary key.
I want that foreign key records are not deleted.
I tried
begin;
create temp table t1 ( pk integer primary key );
insert into t1 values(1);
create temp table t2 (fk integer );
alter t
