Re: [HACKERS] SPI bug.

2005-04-30 Thread Neil Conway
Tzahi Fadida wrote: I think the solution can be either changing the FETCH_ALL to INT_MAX or changing the interface parameter count and subsequent usages to long. I think changing SPI_cursor_fetch() and SPI_cursor_move() to take a "long" for the "count" parameter is the right fix for HEAD. It would

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-04-30 Thread Robert Treat
Just wanted to address a couple of specific items here... On Saturday 30 April 2005 08:54, Rob Butler wrote: > I read the hackers list all the time, and have for > years, and my company sponsors PG events every few > months, and I would consider myself fairly "plugged > in" to PG, and this is the

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-04-30 Thread Robert Treat
On Saturday 30 April 2005 06:05, Kris Jurka wrote: > On Sat, 30 Apr 2005, Nicolai Petri (lists) wrote: > > We also use PostgreSQL as our primary db so it would be more than likely > > that we would donate money for something similar with postgresql if > > either : > > a) we can direct the money a

[HACKERS] pl/Python

2005-04-30 Thread James William Pye
Greets, [apologies if an earlier dup gets "unswallowed"] Well, I've been solo'ing it for over a year now, and it's definitely time to make my presence known to the community and invite others to participate as I can't keep putting it off as I have been. There has always been something else that I

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-04-30 Thread Robert Treat
On Saturday 30 April 2005 17:40, David Fetter wrote: > On Sat, Apr 30, 2005 at 10:37:06AM +0200, Nicolai Petri (lists) wrote: > > I totally agree. In our preference list I would have the following tasks > > : 1) IOT (Index Ordered Tables) > > Is this different from CLUSTER? > I think what he is l

[HACKERS] OLAP and PG and deja-vu

2005-04-30 Thread Mischa Sandberg
Just finished writing the PG rules to maintain a bunch of materialized (aggregate) views on a ROLAP cube --- yes, I've seen Jonathan Gardner's "matview" for postgres; didnt cover what I needed :-(. PG happens to be pretty convenient for roll-your-own OLAP, thanks to RULES and ARRAY datatypes. S

Re: [HACKERS] Output functions with multiple arguments considered harmful

2005-04-30 Thread elein
On Sat, Apr 30, 2005 at 05:31:28PM -0400, Tom Lane wrote: > [EMAIL PROTECTED] (elein) writes: > > On Sat, Apr 30, 2005 at 04:17:59PM -0400, Tom Lane wrote: > >> It is trivial to crash 8.0's record_out > >> by lying to it about the rowtype of its first argument. > > > Is it not as trivial to crash

Re: [HACKERS] Output functions with multiple arguments considered

2005-04-30 Thread James William Pye
On Sat, 2005-04-30 at 16:17 -0400, Tom Lane wrote: > An example that Elein put up yesterday: > http://archives.postgresql.org/pgsql-general/2005-04/msg01384.php > caused me to realize that type output functions that depend on > additional arguments to determine what they are dealing with are > fund

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-04-30 Thread David Fetter
On Sat, Apr 30, 2005 at 10:37:06AM +0200, Nicolai Petri (lists) wrote: > >Anyone interested in pooling funds for features should take a look at > >http://people.freebsd.org/~phk/funding.html, which is about a FreeBSD > >developer who offered to work full-time on developing some specific > >features

Re: [HACKERS] Output functions with multiple arguments considered harmful

2005-04-30 Thread Tom Lane
[EMAIL PROTECTED] (elein) writes: > On Sat, Apr 30, 2005 at 04:17:59PM -0400, Tom Lane wrote: >> It is trivial to crash 8.0's record_out >> by lying to it about the rowtype of its first argument. > Is it not as trivial to crash it if one passes bad data into it? > Why is the oid arg worse than the

Re: [HACKERS] Output functions with multiple arguments considered harmful

2005-04-30 Thread elein
On Sat, Apr 30, 2005 at 04:17:59PM -0400, Tom Lane wrote: > An example that Elein put up yesterday: > http://archives.postgresql.org/pgsql-general/2005-04/msg01384.php > caused me to realize that type output functions that depend on > additional arguments to determine what they are dealing with are

[HACKERS] pg_locks needs a facelift

2005-04-30 Thread Tom Lane
There was some previous discussion in a thread starting at http://archives.postgresql.org/pgsql-hackers/2005-01/msg00750.php about expanding the pg_locks view to provide more useful support for contrib/userlock locks. Also, the changes Alvaro and I just finished for sharable row locks mean that th

[HACKERS] Output functions with multiple arguments considered harmful

2005-04-30 Thread Tom Lane
An example that Elein put up yesterday: http://archives.postgresql.org/pgsql-general/2005-04/msg01384.php caused me to realize that type output functions that depend on additional arguments to determine what they are dealing with are fundamentally security holes. It is trivial to crash 8.0's recor

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-04-30 Thread Robert Treat
On Saturday 30 April 2005 02:02, Joshua D. Drake wrote: > > We'd like to avoid such unpleasant surprises, but how to get the word > > out? > > More prominent placement of how to contribute would probably help. The > PGF could help with this as well once it is done. Right now it is ether > on how to

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-04-30 Thread Bruce Momjian
pgman wrote: > Kris Jurka wrote: > > One thing that definitely would be nice would be to be able to combine > > funds from various sponsors for various features. Alone a company can't > > spring for it, but by pooling resources it could get done. This is a lot > > tougher to coordinate and unl

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-04-30 Thread Bruce Momjian
Kris Jurka wrote: > One thing that definitely would be nice would be to be able to combine > funds from various sponsors for various features. Alone a company can't > spring for it, but by pooling resources it could get done. This is a lot > tougher to coordinate and unless there is a complete

Re: [HACKERS] Increased company involvement

2005-04-30 Thread Bruce Momjian
Tom Lane wrote: > Andrew Dunstan <[EMAIL PROTECTED]> writes: > > Regarding the secret code stuff - I predict that it will quickly bite > > whoever does it, unless they are extremely lucky. > > Yeah. Bruce and I were worrying about this on the phone today. > If a company is doing some work with t

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-04-30 Thread Rob Butler
I read the hackers list all the time, and have for years, and my company sponsors PG events every few months, and I would consider myself fairly "plugged in" to PG, and this is the first I have seen/heard of the PostgreSQL Foundation http://thepostgresqlfoundation.org/ Perhaps a little more prom

Re: [HACKERS] [proposal] protocol extension to support loadable stream

2005-04-30 Thread Neil Conway
Alvaro Herrera wrote: BTW, why not get rid of src/corba? Good question; I'll remove it from HEAD tomorrow, barring any objections. -Neil ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-04-30 Thread Kris Jurka
On Sat, 30 Apr 2005, Nicolai Petri (lists) wrote: > We also use PostgreSQL as our primary db so it would be more than likely > that we would donate money for something similar with postgresql if > either : > a) we can direct the money at one or more specific tasks > or > b) the tasks found

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-04-30 Thread Nicolai Petri (lists)
Anyone interested in pooling funds for features should take a look at http://people.freebsd.org/~phk/funding.html, which is about a FreeBSD developer who offered to work full-time on developing some specific features should enough people donate. Also worthy of mention is http://www.freebsdfoundatio