Re: [BUGS] BUG #2195: log_min_messages crash server when in DEBUG3 to

2006-01-26 Thread Tom Lane
Bruce Momjian writes: > configure \ > --with-x \ > --with-tcl \ > --with-perl \ > --enable-pltcl-unknown \ > --with-tclconfig=/u/lib \ > --with-tkconfig=/u/lib \ > --with-includes="/usr/local/include/readline /usr/contrib/include" \ > --with-librarie

Re: [BUGS] INSERT causes psql to crash

2006-01-26 Thread Tom Lane
[EMAIL PROTECTED] writes: > I'm hoping strace output will be useful. To recap, psql crashes > on "INSERT INTO TEST VALUES(8)". The insert succeeds, and strace > shows the insert response coming back. I'm wondering if there is > anything suspicious in the response from the backend: > recv(3, "C\0\0

Re: [BUGS] INSERT causes psql to crash

2006-01-26 Thread jao
I was experiencing a psql crash. psql reported "buffer overflow detected" and a stack dump. Quoting Tom Lane <[EMAIL PROTECTED]>: [EMAIL PROTECTED] writes: Quoting Tom Lane <[EMAIL PROTECTED]>: If it just started happening, I'd speculate about a corrupt executable file for psql or libpq. I d

Re: [BUGS] improper estimates even with high statistic values

2006-01-26 Thread Bruce Momjian
Has this been researched. Josh posted he thought it was an optimizer bug, but I haven't seen anyone investigate it: http://archives.postgresql.org/pgsql-performance/2006-01/msg00248.php http://archives.postgresql.org/pgsql-performance/2006-01/msg00265.php --

Re: [BUGS] BUG #2192: misbehaving IRIX strtod() subverts parsing of

2006-01-26 Thread Bruce Momjian
Would you ask SGI to fix the bug? + /* The IRIX strtod() accepts "infinity" or +* "-infinity", but it leaves endptr pointing at +* "inity" and seems to ignore the negative sign. */

Re: [BUGS] BUG #2195: log_min_messages crash server when in DEBUG3 to

2006-01-26 Thread Bruce Momjian
Tom Lane wrote: > I wrote: > > Bruce Momjian writes: > >> I just tested again using your pg_config.h modification, and I still > >> get the failure, so perhaps BSD/OS and Win32 have similar issues with > >> our code. > > > Hmph. I've just been trying to reproduce it on Linux (FC4), and it's > >

Re: [BUGS] BUG #2195: log_min_messages crash server when in DEBUG3 to

2006-01-26 Thread Tom Lane
I wrote: > Bruce Momjian writes: >> I just tested again using your pg_config.h modification, and I still >> get the failure, so perhaps BSD/OS and Win32 have similar issues with >> our code. > Hmph. I've just been trying to reproduce it on Linux (FC4), and it's > OK for me there as well as on HP

Re: [BUGS] BUG #2195: log_min_messages crash server when in DEBUG3 to

2006-01-26 Thread Tom Lane
Bruce Momjian writes: > I just tested again using your pg_config.h modification, and I still > get the failure, so perhaps BSD/OS and Win32 have similar issues with > our code. Hmph. I've just been trying to reproduce it on Linux (FC4), and it's OK for me there as well as on HPUX where I tried f

Re: [BUGS] BUG #2195: log_min_messages crash server when in DEBUG3 to

2006-01-26 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > Tom Lane wrote: > >> I tried on CVS tip and don't see a problem. Which branch were you > >> testing? > > > Uh, CVS HEAD. I put -DEXEC_BACKEND into Makefile.custom, and recompiled > > and initdb'ed. I then modified postgresql.conf and set log_min_mess

Re: [BUGS] BUG #2195: log_min_messages crash server when in DEBUG3 to

2006-01-26 Thread Tom Lane
Bruce Momjian writes: > Tom Lane wrote: >> I tried on CVS tip and don't see a problem. Which branch were you >> testing? > Uh, CVS HEAD. I put -DEXEC_BACKEND into Makefile.custom, and recompiled > and initdb'ed. I then modified postgresql.conf and set log_min_messages > to "debug5". Then stop

Re: [BUGS] BUG #2195: log_min_messages crash server when in DEBUG3 to

2006-01-26 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > I was able to reproduce this on Unix by adding -DEXEC_BACKEND to the > > compile line. It errors out on DEBUG3 and higher. > > I tried on CVS tip and don't see a problem. Which branch were you > testing? Uh, CVS HEAD. I put -DEXEC_BACKEND into Makef

Re: [BUGS] BUG #2195: log_min_messages crash server when in DEBUG3 to

2006-01-26 Thread Tom Lane
Bruce Momjian writes: > I was able to reproduce this on Unix by adding -DEXEC_BACKEND to the > compile line. It errors out on DEBUG3 and higher. I tried on CVS tip and don't see a problem. Which branch were you testing? regards, tom lane ---(end

Re: [BUGS] BUG #2212: Extracting array from 2 dim array may be incorrect

2006-01-26 Thread Tom Lane
"Walter Roeland" <[EMAIL PROTECTED]> writes: > Select (Array[5,8,1])[2] as E; > returns 8 (ok, dimension is lowerd from 1 to 0). > Select (Array[Array[3,2,2],Array[7,4,4],Array[5,8,1]])[3:3] as V; > returns {{5,8,1}} (I suppose this is ok, same dimension). > But: > Select (Array[Array[3,2,2],Arra

Re: [BUGS] BUG #2215: Cannot restore backup cause of view's representaion

2006-01-26 Thread Tom Lane
"Sokolov Yura" <[EMAIL PROTECTED]> writes: > View's text representation is wrong, when row_value used inside a view. Fixed for next release. Thanks for the report! regards, tom lane ---(end of broadcast)--- TIP 1: if postin

Re: [BUGS] BUG #2214: release.sgml - Migration to version 8.1

2006-01-26 Thread Bruce Momjian
Thanks. This has been fixed already and will be in the next release. --- ISHIDA Akio wrote: > > The following bug has been logged online: > > Bug reference: 2214 > Logged by: ISHIDA Akio > Email address:

Re: [BUGS] BUG #2211: select (1::float-1::float)*(-1) = -0 ??

2006-01-26 Thread Tom Lane
"Tiago D. J." <[EMAIL PROTECTED]> writes: > But run this query : > select (1::float-1::float)*(-1) > it returns -0 AFAIK this is correct behavior per the IEEE floating-point-math spec. regards, tom lane ---(end of broadcast)---

Re: [BUGS] BUG #2213: lack of codepage Windows CP1257

2006-01-26 Thread Bruce Momjian
Ansis wrote: > > The following bug has been logged online: > > Bug reference: 2213 > Logged by: Ansis > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1 > Operating system: FreeBSD > Description:lack of codepage Windows CP1257 > Details: > > It's not exact

Re: [BUGS] BUG #2211: select (1::float-1::float)*(-1) = -0 ??

2006-01-26 Thread Jaime Casanova
On 1/25/06, Tiago D. J. <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: > > Bug reference: 2211 > Logged by: Tiago D. J. > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1 > Operating system: Slackware 10.2 > Description:select (1::flo

Re: [BUGS] BUG #2195: log_min_messages crash server when in DEBUG3 to 5

2006-01-26 Thread Tom Lane
Bruce Momjian writes: > I was able to reproduce this on Unix by adding -DEXEC_BACKEND to the > compile line. It errors out on DEBUG3 and higher. Oh, OK, I'll take a look. regards, tom lane ---(end of broadcast)--- TIP 3: H

[BUGS] BUG #2213: lack of codepage Windows CP1257

2006-01-26 Thread Ansis
The following bug has been logged online: Bug reference: 2213 Logged by: Ansis Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: FreeBSD Description:lack of codepage Windows CP1257 Details: It's not exactly a bug, but a really big minus, at

[BUGS] BUG #2215: Cannot restore backup cause of view's representaion

2006-01-26 Thread Sokolov Yura
The following bug has been logged online: Bug reference: 2215 Logged by: Sokolov Yura Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.2 Operating system: Windows XP SP2, Slackware 10.2 Description:Cannot restore backup cause of view's representaion Details:

[BUGS] BUG #2211: select (1::float-1::float)*(-1) = -0 ??

2006-01-26 Thread Tiago D. J.
The following bug has been logged online: Bug reference: 2211 Logged by: Tiago D. J. Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Slackware 10.2 Description:select (1::float-1::float)*(-1) = -0 ?? Details: Hi people, I think that anythi

[BUGS] BUG #2214: release.sgml - Migration to version 8.1

2006-01-26 Thread ISHIDA Akio
The following bug has been logged online: Bug reference: 2214 Logged by: ISHIDA Akio Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.2 Operating system: Linux Description:release.sgml - Migration to version 8.1 Details: ./doc/src/sgml/release.sgml *** ./doc

[BUGS] BUG #2212: Extracting array from 2 dim array may be incorrect

2006-01-26 Thread Walter Roeland
The following bug has been logged online: Bug reference: 2212 Logged by: Walter Roeland Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.2 Operating system: Windows XP professional Description:Extracting array from 2 dim array may be incorrect Details: Selec

[BUGS] BUG #2210: an update query bug with a table but not with your backup

2006-01-26 Thread Ricardo Solanilla
The following bug has been logged online: Bug reference: 2210 Logged by: Ricardo Solanilla Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows XP Description:an update query bug with a table but not with your backup Details: i try thos

Re: [BUGS] BUG #2195: log_min_messages crash server when in DEBUG3 to

2006-01-26 Thread Bruce Momjian
Milen A. Radev wrote: > Tom Lane writes: > > "Jaime Casanova" <[EMAIL PROTECTED]> writes: > >> in my machine (win xp) i was trying to start psql (8.1.1) with > >> log_min_messages to debug5 (just to see the messages :) but even the > >> service start i cannot use psql nor pgadmin i receive an error