I was having a lot of trouble the other day and thanks to Tom Lane for his
help in getting me up and running. I did find however that pgAdminII 1.4.12
did not drop triggers properly.
I've enclosed a file which contains the db schema. Although, I couldn't get
it to install the plpgsql language and create the database in pgAdminII so I
had to create those on the command line.
geoff(at)emsdev:~$ createdb test
geoff(at)emsdev:~$ createlang plpgsql test
In pgAdmin, if you drop the function first, and refresh the schema, it shows
that the trigger no longer exists on the table blah. However, you would
still see the trigger using the psql interface and will have to drop it here
otherwise you get cache lookup failed errors and can't install the trigger
again as it already exists.
If you drop the trigger first, this works fine. So I guess I'm saying you
need to drop the trigger explicitly rather than doing it via dropping the
Is this a feature or a bug? ;o)
Sorry if this has been made aware...
Description: application/octet-stream (1.1 KB)
pgadmin-support by date
|Next:||From: John Wells||Date: 2003-01-16 13:24:10|
|Subject: Re: Error installing pgadmin II on Windows 98|
|Previous:||From: Dave Page||Date: 2003-01-15 21:22:02|
|Subject: Re: Error installing pgadmin II on Windows 98 |