Re: Can I use row-level locks to sequence READ COMMITTED transactions?

Actually, I was having problems with restoring a pg dump too although it may
be tied to my date settings. I changed my date format to non-US and I
periodically get an email containing the following:

From: Cron Daemon [mailto:root(at)hades(dot)emedscentral]
Sent: July 22, 2002 4:00 AM
To: postgres(at)hades(dot)emedscentral
Subject: Cron <postgres(at)hades> [ -x
/usr/lib/postgresql/bin/do.maintenance ] &&
/usr/lib/postgresql/bin/do.maintenance -a

NOTICE: Conflicting settings for date
NOTICE: Conflicting settings for date
NOTICE: Conflicting settings for date
NOTICE: Conflicting settings for date
NOTICE: Conflicting settings for date

When I try to restore a dumped database, this error comes back up along with
the following user error:

craig(at)hades:~$ psql polaris < /home/craig/enigma.dump
NOTICE: Conflicting settings for date
\connect: FATAL 1: IDENT authentication failed for user "postgres"

craig(at)hades:~$

Anyone know where else I should change my date format and whether this could
be causing the ident problem? Both the database and dump file are owned by
the user craig. This is all under PostgreSQL 7.2.1 on a Debian woody
system.

Thanks,

Craig S.

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Tom Lane
Sent: July 22, 2002 4:31 PM
To: Matthew Woodcraft
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Can I use row-level locks to sequence READ
COMMITTED transactions?

Matthew Woodcraft <mattheww(at)chiark(dot)greenend(dot)org(dot)uk> writes:
> If I use a READ COMMITTED transaction, the documentation says that a
> query in my transaction may see changes which were committed by other
> transactions after my transaction started.
> My question is, is it guaranteed that a SELECT in my transaction will
> see changes previously committed by other transactions, or is it only a
> possibility?
> By 'previously committed', I mean 'committed by a transaction which held
> a row-level lock which my transaction has since obtained'.

Yes, that will work. The SELECT sees rows that were committed at the
instant it starts, which will be after the other xact completes if you
use a FOR UPDATE lock.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)