PgSql

[HACKERS] mremap and bus error
Hi, I playing with mmap. I have a problem with mremap function. It doesn't allocate correct memory. All others work well. static void * mmap_realloc(void *ptr, Size size) { Size oldsize; void *result; int i; char *x; ptr = (char *) ptr - MAXALIGN(sizeof(Size... 31 Mar 2010 12:07

[HACKERS] pgindent excluded files list
I propose that we create a file containing the list of patterns to exclude from pgindent runs. It would look like this: #list of file patterns to exclude from pg_indent runs /s_lock\.h$ /ecpg/test/expected/ /snowball/libstemmer/ /ecpg/include/(sqlda|sqltypes)\.h$ /ecpg/include/prepro... 31 Mar 2010 10:58

sorry, too many standbys already vs. MaxWalSendersvs. max_wal_senders
Robert Haas escribi�: On Wed, Mar 31, 2010 at 8:19 AM, Magnus Hagander <magnus(a)hagander.net> wrote: How about using errhint to tell the user which parameter to use? I thought about that. I noticed that the error message from the master gets displayed on the slave. I didn't check if an errhint wou... 31 Mar 2010 09:51

ECPG pointer vs array
On Wed, Mar 31, 2010 at 10:37:13AM +0200, Boszormenyi Zoltan wrote: It would be good if libecpg to support e.g. "char **strings" instead of "char *strings[]" for preallocated strings and the array of those. ... I'm open to improvements. The way ecpg accesses variables hasn't been changed for ages, just new... 31 Mar 2010 07:37

Performance Enhancement/Fix for Array Utility Functions
Woops. I sent the wrong patch. My apologies. Attached is the real patch. Sorry, also forgot this is made against 9.0 alpha 4 tag. Thanks, Mike -- Michael Lewis lolrus.org mikelikespie(a)gmail.com On Wed, Mar 31, 2010 at 12:39 AM, Mike Lewis <mikelikespie(a)gmail.com> wrote: I noticed while doing work... 31 Mar 2010 13:14

[HACKERS] ECPG pointer vs array
Hi, It would be good if libecpg to support e.g. "char **strings" instead of "char *strings[]" for preallocated strings and the array of those. IIRC, the first version overwrote my stack in a test programme, as these two are treated the same but they are not. Also, as "numeric" is supposed to be allocated using... 31 Mar 2010 05:27

[HACKERS] Performance Enhancement/Fix for Array Utility Functions
I noticed while doing work with very large arrays that several functions such as array_length detoast the entire array instead of only what is required. I found the solution to be just unpacking the header portion of the array and ignoring the rest. Since the header (including the dimensions) is variable length... 31 Mar 2010 04:22

[HACKERS] Feature request - function-based deferrable uniques.
For now Postgres able to create deferrable uniques with following syntax: .... and table_constraint is: [ CONSTRAINT constraint_name ] { UNIQUE ( column_name [, ... ] ) index_parameters | PRIMARY KEY ( column_name [, ... ] ) index_parameters | CHECK ( expression ) | FOREIGN KEY ( column_name [, ... ] )... 31 Mar 2010 02:13

[HACKERS] sorry, too many standbys already vs. MaxWalSenders vs. max_wal_senders
After snapshotting my master using hot backup to create a workable slave instance, I created recovery.conf on the slave and tried to get it to connect to the master and stream WAL. This led to the message "sorry, too many standbys already", which did not immediately clue me in as to what I needed to do to fix the... 31 Mar 2010 00:03

[HACKERS] OK for ABI break of PlannerInfo in 8.4?
Marc Cousins pointed out here http://archives.postgresql.org/pgsql-general/2010-03/msg01123.php that the "constraint_exclusion = partition" feature added in 8.4 does not do what you'd expect for the target relation of an UPDATE or DELETE. That's because expansion of an inheritance set is managed differently for a... 30 Mar 2010 11:38