Re: command to Describe RULE
От | PGMailList |
---|---|
Тема | Re: command to Describe RULE |
Дата | |
Msg-id | 003901c1d58c$3199b820$05faa8c0@edios обсуждение исходный текст |
Ответ на | command to Describe RULE (<tsmets@brutele.be>) |
Список | pgsql-general |
select * from pg_rules http://www.pgexplorer.com ----- Original Message ----- From: <tsmets@brutele.be> To: <pgsql-general@postgresql.org> Sent: Wednesday, March 27, 2002 3:19 AM Subject: [GENERAL] command to Describe RULE > > > I create a table (addresses) & its "historification". > When an address is modified, it's moved to the historification which is > basically a copy on "update" or "delete". > I seem to have a proble & I wanna find the RULE I created to alter them. > What command should I issue for that. > I seem to not be able to find any \d command for that ... > Could some one hint me ? > > Tx, > > Thomas, > > =============================== > > > > -- This table is really useless as such > -- ************************************* > CREATE TABLE historification ( pkh SERIAL, > -- This will be the moment the record is "archived" > dateend TIMESTAMP DEFAULT CURRENT_TIMESTAMP); > > > > -- Here is a basic address table > CREATE TABLE addresses ( pk SERIAL, > street CHAR(50) NOT NULL, > street2 CHAR(50), > zip CHAR(10) NOT NULL, > city CHAR(30) NOT NULL, > -- I have a table countries where the countries > -- iso-codes are stored > Country CHAR(2) REFERENCES COUNTRIES, > datemodified TIMESTAMP DEFAULT CURRENT_TIMESTAMP); > > > -- Here is the PostgreSQL historification > CREATE TABLE AddressHistorics () > INHERITS (historification, addresses); > > > > CREATE RULE update_address AS > ON UPDATE TO addresses > DO > INSERT INTO AddressHistorics (pk, street, street2, zip, city, > country, datemodified) > VALUES (old.pk, old.street, old.street2, old.zip, old.city, > old.country, old.datemodified); > > > CREATE RULE delete_address AS > ON DELETE TO Addresses > DO > INSERT INTO AddressHistorics (pk, street, street2, zip, city, > country, datemodified) > VALUES (old.pk, old.street, old.street2, old.zip, old.city, > old.country, old.datemodified); > > > -- > Thomas SMETS > rue J. Wytsmanstraat 62 > 1050 Bruxelles > yahoo-id : smetsthomas > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >
В списке pgsql-general по дате отправления: