INSERT into VIEW

From: Oleg Broytmann <phd(at)sun(dot)med(dot)ru>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Cc: Artem Chuprina <ran(at)pirit(dot)com>
Subject: INSERT into VIEW
Date: 1999-06-06 14:08:22
Message-ID: Pine.SOL2.3.96.SK.990606180614.1940A-100000@sun.med.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello!

PostgreSQL 6.4.2.

ran=> create table t (some_number int4, some_string text);
CREATE
ran=> insert into t values(-1,'a');
INSERT 20362 1
ran=> insert into t values(1,'d');
INSERT 20363 1
ran=> create view v as select * from t where some_number>=0;
CREATE
ran=> insert into v values (17,'q');
INSERT 20375 1
ran=> select * from t;
some_number|some_string
-----------+-----------
-1|a
1|d
(2 rows)

What is 20375? Is it real OID of dummy row?

Oleg.
----
Oleg Broytmann http://members.xoom.com/phd2/ phd2(at)earthling(dot)net
Programmers don't die, they just GOSUB without RETURN.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kaare Rasmussen 1999-06-06 14:35:14 Re: [HACKERS] Priorities for 6.6
Previous Message Vadim Mikheev 1999-06-06 13:32:36 Re: [HACKERS] Bizarre coding in _bt_binsrch