Re: [pgadmin-support] pgAdmin Funciton Code

2006-11-28 Thread Raymond O'Donnell
On 28 Nov 2006 at 22:06, Raymond O'Donnell wrote: > Don't you need to declare pCentreGroupPolicyID first? - Oops, my mistake - you don't of course, because it's an INOUT parameter. --Ray. -- Raymond O'Donnell Director of Mu

Re: [pgadmin-support] pgAdmin Funciton Code

2006-11-28 Thread Raymond O'Donnell
On 28 Nov 2006 at 8:45, kenp wrote: > SELECT INTO >"pCentreGroupPolicyID" Don't you need to declare pCentreGroupPolicyID first? - .etc $body$ declare pCentreGroupPolicyID bigint; begin ..etc This would cause the function not to run..what error me

Re: [pgadmin-support] pgAdmin Funciton Code

2006-11-28 Thread Dave Page
kenp wrote: The code displayed by pgAdmin, for a function I have created, does not allow me to recreate the function as I would like. If I run :- Thanks Ken - I've fixed this for 1.6.1. Regards Dave ---(end of broadcast)--- TIP 3: Have you che

[pgadmin-support] pgAdmin Funciton Code

2006-11-28 Thread kenp
The code displayed by pgAdmin, for a function I have created, does not allow me to recreate the function as I would like. If I run :- CREATE SCHEMA "Security" AUTHORIZATION postgres; CREATE TABLE "Security"."CentreGroupPolicy" ( "CentreGroupPolicyID" bigint NOT NULL ) WITHOUT OIDS; CREATE OR