[BUGS] check_locale() and the empty string

2012-03-11 Thread Jeff Davis
The following SQL succeeds: create database foodb with template = template0 encoding = 'UTF8' lc_collate='' lc_ctype=''; (any other template fails because it actually checks for a match against the template). The problem seems to be in check_locale(), which just checks for a no

Re: [BUGS] BUG #6524: lpermission denied to create extension "ltree". Must be superuser to create this extension.

2012-03-11 Thread Josh Kupershmidt
On Fri, Mar 9, 2012 at 8:50 PM, wrote: > CREATE EXTENSION ltree; > ERROR:  permission denied to create extension "ltree" > HINT:  Must be superuser to create this extension. > > Why does ltree require superuser privledge? Is it dangerous and allow > circumventing server security? No mention of t

Re: [BUGS] BUG #6525: t_infomask2 is uint16, not int16

2012-03-11 Thread Tom Lane
koizumi...@minos.ocn.ne.jp writes: > In Table 55-4. HeapTupleHeaderData Layout, the type of t_infomask2 is > "int16". But in src/include/access/htup.h, it is "uint16". Maybe the > document is wrong. Yeah, that probably should say uint16. Fixed, thanks for the report.

[BUGS] BUG #6526: Intermittent connect issue

2012-03-11 Thread adam . robertson
The following bug has been logged on the website: Bug reference: 6526 Logged by: Adam Robertson Email address: adam.robert...@arvixe.com PostgreSQL version: 8.3.7 Operating system: Windows Server 2008 R2 Standard Description: I'm experiencing intermittent yet frequent

Re: [BUGS] BUG #6526: Intermittent connect issue

2012-03-11 Thread Tom Lane
adam.robert...@arvixe.com writes: > PostgreSQL version: 8.3.7 > Operating system: Windows Server 2008 R2 Standard > FATAL: could not reattach to shared memory (key=268, addr=0206): 487 This is fixed in (IIRC) 8.3.8 and later. The version you are running is nearly 3 years old ...

Re: [BUGS] table row type and query-specified row type do not match

2012-03-11 Thread Tom Lane
I wrote: > What I would have expected to happen is for the ALTER TABLE to throw an > error telling you it couldn't cope with updating the rule, and that > you'd need to fix that manually. There is such a test involving views; > not sure why it's not catching this rule. FYI, I've committed a patch

Re: [BUGS] Regression from 8.4 to 9.1.2/9.1.3: Optimizing filters on constants in unions

2012-03-11 Thread Tom Lane
Claus Stadler writes: > Hi, not sure if this bug is already known, so sorry if it is ;) > Filtering a Union on constant custom type: This seems to be another unpleasant consequence of http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=57664ed25e5dea117158a2e663c29e60b3546e1c I'm s