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

Re: Known problem? Column mixup in sql-function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas <maps(dot)on(at)gmx(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Known problem? Column mixup in sql-function
Date: 2011-08-30 04:06:29
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Andreas <maps(dot)on(at)gmx(dot)net> writes:
> Am 29.08.2011 18:10, schrieb Tom Lane:
>> Well, without a concrete test case it's hard to say, but certainly there
>> have been a lot of bugs fixed between 8.4.0 and 8.4.8.

> This table was one of the first in the db and got added columns and 
> dropped, too.

That could be it then ...

> The 8.4.0 was part of the distribution and they keep the version.

You need to rattle some cages a bit harder.  There are multiple known
security and data-loss bugs in 8.4.0; the one you've hit here is minor
by comparison.  It's frankly irresponsible, not to say bordering on
incompetent, to refuse to update to a more recent bug-fix release.

> I can't drop the table b/c there are a number of references.

Well, if a dump and reload is acceptable, that should fix it too ---
assuming it is what I'm guessing it is.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Ennio-SrDate: 2011-08-30 16:58:03
Subject: Data corruption magically disappeared?
Previous:From: AndreasDate: 2011-08-30 03:53:51
Subject: Re: Known problem? Column mixup in sql-function

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