From: | Peter Vazsonyi <neko(at)kredit(dot)sth(dot)szif(dot)hu> |
---|---|
To: | Michael Fraley <fraley(at)usfca(dot)edu> |
Cc: | pgsql-hackers(at)postgresql(dot)org, Michael Fraley <fraley(at)beta(dot)usfca(dot)edu> |
Subject: | Re: Please help cache lookup failed |
Date: | 2000-06-27 21:48:36 |
Message-ID: | Pine.LNX.4.10.10006272324550.5126-100000@kredit.sth.szif.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general pgsql-hackers |
This works, but you may create the function first...
And then the trigger...
On Tue, 27 Jun 2000, Michael Fraley wrote:
> ERROR: fmgr_info: function 19104: cache lookup failed
> create subscriptions table
> -------------------
> CREATE SEQUENCE "subscriptions_script_id_seq" start 1 increment 1 maxvalue
> 2147483647 minvalue 1 cache 1 ;
> CREATE TABLE "subscriptions" (
> "script_id" int4 DEFAULT nextval('subscriptions_script_id_seq') NOT NULL,
> "mag_id" int4 NOT NULL,
> "paid_amount" money NOT NULL,
> "start_date" date NOT NULL,
> "end_date" date NOT NULL,
> "notes" text);
> CREATE UNIQUE INDEX "subscriptions_script_id_key" on "subscriptions" using btree
> ( "script_id" "int4_ops" );
> CREATE TRIGGER "sub_mag_trigger" BEFORE INSERT OR UPDATE ON "subscriptions"
> FOR EACH ROW EXECUTE PROCEDURE
> check_primary_key ('mag_id', 'magazines', 'mag_id');
>
> create function
> ------------
> CREATE FUNCTION "check_primary_key" ( ) RETURNS opaque AS
> '/usr/local/pgsql/lib/modules/refint.so' LANGUAGE 'C';
>
>
> --
>
> Michael Fraley
> fraley(at)usfca(dot)edu
> http://www.usfca.edu/~fraley
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-06-27 21:49:04 | Re: Please help cache lookup failed |
Previous Message | Michael Edwards | 2000-06-27 08:46:17 | PostgreSQL & Openmerchan |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-06-27 21:49:04 | Re: Please help cache lookup failed |
Previous Message | Sravan Kumar Reddy Changal | 2000-06-27 20:24:18 | Regarding editor commands |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-06-27 21:49:04 | Re: Please help cache lookup failed |
Previous Message | Tom Lane | 2000-06-27 21:48:04 | Re: Fwd: Re: Fwd: Problem with recv syscall on socket when other side closed connection |