Re: [BUGS] BUG #8470: 9.3 locking/subtransaction performance regression

2013-10-04 Thread Alvaro Herrera
AFAICS the problem here is that this test doesn't use MultiXactIds at all in 9.2, but it does in 9.3. I vaguely recall Noah tried to convince me to put in an optimization which would have avoided this issue; I will give that a thought. I don't think I will be able to get it done for 9.3.1 though.

Re: [BUGS] BUG #8469: Xpath behaviour unintuitive / arguably wrong

2013-10-04 Thread Stefan Kaltenbrunner
On 10/02/2013 06:19 PM, Bruce Momjian wrote: > On Tue, Sep 24, 2013 at 06:43:19PM +, dennis.noord...@helsinki.fi wrote: >> The following bug has been logged on the website: >> >> Bug reference: 8469 >> Logged by: Dennis >> Email address: dennis.noord...@helsinki.fi >> Postgre

[BUGS] BUG #8500: Upgrade to postgis 2.1 breaks existing databases

2013-10-04 Thread kyrimis
The following bug has been logged on the website: Bug reference: 8500 Logged by: Kriton Kyrimis Email address: kyri...@alumni.princeton.edu PostgreSQL version: 9.2.4 Operating system: Scientific Linux 6.4 Description: The version of postgis, available in the postgresq

Re: [BUGS] BUG #8434: Why does dead lock occur many times ?

2013-10-04 Thread Alvaro Herrera
I spent a lot of time looking at this issue. Your problem scenario can be reduced to the following test case: CREATE TABLE t (a INT); INSERT INTO t VALUES (1); The three sessions need to execute the following commands, in this sequence: -- Session 1 /* 1 */ BEGIN; SELECT * FROM t FOR UPDATE; -

Re: [BUGS] pg_upgrade 9.0->9.2 failure: Mismatch of relation OID in database

2013-10-04 Thread Christoph Berg
Re: Bruce Momjian 2013-10-02 <20131002170628.gc5...@momjian.us> > That is very interesting, and it certainly should not be failing. > > I am surprised it got an oid that was one less than the desired one, > 18803. Is there any mention of 18803 in the SQL file? 18803 wasn't mentioned anywhere, ju

Re: [BUGS] BUG #8496: psqlODBC driver does not work well via Excel

2013-10-04 Thread Pavel Stehule
2013/10/4 Heikki Linnakangas > On 02.10.2013 14:57, > manindra.sarkar@brightnorth.**co.ukwrote: > >> Excel does not seem to respond with any data - but does give an idea that >> it >> has made some sort of a connection with the database. SQL commands fail >> from >> being executed. >> > It is st

Re: [BUGS] BUG #8496: psqlODBC driver does not work well via Excel

2013-10-04 Thread Heikki Linnakangas
On 02.10.2013 14:57, manindra.sar...@brightnorth.co.uk wrote: Excel does not seem to respond with any data - but does give an idea that it has made some sort of a connection with the database. SQL commands fail from being executed. I'm afraid you'll have to provide a lot more details for anyone