Bug in pg_get_ruledef?
| От | Sergio Pili |
|---|---|
| Тема | Bug in pg_get_ruledef? |
| Дата | |
| Msg-id | 3C016F90.AA8824ED@sinectis.com.ar обсуждение исходный текст |
| Ответы |
Re: Bug in pg_get_ruledef?
Re: Bug in pg_get_ruledef? |
| Список | pgsql-hackers |
Hello,
pg_get_ruledef cannot read the following rule:
test=# select version(); version
---------------------------------------------------------------------PostgreSQL 7.2b3 on i686-pc-linux-gnu, compiled by
GCCegcs-2.91.66
(1 row)
With the following tables:
test=# \d rd Table "rd"Column | Type | Modifiers
--------+----------+-----------a | smallint |b | smallint |c | text |
Table "ri"Column | Type | Modifiers
--------+----------+--------------d | smallint |e | text |a | smallint | default 1000b |
smallint| default 2000
I create the following rule:
CREATE RULE ins_rd
AS ON INSERT TO ri
WHERE NEW.a IS NOT NULL AND NEW.b IS NOT NULL
DO INSERT INTO rd (a,b) select distinct new.a,new.b
The rule works well. But when i select pg_rules:
test=# select * from pg_rules;
ERROR: Invalid attnum 3 for rangetable entry *SELECT*
Thanks in advance
Sergio.
В списке pgsql-hackers по дате отправления: