trouble installing plpgsql

Started by Wiebe de Jongover 21 years ago2 messagesgeneral
Jump to latest
#1Wiebe de Jong
wiebedj@shaw.ca

Hello,

When I attempt to run 'createlang plpgsql template1' I get the following
error:

Error at or near "createlang" at character 1

Running psql 7.3.4 on redhat 9

Logged in as postgres

Verified existence of /usr/lib/pgsql/plpgsql.so

Any ideas on how to fix this problem?

Wiebe de Jong

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Wiebe de Jong (#1)
Re: trouble installing plpgsql

Wiebe de Jong <wiebedj@shaw.ca> writes:

When I attempt to run 'createlang plpgsql template1' I get the following
error:

Error at or near "createlang" at character 1

createlang is a shell script, not an SQL command. Run it from the shell.

regards, tom lane