> "EST" looks suspiciously like "Eastern Standard Time," considering
> that the timezone in your email is -0500. Does a timestamp immediately
> precede the above string? Have you set log_line_prefix without a
> trailing space?
>
Yep, its East Std. Time.. I've already awarded myself the DA award for
today... :(
> As for "relation with OID X does not exist," see if the FAQ's
> explanation fits your situation:
>
> http://www.postgresql.org/docs/faqs.FAQ.html#item4.19
>
No, no temp tables are used in any of our functions. It seems to have
gone away after I stopped and restarted the database.
Here's a little background on the db that was having this problem.
The database is not typical, its created using files and tables are
basically dropped and recreated every time one of the source files
change. Temp tables are created and populated then within a transaction
the live table is dropped and the tmp table is renamed to be the live
table.
thanks
-mike