[BUGS] VACUUM ANALYZE

2004-07-29 Thread André Gomes
Your name:André Gomes Lamas Otero Your email address: [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : Alpha Operating System (example: Linux 2.4.18) : Linux 2.2 PostgreSQL version (example: PostgreSQL-7.4.2):

[BUGS] Strange AFTER UPDATE trigger behavior

2004-07-29 Thread Mason
POSTGRESQL BUG REPORT TEMPLATE Your name : mason Your email address : mason (at) vanten.com System Configuration - Archit

[BUGS] INDEX_MAX_KEYS too small, need 36 parameters

2004-07-29 Thread Hans Schou
POSTGRESQL BUG REPORT TEMPLATE Your name : Hans Schou Your email address : [EMAIL PROTE

[BUGS] 7.5dev assertion failure w/ v3 protocol and transactions

2004-07-29 Thread Kris Jurka
Running the JDBC driver's regression tests I came across an assertion failure in 7.5dev. The test does: BEGIN; SELECT 1/0; COMMIT; and gets the following stacktrace. Note this cannot be replicated in psql because it requires using the extended query protocol. Kris Jurka #0 0x402a5721 in k

Re: [BUGS] 7.5dev assertion failure w/ v3 protocol and transactions

2004-07-29 Thread Kris Jurka
On Thu, 29 Jul 2004, Kris Jurka wrote: > > Running the JDBC driver's regression tests I came across an assertion > failure in 7.5dev. The test does: > This also produces a second core file in the directory the postmaster was started in which contains: #0 0x402a5721 in kill () from /lib/l

Re: [BUGS] 7.5dev assertion failure w/ v3 protocol and transactions

2004-07-29 Thread Tom Lane
Kris Jurka <[EMAIL PROTECTED]> writes: > This also produces a second core file in the directory the postmaster was > started in which contains: > #0 0x402a5721 in kill () from /lib/libc.so.6 > #1 0x402a54c5 in raise () from /lib/libc.so.6 > #2 0x402a69e8 in abort () from /lib/libc.so.6 > #3 0

Re: [BUGS] 7.5dev assertion failure w/ v3 protocol and transactions

2004-07-29 Thread Kris Jurka
On Thu, 29 Jul 2004, Tom Lane wrote: > This appears to be here: > > ereport(PANIC, > (errcode_for_file_access(), > errmsg("could not open control file \"%s\": %m", > ControlFilePath))); > > but it's difficult to go any further wi

Re: [BUGS] 7.5dev assertion failure w/ v3 protocol and transactions

2004-07-29 Thread Tom Lane
Kris Jurka <[EMAIL PROTECTED]> writes: > Running the JDBC driver's regression tests I came across an assertion > failure in 7.5dev. The test does: > #3 0x082313c2 in ExceptionalCondition ( > conditionName=0x6 , > errorType=0x82546fb "FailedAssertion", fileName=0x403ab550 "`\022", >

Re: [BUGS] 7.5dev assertion failure w/ v3 protocol and transactions

2004-07-29 Thread Kris Jurka
On Thu, 29 Jul 2004, Tom Lane wrote: > There's no Assert at line 574 in CVS tip; how far back is your copy? > I think this might be related to some changes I made recently, so > please try if it still happens in CVS tip. > This is odd. I updated earlier today, and just to make sure I did a ma

Re: [BUGS] INDEX_MAX_KEYS too small, need 36 parameters

2004-07-29 Thread Peter Eisentraut
Hans Schou wrote: > I needed to have 36 function parameters. > PostgreSQL only allows 32. If you index more than three or four columns you're doing something wrong. Please explain in more detail why a practical application would need that many index columns. -- Peter Eisentraut http://develop