RE: Stumped on PlPgSql - Mailing list pgsql-general

From Eustace, Glen
Subject RE: Stumped on PlPgSql
Date
Msg-id E57866E2EBE3D311B3720008C7840931024DD2C2@its-xchg2.massey.ac.nz
Whole thread Raw
In response to Stumped on PlPgSql  (AGRE Enterprises <agree@godzone.net.nz>)
List pgsql-general
This was a classic case of seeing what I thought was there not what was
actually there :-(

> export PGOPTIONS="-d2"
> psql yourdb

This gave the show away, thanks Tom.

I had added an extra parameter, but gave it the same ALIAS as a column in
the insert, hence the syntax error.  The column was rplace by $1.

pgsql-general by date:

Previous
From: Peter Mount
Date:
Subject: Re: Error building JDBC Driver
Next
From: "Michael Simcich"
Date:
Subject: RE: DOUBLE MESSAGE