[BUGS] BUG #1242: Major bug in pgSQL

2004-09-07 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1242 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.3 Operating system: Linux Debian 3.1 Description:Major bug in pgSQL Details: Hi, apparently we have found a critical bug in

[BUGS] BUG #1243: Driver problem

2004-09-07 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1243 Logged by: Hanna Tapani Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.2 Operating system: Solaris Description:Driver problem Details: SQLException: Something unusual has occured to cause

Re: [BUGS] BUG #1242: Major bug in pgSQL

2004-09-07 Thread Gaetano Mendola
PostgreSQL Bugs List wrote: Problem: in some cases we experience the following problem - we have found in the database some _absolutely_ identical rows, despite the fact, that we have defined some unique (!) indexes on some of the fields and even primary (!) keys, we can see, that the rows are

Re: [BUGS] BUG #1242: Major bug in pgSQL

2004-09-07 Thread Tom Lane
Gaetano Mendola [EMAIL PROTECTED] writes: When you are experiencing this show us the result of this query: select cmax, cmin, xmax, xmin, * from table where your condition; Also, please, the ctid and oid columns (but leave out oid if you made the table WITHOUT OIDS). Also, if the condition is

Re: [PATCHES] [pgsql-hackers-win32] [BUGS] Win32 deadlock detection not working for Postgres8beta1

2004-09-07 Thread Tom Lane
Magnus Hagander [EMAIL PROTECTED] writes: How does this fix that case? It doesn't. This is why the second version of the patch was required, per http://archives.postgresql.org/pgsql-patches/2004-09/msg00039.php. Okay, I've applied the right version of the patch now ;-)

Re: [BUGS] BUG #1244: Postgres doesn't work on FAT

2004-09-07 Thread Harald Armin Massa
Hello, in the release notes there is a FAT is not really supported notice for PostgreSQL. I suggest following workaround: create a cacls.exe and put it first in the search path. That cacls.exe should just return OK no matter of the imput-params. Be warned that FAT is not really supported has

[BUGS] PosgreSQL is crashing with a signal 11 - Bug?

2004-09-07 Thread Rafael Martinez Guerrero
Hello We have a problem with one of our central databases and we need your help to find a solution. -- * Description: -- PosgreSQL is crashing with a signal 11 and we do not think is a hardware problem :( Since last week, we are having a big problem with

Re: [BUGS] PosgreSQL is crashing with a signal 11 - Bug?

2004-09-07 Thread Tom Lane
Rafael Martinez Guerrero [EMAIL PROTECTED] writes: * Information from CORE dump we got with --enable-debug. We have compiled a new version of postgres and run it through gdb with the core dump we had/got from postgres without --enable-debug.=20 Okay, theoretically that works, but it might be

Re: [BUGS] PosgreSQL is crashing with a signal 11 - Bug?

2004-09-07 Thread Rafael Martinez
On Tue, 2004-09-07 at 19:58, Tom Lane wrote: Rafael Martinez Guerrero [EMAIL PROTECTED] writes: * Information from CORE dump we got with --enable-debug. We have compiled a new version of postgres and run it through gdb with the core dump we had/got from postgres without --enable-debug.=20

Re: [BUGS] PosgreSQL is crashing with a signal 11 - Bug?

2004-09-07 Thread Tom Lane
Rafael Martinez [EMAIL PROTECTED] writes: Hmm, what do you get from x/10 3054556648 ? (gdb) x/10 3054556648 0xb610d5e8: 0x2f0c 0x0002 0x3017 0x020c6172 0xb610d5f8: 0x 0x 0x00ae 0x0006002b 0xb610d608: 0x2f1c0913

Re: [BUGS] PosgreSQL is crashing with a signal 11 - Bug?

2004-09-07 Thread Tom Lane
Rafael Martinez [EMAIL PROTECTED] writes: I got this from one of our developers (from the core dump generated by 7.3.7 without --enable-debug): (gdb) inspect *att[i] $3 = {attrelid = 0, attname = {data = '\0' repeats 63 times, alignmentDummy = 0}, atttypid = 1700, attstattarget = -1, attlen