Re: [BUGS] Weird message when creating PK constraint named like table

2012-01-12 Thread Pavel Golub
Hello, r. You wrote: rd> When I do this rd> CREATE TABLE "T1" rd> ( rd> "T1_ID" bigint NOT NULL, rd> CONSTRAINT "T1" PRIMARY KEY ("T1_ID" ) rd> ); rd> I get the following message: rd> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "T1" for table "T1" rd> ERROR: relation "

Re: [BUGS] Weird message when creating PK constraint named like table

2012-01-12 Thread Thomas Kellerer
Kevin Grittner, 11.01.2012 21:16: When I do this CREATE TABLE "*T1*" ( "T1_ID" bigint NOT NULL, CONSTRAINT "*T1*" PRIMARY KEY ("T1_ID" ) ); I get the following message: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "T1" for table "T1" ERROR: relation "T1" already exist

[BUGS] BUG #6395: Invalid XPath expression

2012-01-12 Thread franco . ricci
The following bug has been logged on the website: Bug reference: 6395 Logged by: Franco Ricci Email address: franco.ri...@phys.uniroma1.it PostgreSQL version: 9.1.2 Operating system: FreeBSD 9 Description: Query at bottom returns: "ERROR: invalid XPath expression DET

Re: [BUGS] BUG #6395: Invalid XPath expression

2012-01-12 Thread Florian Weimer
* franco ricci: > The same query on PostgreSQL 9.x works fine! I think you mean 9.0. > xpath('/llrp:RO_ACCESS_REPORT/llrp:TagReportData/llrp:*[contains(name(),\"EPC\")]/llrp:EPC/text()', Does it work if you drop the '\'? PostgreSQL 9.1 defaults to standard_conforming_strings=on. See the relea

Re: [BUGS] BUG #6393: cluster sometime fail under heavy concurrent write load

2012-01-12 Thread Tom Lane
Maxim Boguk writes: > PS: no such effects happens on 9.0.4 > I think it can be related to TOAST related changes in 9.0.6 Yes, this is a consequence of commit 44b6d53b467bfe848c34c7a8a174779bb2f43c39, which tried to preserve toast OIDs when doing a table rewrite. The problem is that CLUSTER needs

Re: [BUGS] BUG #6395: Invalid XPath expression

2012-01-12 Thread Franco Ricci
On 12-1-2012 4:58 PM, Florian Weimer wrote: * franco ricci: The same query on PostgreSQL 9.x works fine! I think you mean 9.0. Yes, I mean 9.0.5 xpath('/llrp:RO_ACCESS_REPORT/llrp:TagReportData/llrp:*[contains(name(),\"EPC\")]/llrp:EPC/text()', Does it work if you drop the '\'? Thanks a

Re: [BUGS] BUG #6393: cluster sometime fail under heavy concurrent write load

2012-01-12 Thread Tom Lane
I wrote: > Yes, this is a consequence of commit > 44b6d53b467bfe848c34c7a8a174779bb2f43c39, which tried to preserve toast > OIDs when doing a table rewrite. The problem is that CLUSTER needs to > copy both the old and new versions of an updated row, since the old one > is only "recently dead", and

Re: [BUGS] Botched estimation in eqjoinsel_semi for cases without reliable ndistinct

2012-01-12 Thread Casey Allen Shobe
On Wed, 11 Jan 2012 19:40:34 -0500, Andres wrote: > Unfortunately the pastebins where raptelan provided plans expired by > now... Perhaps he can provide them again? Sure, the original curiosity I noticed was that adjusting the block size of results returned by the CTE had widely different effects,

[BUGS] BUG #6396: PgFoundry is down

2012-01-12 Thread bfroz63
The following bug has been logged on the website: Bug reference: 6396 Logged by: Bruno Rodrigues Froz Email address: bfro...@gmail.com PostgreSQL version: 9.1.2 Operating system: Windows Description: The web page PgFounfry id out. I want to download the npgsql, but I

Re: [BUGS] BUG #6396: PgFoundry is down

2012-01-12 Thread Magnus Hagander
On Fri, Jan 13, 2012 at 01:16, wrote: > The following bug has been logged on the website: > > Bug reference:      6396 > Logged by:          Bruno Rodrigues Froz > Email address:      bfro...@gmail.com > PostgreSQL version: 9.1.2 > Operating system:   Windows > Description: > > The web page PgFou