On Mon, Apr 4, 2011 at 5:40 AM, Howard Cole <howardnews@xxxxxxxxxxxxx> wrote: > On 04/04/2011 11:47 AM, salah jubeh wrote: > > What will happen if > > 1. dropped table a > 2. insert data on b and the other relations > 3. restore table a and it's dependency (table b). > > Simple advice would be to create a script on an offline system for testing - > when you are happy with the results - do it on the online system - after > making a backup of course! Anything else would be suicidal. Agreed. AND on the production system first take a backup and THEN run the drop cascade inside a transaction in case it does crazy things you didn't foresee. begin; drop object yada cascade; then rollback if things get too scary. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
