From: | "ALEXEY PARSHIN" <alexeyp(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #3229: Incorrect temp table work |
Date: | 2007-04-16 09:12:04 |
Message-ID: | 200704160912.l3G9C48k046754@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 3229
Logged by: ALEXEY PARSHIN
Email address: alexeyp(at)gmail(dot)com
PostgreSQL version: 8.1.8
Operating system: Gentoo Linux
Description: Incorrect temp table work
Details:
If I call the following function two or more time, I get an error "relation
with OID 318730 does not exist":
CREATE OR REPLACE FUNCTION temp_test(
) RETURNS void AS $$
BEGIN
BEGIN
CREATE TEMP TABLE session_info(
si_person int not null,
si_person_name varchar(40) not null,
si_server int not null
);
EXCEPTION
-- Table already exists? Clean it
WHEN others THEN
DELETE FROM session_info;
END;
INSERT INTO session_info (si_person,si_person_name,si_server)
VALUES (1,'test',1);
RAISE EXCEPTION 'Something went wrong';
END;
$$ LANGUAGE 'plpgsql';
----------------------------------------------------------------------------
----
GRANT EXECUTE ON FUNCTION temp_test() TO PUBLIC;
From | Date | Subject | |
---|---|---|---|
Next Message | Jeferson Kasper | 2007-04-16 12:33:12 | BUG #3230: Division problem |
Previous Message | David Darville | 2007-04-16 08:00:48 | Re: Continuous archiving fails |