"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"
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