Re: Having a problem with RoR-3.1.1 and Pg-9.1

Here is an interesting situation. In PGAdmin3-1.14.2 when
I display the extension properties then I see this:

CREATE EXTENSION plpgsql
SCHEMA pg_catalog
VERSION "1.0";
ALTER EXTENSION plpgsql
OWNER TO postgres;

However, if I do this exact statement in the SQL pane
while connected as the postgres superuser then I see this:

ALTER EXTENSION plpgsql OWNER TO postgres;
ERROR: syntax error at or near "OWNER"
LINE 1: ALTER EXTENSION plpgsql OWNER TO postgres;
^

********** Error **********

ERROR: syntax error at or near "OWNER"
SQL state: 42601
Character: 25

So, as I am unfamiliar with the EXTENSION syntax, what is
wrong with the preceding statement? What is the correct
syntax?

--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne mailto:ByrneJB(at)Harte-Lyne(dot)ca
Harte & Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3