[HACKERS] Another pgindent gripe

2001-06-04 Thread Tom Lane
Why does pgindent sometimes insert whitespace into the return type part of a function definition? Here's an example from the last pgindent run: RCS file: /home/projects/pgsql/cvsroot/pgsql/src/backend/optimizer/plan/createplan.c,v retrieving revision 1.103 retrieving revision 1.104 diff -c -r1.1

Re: [HACKERS] Mirrors not tracking main ftp site?

2001-06-04 Thread Tom Lane
bpalmer <[EMAIL PROTECTED]> writes: > Found the problem. Since rsync gets a perms denied from .hidden, it > refuses to delete files. Ah-hah. And that directory seems to have appeared on 13 Apr, which is right about the time that the oldest un-deleted files on the mirrors are from: > ls -ld ~p

Re: [HACKERS] Re: [GENERAL] +/- Inf for float8's

2001-06-04 Thread Tom Lane
Thomas Lockhart <[EMAIL PROTECTED]> writes: > On a modestly related note, I'm come over to the notion that the > date/time value 'current' could be ripped out eventually. Tom, isn't > that the only case for those types which bolluxes up caching of > date/time types? Yes, I believe so. At least,

Re: [HACKERS] Question about inheritance

2001-06-04 Thread Stephan Szabo
On Tue, 5 Jun 2001, Christopher Kings-Lynne wrote: > Hi guys, > > It's relatively straightforward to allow check constraints to be inherited - > but is it really possible to ever do the same with primary, unique or even > foreign constraints? > > ie. Say a table has a primary key and I inherit

Re: [HACKERS] Question about inheritance

2001-06-04 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > Am I misunderstanding how the mechanism works, or is this a big, not easily > solved, problem? The latter. Check the list archives for previous debates about this. It's not real clear whether an inherited primary key should be expected to b

[HACKERS] Mirrors not tracking main ftp site?

2001-06-04 Thread Tom Lane
On hub, in /home/projects/pgsql/ftp/pub/dev I see *.tar.gz.md5postgresql-opt-snapshot.tar.gz doc postgresql-opt-snapshot.tar.gz.md5 postgresql-base-snapshot.tar.gz postgresql-snapshot.tar.gz postgresql-base-snapshot.tar.gz.md

Re: [HACKERS] Curious (mis)behavior of access rights

2001-06-04 Thread Tom Lane
"Matthew T. O'Connor" <[EMAIL PROTECTED]> writes: >> The only downside of this is that we'd lose the "feature" of being able >> to revoke from a particular user a right that is available via PUBLIC to >> everyone else. > Could we add additional privlideges that explicitly restrict a user? > Perha

[HACKERS] Curious (mis)behavior of access rights

2001-06-04 Thread Tom Lane
A question from Joe Mitchell led me to investigate some access-checking behavior that seems kinda broken. Currently, when aclinsert3() creates a new entry in an ACL list, it effectively initializes the entry with the current PUBLIC access rights, rather than with zero rights. Thus: regression=#

Re: [HACKERS] Re: Interesting Atricle

2001-06-04 Thread Nathan Myers
On Mon, Jun 04, 2001 at 04:55:13PM -0400, Bruce Momjian wrote: > > This is getting off-topic, but ... > > > > I keep CSS, Javascript, Java, dynamic fonts, and images turned off, and > > Netscape 4.77 stays up for many weeks at a time. I also have no Flash > > plugin. All together it makes for

Re: [HACKERS] Re: Interesting Atricle

2001-06-04 Thread Nathan Myers
On Sat, Jun 02, 2001 at 10:59:20AM -0400, Vince Vielhaber wrote: > On Fri, 1 Jun 2001, Bruce Momjian wrote: > > > > > Thought some people might find this article interesting. > > > > http://www.zend.com/zend/art/databases.php > > > > > > The only interesting thing I noticed is how fast it crashes