for procCxt is only freed when I presume the
TopTransaction is aborted or committed.
Should SPI_connect be called again after the subtransaction is created?
And SPI_finish before the subtransaction is committed or aborted?
On Thu, Jul 11, 2013 at 8:46 PM, Chad Wagner wrote:
> It looks like
It looks like to me exec_stmt_block creates a subtransaction if the block
has an exception handler by calling BeginInternalSubTransaction. Then
inside the PG_TRY it calls exec_stmts which runs the actual body of the
begin block. If an exception is thrown then I presume we are hitting the
PG_CATCH
Just a heads up, not sure if you guys are aware of it. But one of the
Makefile's (src/backend/tsearch/Makefile) added by this patch breaks the
"build out of source tree" feature of autoconf/automake. The problem is
pretty straightforward, and after adding $(srcdir) everything seems to be
fine.
I
On 2/12/07, Gene <[EMAIL PROTECTED]> wrote:
I was curious to see how postgres would perform with wal on a tmpfs vs
disk here are some numbers I got from pgbench. Let me know if I did
something stupid, this is the first time I've used pgbench. The wal on tmpfs
method is not significantly faster.
On 2/17/07, elein <[EMAIL PROTECTED]> wrote:
For other recent time travel ideas see:
http://www.varlena.com/GeneralBits/122.php
Time travel is not cheap, though.
I am sure this topic has probably been beaten to death in the past, but has
anyone talked about the advantages of Oracle's MVCC mo
On 2/17/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
My understanding is that the main difference is that rollbacks are
inexpensive for us, but expensive for Oracle. Talk to an Oracle DBA
about their Rollback logs :0.
Yes, I have seen cases where undo segments are thrashed. Generally it wo
On 2/17/07, Brendan Jurd <[EMAIL PROTECTED]> wrote:
I just looked through the Oracle documentation, and it is
conspicuously silent on the topic of invalid format patterns. Much
like ours in fact.
On the case of the format: -MM-DD J, if J is the same date as -MM-DD
then Oracle appears
On 2/24/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
>>> ERROR: Multiple definitions of the symbol 'creation' in
'../pgsql-cvs/cvsroot/pgsql/src/interfaces/perl5/Attic/test.pl.newstyle,v'
>>> ERROR: Multiple definitions of the symbol 'creation' in
'../pgsql-cvs/cvsroot/pgsql/src/interfaces/per
On 2/24/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
I don't know :-( I've tried to use the Trac site looking for particular
changesets and found that for some of them, the list of files are out of
sync with reality, and sometimes the diff don't have anything to do with
what the commit message
On 2/26/07, Josh Berkus wrote:
> Just wondering after reading so many mails from Hackers List.(its 2.15AM
> now!!) Is there anybody working on something to create a DB from
> a) The TODO list http://www.postgresql.org/docs/faqs.TODO.html
> b) The sourcecode of PostgreSQL
> c) The relevant Maili
On 2/27/07, Andrew Dunstan <[EMAIL PROTECTED]> wrote:
Before we rehash recent debates, please, everybody, review them. Going
over and over and over the same ground laboriously is really getting
tiresome, and unfortunately it's also getting more frequent. It's *déjà
vu *all over again.
History
11 matches
Mail list logo
