[SQL] must I create the function check_primary_key ?

[Peter J. Schoenster]

Hi,

Thanks to many who clued me on on using "arrow keys" to 
traverse history. I just installed readline and 7.1 .. seems that 
mysql has its own readline.

I want to use this referential integrity etc. that I've never used in 
mysql ... so I tried many things and looked here and there ... My 
example below produces this error:

> CreateTrigger: function check_primary_key() does not exist

Here is what I was trying to create:

DROP TABLE company_profile;

CREATE TABLE company_profile (
        employer_id int4,       
        leadership text,
        company_description  text,
        key_financial_statictics varchar (255),
        company_name varchar (255),
        url varchar (255),
        sec_fillings_url varchar (255),
        mission text,
        employees int4,
        type varchar (50),
        growth_rate varchar (50),
        culture  text,
        year int4,
        PRIMARY KEY (employer_id)
);

CREATE TRIGGER employer_id_exists
BEFORE INSERT OR UPDATE ON company_profile FOR EACH 
ROW
EXECUTE PROCEDURE check_primary_key('employer_id', 
'employer_profile', 'employer_id');

__end example

I just copied the above TRIGGER  .... but it doesn't work for me.

Thanks,

Peter
All idioms must be learned.
Good idioms only need to be learned once. 
--Alan Cooper

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl