Strange behaviour of RULE (selecting last inserted ID of 'sequenced' column) - Mailing list pgsql-general

From Nikolay Samokhvalov
Subject Strange behaviour of RULE (selecting last inserted ID of 'sequenced' column)
Date
Msg-id e431ff4c0607130715u39894e48qb3011a3a3b2d6038@mail.gmail.com
Whole thread Raw
List pgsql-general
Is this a bug?

test=> create sequence strange_seq;
CREATE SEQUENCE
test=> create table strange(id integer not null default
nextval('strange_seq') primary key, data text);
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"strange_pkey" for table "strange"
CREATE TABLE
test=> create rule strange_rule as on insert to strange do select new.id as id;
CREATE RULE
test=> insert into strange(data) values('adas');
 id
----
  2
(1 row)

test=> select * from strange;
 id | data
----+------
  1 | adas
(1 row)

test=> insert into strange(data) values('adas');
 id
----
  4
(1 row)

test=> insert into strange(data) values('adas');
 id
----
  6
(1 row)

test=> select * from strange;
 id | data
----+------
  1 | adas
  3 | adas
  5 | adas
(3 rows)


--
Best regards,
Nikolay

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: getting function argument names from psql?
Next
From: Heatsink Admin
Date:
Subject: Understanding fsync error