Re: [HACKERS] Failure on tapir / only 10 max connections?

2006-11-11 Thread Simon Riggs
On Fri, 2006-11-10 at 23:31 -0600, Jim C. Nasby wrote: > BTW, does make check log it's initdb output anywhere? It'd be handy if > it did... They are logged in src/test/regress/log/initdb.log but the make check failure message gives a relative filename, so you have to know what the upper part of t

[HACKERS] Dumb user question re: updates, Toast, HOT

2006-11-11 Thread Richard Huxton
The recent discussion on the proposed HOT scheme has reminded me of a question I meant to ask about TOASTing when it was introduced back in 7.1(?) If I have a table something like: (id, status, big_text) and just update the "status" column on a row, do I have two copies of "big_text" TOASTED o

Re: [HACKERS] Failure on tapir / only 10 max connections?

2006-11-11 Thread Andrew Dunstan
Simon Riggs wrote: > On Fri, 2006-11-10 at 23:31 -0600, Jim C. Nasby wrote: > >> BTW, does make check log it's initdb output anywhere? It'd be handy if >> it did... > > They are logged in src/test/regress/log/initdb.log > but the make check failure message gives a relative filename, so you > have t

[HACKERS] Giving up multiple postmaster + RPM issue

2006-11-11 Thread Devrim GUNDUZ
Hello, As some of you already know, I have been working on multiple postmaster + RPM issue for some time. We are approaching 8.2.0, and I still could not complete this. Also, I'm having problems with my eyes which prevents me working (for long hours) (Vision Fatigue); so I want to give up this i

Re: [HACKERS] Dumb user question re: updates, Toast, HOT

2006-11-11 Thread Andrew - Supernews
On 2006-11-11, Richard Huxton wrote: > The recent discussion on the proposed HOT scheme has reminded me of a > question I meant to ask about TOASTing when it was introduced back in 7.1(?) > > If I have a table something like: (id, status, big_text) and just update > the "status" column on a row,

Re: [HACKERS] [JDBC] server process (PID 1188) exited with exit code -1073741819, 8.2 beta1

2006-11-11 Thread Tom Lane
Dave Cramer <[EMAIL PROTECTED]> writes: > This is a server bug, I will post to hackers for you, it has little > to do with JDBC, however the ? can't be a column in a prepared statement I cannot reproduce any problem using what I think is equivalent in libpq: /* Here is our out-of-line param

Re: [HACKERS] [PATCHES] [BUGS] BUG #2704: pg_class.relchecks overflow problem

2006-11-11 Thread Tom Lane
Toru SHIMOGAKI <[EMAIL PROTECTED]> writes: > + if (numchecks == 0x7FFF) > + ereport(ERROR, > + > (errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED), > + errmsg("cannot have more than 2^15-1 checks in a > table"))); W