Re: [BUGS] Error when lock conflict on REPLACE function

2010-03-17 Thread Robert Haas
On Tue, Mar 16, 2010 at 7:02 AM, Peter Eisentraut wrote: > On mån, 2010-03-15 at 14:13 -0700, Josh Berkus wrote: >> 1. Create a function. >> 2. In one session, start an explicit transaction. >> 3. Do a CREATE OR REPLACE on the same function, but do not commit. >> 4. Open a 2nd session, and an expl

Re: [BUGS] Error when lock conflict on REPLACE function

2010-03-16 Thread Peter Eisentraut
On mån, 2010-03-15 at 14:13 -0700, Josh Berkus wrote: > 1. Create a function. > 2. In one session, start an explicit transaction. > 3. Do a CREATE OR REPLACE on the same function, but do not commit. > 4. Open a 2nd session, and an explicit transaction in that session. > 5. Do a CREATE OR REPLACE on

[BUGS] Error when lock conflict on REPLACE function

2010-03-15 Thread Josh Berkus
Severity: Annoyance Versions Tested: 8.4.2 Platform: Linux RHEL 5.4 Reproduceable: always Steps to reproduce: 1. Create a function. 2. In one session, start an explicit transaction. 3. Do a CREATE OR REPLACE on the same function, but do not commit. 4. Open a 2nd session, and an explicit transactio