Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] My postmaster just crashed !

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org, PFC <lists(at)boutiquenumerique(dot)com>,postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] My postmaster just crashed !
Date: 2005-01-27 20:01:14
Message-ID: 23579.1106856074@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-general
Michael Fuhr <mike(at)fuhr(dot)org> writes:
> Hmmm...the PostgreSQL binaries on my Solaris/sparc box are 32-bit
> and the FreeBSD box is a 32-bit i386, yet both are susceptible to
> the crash.

On looking at it, the problem is that the functions are defined in such
a way that you can pass any random integer value to int_agg_final_array(),
and it'll try to interpret that as a pointer.  So (a) it definitely
cannot work on 64-bit-pointer machines, and (b) it's trivial to crash it
by passing a number that's not a pointer.

The code should be rewritten by someone who has the skill to program
their way out of a paper bag :-( but I don't think there is time for a
proper fix right now.  What I'm inclined to do as a stopgap is just to
revoke all privileges from public on the two component functions of the
aggregate, since there is no particularly good reason to allow them to
be called directly anyway.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Michael FuhrDate: 2005-01-27 20:10:38
Subject: Re: [BUGS] My postmaster just crashed !
Previous:From: Frank D. Engel, Jr.Date: 2005-01-27 20:00:06
Subject: Re: [BUGS] My postmaster just crashed !

pgsql-general by date

Next:From: Joshua D. DrakeDate: 2005-01-27 20:02:49
Subject: Re: convert mdb files to pg?
Previous:From: Frank D. Engel, Jr.Date: 2005-01-27 20:00:06
Subject: Re: [BUGS] My postmaster just crashed !

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group