From: | Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | PL/pgSQL in 8.0 |
Date: | 2005-08-08 15:11:41 |
Message-ID: | 200508081211.42285.martin@bugs.unl.edu.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I upgraded a couple of servers to 8.0.3 a few weeks ago, and just found out
that some of the PL/pgSQL functions ar not working as they did, even more,
they are giving errors.
Did something change from 7.4? Particularly, the use of RECORD? It looks like
RECORD doesn't like to get assigned a single column:
CONTEXTO: sentencia SQL: «SELECT nuevo_vto FROM modif_sancion WHERE $1 =
$2 ORDER BY femodif DESC LIMIT 1»
PL/pgSQL function "getvencimientosancion" line 13 at select into
variables
ERROR: el operador no existe: record = integer
I did a dumapall and then recovered, as I always do, with psql, before the
upgrade.
--
11:55:33 up 36 days, 20:41, 2 users, load average: 1.73, 1.35, 1.25
---------------------------------------------------------
Lic. Martín Marqués | SELECT 'mmarques' ||
Centro de Telemática | '@' || 'unl.edu.ar';
Universidad Nacional | DBA, Programador,
del Litoral | Administrador
---------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2005-08-08 15:18:11 | Re: postgresql Secure Mode |
Previous Message | Mario Soto Cordones - Venezuela | 2005-08-08 15:09:03 | Re: postgresql Secure Mode |