Re: [HACKERS] Unixware Patch (Was: Re: Beta2 Tag'd and Bundled ...)

2003-09-13 Thread Bruce Momjian
[ I have retained the original email below so people can remember where we left this.] After much agonizing, I have applied a patch to attempt threading in this order: use non-*_r function names if they are all thread-safe (NEED_REENTRANT_FUNCS=no) use *_r functions if

Re: [HACKERS] Another small bug (pg_autovacuum)

2003-09-13 Thread Bruce Momjian
Patch applied as part of Christopher Browne's patch. --- Matthew T. O'Connor wrote: On Fri, 2003-09-12 at 09:35, Bruce Momjian wrote: Matthew T. O'Connor wrote: I made a patch to fix this, but in testing it I noticed

Re: [HACKERS] Another small bug (pg_autovacuum)

2003-09-13 Thread Bruce Momjian
This was a combined patch including Matthew T. O'Connor's Patch. Applied. Thanks. --- Christopher Browne wrote: [EMAIL PROTECTED] (Matthew T. O'Connor) writes: OK, well as we wait on the fix for the stats system, let

[HACKERS] Link.shared help

2003-09-13 Thread Larry Rosenman
With the patch I supplied for UnixWare for absolute pathnames, I've created a chicken and egg problem. I need to be able to set $(libdir) to nada during build, and link, and then re-link the shared libs on the install with $(libdir) set correctly. The reason is: gmake[4]: Entering directory

Re: [HACKERS] memory allocation and powers of two

2003-09-13 Thread Tom Lane
David Schultz [EMAIL PROTECTED] writes: While looking into a block size mismatch problem between Postgresql and FreeBSD's FFS, I noticed that postgresql is making some rather odd-sized requests to malloc(3): 0x2034, 0x2020, 0x4018, 0x8018, etc. Most malloc(3) implementations round large

Re: [HACKERS] Problem with function permission test in a view

2003-09-13 Thread Gaetano Mendola
Bruce Momjian [EMAIL PROTECTED] wrote: Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Someone asked me a question about view and function permissions. I assumed all object access done by a view would be based on the permissions on the view, and not the permissions of the

Re: [HACKERS] memory allocation and powers of two

2003-09-13 Thread Tom Lane
David Schultz [EMAIL PROTECTED] writes: ... I assume that pgsql will be able to use the slack allocated in each chunk. That's the theory, anyway. Undoubtedly the extra allocation will go to waste in some scenarios, but we're no worse off than we were before. regards,

Re: [HACKERS] massive quotes?

2003-09-13 Thread Tom Lane
Attached is a proof-of-concept diff that makes the main SQL parser accept quoted strings in the style recently discussed ($Q$ ... $Q$). To complete the feature, we'd need to make the plpgsql parser do the same, update psql to understand this, update pg_dump to use this style of quoting for