Re: [BUGS] BUG #1295: Problem on trigger

2004-10-25 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > CREATE OR REPLACE FUNCTION _test_delete_and_drop() > RETURNS void AS $$ > BEGIN > DELETE FROM _test; > DROP TABLE _test; > RETURN; > END; > $$ LANGUAGE plpgsql; This will work fine the first time. When you recreate the "_test"

[BUGS] BUG #1295: Problem on trigger

2004-10-25 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1295 Logged by: shancheng Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Beta Operating system: Fedora2 Description:Problem on trigger Details: I have a table for test. CREATE TABLE _test(id int