Re: Using a lock to avoid: could not open relation with OID - Mailing list pgsql-general

Craig Ringer writes:

> Possible workaround: Instead of your table creation, renaming and
> dropping, use TRUNCATE.

Have to support both 8.1 and 8.4.
If I recall correctly 8.1 did not support truncate inside of a transaction.

We are in the process of upgrading everything to 8.4, but until then.. have
to deal with all the 8.1 and 8.2 machines.