From: | jdp <paquette(at)mediaone(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | select during transaction? |
Date: | 1999-10-21 22:57:00 |
Message-ID: | ipkPOGh9riwFHXEFxNrEg5TFcLfi@4ax.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I'm using postgresql 6.5.1 on RH6.0 and can't do a select during a
transaction. Is there a reason for this behavior?
Here is a simplified example:
psql wwmix
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc 2.7.2.3]
type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: wwmix
wwmix=> begin transaction;
BEGIN
w
wwmix=> select * from users;
NOTICE: (transaction aborted): queries ignored until END
*ABORT STATE*
wwmix=> end transaction;
END
Thanks,
Jeff
--
Jeff Paquette
paquette at mediaone.net, paquette at acm.org
http://atnetsend.ne.mediaone.net
From | Date | Subject | |
---|---|---|---|
Next Message | Lincoln Yeoh | 1999-10-22 00:50:00 | Re: What's WAL (wasRe: [GENERAL] Postgres INSERTs much slower than MySQL?) |
Previous Message | Alain TESIO | 1999-10-21 22:30:00 | Re: [GENERAL] Installation simplicity |