Обсуждение: unterminated dollar-quoted string at or near "$$ language plpgsql;" at character 1
unterminated dollar-quoted string at or near "$$ language plpgsql;" at character 1
От
"Mikael Carneholm"
Дата:
This seems to be a psql(?) bug: test.sql -------- create or replace function test1() returns void as $$ declare var1 integer; var2 integer; var3 integer; begin end; $$ language plpgsql; miano=3D> \i test.sql=20 psql:test.sql:3: ERROR: unterminated dollar-quoted string at or near "$$= =20=20=20 declare var1 integer;" at character 52 psql:test.sql:4: ERROR: syntax error at or near "var2" at character 3 psql:test.sql:5: ERROR: syntax error at or near "var3" at character 3 psql:test.sql:7: ERROR: syntax error at or near "end" at character 7 psql:test.sql:8: ERROR: unterminated dollar-quoted string at or near "$$ l= anguage plpgsql;" at character 1 It compiles when run from the PgAdmin III Query tool, but fails when run fr= om psql (see above output). miano=3D> select version(); version=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20 ---------------------------------------------------------------------------= ------------------------ PostgreSQL 8.1.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.4 200= 50721 (Red Hat 3.4.4-2) (1 row)
Re: unterminated dollar-quoted string at or near "$$ language plpgsql;" at character 1
От
Peter Eisentraut
Дата:
Mikael Carneholm wrote: > This seems to be a psql(?) bug: It seems you're using an older version of psql. -- Peter Eisentraut http://developer.postgresql.org/~petere/
Re: unterminated dollar-quoted string at or near "$$ language plpgsql;" at character 1
От
"Mikael Carneholm"
Дата:
*doh* Someone had installed v7.4 from rpm which placed psql in /usr/bin (precedin= g v8.1/bin in PATH), causing the 7.4 version to be run instead of the 8.1 v= ersion. Sorry for that. -----Original Message----- From: Peter Eisentraut [mailto:peter_e@gmx.net] Sent: den 20 mars 2006 12:45 To: pgsql-bugs@postgresql.org Cc: Mikael Carneholm Subject: Re: [BUGS] unterminated dollar-quoted string at or near "$$ language plpgsql;" at character 1 Mikael Carneholm wrote: > This seems to be a psql(?) bug: It seems you're using an older version of psql. --=20 Peter Eisentraut http://developer.postgresql.org/~petere/