[GENERAL] Delete across 5 Joined tables

2008-08-17 Thread Fuzzygoth
Hi, I am trying to delete a set of related record across the whole database, In tests I have managed to delete records from 2 tables using the code below. DELETE FROM phillipsd.tablea using phillipsd.tableb WHERE tablea.one = 2; but I need to be able to delete from up to 5 different tables, is th

[GENERAL] invalid byte sequence for encoding "UTF8"

2007-03-21 Thread Fuzzygoth
Hi, I am trying currently trying to setup our new database sever, we have upgraded to PostgreSQL 8.1.8. When I try to restore the backup (which is stored as a set of SQL statements that my restore script feeds into PSQL to execute) it returns the following error. psql:/mnt/tmp/app/application_dat