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
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
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.
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
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 part
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 integer,b
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 (localized).
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]
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
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
.so.
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]
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
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 .
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
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 do we feel it
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
---(end
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
17 matches
Mail list logo