[BUGS] Bugs

2008-01-29 Thread Abhay Kumar
Hi, I am installing the Postgis 2.2.1 on PostgreSQL. I am acing the error: 1. Download postgis-1.2.1.tar.gz from http://postgis.refractions.net/download/ to /usr/share/postgresql/8.1/contrib 2. tar xvzf postgis-1.2.1.tar.gz cd postgis-1.2.1 ./configur

[BUGS] BUG #3910: Incorrect behavior of UPDATE statement on tables with constraints UNIQUE/PRIMARY KEY

2008-01-29 Thread Dmitry Afanasiev
The following bug has been logged online: Bug reference: 3910 Logged by: Dmitry Afanasiev Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.19 Operating system: FreeBSD 7.0 / 5.5 Description:Incorrect behavior of UPDATE statement on tables with constraints UNIQ

Re: [BUGS] Bugs

2008-01-29 Thread Gregory Stark
"Abhay Kumar" <[EMAIL PROTECTED]> writes: > Hi, > I am installing the Postgis 2.2.1 on PostgreSQL. I think you would be better off speaking to this mailing list: http://postgis.refractions.net/mailman/listinfo/postgis-users -- Gregory Stark EnterpriseDB http://www.enterprise

[BUGS] BUG #3897: plJava dll still doesn't load for 8.3RC2

2008-01-29 Thread David JL Gradwell
Dave & Kris, I've dug into some of the problems I've been having in a bit more logical detail. A useful tool is Dependency Walker http://www.dependencywalker.com/ Try running this against pljava.dll. You will get varying results, depending on the PATH and whether you have PostgreSQL 8.2 or 8.3

Re: [BUGS] BUG #3910: Incorrect behavior of UPDATE statement on tables with constraints UNIQUE/PRIMARY KEY

2008-01-29 Thread David Fetter
On Tue, Jan 29, 2008 at 09:45:28AM +, Dmitry Afanasiev wrote: > > The following bug has been logged online: > > Bug reference: 3910 > Logged by: Dmitry Afanasiev > Email address: [EMAIL PROTECTED] > PostgreSQL version: 7.4.19 > Operating system: FreeBSD 7.0 / 5.5 > Descri

Re: [BUGS] BUG #3910: Incorrect behavior of UPDATE statement on tables with constraints UNIQUE/PRIMARY KEY

2008-01-29 Thread Alvaro Herrera
Dmitry Afanasiev wrote: > Constraints must be checked AFTER updating ALL of rows, but really after > every row. > For illustrate try this simple sql script: > CREATE TABLE n(n INTEGER PRIMARY KEY); > INSERT INTO n VALUES(1); > INSERT INTO n VALUES(2); > INSERT INTO n VALUES(3); > UPDATE n SET n =

Re: [BUGS] BUG #3902: Segmentation faults using GSSAPI authentication

2008-01-29 Thread Peter Koczan
> > No, we want a stack trace from the crash. You could attach gdb to the > > child process after forking and before you provoke the crash; or arrange > > for a core dump file to be produced and gdb that. > > I should be able to get that for you tomorrow, if we don't figure out > the issue sooner.

Re: [BUGS] BUG #3897: plJava dll still doesn't load for 8.3RC2

2008-01-29 Thread Dave Page
On Jan 29, 2008 3:33 PM, David JL Gradwell <[EMAIL PROTECTED]> wrote: > Dave & Kris, > > From this I deduce that the MSVCR80.dll needs to be distributed in the > PostreSQL distribution for Windows. It is - without it, PostgreSQL wouldn't even run (or pgAdmin, StackBuilder etc for that matter). We

[BUGS] BUG #3911: can not 'make'

2008-01-29 Thread ted petrosky
The following bug has been logged online: Bug reference: 3911 Logged by: ted petrosky Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3RC2 Operating system: os x Description:can not 'make' Details: Ok, what am I doing wrong? I downloaded RC2 and config with:

Re: [BUGS] BUG #3911: can not 'make'

2008-01-29 Thread Tom Lane
Theodore Petrosky <[EMAIL PROTECTED]> writes: > when I check the results/float4.out I see: > psql: FATAL: sorry, too many clients already Hah. Check what initdb set max_connections to, and run the tests with fewer clients than that: make MAX_CONNECTIONS=n check In the long run you'll wa

Re: [BUGS] BUG #3911: can not 'make'

2008-01-29 Thread Theodore Petrosky
10.5.1 a new install on a separate HD. Xcode 3 was installed fresh (as the HD was freshly formatted) intel (quad processor) Ted --- Tom Lane <[EMAIL PROTECTED]> wrote: > "ted petrosky" <[EMAIL PROTECTED]> writes: > > PostgreSQL version: 8.3RC2 > > Operating system: os x > > Description:

Re: [BUGS] BUG #3911: can not 'make'

2008-01-29 Thread Tom Lane
"ted petrosky" <[EMAIL PROTECTED]> writes: > PostgreSQL version: 8.3RC2 > Operating system: os x > Description:can not 'make' OS X which? And is this PPC or Intel hardware? > Ok, what am I doing wrong? I downloaded RC2 and config with: > ./configure --with-libedit-preferred --enable-

Re: [BUGS] BUG #3911: can not 'make'

2008-01-29 Thread Theodore Petrosky
so I just tried uninstalling and reinstalling Xcode3 same result. will it help to see the actual logs? Ted --- Tom Lane <[EMAIL PROTECTED]> wrote: > "ted petrosky" <[EMAIL PROTECTED]> writes: > > PostgreSQL version: 8.3RC2 > > Operating system: os x > > Description:can not 'make' >

Re: [BUGS] BUG #3911: can not 'make'

2008-01-29 Thread Tom Lane
Theodore Petrosky <[EMAIL PROTECTED]> writes: > 10.5.1 a new install on a separate HD. Xcode 3 was > installed fresh (as the HD was freshly formatted) > intel (quad processor) Hmmm ... 10.5 on Intel is the one case that's not getting exercised on a fairly regular basis (either by the buildfarm or

Re: [BUGS] BUG #3911: can not 'make'

2008-01-29 Thread Theodore Petrosky
So the solution is to create a file /etc/sysctl.conf with the following: kern.sysv.shmmax=33554432 kern.sysv.shmmin=1 kern.sysv.shmmni=32 kern.sysv.shmseg=8 kern.sysv.shmall=65536 I went looking for my rc.conf and can not find it under os 10.5... Apple must have moved it again. If someone very

Re: [BUGS] BUG #3911: can not 'make'

2008-01-29 Thread Tom Lane
Theodore Petrosky <[EMAIL PROTECTED]> writes: > So the solution is to create a file /etc/sysctl.conf > with the following: > kern.sysv.shmmax=33554432 > kern.sysv.shmmin=1 > kern.sysv.shmmni=32 > kern.sysv.shmseg=8 > kern.sysv.shmall=65536 > I went looking for my rc.conf and can not find it > und

Re: [BUGS] BUG #3902: Segmentation faults using GSSAPI authentication

2008-01-29 Thread Tom Lane
"Peter Koczan" <[EMAIL PROTECTED]> writes: > Program received signal SIGSEGV, Segmentation fault. > 0x0056bfde in getenv () from /lib/libc.so.6 > (gdb) bt > #0 0x0056bfde in getenv () from /lib/libc.so.6 > #1 0x005c1490 in tzset_internal () from /lib/libc.so.6 > #2 0x005c1fad in tzset () from /l