delete - Search results
Mailing lists >> pgsql-novice >> Thread
2021-04-15 13:15:23 | Re: Advice on foreign key and cascading delete design - postgresql 12.6 (Bzzzz)
delete the original table and finally, rename the new_table to the old name and re-check
Mailing lists >> pgsql-novice >> Thread
2021-04-15 07:07:20 | Re: Advice on foreign key and cascading delete design - postgresql 12.6 (Steve Tucknott (TuSol))
On Wed, 2021-04-14 at 14:27 +0200, Bzzzz wrote: Thanks Jean-Yves, that
Mailing lists >> pgsql-novice >> Thread
2021-04-14 12:27:19 | Re: Advice on foreign key and cascading delete design - postgresql 12.6 (Bzzzz)
DELETE CASCADE | create table schema.main1_dependency( int not null references schema.main1(id) on delete cascade int not null
Mailing lists >> pgsql-novice >> Thread
2021-04-14 06:50:45 | Re: Advice on foreign key and cascading delete design - postgresql 12.6 (Steve Tucknott (TuSol))
DELETE CASCADE and use it on other tables,but I still don't see how that
Mailing lists >> pgsql-novice >> Thread
2021-04-13 16:11:13 | Re: Advice on foreign key and cascading delete design - postgresql 12.6 (Bzzzz)
should of course read : REFERENCES public.main(id) ON DELETE CASCADE my bad, sorry. Jean-Yves
Mailing lists >> pgsql-novice >> Thread
2021-04-13 16:08:41 | Re: Advice on foreign key and cascading delete design - postgresql 12.6 (Bzzzz)
deleted, the 'dependency' row is automatically also deleted. Read the doc to see what to add if you create
Mailing lists >> pgsql-novice >> Thread
2021-04-13 15:48:48 | Re: Advice on foreign key and cascading delete design - postgresql 12.6 (Steve Tucknott (TuSol))
Tom, Maybe it's me that's missing it. On my subordinate table I have
Mailing lists >> pgsql-novice >> Thread
2021-04-13 14:47:18 | Re: Advice on foreign key and cascading delete design - postgresql 12.6 (Tom Lane)
just looking for the ON DELETE CASCADE option of foreign key constraints? regards, tom lane
Mailing lists >> pgsql-novice >> Thread
2021-04-13 12:40:51 | Advice on foreign key and cascading delete design - postgresql 12.6 (Steve Tucknott (TuSol))
delete the subservient recs when the parent is deleted? OR have I got the structure