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-29 16:10:21
Message-ID: 22755.1314634221@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Andreas <maps(dot)on(at)gmx(dot)net> writes:
> This works nicely with a PG 8.4.8 on Windows but fails with a PG 8.4.0 
> on openSuse 11.1.

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.

If I had to bet based on the small amount of information you've shown
us, I'd wonder whether the projects table has had any columns dropped
from it.  If this is related to one of the dropped-column bugs we've
fixed, you could presumably work around it by dropping and recreating
the projects table.  But updating to 8.4.current would be a much better
idea.

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: bradgDate: 2011-08-29 17:24:02
Subject: Trouble including "pg_type.h"
Previous:From: AndreasDate: 2011-08-29 15:26:16
Subject: Known problem? Column mixup in sql-function

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