Thread: creating temp table...

Hi,
I've got PostgreSQL 6.5.2 installed and strange things happens when I
try to create temp table in transaction block.

Here's SQL commands send to backend:

SELECT data FROM aukcje WHERE aukcja_id = '1'
SELECT reklama,logo_loid,logo_content,www,nazwa FROM domy WHERE dom_id =
'0'
BEGIN
SELECT * FROM domy WHERE dom_id = '0'
CREATE TEMPORARY TABLE tmp (obraz_id int,tytul varchar(80),nazwa
varchar(40),obrazm_loid oid,obrazm_content varchar(20))
INSERT INTO tmp SELECT obraz_id,tytul,nazwa,obrazm_loid,obrazm_content
FROM obrazy,autorzy,aukcje WHERE obrazy.autor_id = autorzy.autor_id AND
obrazy.aukcja_id
= aukcje.aukcja_id AND dom_id = '0' AND obrazy.aukcja_id = '1'
DECLARE obraz_cur CURSOR FOR SELECT * FROM tmp
select count(obraz_id) FROM tmp
FETCH FORWARD 10 IN obraz_cur
CLOSE obraz_cur
COMMIT

Everything is going fine but from time to time I've got something like
this:

SELECT data FROM aukcje WHERE aukcja_id = '1'
SELECT reklama,logo_loid,logo_content,www,nazwa FROM domy WHERE dom_id =
'0'
BEGIN
SELECT * FROM domy WHERE dom_id = '0'
CREATE TEMPORARY TABLE tmp (obraz_id int,tytul varchar(80),nazwa
varchar(40),obrazm_loid oid,obrazm_content varchar(20))

Warning: PostgresSQL query failed: pqReadData() -- backend closed the
channel unexpectedly. This probably means the backend terminated
abnormally before or while
processing the request. in common.inc on line 19

[message wrapped by php interpreter]

Any suggestions? Is this a bug in backend server or something is wrong
with my SQL ?

thanks for any help

--
Łukasz Michalski
mailto:zork@clan.pl

Lukasz Michalski <zork@clan.pl> writes:
> I've got PostgreSQL 6.5.2 installed and strange things happens when I
> try to create temp table in transaction block.

Yes, that area is kinda broken in 6.5.*.  Try it with 7.0 (RC1 or
later).

            regards, tom lane