Inserting into views

From: Richard Harvey Chapman <hchapman(at)3gfp(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Inserting into views
Date: 2000-06-28 03:00:55
Message-ID: Pine.LNX.4.10.10006271957170.14843-100000@smile.3gfp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is this allowed in Postgresql?

It "appears" to work, but then doesn't.

R.
----
test=# create table liar (num integer, name varchar(20));
CREATE
test=# insert into liar values (32, 'Bill');
INSERT 31754 1
test=# insert into liar values (2, 'Joey');
INSERT 31755 1
test=# insert into liar values (6, 'Felicia');
INSERT 31756 1
test=# select * from liar;
num | name
-----+---------
32 | Bill
2 | Joey
6 | Felicia
(3 rows)

test=# create view liar_view as select num, name, num as fodder from liar;
CREATE 31768 1
test=# SELECT * from liar_view ;
num | name | fodder
-----+---------+--------
32 | Bill | 32
2 | Joey | 2
6 | Felicia | 6
(3 rows)

test=# insert into liar_view (num, name) values (43, 'Jane');
INSERT 31769 1
test=# SELECT * from liar_view ;
num | name | fodder
-----+---------+--------
32 | Bill | 32
2 | Joey | 2
6 | Felicia | 6
(3 rows)

test=# select * from liar;
num | name
-----+---------
32 | Bill
2 | Joey
6 | Felicia
(3 rows)

test=# insert into liar_view (num, name, fodder) values (43, 'Jane', 43);
INSERT 31770 1

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Howard 2000-06-28 03:29:28 Connecting postgreSQL using JDBC
Previous Message Richard Harvey Chapman 2000-06-28 01:59:18 Re: Re: PostgreSQL General Digest V1 #266