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
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
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
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?
> 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?
> 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
> 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
> 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
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