Re: [BUGS] BUG #4771: Postgres wont start

2009-04-21 Thread tushar
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Christine Penner wrote: > The following bug has been logged online: > > Bug reference: 4771 > Logged by: Christine Penner > Email address: christi...@telus.net > PostgreSQL version: 8.3.7 > Operating system: Vista > Description:

[BUGS] BUG #4771: Postgres wont start

2009-04-21 Thread Christine Penner
The following bug has been logged online: Bug reference: 4771 Logged by: Christine Penner Email address: christi...@telus.net PostgreSQL version: 8.3.7 Operating system: Vista Description:Postgres wont start Details: I have had Postgres running and working on the co

Re: [BUGS] BUG #4770: Error initializing slon in command line and hence running Slony

2009-04-21 Thread Dave Page
On Tue, Apr 21, 2009 at 8:22 PM, Quincy wrote: > > What I found as a work around was to first stop the posgres service, then > use the libiconv-2.dll > > (947kb) originally installed by postgres and by either renaming or moving > that file to then > > overwrite the libiconv-2.dll created by the sl

[BUGS] BUG #4770: Error initializing slon in command line and hence running Slony

2009-04-21 Thread Quincy
The following bug has been logged online: Bug reference: 4770 Logged by: Quincy Email address: qj_qwe...@hotmail.com PostgreSQL version: 8.3.7 Operating system: Windows Vista Description:Error initializing slon in command line and hence running Slony Details: Hello

[BUGS] Automatic login deactivated in Windows 7

2009-04-21 Thread Vins
Hi, I want to report a little bug I've encountered in Windows 7... With the latest version 8.3.7 finally it install and works fine, except for the automatic login that it deactivated (in WinXP and WinVista it doesn't)... For example: if I have only one user on my pc, without password and with au

Re: [BUGS] BUG #4768: FATAL:could not reattach to shared memory:487

2009-04-21 Thread Ghislain ROUVIGNAC
Thanks for your answer. Stoping/starting the server does not solve the problem. It reappears quickly. As a work around I still run my DB on Linux Red Hat with Postgres 8.1, but i would like to move to the new Windows 2008 server. How can I know when a fix will be released ? -Message d'

Re: [BUGS] BUG #4768: FATAL:could not reattach to shared memory:487

2009-04-21 Thread Bruce Momjian
Ghislain ROUVIGNAC wrote: > I didn't tried to reboot the windows server. > I'll try it when i will have time. > > > Thank you for the references to the problem. OK, let us know if it does not fix the problem. As you can see this bug has been around for a while. -- Bruce Momjian htt

Re: [BUGS] BUG #4768: FATAL:could not reattach to shared memory:487

2009-04-21 Thread Bruce Momjian
Bruce Momjian wrote: > Ghislain ROUVIGNAC wrote: > > Thanks for your answer. > > > > > > Stoping/starting the server does not solve the problem. > > It reappears quickly. > > > > As a work around I still run my DB on Linux Red Hat with Postgres 8.1, but i > > would like to move to the new Window

Re: [BUGS] BUG #4768: FATAL:could not reattach to shared memory:487

2009-04-21 Thread Bruce Momjian
Ghislain ROUVIGNAC wrote: > Thanks for your answer. > > > Stoping/starting the server does not solve the problem. > It reappears quickly. > > As a work around I still run my DB on Linux Red Hat with Postgres 8.1, but i > would like to move to the new Windows 2008 server. > > > How can I know w

Re: [BUGS] BUG #4765: GIST box Segfaulting on Inserts

2009-04-21 Thread Tom Lane
"Paolo Saul" writes: > [ apparently infinite recursion in gistSplit ] This may be the same problem identified a couple of weeks ago. Does this patch fix it? http://archives.postgresql.org/pgsql-committers/2009-04/msg00076.php regards, tom lane -- Sent via pgsql-bugs ma

Re: [BUGS] BUG #4768: FATAL:could not reattach to shared memory:487

2009-04-21 Thread Bruce Momjian
This is a known problem. I think stoping/starting the server will fix it. We hope to find the cause soon. --- grouvi wrote: > > The following bug has been logged online: > > Bug reference: 4768 > Logged by:

Re: [BUGS] bitfromint4() in v7.2.3 to bit() in v8.1?

2009-04-21 Thread Tom Lane
=?ISO-8859-1?B?Qmr2cm4g3vNyIErzbnNzb24=?= writes: > In version 7.2.3 this works fine: > select substring(bitfromint4(cast (-2^31 + 22 as int4)), 1, 32); > and now I'm porting the legacy code, that this line is part of, to version > 8.1 but am having no luck updating it - have tried something lik

[BUGS] BUG #4769: xmlconcat produces invalid xml values -> data corruption

2009-04-21 Thread Arjen Nienhuis
The following bug has been logged online: Bug reference: 4769 Logged by: Arjen Nienhuis Email address: a.g.nienh...@gmail.com PostgreSQL version: 8.3.7 Operating system: Ubuntu 8.10 and 9.04 Description:xmlconcat produces invalid xml values -> data corruption Details:

Re: [BUGS] BUG #4767: create operator - negator doesn't work

2009-04-21 Thread Peter Eisentraut
On Tuesday 21 April 2009 14:04:01 fduerr wrote: > CREATE OR REPLACE FUNCTION eq_int_bool(INTEGER, BOOLEAN) RETURNS BOOLEAN AS > 'SELECT CAST($1 AS BOOLEAN)=$2;' LANGUAGE SQL IMMUTABLE; > CREATE OPERATOR = ( > LEFTARG=INTEGER, > RIGHTARG=BOOLEAN, > PROCEDURE=eq_int_bool, > COMMUTATOR= = , > NE

[BUGS] BUG #4768: FATAL:could not reattach to shared memory:487

2009-04-21 Thread grouvi
The following bug has been logged online: Bug reference: 4768 Logged by: grouvi Email address: g...@sylob.com PostgreSQL version: 8.3.7 Operating system: Windows 2008 x64 Description:FATAL:could not reattach to shared memory:487 Details: Symptoms: My DB update scrip

[BUGS] BUG #4767: create operator - negator doesn't work

2009-04-21 Thread fduerr
The following bug has been logged online: Bug reference: 4767 Logged by: fduerr Email address: fdu...@gmx.de PostgreSQL version: 8.3.x 8.4.b1 Operating system: Debian Lenny Description:create operator - negator doesn't work Details: Hi, my apologies beforehand in ca

[BUGS] BUG #4766: i cant setup a program

2009-04-21 Thread Robert
The following bug has been logged online: Bug reference: 4766 Logged by: Robert Email address: robb...@rambler.ru PostgreSQL version: 8.3.7-1 Operating system: Windows XP Professional Description:i cant setup a program Details: Installation directory -> next Data di

[BUGS] BUG #4765: GIST box Segfaulting on Inserts

2009-04-21 Thread Paolo Saul
The following bug has been logged online: Bug reference: 4765 Logged by: Paolo Saul Email address: paolo.s...@telogis.com PostgreSQL version: 8.3.5 Operating system: RHEL5 x64 Description:GIST box Segfaulting on Inserts Details: We have a table with GIST indexes on

[BUGS] Segfaults When Inserting into a Geom Index

2009-04-21 Thread Paolo Saul
Hi Everyone, We have a Database ( 8.3.5) on RHEL5 x64. It recently ran into Segmentation Faults when inserting rows over a Geom Index. This happened several times this last weekend. The fix was to drop or reindex it. We have set it to dump core at the moment. Any insights into this? Thanks, Jea

[BUGS] bitfromint4() in v7.2.3 to bit() in v8.1?

2009-04-21 Thread Björn Þór Jónsson
Hi, In version 7.2.3 this works fine: select substring(bitfromint4(cast (-2^31 + 22 as int4)), 1, 32); and now I'm porting the legacy code, that this line is part of, to version 8.1 but am having no luck updating it - have tried something like: select substring(bit(cast (-2^31 + 22 as int4)), 1,