Re: [BUGS] Inconsistency between TO_CHAR() and TO_NUMBER()

2013-05-16 Thread Bruce Momjian
On Fri, May 10, 2013 at 11:49:18AM -0400, Tom Lane wrote: > Patryk Kordylewski writes: > > SET lc_numeric TO 'de_DE.UTF-8'; > > SET > > > SELECT > >TO_CHAR(123456789.123, 'FM99G999G999G999G999G999G999D000'), > >TO_NUMBER(TO_CHAR(123456789.123, 'FM99G999G999G999G999G999G999D000'), > > 'FM

Re: [BUGS] BUG #8167: false EINVAL -22 for opening a file

2013-05-16 Thread Robert Haas
On Thu, May 16, 2013 at 11:55 AM, Tom Lane wrote: > I've not really reviewed fd.c for other instances of the same bug, > but I do see some places where there are DO_DB(...) debug calls in > places where errno had better not change. I'm thinking maybe we should > improve that macro to include save

Re: [BUGS] pg_ctl -D "/absolute/path" -m fast restart - doesn't work in some cases

2013-05-16 Thread Tom Lane
Alvaro Herrera writes: > Um, if this is a bug introduced during the 9.3 timeframe surely we > ought to fix it now instead of waiting for the CF. I think it's been that way all along. Nonetheless, if you feel motivated to review the patch now, there's nothing wrong with that.

Re: [BUGS] pg_ctl -D "/absolute/path" -m fast restart - doesn't work in some cases

2013-05-16 Thread hubert depesz lubaczewski
On czw, maj 16, 2013 at 05:55:54 -0400, Alvaro Herrera wrote: > > > only when Pg is started with relative path, and restarted with absolute, > > > the > > > problem shows. > > It has been a nuisance for me too. Possible patch for pg_ctl is in the next > > CF: > > > > http://www.postgresql.org/

Re: [BUGS] pg_ctl -D "/absolute/path" -m fast restart - doesn't work in some cases

2013-05-16 Thread Alvaro Herrera
Josh Kupershmidt escribió: > On Thu, May 16, 2013 at 4:34 PM, hubert depesz lubaczewski > wrote: > > only when Pg is started with relative path, and restarted with absolute, the > > problem shows. > It has been a nuisance for me too. Possible patch for pg_ctl is in the next > CF: > > http://

Re: [BUGS] pg_ctl -D "/absolute/path" -m fast restart - doesn't work in some cases

2013-05-16 Thread Josh Kupershmidt
On Thu, May 16, 2013 at 4:34 PM, hubert depesz lubaczewski wrote: > =$ pg_ctl -D $( pwd ) -m fast restart > waiting for server to shut down done > server stopped > server starting > postgres cannot access the server configuration file > "/home/test/test/slave/test/slave/postgresql.conf": No

[BUGS] pg_ctl -D "/absolute/path" -m fast restart - doesn't work in some cases

2013-05-16 Thread hubert depesz lubaczewski
hi, I have 9.3beta1, and strange problem. Have running slave pg in directory /home/test/test/slave: =$ pwd /home/test/test/slave =$ cat postmaster.pid 16961 /home/test/test/slave 1368736261 5433 /tmp * 5433001 7241781 =$ ps uxf USER PID %CPU %MEMVSZ RSS TTY STAT START TI

Re: [BUGS] easy crash on HEAD

2013-05-16 Thread Tom Lane
Josh Kupershmidt writes: > I am pretty sure this is an easily-reproducible crash on git head > (well, as of a2a480af889b5), helpfully confirmed on IRC by wulczer and > deko. I reproduced the crash myself on OS X and 64-bit Debian. > create table foo (a int); > CREATE RULE notify_foo_updates AS ON

Re: [BUGS] easy crash on HEAD

2013-05-16 Thread Josh Kupershmidt
On Thu, May 16, 2013 at 3:33 PM, Josh Kupershmidt wrote: > Backtrace looks like this: My mistake -- the last backtrace was from an idle client before the crash. Thank you andres and wulczer for the correction. Here is the interesting one: (gdb) bt #0 has_unnamed_full_join_using (jtnode=0x0) at

[BUGS] easy crash on HEAD

2013-05-16 Thread Josh Kupershmidt
I am pretty sure this is an easily-reproducible crash on git head (well, as of a2a480af889b5), helpfully confirmed on IRC by wulczer and deko. I reproduced the crash myself on OS X and 64-bit Debian. --- create table foo (a int); CREATE RULE notify_foo_updates AS ON UPDATE TO foo DO NOTIFY foo; \d

Re: [BUGS] Postgresql 9.12 support cluster mode

2013-05-16 Thread John R Pierce
On 5/16/2013 2:14 AM, weiwei wrote: Postgresql 9.12 support cluster mode? Equivalent of main spare automatic switching there's no such thing as PostgreSQL 9.12, there's 9.1 of which the current build is 9.1.9, and there's 9.2 which is currently 9.2.4. You can build a active/standby failover

Re: [BUGS] BUG #8167: false EINVAL -22 for opening a file

2013-05-16 Thread Tom Lane
nel...@monkey.org writes: > RhodiumToad asked me to report "pg in PathNameOpenFile / mdopen is > assuming that errno is preserved over calls to free() which is not > required by the spec" Good catch! The proximate problem appears to be this bit in PathNameOpenFile: vfdP->fd = BasicOpenFi

[BUGS] 回复: Postgresql 9.12 support cluster mode

2013-05-16 Thread weiwei
Dear hello： Postgresql 9.12 support cluster mode? Equivalent of main spare automatic switching weiwei 发件人： weiwei 发送时间： 2013-05-16 17:14 收件人： pgsql-bugs 主题： Postgresql 9.12 support cluster mode 电话：010-87120766-5738 手机：13371663316 邮件：wei...@ti-net.com.cn

[BUGS] Postgresql 9.12 support cluster mode

2013-05-16 Thread weiwei
Dear hello： Postgresql 9.12 support cluster mode? Equivalent of main spare automatic switching 电话：010-87120766-5738 手机：13371663316 邮件：wei...@ti-net.com.cn

[BUGS] BUG #8167: false EINVAL -22 for opening a file

2013-05-16 Thread nelson
The following bug has been logged on the website: Bug reference: 8167 Logged by: Nelson Minar Email address: nel...@monkey.org PostgreSQL version: 9.2.4 Operating system: MacOS 10.8.3 Description: This report and supporting files are available at https://gist.github.c