Re: [HACKERS] PL/PgSQL "bare" function calls

2004-09-16 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > On Fri, 2004-09-17 at 00:34, Tom Lane wrote: >> I think Andrew has a point: why aren't they the same issue? > (Note that we need to support CALL proc(...); in SQL for standards > compliance in any event.) Right. I'm thinking we could effectively make the

Re: [HACKERS] Others applying patch queue patches

2004-09-16 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Neil Conway wrote: >> On Thu, 2004-09-16 at 23:24, Bruce Momjian wrote: >>> It will be applied as soon as one of the PostgreSQL committers reviews >>> and approves it. >> >> does this reflect a change in the patch application procedures? In my mind this

Re: [HACKERS] PL/PgSQL "bare" function calls

2004-09-16 Thread Neil Conway
On Fri, 2004-09-17 at 00:34, Tom Lane wrote: > I think Andrew has a point: why aren't they the same issue? It would > certainly be no harder to support > func( ... ); > as a SQL statement than as something allowed only in plpgsql. If there's a consensus that it is better to modify the main

[HACKERS] Others applying patch queue patches

2004-09-16 Thread Bruce Momjian
Neil Conway wrote: > On Thu, 2004-09-16 at 23:24, Bruce Momjian wrote: > > It will be applied as soon as one of the PostgreSQL committers reviews > > and approves it. > > Hey Bruce, > > does this reflect a change in the patch application procedures? (i.e. in > the past the pgpatches list you main

[HACKERS] fs+sql

2004-09-16 Thread Konstantin Besch
Hello ! I've written a small description of the project I would like to work on, and since it involves Postgres , decided to ask for a feedback from the people who can help . Thank you :). The Problem : Automate database-oriented development. Solution : automate representation of relational dat

Re: [HACKERS] problem permission on view

2004-09-16 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: > As said, I discussed this with Gaetano on IRC, and am not sure why things are > set up the way they are.If a user has permission on a view, shouldn't > that include permission on any functions executed by the view?If not, why > not? See prior disc

Re: [HACKERS] problem permission on view

2004-09-16 Thread Greg Stark
Josh Berkus <[EMAIL PROTECTED]> writes: > As said, I discussed this with Gaetano on IRC, and am not sure why things are > set up the way they are.If a user has permission on a view, shouldn't > that include permission on any functions executed by the view?If not, why > not? Then all s

Re: [HACKERS] subtransaction assert failure

2004-09-16 Thread Gavin Sherry
On Thu, 16 Sep 2004, Tom Lane wrote: > Gavin Sherry <[EMAIL PROTECTED]> writes: > > Interestingly, I *cannot* recreate on the single CPU system and I cannot > > get abort() to generate a core. > > By that do you mean that you don't see any corefile in the DB directory > when you look after the dus

Re: [HACKERS] problem permission on view

2004-09-16 Thread Josh Berkus
Folks, > If the view V use a function F. > > In this last case is not enough have the select permisson on V but I have > to give also the Execution permission on F!!! As said, I discussed this with Gaetano on IRC, and am not sure why things are set up the way they are.If a user has permissio

[HACKERS] problem permission on view

2004-09-16 Thread Gaetano Mendola
Hi all, I'm having some problem with permissions on views, I spoke with Josh on IRC about it and I'm reposting it: I found a not simmetrical behavior about permission on views and functions. Let me explain: If I use the view/table T inside the view V, is enough give the select permission on view V

Re: [HACKERS] Problems with SPI memory management

2004-09-16 Thread Tom Lane
"Katsaros Kwn/nos" <[EMAIL PROTECTED]> writes: > On Wed, 2004-09-15 at 19:51, Tom Lane wrote: >> You'd be well advised to be doing this sort of hackery in a build with >> --enable-cassert. That turns on CLOBBER_FREED_MEMORY which makes >> misuse of freed memory a whole lot more obvious. > I did

Re: [HACKERS] pg_dump --exclude-schema=foo

2004-09-16 Thread Tom Lane
Chris Browne <[EMAIL PROTECTED]> writes: > We have discovered an interesting locking scenario with Slony-I that > is pointing to a use for the ability to exclude certain schemas from > pg_dump. > The situation is that when a "full" pg_dump kicks off, a Slony-I > "create sync" event, which expects

Re: [HACKERS] subtransaction assert failure

2004-09-16 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > I'm seeing an intermittent assertion failure while running "make check" > with current sources. > TRAP: FailedAssertion("!(TransactionIdFollowsOrEquals(xid, > RecentXmin))", File: > "/Users/neilc/pgsql/src/backend/access/transam/subtrans.c", Line: 146)

Re: [HACKERS] subtransaction assert failure

2004-09-16 Thread Andrew Dunstan
Michael Glaesemann wrote: On Sep 16, 2004, at 8:48 PM, Andrew Dunstan wrote: I am also seeing regular "make check" failures on my test buildfarm system (FC1, 2.4.22 kernel, cassert turned on): Mmm :) buildfarm! I like the sound of that! Let us know how it goes, eh? As you saw, the actual runnin

