must I create the function check_primary_key ?
От | Peter J. Schoenster |
---|---|
Тема | must I create the function check_primary_key ? |
Дата | |
Msg-id | 3AE7463E.27747.CD77E8D@localhost обсуждение исходный текст |
Ответы |
Re: must I create the function check_primary_key ?
|
Список | pgsql-sql |
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,typevarchar (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
В списке pgsql-sql по дате отправления: