Core dump on select from psql on AIX 5.x I have the following task at hand - A huge table, one of the column data has duplicated entries. I want to find those duplicated records in this column - select count(*), col-x from table-x group by col-x having count(*) >1;
Of course, the above query will produce a core!! My question is: is there a smart way in postgresql to solve this problem? Could I avoid this core dump issue if I use pgplsql? john -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Sullivan Sent: Monday, September 27, 2004 8:38 AM To: [EMAIL PROTECTED] Subject: Re: [GENERAL] core dump on select On Fri, Sep 24, 2004 at 03:55:43PM -0500, John Liu wrote: > max memory size (kbytes) 32768 > > open files 2000 > > pipe size (512 bytes) 64 > > stack size (kbytes) 2097151 My guess is that one of these -- likely the first -- is biting you. What isn't clear to me is whether you're getting core from the postmaster or psql itself. I've seen the latter pretty frequently, but there is a current segfault problem with AIX 5.1 at least. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
