BUG #11484: 42804: il tipo del parametro 69 (numeric) non combacia con quello usato alla preparazione del piano

From: cadili(at)gesp(dot)it
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #11484: 42804: il tipo del parametro 69 (numeric) non combacia con quello usato alla preparazione del piano
Date: 2014-09-24 16:23:42
Message-ID: 20140924162342.17173.55401@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: 11484
Logged by: Francesco Cadili
Email address: cadili(at)gesp(dot)it
PostgreSQL version: 9.3.5
Operating system: Ubuntu 12.04.05 LTS
Description:

The PSQL code execute a dynamic query:

The test is in two steps:
1. The code execute a query on a table forcing the type to integer.
exec 'select istat::integer as istat from
import.c070101_gestore_3459_wgs84u32n group by istat order by istat';

2. the code execute a similar query in another table without casting. The
type of the column is number(10,0)
exec 'select istat as istat from import.c070101_gestore_3459_wgs84u32n group
by istat order by istat';

The result of the test is that the first query is executed whereas the
second rise an 42804 error.

Recreating the function remove the error till a new sequence of steps is
performed.

The error also occur executing first step 2 and than 1. In this case the
error is raised after step 1.

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2014-09-25 12:22:38 Re: [BUGS] Re: [BUGS] Re: BUG #11431: Failing to backup and restore a Windows postgres database, with Norwegian Bokmål locale.
Previous Message Tom Lane 2014-09-24 00:27:41 Re: BUG #11478: regexp_matches regression in 9.2