| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Satya Prakash Tripathi" <sptripathi78(at)yahoo(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #2463: postgres server crashes on "select count(*) from table; " |
| Date: | 2006-06-02 13:57:24 |
| Message-ID: | 27999.1149256644@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"Satya Prakash Tripathi" <sptripathi78(at)yahoo(dot)com> writes:
> postgres server crashes on running "select count(*) from table;" from psql
> client
I don't think so ;-). Perhaps you have a corrupted copy of the postgres
executables?
> test_db=# select count(*) from test_tbl;
> WARNING: terminating connection because of crash of another server process
It's worth noting that this is NOT what you'd see if the select count(*)
itself were failing. Perhaps you have something going on in the
background that is causing a crash of a different query? Look in your
postmaster log to find out what's actually failing, because the above is
merely blowback.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sebastien MAYER | 2006-06-02 16:11:48 | BUG #2464: 'After' are not called the first time of the user session |
| Previous Message | Satya Prakash Tripathi | 2006-06-02 10:15:16 | BUG #2463: postgres server crashes on "select count(*) from table;" |