Kerri Reno wrote: > Adrian, > > I don't understand. Why do I need to use execute?
It's a Postgres shortcoming. It's fixed in 8.3 so if it annoys you too much you can just upgrade. > It runs fine the first > time. The second time it bombs, because it's not seeing schedrec > correctly. Which part should be in an execute query statement? All sentences referring to the temp table. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
