| From: | salah jubeh <s_jubeh(at)yahoo(dot)com> | 
|---|---|
| To: | pgsql <pgsql-general(at)postgresql(dot)org> | 
| Subject: | Convert table to view 9.1 | 
| Date: | 2013-12-11 12:06:46 | 
| Message-ID: | 1386763606.46451.YahooMailNeo@web122206.mail.ne1.yahoo.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
Hello Guys,
ERROR:  could not convert table "b" to a view because it has triggers
HINT:  In particular, the table cannot be involved in any foreign key relationships.
********** Error **********
ERROR: could not convert table "b" to a view because it has triggers
SQL state: 55000
Hint: In particular, the table cannot be involved in any foreign key relationships.
Scenario:
create table a (id int primary key);
create table b (id int primary key, a_id int references a (id));
insert into  a values (1);
insert into  b values (1,1);
create table c AS SELECT * FROM b;
TRUNCATE b;
ALTER TABLE b DROP CONSTRAINT b_a_id_fkey;
ALTER TABLE b DROP CONSTRAINT b_pkey;
ALTER TABLE b ALTER COLUMN id DROP NOT NULL;
 
CREATE RULE "_RETURN" AS ON SELECT TO b DO INSTEAD SELECT * FROM C;
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Szymon Guz | 2013-12-11 12:11:56 | Re: validate synatax | 
| Previous Message | Dev Kumkar | 2013-12-11 11:38:12 | Scheduled Events |