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
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
On 12/8/09 12:36 PM, "Robert Haas" wrote:
> On Tue, Dec 8, 2009 at 12:16 PM, Chad Sellers wrote:
>> On 12/8/09 11:51 AM, "David P. Quigley" wrote:
>>
>>> On Tue, 2009-12-08 at 11:48 -0500, Robert Haas wrote:
>>>> On Tue, Dec 8, 2009
o arbitrary
>> objects.
>>
>> ...Robert
>
>
> So I was reading through a set of slides that KaiGai has and he
> mentioned a May commitfest link and I looked for the comments related to
> his PGACE patches. I've been crawling through the commitfest paces so I
> can figure out what the latest version of the pgace patch is. Does
> anyone know when the patch was reduced to what it is today?
>
> Dave
>
I'm another SELinux developer and I'd like to help out where I can here. I'm
a bit confused by this discussion of PGACE. I thought the postgresql
community agreed that they wanted this removed in order to make the patch
size smaller. Has that changed? Is the increase in patch size now
acceptable? Sorry if I'm joining the conversation late.
Thanks,
Chad Sellers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
eful. While many of the use cases we've wanted
this for require row-level access control, there have been several that did
not. It is definitely still useful, especially if it is a path toward
row-level access control in a later release.
Chad
--
Sent via pgsql-hackers mailing list (pgsql-h
On 1/27/09 6:57 PM, "Greg Smith" wrote:
> On Tue, 27 Jan 2009, Chad Sellers wrote:
>
>> I'll speak to this a bit (Josh is also a Tresys employee). I can't say who
>> my customers are, but I can speak to their needs. They really need row-level
>> ma
and simply
relabel the row(s). Each stage would be granted the ability to relabel from
its type to the type of the next stage. No copies are necessary.
I hope those help. I realize that many of you may not be used to dealing
with customers who have such stringent security requirements, but if
SE-Po
unately, these
developments have all had maintenance requirements that precluded using
KaiGai's code as it was outside not in a commercial distribution. We've been
waiting anxiously for it to be merged upstream.
Additionally, I've talked to many other end users that really want to depl
7; as c
FROM
my_table t;
Does this seem reasonable to you? Do you problems with this approach?
Thanks again for your help,
Chad
From: Robins Tharakan [mailto:[EMAIL PROTECTED]
Sent: Monday, April 14, 2008 8:34 PM
To: Chad Showalter
Cc: [EMAIL PROTECTED]
Subject: Re: [SQL] rule for
id" in this case references more than one row, if
more than one row with
the given id already exists in my_audit_table.
How do I accomplish what I want to accomplish here? I'd prefer not to use a
sp.
Thanks,
Chad
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/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
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/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/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
elect to_date('1', 'Q') from dual;
select to_date('1', 'Q') from dual
*
ERROR at line 1:
ORA-01820: format code cannot appear in date input format
--
Chad
http://www.postgresqlforums.com/
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, 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/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.
Hi
Thinking of producing a modified version of Postgres to allow clients
bypass the SQL type intefaces.
How easy is to to get cursor access to the indexes and fine grained
control of the transaction system, are their fairly clean internal
APIs I can leverage.
Cheers
Chad
Is it possible for Postgres Btrees to support access by logical row number ?
If not available is ti a huge job to support for sombebody willing to have a go ?
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Tue, Oct 22, 2002 at 05:05:38PM +0200, Igor Georgiev wrote:
> or my nightmare a cygwin on Win 98 everybody can can access everything
Or =my= nightmare: Anything important on any Windows platform.
-crl
--
Chad R. Larson (CRL22)[EMAIL PROTECTED]
Eldorado Computing, Inc.
What I'd like to see in 7.2 is a WAL API with the following
functionality:
* Get the latest transaction in the WAL
* Get transaction, transId, from the WAL
* Was a given transaction rolled back?
What I don't want to have to worry about is all the internals needed for
writting the log. I
Bruce Momjian wrote:
Okay, would it be helpful if I made a few suggestions on things that I
as a user/tool developer of postgres might find helpful?
>
> > Is there an easy way to read the WAL files generated by Postgres? I'm
> > looking into writting a replication deamon for postgres and think
Is there an easy way to read the WAL files generated by Postgres? I'm
looking into writting a replication deamon for postgres and think that
the WAL files are the best way to know what has happened to the db and
what has to be replicated. I have a roughed out idea of how to code it
up but the on
25 matches
Mail list logo
