From: | "Brodie Thiesfield" <brofield2(at)jellycan(dot)com> |
---|---|
To: | "Magnus Hagander" <magnus(at)hagander(dot)net> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #3520: insert causing error "invalid memory alloc request size 2147483648" |
Date: | 2007-08-07 14:28:17 |
Message-ID: | a6507e6c0708070728i169665b1j6c73eddb9b7fb346@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The database is created in UTF-8.
CREATE DATABASE crossbase WITH OWNER = tserver ENCODING = 'UTF-8';
postgres=# \l
List of databases
Name | Owner | Encoding
-----------+----------+----------
crossbase | tserver | UTF8
crosstest | postgres | UTF8
postgres | postgres | UTF8
template0 | postgres | UTF8
template1 | postgres | UTF8
System locale is Japanese cp932.
lc_collate | Japanese_Japan.932
lc_ctype | Japanese_Japan.932
lc_messages | Japanese_Japan.932
lc_monetary | Japanese_Japan.932
lc_numeric | Japanese_Japan.932
lc_time | Japanese_Japan.932
If there are any other settings you need from show all then it is in
the attached file.
Regards,
Brodie
On 8/7/07, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> On Tue, Aug 07, 2007 at 03:41:07AM +0000, Brodie Thiesfield wrote:
> >
> > The following bug has been logged online:
> >
> > Bug reference: 3520
> > Logged by: Brodie Thiesfield
> > Email address: brofield2(at)jellycan(dot)com
> > PostgreSQL version: 8.2.4
> > Operating system: Windows XP SP2
> > Description: insert causing error "invalid memory alloc request size
> > 2147483648"
> > Details:
> >
> > See SQL script and output at:
> > http://jellycan.com/etc/postgres-bug.zip
>
> This looks like it could be this bug:
> http://archives.postgresql.org/pgsql-committers/2007-05/msg00088.php
>
> I've been unable to reproduce it on CVS HEAD, which could be why.
>
> What encoding is your database in? Is it also UTF-8?
>
> //Magnus
>
Attachment | Content-Type | Size |
---|---|---|
showall.txt | text/plain | 24.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Mouhamadou Dia | 2007-08-07 14:31:14 | RE : RE : RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues |
Previous Message | Mouhamadou Dia | 2007-08-07 14:27:55 | RE : RE : RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues |