Here is, what I've put together from various messages posted
November/December last year.
. Subtrans trees
. Transaction states
. Tuple visibility
. HeapTupleSatifiesUpdate
. Shortcuts
. Still missing
. Objections and suggestions
Subtrans t
Hi all,
Can someone tell me what happened with Win32 native port ?
Discussion bevore beginning of 7.4, TODO entry this time as "urgent",
but without dash. What does it mean - comes native port with 7.4 or it
doesn't ? Thanks for any information.
Best regards
Rony
---(en
On Tue, 2003-03-18 at 19:00, Hiroshi Inoue wrote:
> Bruce Momjian wrote:
> >
> > Tom Lane wrote:
> > > Bruce Momjian <[EMAIL PROTECTED]> writes:
> >
> > > The question here is do we want to offer a half-baked solution,
> > > recognizing that it's some improvement over no solution at all?
> > > Or
Alvaro Herrera wrote:
> On Tue, Mar 18, 2003 at 05:18:02PM -0500, Bruce Momjian wrote:
> > Peter Eisentraut wrote:
> > > Bruce Momjian writes:
> > >
> > > > What if folks want all their connections autocommit off.
> > >
> > > For interactive use, people can record their preferred setting in
> > >
Hi allI have read some code on transaction part.When the new
transaction starts, it record the snapshot of database containing the current
transaction id,etc. So depending on the snapshot, the transaction decide
which tuple is visible.But transaction could also be implemented by lock. so
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> When I connect to a non-existing server over Unix-domain sockets I now
> simply get
> createdb: could not connect to database template1: could not create socket: No such
> file or directory
I'm not getting quite that behavior --- how did you invoke
bingo! nice catch!
after a little sleuthing, the local CVS source copy DID have a series of
".dylib-handling" patches applied (have to revisit local naming
conventions )
a virgin refresh with 7.3.2-STABLE solved the plpgsql issue. thanks!!
altho, --with-java now breaks the build
When I connect to a non-existing server over Unix-domain sockets I now
simply get
createdb: could not connect to database template1: could not create socket: No such
file or directory
There used to be a more verbose message along the lines of "Is the server
running on ... and accepting connectio
Neil Conway writes:
> I'm currently planning to implement (1), as it is sufficient for the
> immediate need that I'm facing.
What need are you facing, and why is it not sufficient to explicitly store
the query results in a temporary table?
--
Peter Eisentraut [EMAIL PROTECTED]
-
R Blake writes:
> ERROR: Load of file /usr/local/pgsql/lib/plpgsql.dylib failed: no error
> message available createlang: language installation failed
The fact that the file extension is ".dylib" makes me suspicious that you
are using a patched version. In the original source the extension is
"
On Tue, Mar 18, 2003 at 10:32:58AM +0100, Manfred Koizar wrote:
> On Tue, 18 Mar 2003 00:20:40 -0400, Alvaro Herrera
> <[EMAIL PROTECTED]> wrote:
> >We will add a field to TransactionStateData with the xid of the parent
> >transaction. If it's set to InvalidTransactionId, then the transaction is a
On Tuesday 18 Mar 2003 8:07 pm, Nigel J. Andrews wrote:
> On Tue, 18 Mar 2003, Shridhar
Daithankar<[EMAIL PROTECTED]> wrote:
> > I consider this as a bug but given my understanding of sql, I won't count
> > on it. Any comments?
>
> If a is to be referenced in a foreign key it needs to be unique or
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Tom Lane writes:
>> MMessage --- the string is the primary error message (localized).
>> DDetail --- secondary error message, carrying more detail about
>> the problem (localized).
>> HHint --- a suggestion what to do about the error (local
On Tue, 18 Mar 2003, Shridhar Daithankar<[EMAIL PROTECTED]> wrote:
> Hi,
>
> Today I discovered that if there is a compund primary key on a table, I can
> not create a reference from another table to one of the fields in the primary
> key..
>
> Look at this..
>
> phd=# create table tmp1(a int
Tom Lane writes:
> M Message --- the string is the primary error message (localized).
> D Detail --- secondary error message, carrying more detail about
> the problem (localized).
> H Hint --- a suggestion what to do about the error (localized).
Client interfaces for the most pa
Tom Lane writes:
> Hmm. I can't see any advantage to these over assigning our own codes;
> ours would have at least *some* mnemonic value, rather than being chosen
> completely at random ...
One advantage is that interfaces that are required to use these constants
would not need an internal tran
Manfred Koizar <[EMAIL PROTECTED]> writes:
> On COMMIT: end the current subtransaction (marking it as aborted in
> pg_clog), pop it from the stack, set the enclosing transaction to
> (SUB)TRANS_ABORT.
Surely not. The outer transaction must remain alive, else there's no
point in the whole thing.
Oracle is now providing higher level support for United Linux than for
Red Hat Linux:
http://www.silicon.com/news/500011/1/3315.html
I wonder if that is related to Red Hat's support for PostgreSQL.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED]
Hi,
Today I discovered that if there is a compund primary key on a table, I can
not create a reference from another table to one of the fields in the primary
key..
Look at this..
phd=# create table tmp1(a integer,b integer,primary key(a,b));
NOTICE: CREATE TABLE / PRIMARY KEY will create impl
On Tue, 18 Mar 2003 00:20:40 -0400, Alvaro Herrera
<[EMAIL PROTECTED]> wrote:
>We will add a field to TransactionStateData with the xid of the parent
>transaction. If it's set to InvalidTransactionId, then the transaction is a
>parent transaction
We need a stack of currently executing transaction
Peter Eisentraut wrote:
I don't get it. Say I execute SELECT a, b, c FROM foo;. In order to
update that query, the application needs to create some update statement,
say UPDATE foo SET a = entered_value;. So the application already knows
that "foo" is the table and "a" is the column. So if the
21 matches
Mail list logo
