[PATCHES] Updated kerberos service name patch

2005-05-09 Thread Magnus Hagander
Here is an updated version of the patch from http://candle.pha.pa.us/mhonarc/patches2/msg00025.html. It handles the options for libpq connections the same way other options are handled, and it also updates the kerberos documentation. It contains a couple of minor changes to the Kerberos documentati

Re: [PATCHES] Added columns to pg_stat_activity

2005-05-09 Thread Neil Conway
Tom Lane wrote: If the stats collector gets sufficiently backed up, you will lose messages. [...] Please do not try to make piecemeal changes in that basic design decision. Fair enough. > (Actually, we could skinny it down to backend PID only ... but that would add a hashtable lookup to every mess

Re: [PATCHES] Added columns to pg_stat_activity

2005-05-09 Thread Magnus Hagander
Certainly seems that way. Missed a .diff for the rules output there... Should be a simple replace, from what I can tell what's in the output on the buildfarm boxes I checked is correct, the expected file shuold changed. Oops. //Magnus > > Is this what broke the regression tests on HEAD? > > c

Re: [PATCHES] Added columns to pg_stat_activity

2005-05-09 Thread Andrew Dunstan
Is this what broke the regression tests on HEAD? cheers andrew Neil Conway wrote: Tom Lane wrote: If the stats collector gets sufficiently backed up, you will lose messages. [...] Please do not try to make piecemeal changes in that basic design decision. Fair enough. > (Actually, we could skinny

Re: [PATCHES] Added columns to pg_stat_activity

2005-05-09 Thread Neil Conway
Andrew Dunstan wrote: Is this what broke the regression tests on HEAD? Yes, it is -- fix checked in to HEAD. My apologies for missing this. -Neil ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscr

[PATCHES] csv header feature regression test

2005-05-09 Thread Andrew Dunstan
tiny patch to test this feature. cheers andrew Index: input/copy.source === RCS file: /home/cvsmirror/pgsql/src/test/regress/input/copy.source,v retrieving revision 1.11 diff -c -r1.11 copy.source *** input/copy.source 16 Mar 2005 06:0

Re: [PATCHES] csv header feature regression test

2005-05-09 Thread Neil Conway
Andrew Dunstan wrote: tiny patch to test this feature. Applied, thanks. -Neil ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [PATCHES] Dealing with CLUSTER failures

2005-05-09 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > I looked over this item, originally posted as: > > http://archives.postgresql.org/pgsql-hackers/2005-03/msg01055.php > > I still think this is substantial complication (more than likely > introducing some bugs) to deal with a non problem. > > http:

Re: [PATCHES] Dealing with CLUSTER failures

2005-05-09 Thread Bruce Momjian
Christopher Kings-Lynne wrote: > Seems like an idea to me... > > On another note, what about the problem I pointed out where it's not > possible to drop the default on a serial column after you alter it to a > varchar, for example... Uh, should we allow a columns data type to be changed if it h

Re: [PATCHES] Update psql and pg_dump for new COPY api

2005-05-09 Thread Bruce Momjian
Path withdrawn by author. --- Christopher Kings-Lynne wrote: > This patch updates psql and pg_dump to use the new copy api. Probably > needs some review. > > I have tested it with dos and unix newlines, etc. > > Chris C

[PATCHES] Translation updates: pt_BR

2005-05-09 Thread Euler Taveira de Oliveira
Hi, This is translation updates for branchs 7.4 and 8.0. http://br.geocities.com/eulerto/nls_74_pt-br.tgz http://br.geocities.com/eulerto/nls_80_pt-br.tgz Please apply. Euler Taveira de Oliveira euler[at]yahoo_com_br __ Converse com seus amigos

Re: [PATCHES] [HACKERS] read-only database

2005-05-09 Thread Bruce Momjian
Satoshi Nagayasu wrote: > > Satoshi Nagayasu wrote: > > I wanted to make the postmaster read-only, and found > > "default_transaction_read_only" option, but it can be overwritten. > > I mean it can be overridden by the user. I don't want that. I understand, but we haven't gotten enough requests

Re: [PATCHES] [HACKERS] read-only database

2005-05-09 Thread Alvaro Herrera
On Mon, May 09, 2005 at 10:13:22PM -0400, Bruce Momjian wrote: > Satoshi Nagayasu wrote: > > > > Satoshi Nagayasu wrote: > > > I wanted to make the postmaster read-only, and found > > > "default_transaction_read_only" option, but it can be overwritten. > > > > I mean it can be overridden by the u

Re: [PATCHES] [HACKERS] read-only database

2005-05-09 Thread Bruce Momjian
Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > The ability to have PGDATA in read-only media (like CDs) has been > > requested a lot of times, hasn't it? > > It's come up a few times ... more than an un-overridable read-only mode > anyway. Also, I should think that those who wan

Re: [PATCHES] [HACKERS] read-only database

2005-05-09 Thread Bruce Momjian
Alvaro Herrera wrote: > On Mon, May 09, 2005 at 10:13:22PM -0400, Bruce Momjian wrote: > > Satoshi Nagayasu wrote: > > > > > > Satoshi Nagayasu wrote: > > > > I wanted to make the postmaster read-only, and found > > > > "default_transaction_read_only" option, but it can be overwritten. > > > > >

Re: [PATCHES] [HACKERS] read-only database

2005-05-09 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > The ability to have PGDATA in read-only media (like CDs) has been > requested a lot of times, hasn't it? It's come up a few times ... more than an un-overridable read-only mode anyway. Also, I should think that those who want a secure read-only mode wa

Re: [PATCHES] [HACKERS] read-only database

2005-05-09 Thread Tom Lane
Bruce Momjian writes: > Having removed our security for not allowing override of things like > log_statement, it seems we need a more general capability for > controlling how something can be set that no one can change. The initial implementation was definitely pretty broken, but I agree we shoul

Re: [PATCHES] [HACKERS] read-only database

2005-05-09 Thread Satoshi Nagayasu
Bruce Momjian wrote: >>It's come up a few times ... more than an un-overridable read-only mode >>anyway. Also, I should think that those who want a secure read-only >>mode want it enforced selectively --- for instance, assuredly read-only >>for some users but not others. I can hardly

Re: [PATCHES] [HACKERS] read-only database

2005-05-09 Thread Joshua D. Drake
> As I mentioned before, I wanted to the read-only database mode. > It is the per-database state. > > http://archives.postgresql.org/pgsql-hackers/2005-03/msg00540.php > > However, if it is not provided, we have to find alternative way > to get our purpose. > > So I'm

[PATCHES] pgstat: reduce message header

2005-05-09 Thread Neil Conway
This patch reduces the size of the message header used by statistics collector messages, per recent discussion. This actually required quite a few changes -- for example, "databaseid != InvalidOid" was used to check whether a slot in the backend entry table was initialized, but that no longer w

[PATCHES] cleanup: remove MemSet() casts

2005-05-09 Thread Neil Conway
There were various locations in the code that were casting the first argument to MemSet() or occasionally memset() to a char *. This is not necessary, per C89: memset's first argument is a void * to begin with, and there is an implicit conversion between void * and any other pointer type. I al

Re: [PATCHES] cleanup: remove MemSet() casts

2005-05-09 Thread Neil Conway
Neil Conway wrote: I also noticed a bit of unclear / inconsistent code in MemSet() itself: it's not obvious whether unary * or postfix ++ has higher precedence (the latter does), so I added some parentheses to make this clear. Okay, apparently I'm the only person who doesn't like code like this :