| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Joe Conway <mail(at)joeconway(dot)com> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: bytea operator bugs (was Re: [GENERAL] BYTEA, indexes |
| Date: | 2002-08-19 13:07:55 |
| Message-ID: | 5977.1029762475@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-patches |
Joe Conway <mail(at)joeconway(dot)com> writes:
> parts=# SELECT * from bombytea where parent_part like '02-%';
> server closed the connection unexpectedly
You should stop right here and investigate the reason for the crash.
> So it appears that "SELECT * from bombytea where parent_part like
> '02-%'; server closed the connection unexpectedly" somehow physically
> corrupts the index!
Hm, I'd have expected WAL recovery to fix that. But the easiest avenue
of attack is to isolate the reason for the crash. Please post a test
case if you want help.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-08-19 13:20:02 | Re: Success: Finished porting application to postgreSQL |
| Previous Message | Martijn van Oosterhout | 2002-08-19 11:38:35 | Re: DATE field subtraction |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2002-08-19 15:12:19 | Re: bytea operator bugs (was Re: [GENERAL] BYTEA, indexes |
| Previous Message | Joe Conway | 2002-08-19 05:53:30 | Re: bytea operator bugs (was Re: [GENERAL] BYTEA, indexes |