psql \r changed behavior in pg10
nd "select 1;" is it right? -- *Regards,Emanuel Araújo*
Re: disable and enable trigger all when a foreign keys
Yeah, I understood, I have to do that, drop and re-add constraint to avoid issues.
disable and enable trigger all when a foreign keys
,'house 1 not sold'); insert into a values (3,2,'apartment 1 not sold'); insert into a values (4,null,'house to buy'); insert into a values (5,3,'car to sell'); select * from a; select * from b; alter table a enable trigger all; select * from a; select * from b; -- *Atenciosamente,Emanuel Araújo* *Linux Certified, DBA PostgreSQL*