http://www.sqle.ru/index.php?action=history&feed=atom&title=PostgreSQL%2FConstraints%2FCreate_Rule
PostgreSQL/Constraints/Create Rule - История изменений
2026-04-04T16:33:01Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=PostgreSQL/Constraints/Create_Rule&diff=4968&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:56Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://www.sqle.ru/index.php?title=PostgreSQL/Constraints/Create_Rule&diff=4969&oldid=prev
Admin: 1 версия
2010-05-26T10:14:32Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==CREATE OR REPLACE RULE==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
postgres=#<br />
postgres=# CREATE TABLE measurement (<br />
postgres(# city_id int not null,<br />
postgres(# logdate date not null,<br />
postgres(# peaktemp int,<br />
postgres(# unitsales int<br />
postgres(# );<br />
CREATE TABLE<br />
postgres=#<br />
postgres=# CREATE TABLE measurement_yy04mm02 (<br />
postgres(# CHECK ( logdate >= DATE "2004-02-01" AND logdate < DATE "2004-03-01" )<br />
postgres(# ) INHERITS (measurement);<br />
CREATE TABLE<br />
postgres=#<br />
postgres=# CREATE TABLE measurement_yy04mm03 (<br />
postgres(# CHECK ( logdate >= DATE "2004-03-01" AND logdate < DATE "2004-04-01" )<br />
postgres(# ) INHERITS (measurement);<br />
CREATE TABLE<br />
postgres=#<br />
postgres=# CREATE OR REPLACE RULE measurement_current_partition AS<br />
postgres-# ON INSERT TO measurement<br />
postgres-# DO INSTEAD<br />
postgres-# INSERT INTO measurement_yy06mm01 VALUES ( NEW.city_id,<br />
postgres(# NEW.logdate,<br />
postgres(# NEW.peaktemp,<br />
postgres(# NEW.unitsales );<br />
ERROR: relation "measurement_yy06mm01" does not exist<br />
postgres=#<br />
postgres=# CREATE RULE measurement_insert_yy04mm02 AS<br />
postgres-# ON INSERT TO measurement WHERE<br />
postgres-# ( logdate >= DATE "2004-02-01" AND logdate < DATE "2004-03-01" )<br />
postgres-# DO INSTEAD<br />
postgres-# INSERT INTO measurement_yy04mm02 VALUES ( NEW.city_id,<br />
postgres(# NEW.logdate,<br />
postgres(# NEW.peaktemp,<br />
postgres(# NEW.unitsales );<br />
CREATE RULE<br />
postgres=#<br />
postgres=# CREATE VIEW allmeasurement AS<br />
postgres-# SELECT * FROM measurement_yy04mm02<br />
postgres-# UNION ALL<br />
postgres-# SELECT * FROM measurement_yy04mm03;<br />
CREATE VIEW<br />
postgres=#<br />
postgres=# drop view allmeasurement cascade;<br />
DROP VIEW<br />
postgres=# drop table measurement_yy04mm02 cascade;<br />
NOTICE: drop cascades to rule measurement_insert_yy04mm02 on table measurement<br />
DROP TABLE<br />
postgres=# drop table measurement_yy04mm03 cascade;<br />
DROP TABLE<br />
postgres=# drop table measurement cascade;<br />
DROP TABLE<br />
postgres=#<br />
postgres=#<br />
<br />
</source></div>
Admin