Re: dollar-quoting trouble

On Fri, Apr 20, 2007 at 12:40:45PM +1000, Klint Gore wrote:

>> I can't spot the trouble with this function definition:
...
>> PostgreSQL 8.1.8 (Debian/Etch) is telling me:
Actually, Lenny.

>> psql:dem-identity.sql:43: ERROR: unterminated dollar-quoted string at or near "$null_empty_title$
>> begin
>> if (NEW.title is null) then
>> return NEW;" at character 83
>
> Does "psql --version" match "select version()"? There's a message in
> the archive pgsql-bugs where this happened.
That was indeed part of the trouble:

Both 7.4.16 and 8.1.8 being installed on Debian I couldn't
get the default psql be 8.1 despite using
update-alternatives. So there was psql 7.4 being used
against the 8.1 server which is bound to lead to trouble.

That being solved by deinstalling 7.4 (which I was
transitioning off anyways) psql created the function just
fine.

My own bootstrapper code still throws the error (it is using
psycopg2 which is using libpq4) ... but, wait, deinstalling
libpq3 apparently makes psycopg2 use libpq4 (?!) as it now
works ...

Thanks for the assistance from the GNUmed team,
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346