RE: Stumped on PlPgSql

From: "Eustace, Glen" <G(dot)Eustace(at)massey(dot)ac(dot)nz>
To: "'pgsql-general(at)hub(dot)org'" <pgsql-general(at)hub(dot)org>
Subject: RE: Stumped on PlPgSql
Date: 2000-10-18 00:01:53
Message-ID: E57866E2EBE3D311B3720008C7840931024DD2C2@its-xchg2.massey.ac.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message Jinsoo Hwang 2000-10-18 01:06:26 who can use plpgsql?
Previous Message Peter Mount 2000-10-17 23:58:00 Re: Error building JDBC Driver