Convert table to view 9.1

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: Raw Message | Whole Thread | 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;

Responses

Browse pgsql-general by date

  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