Re: [GENERAL] Error after upgrade

2008-01-28 Thread Tom Lane
"Paul Houselander" <[EMAIL PROTECTED]> writes: > $uweeklysqlu = "UPDATE stats_? SET > statdate=?,inctr=inctr+?,insize=insize+?,inspam=inspam+?,invir=invir+?,outct > r=outctr+?,outsize=outsize+?,outspam=outspam+?,outvir=outvir+? WHERE > account=? AND stattype=? AND statmode=? AND extract(week from >

[GENERAL] Error after upgrade

2008-01-28 Thread Paul Houselander
Hi Im in the process of moving an application that is currently using Postgres 7.4.8 to a new system running Postgres 8.1.9 Ive managed to use pg_dump to get all the data migrated across, however I have an update script that causes an error on the new system but works on the older one, I just can