Re: [BUGS] error in simple sql function breaks connection

2004-09-06 Thread Tom Lane
Fabien COELHO <[EMAIL PROTECTED]> writes: > psql> CREATE FUNCTION add_data(TEXT) RETURNS boolean LANGUAGE SQL AS >'BEGIN; INSERT INTO foo(data) VALUES($1); COMMIT; SELECT TRUE;'; > psql> SELECT add_data('hello'); > FATAL: EndTransactionBlock: unexpected state BEGIN > CONTEXT: SQL functio

[BUGS] error in simple sql function breaks connection

2004-09-06 Thread Fabien COELHO
Dear bug-hunters, With a nearly current cvs head version I have the following: psql> SELECT VERSION(); ... PostgreSQL 8.0.0beta2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.4 (Debian 1:3.3.4-6sarge1) psql> CREATE TABLE foo(id SERIAL PRIMARY KEY, data TEXT); psql> CREATE FUNCTION add_data(