Thread: How to overwrite a table [only data]?
Hi list,<br /><br /> I would like to overwrite a table with problem with his original. But there are some points.<br /><br/> I can't just delete and restore it becouse it has a foreign key and when I try to delete it ask for drop cascade.<br/><br /> As I know the drop cascade delete in both tables the rows related. Is it correct ?<br /><br /><br />Regards...<br clear="all" /><br />-- <br /> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br /> Atenciosamente(Sincerely)<br /> Ezequias Rodrigues da Rocha <br/> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br />A pior das democracias ainda é melhordo que a melhor das ditaduras<br />The worst of democracies is still better than the better of dictatorships <br /><ahref="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a>
On 10/4/06, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> wrote:
You can drop the foreign keys and then the table. Then when you recreate and repopulate the table, you can add the foreign keys back at the very end.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================
Hi list,
I would like to overwrite a table with problem with his original. But there are some points.
I can't just delete and restore it becouse it has a foreign key and when I try to delete it ask for drop cascade.
As I know the drop cascade delete in both tables the rows related. Is it correct ?
You can drop the foreign keys and then the table. Then when you recreate and repopulate the table, you can add the foreign keys back at the very end.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================
Hi, Ezequias, Ezequias Rodrigues da Rocha wrote: > I would like to overwrite a table with problem with his original. But > there are some points. > > I can't just delete and restore it becouse it has a foreign key and > when I try to delete it ask for drop cascade. As long as the delete and restore is in the same transaction, SET CONSTRAINTS ALL DEFERRED might help. See the docs for more info. > As I know the drop cascade delete in both tables the rows related. Is > it correct ? Yes, cascade will delete all referencing rows in the otehr table to keep the constraints intact, keeping only those rows that have NULL in the foreign key. I think that's not exactly what you want. HTH, Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in Europe! www.ffii.org www.nosoftwarepatents.org