Re: Using a lock to avoid: could not open relation with OID

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Using a lock to avoid: could not open relation with OID
Date: 2010-01-12 04:40:47
Message-ID: cone.1263271247.78794.2771.1000@shelca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message tamanna madaan 2010-01-12 04:50:36 Re: does autovacuum in postgres-8.1.2 use prepared transactions ??
Previous Message AI Rumman 2010-01-12 04:26:22 Re: transaction logging in the form of SQL statements