PL/pgSQL in 8.0

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
---------------------------------------------------------

Responses

Browse pgsql-general by date

  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