[PATCHES] These Lists Are Being Cut To FOUR

2004-11-10 Thread Mike Cox
Hello. My name is Mike Cox. I am in charge of the changing of these
postgresql lists. I have decided that we are going to drop most of the
lists from the vote. We will only be making 4 lists into real Usenet
newsgroups if we win the election. The rest of the lists are crap and
they take up too much fucking room. Marc was an asshole for stealing
BIG8 newsgroup names without voting. He is an irresponsible piece of
shit scumbag cock-licking anus-eating foreskin-sniffing motherfucking
faggot. He has an ego the size of Dolly Parton's tits. Be sure to vote
yes on all four of these lists or every list will be removed. 

Your support is most appreciated!!!

Mike Cox
[EMAIL PROTECTED]

---(end of broadcast)---
TIP 8: explain analyze is your friend


Re: [PATCHES] delete obsolete comment

2004-11-10 Thread Tom Lane
Neil Conway [EMAIL PROTECTED] writes:
 AFAICS, we now longer use a global variable to record the fact that
 we're in the midst of building an index. Therefore, this patch removes
 some comments (in access/hash/hash.c and access/nbtree/nbtree.c) that
 claim we do.

BuildingBtree is definitely gone.  Not sure about the hash case.

regards, tom lane

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])


[PATCHES] Proposed patch to remove USERLIMIT

2004-11-10 Thread Tom Lane
The attached patch removes GUC's USERLIMIT variable category, changing
all the affected variables to be plain SUSET, as per recent discussion.

I also modified postgres.c so that variable settings coming from the
client connection request packet (eg, from PGOPTIONS on the client side)
are processed only after we have determined whether the user is a
superuser.  This allows a superuser to set SUSET options from PGOPTIONS,
which has never worked before.

I consider this to be a lot cleaner and more flexible than what we have
now.  Comments?

regards, tom lane



bin8rEOQ7lV8m.bin
Description: no-userlimit.patch.gz

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [PATCHES] delete obsolete comment

2004-11-10 Thread Neil Conway
On Thu, 2004-11-11 at 04:20, Tom Lane wrote:
 BuildingBtree is definitely gone.  Not sure about the hash case.

Hash is gone as well (there was a BuildingHash variable in 1996, but
no longer).

Patch applied.

-Neil



---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [PATCHES] Proposed patch to remove USERLIMIT

2004-11-10 Thread Bruce Momjian
Tom Lane wrote:
 The attached patch removes GUC's USERLIMIT variable category, changing
 all the affected variables to be plain SUSET, as per recent discussion.
 
 I also modified postgres.c so that variable settings coming from the
 client connection request packet (eg, from PGOPTIONS on the client side)
 are processed only after we have determined whether the user is a
 superuser.  This allows a superuser to set SUSET options from PGOPTIONS,
 which has never worked before.
 
 I consider this to be a lot cleaner and more flexible than what we have
 now.  Comments?

I would be glad to see USERLIMIT gone, even though I wrote it.  However,
I feel we are removing user's ability of non-super users to turn logging
on and off easily without really having thought through a mechanism to
give them that.  I just don't see people creating secuirty definer
functions easily to do this and perhaps we should ship some capability
with our source.

I am thinking we should hold until 8.1.  I do like the idea of moving
things to ALTER USER but I think there is more work for us to do.

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


[PATCHES] Slovenian translations for 8.0

2004-11-10 Thread Aleksander Kmetec
Translations for initdb, pg_config, pg_ctl and pg_dump are new, so
please also add them to nls makefiles.
http://www.medijske.com/pg/initdb-sl.po
http://www.medijske.com/pg/libpq-sl.po
http://www.medijske.com/pg/pg_config-sl.po
http://www.medijske.com/pg/pg_controldata-sl.po
http://www.medijske.com/pg/pg_ctl-sl.po
http://www.medijske.com/pg/pg_dump-sl.po
http://www.medijske.com/pg/pg_resetxlog-sl.po
http://www.medijske.com/pg/pgscripts-sl.po
http://www.medijske.com/pg/psql-sl.po
Thanks.
--
Aleksander
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]