| From: | Ian Turner <vectro(at)pipeline(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)hub(dot)org, iant(at)brainstorm(dot)net |
| Subject: | Re: function language type? |
| Date: | 2000-07-25 21:18:18 |
| Message-ID: | Pine.LNX.4.21.0007251414060.2470-100000@crafter.house |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-07-25 21:43:24 | Re: can disks be read only? |
| Previous Message | Joel Burton | 2000-07-25 21:03:52 | (Fwd) RE: PostgreSQL, ODBC, Access (solution for me) |