Re: function language type? - Mailing list pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> plpgsql is not installed by default.  See "createlang plpgsql".

OK. Now it barfs on this:

    CREATE TEMPORARY TABLE NextHopTemp (
        num        integer    REFERENCES Sectors PRIMARY KEY,
        prev        integer    REFERENCES Sectors,
        settled        boolean,
        cost        integer,
    );
    RETURN 1;

with the error 'ERROR:  copyObject: don't know how to copy 611'. Does this
mean one is not permitted to create tables (even temporaries!) in a
function?

Thanks for your advice,

Ian
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.1 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE5fgQcfn9ub9ZE1xoRAm/oAKDbnXiIYmAaxWKe91t0Du/UiNYUjgCggFwA
ynGoNrrbLFV8ujrU8yUUBXM=
=wNrE
-----END PGP SIGNATURE-----