Am Montag, 18. August 2003 15:38 schrieb Tom Lane:
> Philipp Reisner <[EMAIL PROTECTED]> writes:
> > Now if the applications issues one delete statement concurrently on
> > two connections both block forever.
> >
> > Please correct me if I am wrong, but should not one of the statements
> > succeed
Title: Message
Hi
Your
name
: Arnold Mavromatis
Your email address : [EMAIL PROTECTED]
System Configuration
-
PostgreSQL info
Server version PostgreSQL 7.3.2 on hppa2.0w-hp-hpux11.11
Engine Version 7.3.2
On Wed, 20 Aug 2003, Arnold Mavromatis wrote:
> PostgreSQL info
> Server version PostgreSQL 7.3.2 on hppa2.0w-hp-hpux11.11
> Engine Version 7.3.2
> Compiled by GCC 3.2.1
I couldn't duplicate on Redhat9 using 7.3.4 or 7.4 beta.
What does a plain select to_date('19
Hi
A test of recommended selects is as follows..
db1=> select * from sfc_days2;
stn_num |lsd | max_air_temp
-++--
86071 | 1901-12-13 | 3.0
(1 row)
db1=> select * from sfc_days2 where lsd = to_date('1901-12-13',
'-MM-DD');
stn_num |l
Hi again
We've actually determined that we didn't compile it but just downloaded a
binary from the web...(for HP-UX 11.11) so I've got no idea as to compiler
settings used on this binary...
Cheers
Arn
-Original Message-
From: Arnold Mavromatis [mailto:[EMAIL PROTECTED]
Sent: Wednesday
On Wed, 20 Aug 2003, Arnold Mavromatis wrote:
> db1=> select * from sfc_days2 where lsd = to_date('1901-12-13',
> '-MM-DD');
> stn_num |lsd | max_air_temp
> -++--
>86071 | 1901-12-13 | 3.0
> (1 row)
>
> db1=> select * from sfc_days2 where l
