Re: [ADMIN] Problems doing a restore under 7.4.2

2004-04-22 Thread Tom Lane
Chris White (cjwhite) [EMAIL PROTECTED] writes: I have done a backup of my 7.4.2 database using pg_dump. When I restore the database using the -c option I get the following error message and pg_restore fails pg_restore: [archiver (db)] could not execute query: ERROR: trigger

Re: [ADMIN] Problems doing a restore under 7.4.2

2004-04-22 Thread Chris White (cjwhite)
I got around the problem by using the --disable-triggers option on the restore. Chris -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 9:02 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] Problems doing a restore under 7.4.2

[ADMIN] Problems doing a restore under 7.4.2

2004-04-20 Thread Chris White (cjwhite)
I have just migrated from 7.2.1 to 7.4.2 and I have the following tables defined in my database. /* */ /* Table: vm_config */ /* */ create table vm_config ( Parameter