Re: [GENERAL] A good client

2005-10-18 Thread Steve V
On 10/18/05, Wim Bertels <[EMAIL PROTECTED]> wrote: Dear friends,i've been using postgresql quiet some time now,but i don't find any really good clients for "dummies" to this database.When i look at pgadmin:an anoying feature: it closes when u do something illegal, instead of saying: u don't have t

[GENERAL] Precompiled win32 binary for getCurrentTransactionID?

2005-10-20 Thread Steve V
Does anyone by any chance have a win32 binary compiled for the code found in the below thread? I have been trying and for the life of me cannot get it(or pg from source) to compile in my windows environment. I'm sure it's user error on my part, but I don't have the time at the moment to figure it o

[GENERAL] Transaction IDs not the same in same transaction?

2005-10-22 Thread Steve V
So I was finally able to get a compiled binary for the code in this thread(thanks Magnus): http://archives.postgresql.org/pgsql-general/2005-06/msg00709.php So everything seemed to be fine with my GetCurrentTransactionID() function call returning the txn ID for each query I would run(as far as I c

Re: [GENERAL] Transaction IDs not the same in same transaction?

2005-10-22 Thread Steve V
On 10/22/05, Michael Fuhr <[EMAIL PROTECTED]> wrote: > > It makes sense if you're running PostgreSQL 8.0 or later and are > using subtransactions, whether explicitly or implicitly. The example > you posted didn't show the trigger definition or function -- does > the function do any error trapping?

Re: [GENERAL] Transaction IDs not the same in same transaction?

2005-10-23 Thread Steve V
> Ah, you had not even mentioned that the trigger was in pltcl. > spi_exec runs everything in subtransactions as of 8.0, so that > it can catch errors and propagate them back as Tcl errors. Okay, so are there any possible options? Would GetTopTransactionId() work, as Michael suggested further up?

Re: [GENERAL] Transaction IDs not the same in same transaction?

2005-10-23 Thread Steve V
> I just did some tests with a pltcl function that uses spi_exec in > an AFTER trigger and GetTopTransactionId() returned the same value > for each of several inserts and updates that were in the same > transaction. However, I can't say whether this will work for you > without seeing your code. I

Re: [GENERAL] Transaction IDs not the same in same transaction?

2005-10-23 Thread Steve V
> I haven't received that message yet, nor do I see it in the archives. > One of Tom Lane's replies appeared to quote from it -- did you send > it just to him? If you copied the list then the message might be > stuck somewhere. Yeah, I accidentally only sent it to Tom. Sorry about that. > What p

Re: [GENERAL] Transaction IDs not the same in same transaction?

2005-10-23 Thread Steve V
> It's defined in the backend executable, as is GetCurrentTransactionId(). > A similar wrapper function to the one shown here: > > http://archives.postgresql.org/pgsql-general/2005-06/msg00709.php > > should work. But I agree with the other folks in this thread who have > questioned whether this is

Re: [GENERAL] Unexpected behavior

2006-05-02 Thread Steve V
On 4/27/06, Strobhen <[EMAIL PROTECTED]> wrote: Hey, I am trying to figure out some unexpected behavior in Postgresql. When I create a rule that fires on a table after an update, and if that rule has a SELECT statement in it, it seems to be attempting to fire (on an empty set) regardless of how