Re: [BUGS] BUG #5068: LIKE

2009-09-20 Thread Peter Eisentraut
On Sun, 2009-09-20 at 01:00 +, Paulo wrote: > like to select a field containing Numeric 4 and compared with a > char(30) > field. > In oracle and postgresql to version 8.2 worked perfectly, now the new > version no longer works, as we have many queries in this format. Hard to say without havi

[BUGS] BUG #5069: Segfault

2009-09-20 Thread Kenaniah Cerny
The following bug has been logged online: Bug reference: 5069 Logged by: Kenaniah Cerny Email address: kenan...@gmail.com PostgreSQL version: 8.4.1 Operating system: Centos5.2 Description:Segfault Details: Segfault party output of uname -a: Linux 2.6.18-92.1.

Re: [BUGS] BUG #5069: Segfault

2009-09-20 Thread Tom Lane
"Kenaniah Cerny" writes: > Segfault party I couldn't reproduce a crash given this information. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #5069: Segfault

2009-09-20 Thread Craig Ringer
Tom Lane wrote: > "Kenaniah Cerny" writes: >> Segfault party > > I couldn't reproduce a crash given this information. Which probably means 'it's time to hook up `gdb' and get a backtrace of the crash'. -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

Re: [BUGS] BUG #5066: plperl issues with perl_destruct() and END blocks

2009-09-20 Thread Tim Bunce
On Sat, Sep 19, 2009 at 11:43:26PM -0400, Tom Lane wrote: > Robert Haas writes: > > On Sat, Sep 19, 2009 at 3:53 PM, Tom Lane wrote: > >> "Tim Bunce" writes: > >>> The plperl implementation doesn't call perl_destruct() during server > >>> shutdown. > >> > >> Who cares? �The process is going awa

[BUGS] postgresql doesn't work

2009-09-20 Thread Thibaut
hi i install postgresql 8.3 and when i run it there's a message error: could not create inherited socket: error code 10022 I tried to install without firewall antivirus but i got the same error i tried run lspfix : no problems found my config : windows xp sp3 (french) what can i do to run postgre

[BUGS] erreur postgresql

2009-09-20 Thread Thibaut
hi i install postgresql 8.3 and when i run it there's a message error: could not create inherited socket: error code 10022 I tried to install without firewall antivirus i tried run lspfix : no problems found my config : windows xp sp3 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.o

Re: [BUGS] BUG #5066: plperl issues with perl_destruct() and END blocks

2009-09-20 Thread Alvaro Herrera
There's a definitional problem here however. When should we call the destructor? My impression is that it should happen when the calling query terminates, not when the backend shuts down. I'm sure this will cause other issues -- for example %_SHARED will be destroyed way too early. -- Alvaro H

[BUGS] Databse installation problem

2009-09-20 Thread Bhushan Verma
I have tried to install postgres version 8.3.7 as follows rm -rf /var/lib/pgsql mkdir /var/lib/pgsql ./configure --prefix /var/lib/pgsql gmake su gmake install adduser postgres mkdir /var/lib/pgsql/data chown postgres /var/lib/pgsql/data su - postgres /usr/local/pgsql/bin/initdb -D /var/lib/pgsql/