Re: exception with a temporary table

well i got a trace of the SQL commands sent to the server:

2006-11-20 16:06:51 LOG: statement: PREPARE <unnamed> AS create local
temporary table HT_item (ID BIGINT not null) on commit drop
2006-11-20 16:06:51 LOG: PARSE MESSAGE STATISTICS
2006-11-20 16:06:51 LOG: statement: <BIND>
2006-11-20 16:06:51 LOG: statement: EXECUTE <unnamed> [PREPARE: create
local temporary table HT_item (ID BIGINT not null) on commit drop]
2006-11-20 16:06:51 LOG: QUERY STATISTICS
2006-11-20 16:06:51 LOG: statement: PREPARE <unnamed> AS insert into
HT_item select itemimpl0_.ID as ID from item itemimpl0_ where ID in ($1)
2006-11-20 16:06:51 ERROR: relation "ht_item" does not exist
2006-11-20 16:06:51 LOG: statement: PREPARE <unnamed> AS drop table HT_item
2006-11-20 16:06:51 LOG: PARSE MESSAGE STATISTICS
2006-11-20 16:06:51 LOG: statement: <BIND>
2006-11-20 16:06:51 LOG: statement: EXECUTE <unnamed> [PREPARE: drop
table HT_item]
2006-11-20 16:06:51 ERROR: table "ht_item" does not exist

I think that the problem is in "on commit drop", because i excecute this
statment in the query browse of pgAdmin III and happens the same, What I
must modify?

2006/11/20, Heikki Linnakangas <heikki(at)enterprisedb(dot)com>:
>
> Pablo Araujo wrote:
> > ok, but this assumes that being created everything in the same session.
> >
> > that is to say, it creates it, it inserts data and it destroys it in the
> > same session.
>
> Can you get a trace of the SQL commands sent to the server? One way to
> get that is to set the log_statement configuration parameter in your
> postgresql.conf file to "all".
>
> That would help diagnosing the problem.
>
> --
> Heikki Linnakangas
> EnterpriseDB http://www.enterprisedb.com
>