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
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
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.
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
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 ...
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
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