pgAdmin Funciton Code

From: "kenp" <kpriest(at)rm(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgAdmin Funciton Code
Date: 2006-11-28 16:45:45
Message-ID: 1164732345.037859.185590@h54g2000cwb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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 REPLACE FUNCTION
"Security"."CentreGroupPolicyDetailsGet1"(INOUT "pCentreGroupPolicyID"
bigint) AS
$BODY$
BEGIN
SELECT INTO
"pCentreGroupPolicyID"
cgp."CentreGroupPolicyID"
FROM "Security"."CentreGroupPolicy" cgp
WHERE cgp."CentreGroupPolicyID" = "pCentreGroupPolicyID";
END;
$BODY$
LANGUAGE 'plpgsql' STABLE;

Then pgAdmin shows me:-

CREATE OR REPLACE FUNCTION
"Security"."CentreGroupPolicyDetailsGet1"(INOUT pCentreGroupPolicyID
bigint) AS
$BODY$
BEGIN
SELECT INTO
"pCentreGroupPolicyID"
cgp."CentreGroupPolicyID"
FROM "Security"."CentreGroupPolicy" cgp
WHERE cgp."CentreGroupPolicyID" = "pCentreGroupPolicyID";
END;
$BODY$
LANGUAGE 'plpgsql' STABLE;

Which does not run.

If instead I use:-

CREATE OR REPLACE FUNCTION
"Security"."CentreGroupPolicyDetailsGet1"(INOUT pCentreGroupPolicyID
bigint) AS
$BODY$
BEGIN
SELECT INTO
pCentreGroupPolicyID
cgp."CentreGroupPolicyID"
FROM "Security"."CentreGroupPolicy" cgp
WHERE cgp."CentreGroupPolicyID" = pCentreGroupPolicyID;
END;
$BODY$
LANGUAGE 'plpgsql' STABLE;

pgAdmin gives me:-

CREATE OR REPLACE FUNCTION
"Security"."CentreGroupPolicyDetailsGet1"(INOUT pcentregrouppolicyid
bigint) AS
$BODY$
BEGIN
SELECT INTO
pCentreGroupPolicyID
cgp."CentreGroupPolicyID"
FROM "Security"."CentreGroupPolicy" cgp
WHERE cgp."CentreGroupPolicyID" = pCentreGroupPolicyID;
END;
$BODY$
LANGUAGE 'plpgsql' STABLE;

and the case no longer matches for the parameter.

Is it possible to make it more consistent?

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2006-11-28 17:06:37 Re: pgAdmin Funciton Code
Previous Message Dave Page 2006-11-28 10:35:24 Re: Treatment of views with associated rules -