Re: core dump on select

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: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Andrew Sullivan
Sent: Monday, September 27, 2004 8:38 AM
To: pgsql-general@postgresql.org
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  | ajs@crankycanuck.ca
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 majordomo@postgresql.org