Tom Lane wrote:
> Stu Coates <stu(at)StuCoates(dot)com> writes:
> > Anyway, I've sorted my obsolete version problem, and have discovered
> > another. Attached is a short shell script that causes pg_dump to core
> > dump whilst trying to dump a single, quite simple, table.
> Fix committed --- but it just missed the boat for 7.1beta5 :-(. Please
> try current CVS or tomorrow's snapshot, instead.
Thanks for that Tom, I'll give it a shot later.
On a slightly different matter:
I come from an Oracle background where I can lock an item of data by
performing a "SELECT FOR UPDATE" on the row. This is also implemented
in PostgreSQL. A quite useful feature Oracle does have is the ability
to add a "NOWAIT" clause to the end of the command which will cause an
exception if the item of data already has a lock taken out on it.
AFAIK, this is not implemented in PostgreSQL. I did see a note that
lock timeouts are not implemented, but if "NOWAIT" is added the
application developer could implement/fudge timeouts him/herself. Would
this be relatively easy to add?
Chelmsford, England U.K.
The day Microsoft makes something that doesn't suck is probably the day
they start making vacuum cleaners.
In response to
pgsql-bugs by date
|Next:||From: Tatsuo Ishii||Date: 2001-02-24 13:05:43|
|Subject: Re: Sequence of characters not supported by psql/pg_dump|
|Previous:||From: Tom Lane||Date: 2001-02-24 00:41:23|
|Subject: Re: Receiving "No such file or directory" error from the database |