[BUGS] RULE ON INSERT and INSERT INTO ... SELECT

2005-04-10 Thread falcon
Hello pgsql-bugs, I'm here again. I'm using PostgreSQL 8.0.1 on Windows and Linux Slackware 10.0 --Start test-- create sequence try3_seq; create table try3 ( id int PRIMARY KEY, info varchar(30) ) without oids; create table try4 ( id int, info varchar(30) ) wit

[BUGS] Repeat RULE ON INSERT and DEFAULT nextval('...')

2005-04-10 Thread falcon
Hello pgsql-bugs, Excuse my English. I'm from Russia. I realized i forgotten to write version of PostgreSQL in previous letter. I'm using PostgreSQL 8.0.1 on Windows and Slackware 10.0 compilled with gcc 3.3.4 I understood, that following is implementation behavior, but this is really not what i

[BUGS] RULE ON INSERT and DEFAULT nextval('...')

2005-04-10 Thread falcon
Hello pgsql-bugs, Excuse my English. I'm from Russia. I understood, that following is implementation behavior, but this is really not what i'm expecting to see. --Start test-- create table try1 ( id serial PRIMARY KEY,-- same with DEFAULT nextval('some_sequence') info varchar(