| From: | boskowski+coreybernal(at)gmail(dot)com |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #14406: Statement fails after upgrade to 9.6.1 |
| Date: | 2016-10-31 12:42:40 |
| Message-ID: | 20161031124240.15993.40927@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14406
Logged by: Corey Bernal
Email address: boskowski+coreybernal(at)gmail(dot)com
PostgreSQL version: 9.6.1
Operating system: Ubuntu 16.04
Description:
After upgrading from 9.5.4 to 9.6.1 using pg_upgrade with links an UPDATE
(prepared) statement that previously worked started raising
ERROR: table row type and query-specified row type do not match
DETAIL: Query provides a value for a dropped column at ordinal position
19.
I managed to solve this by creating an identical table, populating with
INSERT/SELECT and swapping the tables by renaming them, all in one
transaction.
Please let me know what detail information can be helpful to you.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2016-10-31 15:58:31 | Re: BUG #14406: Statement fails after upgrade to 9.6.1 |
| Previous Message | Will Pearson | 2016-10-31 10:47:14 | Re: BUG #14403: Large numbers of CREATE OR UPDATE function causes memory exhaustion |