Re: [BUGS] BUG #7517: terminated by exception 0xC0000409

2012-09-04 Thread Magnus Hagander
On Tue, Sep 4, 2012 at 3:00 AM, wrote: > The following bug has been logged on the website: > > Bug reference: 7517 > Logged by: Katsuhito Habaguchi > Email address: katsuhito.habagu...@fujixerox.co.jp > PostgreSQL version: 8.3.20 > Operating system: Windows Server 2008 R2 > D

[BUGS] BUG #7518: "FORMAT" in the "COPY" command

2012-09-04 Thread matsusaka
The following bug has been logged on the website: Bug reference: 7518 Logged by: Daichi Matsusaka Email address: matsus...@sraoss.co.jp PostgreSQL version: 9.1.5 Operating system: (Centos5) Description: Hi, I think manual "COPY" command to be in the wrong. postgres

Re: [BUGS] BUG #7518: "FORMAT" in the "COPY" command

2012-09-04 Thread TAKATSUKA Haruka
Hi, It's not bug. > postgres=# COPY table_name TO '/tmp/out.csv' FORMAT 'CSV'; This should be the following. COPY table_name TO '/tmp/out.csv' (FORMAT 'CSV') On Tue, 04 Sep 2012 09:02:12 + matsus...@sraoss.co.jp wrote: > The following bug has been logged on the website: > > Bug refer

Re: [BUGS] BUG #7514: postgres -k no longer works with spaces in the path

2012-09-04 Thread Tom Lane
murr...@murrayc.com writes: > At some point, probably in 9.1.5, the -k option to Postgres ("Unix-domain > socket location" in --help), stopped accepting paths that contain spaces. > For instance, > -k '/tmp/testglom2FPDKW/path with spaces/some_postgres_data' > It now fails with this error: > FATA

Re: [BUGS] BUG #6528: pglesslog still referenced in docs, but no 9.1 support

2012-09-04 Thread Kevin Grittner
Bruce Momjian wrote: > On Mon, Apr 9, 2012 at 02:07:43PM -0500, Kevin Grittner wrote: >> Bruce Momjian wrote: >>> On Mon, Apr 09, 2012 at 03:37:09PM -0300, Alvaro Herrera wrote: >>> (Another related tool is clearxlogtail which zeroes areas from WAL files when they are empty because of

Re: [BUGS] BUG #6528: pglesslog still referenced in docs, but no 9.1 support

2012-09-04 Thread Bruce Momjian
On Tue, Sep 4, 2012 at 12:11:53PM -0500, Kevin Grittner wrote: > Bruce Momjian wrote: > > On Mon, Apr 9, 2012 at 02:07:43PM -0500, Kevin Grittner wrote: > >> Bruce Momjian wrote: > >>> On Mon, Apr 09, 2012 at 03:37:09PM -0300, Alvaro Herrera wrote: > >>> > (Another related tool is clearxl

Re: [BUGS] BUG #6528: pglesslog still referenced in docs, but no 9.1 support

2012-09-04 Thread Kevin Grittner
Bruce Momjian wrote: > On Tue, Sep 4, 2012 at 12:11:53PM -0500, Kevin Grittner wrote: >> What do you think would be the right thing to do with it at this >> point? > > Well, there should probably be a tar files with a README. What > about adding this to /contrib? I would be happy to add it

Re: [BUGS] BUG #6528: pglesslog still referenced in docs, but no 9.1 support

2012-09-04 Thread Bruce Momjian
On Tue, Sep 4, 2012 at 12:49:40PM -0500, Kevin Grittner wrote: > Bruce Momjian wrote: > > On Tue, Sep 4, 2012 at 12:11:53PM -0500, Kevin Grittner wrote: > > >> What do you think would be the right thing to do with it at this > >> point? > > > > Well, there should probably be a tar files with

Re: [BUGS] BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations

2012-09-04 Thread Alvaro Herrera
Excerpts from Tom Lane's message of vie ago 31 17:50:41 -0400 2012: > Alvaro Herrera writes: > > 2. During ALTER EXTENSION execution, skip moving objects that have > > already been moved. Not really sure how this would be implemented; > > +1 for this approach. I'm a bit surprised we didn't hit

Re: [BUGS] BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations

2012-09-04 Thread Tom Lane
Alvaro Herrera writes: > Putting this kind of change this late in the 9.2 release process makes > me a bit nervous, but I don't see a simpler way to solve the problem. This is a pre-existing bug, not something new in 9.2, and quite honestly I don't think we should try to fix it under time pressur

[BUGS] BUG #7519: incresed data base size and query performance lost

2012-09-04 Thread lokendra . dixit
The following bug has been logged on the website: Bug reference: 7519 Logged by: Lokendra Dixit Email address: lokendra.di...@rmsi.com PostgreSQL version: 8.4.11 Operating system: Windows 7 Description: Hi, 1.When I am taking bacup and restore two three times when

Re: [BUGS] BUG #7514: postgres -k no longer works with spaces in the path

2012-09-04 Thread Murray Cumming
On Tue, 2012-09-04 at 10:31 -0400, Tom Lane wrote: > murr...@murrayc.com writes: > > At some point, probably in 9.1.5, the -k option to Postgres ("Unix-domain > > socket location" in --help), stopped accepting paths that contain spaces. > > > For instance, > > -k '/tmp/testglom2FPDKW/path with spa

Re: [BUGS] BUG #7519: incresed data base size and query performance lost

2012-09-04 Thread Kevin Grittner
wrote: > PostgreSQL version: 8.4.11 > 1.When I am taking bacup and restore two three times when databse > size automatically incresed please descrive the solution. > > 2. I have created non cluster index on tables to increase query > performance at same time performance incresed but after on

Re: [BUGS] BUG #7517: terminated by exception 0xC0000409

2012-09-04 Thread fx HABAGUCHI KATSUHITO
Dear Mr.Hagander. Thank you for your answer to my report. > The error occurred on the server, not the client if you got that message. > The question is what you did on the server when it happened. I describe the situation when the error occurred a little in detail. The client application connect

[BUGS] BUG #7520: regexp_matches does not work as expected

2012-09-04 Thread sbasurto
The following bug has been logged on the website: Bug reference: 7520 Logged by: Sergio Basurto Email address: sbasu...@soft-gator.com PostgreSQL version: 9.1.4 Operating system: Gentoo Description: I am using regexp_matches in a function like this create or replace f

[BUGS] windows 8 RTM compatibility issue (could not reserve shared memory region for child)

2012-09-04 Thread Dave Vitek
Hello pgsql-bugs list, I have attached a patch file that I believe resolves a compatibility issue with Windows 8 RTM and postgresql. The impatient might want to just read the patch, this email is longer than it probably should be. I have CC'd Seiko Ishida who expressed an interest in Windows

Re: [BUGS] BUG #7520: regexp_matches does not work as expected

2012-09-04 Thread Tom Lane
sbasu...@soft-gator.com writes: > I am using regexp_matches in a function like this > create or replace function test (v_string in text) > returns varchar as $$ > declare > i_strings text[]; > i_stringtext[]; > i_strings := > regexp_matches(v_string,E'[a-zA-Z0-9