Hi Tom
Messaggio originale
Da: thombr...@gmail.com
Data: 21/07/2010 10.38
A: "Jan Otto"
Cc: "pdov...@tiscali.it", "pgsql-
gene...@postgresql.org"
Ogg: Re: [GENERAL] INSERT RETURNING and partitioning
On 21 July 2010 09:17, Jan Otto wrote:
> hi,
>
Hi Jan,
Messaggio originale
Da: as...@me.com
Data: 21/07/2010 10.17
A: "pdov...@tiscali.it"
Cc: "pgsql-general@postgresql.org"
Ogg: Re: [GENERAL] INSERT RETURNING and partitioning
hi,
On Jul 21, 2010, at 10:02, "pdov...@tiscali.it"
wrote:
> Hi,
&g
Hi,
I'm testing the system with these two insert commands:
1) this command returns an empty result set:
insert into support.master (a) VALUES (2) RETURNING seq;
2) this command returns correctly the seq (serial) value into result
set:
insert into support.partitionB (a) VALUES (2) RETURNING seq;
Hi all,
I've noticed that an insert command with returning clause returns an
empty result set if done on a master table. Instead the same insert
with returning on partitioned tables works correctly.
Do you know if it's a normal action? I'm doing something wrong?
The partitioning works correctly
