473,326 Members | 2,114 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Rules in Postgresql

10
Dear Postgresql forum,

I have some question related to the rules in postgresql. I have a table invention with the following rules

Rules : rule_invention_insert,
rule_invention_update,
rule_invention_delete.

I need to know the inside of this rule, i mean how the relation and so on. Is there any command to see the inside of this rule ?
Please help me. Thank you very much in advance.

Best regards,
Bogie
Sep 13 '07 #1
2 3136
rski
700 Expert 512MB
Dear Postgresql forum,

I have some question related to the rules in postgresql. I have a table invention with the following rules

Rules : rule_invention_insert,
rule_invention_update,
rule_invention_delete.

I need to know the inside of this rule, i mean how the relation and so on. Is there any command to see the inside of this rule ?
Please help me. Thank you very much in advance.

Best regards,
Bogie

I'm not sre if I understand but if u want to see the definition of the rule
use the below query
select definition from pg_rules where rulename='your rule name';
Sep 13 '07 #2
bogie
10
I'm not sre if I understand but if u want to see the definition of the rule
use the below query
select definition from pg_rules where rulename='your rule name';

HAlo

Thank you very much for your help, it works.

Best regards,
Bogie
Sep 13 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Thomas Reat | last post by:
The postgresql documentation claims that "on insert" rules are executed after the insert. This is not happening for me. I have a rule that is being executed even though the insert should have...
8
by: btober | last post by:
I'm finding that column defaults are not being assigned to nulls when I do an insert by way of a an ON INSERT rule on a view. For example, the following script \set ON_ERROR_STOP ON \c...
2
by: Dmitry Tkach | last post by:
Hi, everybody! Here is a weird problem I ran into with 7.3.4. This is the complete test case: rapidb=# select version (); version...
10
by: Timothy Perrigo | last post by:
I'm trying to set up some basic rules to log inserts, updates, and deletes to tables in an inheritance hierarchy (by inserting records into a log table), and I've got a couple of questions. (1) ...
0
by: Ulrich Meis | last post by:
Hi! Situation two schemas: webviews: Contains a set of views with insert rules on them, accessed via a GUI. devconf: "Business logic", all the tables, functions, triggers that I want to...
1
by: Bastian Blank | last post by:
I'm using postgresql 7.4.2 and COPY FROM don't trigger INSERT rules. Definitions: | CREATE TABLE log.package_status ( | version integer NOT NULL, | architecture integer NOT NULL, | ...
8
by: Najib Abi Fadel | last post by:
Hi all i am running PostgreSQL 7.3.2, i have a VIEW for which i implemented multiple RULES on UPDATE. The weird think is that the Update Query corresponding to one of the rules is updating...
0
by: Vassilev, Lubomir G. | last post by:
i am currently migrating a db from Oracle to Pg and in some of my triggers i use variables, i.e. i have some thing like this: CREATE OR REPLACE TRIGGER "USERACTION_VIEW" INSTEAD OF...
3
by: Robert Fitzpatrick | last post by:
I have a view that used union all to merge three tables together. I was hoping to create a rule, one for each table using the WHERE condition of the rule to determine which table gets updated. Is...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.