Re: [BUGS] Stored procedure error

2009-11-19 Thread Heikki Linnakangas
Valaki Valahol wrote: > ERROR: relation with OID 28461 does not exist http://wiki.postgresql.org/wiki/FAQ#Why_do_I_get_.22relation_with_OID_.23.23.23.23.23_does_not_exist.22_errors_when_accessing_temporary_tables_in_PL.2FPgSQL_functions.3F Upgrading to 8.4 (or 8.3) should fix that. -- Heikki

Re: [BUGS] Stored procedure error

2009-11-19 Thread Pavel Stehule
Hello You cannot to drop temporary table in stored procedure. Then you can have a problem. There are two possibilities: a) you will upgrade to 8.3, b) you will change code - minimum is replace drop table by truncate table please, read http://www.postgres.cz/index.php/Automatic_execution_plan_cach

[BUGS] Stored procedure error

2009-11-19 Thread Valaki Valahol
Dear Sirs, My name is Zoltán Ötvös and I'm from Hungary. Im using PostgreSQL database server from many years and I'm very satisfied with this database. I'm wanted to write a little financial routine in Linux under Lazarus but for the first I've tested it under pgAdmin. Because I didn't wanted