Re: [HACKERS] subtransaction assert failure

2004-09-16 Thread Tom Lane
Gavin Sherry <[EMAIL PROTECTED]> writes: > Interestingly, I *cannot* recreate on the single CPU system and I cannot > get abort() to generate a core. By that do you mean that you don't see any corefile in the DB directory when you look after the dust settles? I ran into the same problem yesterday

Re: [HACKERS] subtransaction assert failure

2004-09-16 Thread Dennis Bjorklund
On Thu, 16 Sep 2004, Dennis Bjorklund wrote: > > Interestingly, I *cannot* recreate on the single CPU system and I cannot > > I've been trying to reproduce it on a single cpu system with fedora 2, > but no luck. I spook too soon. After having run it even more times I finally got a failure as we

Re: [HACKERS] PL/PgSQL "bare" function calls

2004-09-16 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > On Thu, 2004-09-16 at 01:19, Andrew Dunstan wrote: >> ISTM that this is being done at the wrong level anyway. > I think these are two distinct issues. I think Andrew has a point: why aren't they the same issue? It would certainly be no harder to support

Re: [HACKERS] PostgreSQL Core Committee Welcomes New Member

2004-09-16 Thread Lamar Owen
On Wednesday 15 September 2004 18:52, Marc G. Fournier wrote: > In recognition of his role as lead developer on the internationalization > front, as well as his invaluble work in both the build and release > processes, Peter Eisentraut has been invited, and has accepted, to join > the Core Committe

Re: [HACKERS] pg_dump as a bunch of PostgreSQL functions

2004-09-16 Thread Mark Gibson
Mark Gibson <[EMAIL PROTECTED]> writes: I have an idea, to break pg_dump into functions within PostgreSQL. Philip Warner wrote: However, there are some complications because pg_dump is also the upgrade tool; the backed can only know how to describe itself for the current dialect of SQL accepted b

Re: [HACKERS] subtransaction assert failure

2004-09-16 Thread Michael Glaesemann
On Sep 16, 2004, at 8:48 PM, Andrew Dunstan wrote: I am also seeing regular "make check" failures on my test buildfarm system (FC1, 2.4.22 kernel, cassert turned on): Mmm :) buildfarm! I like the sound of that! Let us know how it goes, eh? Michael Glaesemann grzm myrealbox com

Re: [HACKERS] subtransaction assert failure

2004-09-16 Thread Gavin Sherry
On Thu, 16 Sep 2004, Gavin Sherry wrote: > On Thu, 16 Sep 2004, Neil Conway wrote: > > > I can consistently repro this, provided I have the patience to run "make > > check" enough times. Can anyone else repro the problem? > > I've managed to recreate this. > > I've tried on two linux 2.4 systems.

Re: [HACKERS] subtransaction assert failure

2004-09-16 Thread Andrew Dunstan
I am also seeing regular "make check" failures on my test buildfarm system (FC1, 2.4.22 kernel, cassert turned on): sysname | snapshot | status | stage +-++--- cat | 2004-09-15 15:25:59 | 2 | Check cat | 2004-09-15 23:27:37 | 0

Re: [HACKERS] Problems with SPI memory management

2004-09-16 Thread Katsaros Kwn/nos
On Wed, 2004-09-15 at 19:51, Tom Lane wrote: > You'd be well advised to be doing this sort of hackery in a build with > --enable-cassert. That turns on CLOBBER_FREED_MEMORY which makes > misuse of freed memory a whole lot more obvious. I did this but when I try do create a function the following

Re: [HACKERS] subtransaction assert failure

2004-09-16 Thread Dennis Bjorklund
On Thu, 16 Sep 2004, Gavin Sherry wrote: > Interestingly, I *cannot* recreate on the single CPU system and I cannot I've benn trying to reproduce it on a single cpu system with fedora 2, but no luck. If someone wants else to try, don't forget the configure flag --enable-cassert. -- /Dennis Bj

Re: [HACKERS] subtransaction assert failure

2004-09-16 Thread Gavin Sherry
On Thu, 16 Sep 2004, Neil Conway wrote: > I can consistently repro this, provided I have the patience to run "make > check" enough times. Can anyone else repro the problem? I've managed to recreate this. I've tried on two linux 2.4 systems. One way and four way systems. Interestingly, I *cannot*

[HACKERS] subtransaction assert failure

2004-09-16 Thread Neil Conway
I'm seeing an intermittent assertion failure while running "make check" with current sources. I can usually reproduce the problem at least once out of every 3 or 4 runs of "make check" on each of two different machines (one is an 866 mhz iBook running OSX, the other is a dual Xeon @ 2.8 ghz run