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
