unterminated dollar-quoted string at or near "$$ language plpgsql; " at character 1

Started by Mikael Carneholmabout 20 years ago3 messagesbugs
Jump to latest
#1Mikael Carneholm
Mikael.Carneholm@WirelessCar.com

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=> \i test.sql
psql:test.sql:3: ERROR: unterminated dollar-quoted string at or near "$$
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 "$$ language plpgsql;" at character 1

It compiles when run from the PgAdmin III Query tool, but fails when run from psql (see above output).

miano=> select version();
version
---------------------------------------------------------------------------------------------------
PostgreSQL 8.1.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.4 20050721 (Red Hat 3.4.4-2)
(1 row)

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Mikael Carneholm (#1)
Re: 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.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

#3Mikael Carneholm
Mikael.Carneholm@WirelessCar.com
In reply to: Peter Eisentraut (#2)
Re: unterminated dollar-quoted string at or near "$$ language plpgsql; " at character 1

*doh*

Someone had installed v7.4 from rpm which placed psql in /usr/bin (preceding v8.1/bin in PATH), causing the 7.4 version to be run instead of the 8.1 version.

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.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/