Re: [GENERAL] [pgsql-advocacy] MySQL worm attacks Windows servers

2005-02-06 Thread Greg Stark
Jan Wieck <[EMAIL PROTECTED]> writes: > No, Peter. > > Posting a vulnerability on a public mailing list "before" there is a known fix > for it means that you put everyone who has that vulnerability into jeopardy. > Vulnerabilities are a special breed of bugs and need to be exterminated a > littl

Re: [GENERAL] Questions about functionality

2005-02-06 Thread Christopher Browne
The world rejoiced as [EMAIL PROTECTED] ("Ignacio Colmenero") wrote: [Large amount of HTML removed... _Please_ post in plain text...] There is no direct analogue to Oracle's SQL*Loader product for PostgreSQL at this time. That being said... 1. Plenty of scripting languages are available for Un

Re: [GENERAL] Update command too slow

2005-02-06 Thread Christopher Browne
Oops! [EMAIL PROTECTED] (Venkatesh Babu) was seen spray-painting on a wall: > There aren't any triggers but there are 75262 update > statements. The problem is that we have a datatype > called as "Collection" and we are fetching the data > rows into it, modifying the data and call > Collection.save

Re: [GENERAL] Referencing uninitialized variables in plpgsql

2005-02-06 Thread Tom Lane
"Karl O. Pinc" <[EMAIL PROTECTED]> writes: > AFICT, the docs arn't clear when it comes to referencing unitialized > array elements. I assume you get NULL values here as well even > though other array elements may have been given non-NULL values. There is no such thing as an uninitialized array el

Re: [GENERAL] Referencing uninitialized variables in plpgsql

2005-02-06 Thread Karl O. Pinc
On 02/05/2005 10:57:45 PM, John DeSoi wrote: Yes, exactly. If you don't assign a value to a declared pspgsql variable, it is NULL. Thanks, just what I needed. If you are concerned about this, then always assign a value when you declare it. This does not really address my concern. See below. Also

Re: [GENERAL] [pgsql-advocacy] MySQL worm attacks Windows servers

2005-02-06 Thread J. Greenlees
Jan Wieck wrote: On 1/30/2005 10:18 AM, Peter Eisentraut wrote: Dawid Kuroczko wrote: I think it is in good taste that when you find a bug/vulnerability/etc first you contact the author (in this case: core), leave them some time to fix the problem and then go on announcing it to the world. In thi

Re: [GENERAL] [pgsql-advocacy] MySQL worm attacks Windows servers

2005-02-06 Thread Jan Wieck
On 1/30/2005 10:18 AM, Peter Eisentraut wrote: Dawid Kuroczko wrote: I think it is in good taste that when you find a bug/vulnerability/etc first you contact the author (in this case: core), leave them some time to fix the problem and then go on announcing it to the world. In this case, core is not

Re: [GENERAL] Help with access check

2005-02-06 Thread Thomas Hallgren
Alvaro Herrera wrote: On Sun, Feb 06, 2005 at 03:28:31PM +0100, Thomas Hallgren wrote: Hi, From code inside a C-function, given the AclId of a user and the Oid of a Schema, what's the most efficient way to find out if the user has been granted CREATE on the schema? See src/backend/catalog

Re: [GENERAL] Help with access check

2005-02-06 Thread Alvaro Herrera
On Sun, Feb 06, 2005 at 03:28:31PM +0100, Thomas Hallgren wrote: Hi, > From code inside a C-function, given the AclId of a user and the Oid of > a Schema, what's the most efficient way to find out if the user has been > granted CREATE on the schema? See src/backend/catalog/aclchk.c, function p

Re: [GENERAL] security

2005-02-06 Thread Ron Peterson
On Sat, Feb 05, 2005 at 11:00:28PM -0800, David Fetter wrote: > On Sat, Feb 05, 2005 at 09:08:00PM -0500, Ron Peterson wrote: > > I would like to be able to assert that the security of data stored > > as a value in a PostgreSQL table can be as high as the security of > > saving that same piece of d

[GENERAL] Help with access check

2005-02-06 Thread Thomas Hallgren
Hi, From code inside a C-function, given the AclId of a user and the Oid of a Schema, what's the most efficient way to find out if the user has been granted CREATE on the schema? Thanks, Thomas Hallgren ---(end of broadcast)--- TIP 9: the planner w

Re: [GENERAL] pgpool simple feature request

2005-02-06 Thread Tatsuo Ishii
> Hello, > > Command Prompt develops a lot of web based applications. > One of the problems with the web is you can't really > pre determine a lot of tasks because of the statelessness. > > It would be nice if you could tell pgpool to perform certain > queries on initialization of a new connectio

Re: [GENERAL] Help with sorting (ie. ORDER BY expression)

2005-02-06 Thread Bruno Wolff III
On Sat, Feb 05, 2005 at 17:25:06 -0500, "Reuben D. Budiardja" <[EMAIL PROTECTED]> wrote: > > Hello, > I am running postgres-7.3. I have a query like this: > > SELECT question_id, question_text > FROM quiz_table > WHERE question_id IN (2,10,3,6,4,5); > > But I want the output to be sorted in th

Re: [GENERAL] pgpool 2.5b2 released

2005-02-06 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2005-02-06 09:34:53 -: > Since I posted my original question, I realized that pgpool notes a > failure of either master or slave in its log. Would we want something > more proactive? snmp? -- If you cc me or remove the list(s) completely I'll most likely ignore you

Re: [GENERAL] pgpool 2.5b2 released

2005-02-06 Thread Jean-Paul Argudo
Tatsuo Ishii wrote: Pgpool 2.5b2 supports "master slave mode" which can cope with master/slave replication softwares such as Slony-I. In this mode pgpool sends non SELECT queries to master only. SELECTs are load balanced by pgpool. First of all, thanks so much Tatsuo for such a great project! This

Re: [GENERAL] pgpool 2.5b2 released

2005-02-06 Thread Julian Scarfe
> After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] ("Julian Scarfe") belched out: > > So all I'm looking for is a way for pgpool to shout if it detects a > > failure. That could initiate the investigation of the other > > criteria required for failover. > > _There_ lies the one change t