[BUGS] No error-checking on binary timestamp

2004-04-02 Thread Stephen Frost
Greetings, Based on some experimentation and reading through the code in: src/backend/utils/adl/timestamp.c ; it would appear that there's no error-checking when receiving a binary timestamp. I wouldn't care if I had figured out the binary timestamp format on the first shot but apparent

[BUGS] BUG #1122: limit 1 doing a sequential scan

2004-04-02 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1122 Logged by: P Buder Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.5 Operating system: Debian Linux Description:limit 1 doing a sequential scan Details: I am actually running 7.3.6 but that

Re: [BUGS] BUG #1122: limit 1 doing a sequential scan

2004-04-02 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > When I do a select * from table limit 1 > Postgresql does a sequential scan on the whole table. AFAICS you simply are misreading the EXPLAIN output. (It also sounds like you haven't vacuumed or analyzed that table in a mighty long time... if y