Re: [BUGS] UPDATE fails on large table

2001-11-23 Thread Tom Lane
Kostis <[EMAIL PROTECTED]> writes: > ERROR: Deadlock detected. > See the lock(l) manual page for a possible cause. Hard to see how you could be getting that with only one process accessing the database. What else is going on? Also, you've been pretty incomplete about your description o

Re: [BUGS] Bug #519: Bug in order by clausule

2001-11-23 Thread Tom Lane
[EMAIL PROTECTED] writes: > Bug in order by clausule What locale are you running the postmaster in? This looks to me like nothing but a locale-specific sort order. regards, tom lane ---(end of broadcast)--- TIP 6: Have you

Re: [BUGS] Bug #520: Bug in order by clausule part II

2001-11-23 Thread Markus Bertheau
On Fri, 2001-11-23 at 11:24, [EMAIL PROTECTED] wrote: > now the sql command: select mit_id from table order by mit_id > should select all rows odered as the ABC. f.e.:123456789ABCD...QRSTetc. > At the range of 00C0...00CZ it goes creazy: > > 00CP > 00

[BUGS] Bug #520: Bug in order by clausule part II

2001-11-23 Thread pgsql-bugs
Sandor, Vig ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Bug in order by clausule part II Long Description Sorry, I forgot: The select max(mit_id) from table is also wrong! (At the specified range. see below) I have made

[BUGS] Bug #519: Bug in order by clausule

2001-11-23 Thread pgsql-bugs
Sandor, Vig ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Bug in order by clausule Long Description I have made a table with a TableID called "mit_id" character(16) This column is filled as follows: row 0: