Re: [HACKERS] Avoiding legal email signatures

2007-06-10 Thread Andrew Sullivan
On Sat, Jun 09, 2007 at 06:14:00PM -0400, Bruce Momjian wrote: I know we have talked about how to avoid legal email signatures on this list. One idea would be for a small percentage of our users to ignore emails with a legal signature. I know I am less likely to reply to such an email. The

Re: [HACKERS] Avoiding legal email signatures

2007-06-10 Thread Greg Smith
On Sat, 9 Jun 2007, Bruce Momjian wrote: If enough people do that, it might coerce people to avoid them, and perhaps we could put something in the FAQ about it. You should just say flat-out that the terms of the mailing list are incompatible with confidentiality and similar legal disclaimers

Re: [HACKERS] Avoiding legal email signatures

2007-06-10 Thread Greg Smith
On Sun, 10 Jun 2007, Andrew Sullivan wrote: Moreover, people who are in such environments are often prevented from visiting gmail, hotmail, or the other likely suspects in order to send their messages in circumvention of corporate policy. This is all true, but the reality here is that people

Re: [HACKERS] Avoiding legal email signatures

2007-06-10 Thread Joshua D. Drake
Bruce Momjian wrote: I know we have talked about how to avoid legal email signatures on this list. One idea would be for a small percentage of our users to ignore emails with a legal signature. I know I am less likely to reply to such an email. Bah Bruce come on. The people that are

Re: [HACKERS] Avoiding legal email signatures

2007-06-10 Thread Joshua D. Drake
Greg Smith wrote: On Sat, 9 Jun 2007, Bruce Momjian wrote: If enough people do that, it might coerce people to avoid them, and perhaps we could put something in the FAQ about it. You should just say flat-out that the terms of the mailing list are incompatible with confidentiality and

Re: [HACKERS] Avoiding legal email signatures

2007-06-10 Thread Andrew Sullivan
On Sun, Jun 10, 2007 at 12:50:11PM -0400, Greg Smith wrote: This is all true, but the reality here is that people in such a situation are usually flat-out violating their corporate policy by posting to the list at all from inside this kind of company. We don't know that in advance, and we

Re: [HACKERS] little PITR annoyance

2007-06-10 Thread ohp
Hi Simon, Sorry for replying so late... On Fri, 8 Jun 2007, Simon Riggs wrote: Date: Fri, 08 Jun 2007 20:16:35 +0100 From: Simon Riggs [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: pgsql-hackers list pgsql-hackers@postgresql.org Subject: Re: [HACKERS] little PITR annoyance Hi Olivier, On

Re: [HACKERS] Controlling Load Distributed Checkpoints

2007-06-10 Thread Heikki Linnakangas
Jim C. Nasby wrote: On Thu, Jun 07, 2007 at 10:16:25AM -0400, Tom Lane wrote: Heikki Linnakangas [EMAIL PROTECTED] writes: Thinking about this whole idea a bit more, it occured to me that the current approach to write all, then fsync all is really a historical artifact of the fact that we

[HACKERS] ecpg leaves broken files around

2007-06-10 Thread Magnus Hagander
When working on the ecpg regression stuff things, it's the first time I've actually used ecpg. And I notice now that it leaves incomplete and broken files around when it fails. For example, I currently get: parser.pgc:26: ERROR: syntax error at or near NULLS when building. I have to

Re: [HACKERS] little PITR annoyance

2007-06-10 Thread Simon Riggs
On Sun, 2007-06-10 at 20:48 +0200, [EMAIL PROTECTED] wrote: My questions was: why don't we start the archiving *BEFORE* postmaster to make room. The archiver is executed from the postmaster, so thats not possible. I'm aware of that, my point is maybe the archiver doesn't need

Re: [HACKERS] Updatable cursors thoughts

2007-06-10 Thread Simon Riggs
On Sat, 2007-06-09 at 16:25 -0400, Tom Lane wrote: What I think we could do instead is not change any existing behavior of cursor declarations, but when WHERE CURRENT OF is used, dig through the execution node tree of the cursor to find the scan node for the target table. Sounds good. The

Re: [HACKERS] Truncate Permission

2007-06-10 Thread Stephen Frost
* Tom Lane ([EMAIL PROTECTED]) wrote: Nick Barr [EMAIL PROTECTED] writes: I was looking to start development on the following TODO entry. Add a separate TRUNCATE permission Is there actually a use-case for that? It seems like mostly pointless complication to me. (Note that in the role

Re: [HACKERS] Updatable cursors thoughts

2007-06-10 Thread Tom Lane
Simon Riggs [EMAIL PROTECTED] writes: Sounds good. The cost is paid by the WHERE CURRENT OF query, not as an overhead on all cursors. Sounds like it will still be very fast too. Yeah, there's zero added cost in the existing code paths, and the lookup isn't really that expensive. Presumably

[HACKERS] What's with the StartDb:2 failures on skylark?

2007-06-10 Thread Tom Lane
Every so often, buildfarm member skylark reports a StartDb:2 failure, as for instance here: http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=skylarkdt=2007-06-10%2023:00:01 but the logs contain no trace of any actual failure. What's happening, and why is the buildfarm failing to record any

Re: [HACKERS] Stats not updated after rollback -- autovacuum confused.

2007-06-10 Thread Alvaro Herrera
Bruce Momjian escribió: This has been saved for the 8.4 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold FWIW this has been fixed in 8.3, you can drop the item from the 8.4 queue. Thanks. ---

Re: [HACKERS] Stats not updated after rollback -- autovacuum confused.

2007-06-10 Thread Bruce Momjian
Removed. --- Alvaro Herrera wrote: Bruce Momjian escribi?: This has been saved for the 8.4 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold FWIW this has been fixed in 8.3, you can drop the

Re: [HACKERS] Stats not updated after rollback -- autovacuum confused.

2007-06-10 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: FWIW this has been fixed in 8.3, you can drop the item from the 8.4 queue. Thanks. There are a couple of other things on that page that seem already applied, for instance hashing for numeric and an early form of the seq scan ringbuffer patch. While

Re: [HACKERS] Stats not updated after rollback -- autovacuum confused.

2007-06-10 Thread Bruce Momjian
Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: FWIW this has been fixed in 8.3, you can drop the item from the 8.4 queue. Thanks. There are a couple of other things on that page that seem already applied, for instance hashing for numeric and an early form of the seq scan