Postgres Stored procedures and Entity Developer
Posted: Tue 04 Oct 2011 18:15
I have an Entity Model for my database. I want to add stored procedures for inserting, updating, and deleting rows from certain tables. I can't get entity developer to list my stored procedures in the Behavior dialog.
Here's a sample of a stored procedure I've written:
This stored function shows up under "Stored Procedures", but I cannot do anything with it in the model.
What am I doing wrong?
Thanks
Tony
Here's a sample of a stored procedure I've written:
Code: Select all
CREATE OR REPLACE FUNCTION "CarSystem"."InsertList"( ListName VARCHAR(50), ListTypeId INT, DomainId INT, Geofencing VARCHAR, Salt VARCHAR(50), WhiteListAlarmClassId INT ) RETURNS VOID AS $$
INSERT INTO "CarSystem"."Lists"
( "ListName", "ListTypeId", "DomainId", "LastUpdate", "Geofencing", "Salt", "WhiteListAlarmClassId" )
VALUES
( $1, $2, $3, NOW(), $4, $5, $6 );
$$ LANGUAGE SQL;
What am I doing wrong?
Thanks
Tony