On 21 Jul 2010, at 11:35, pdov...@tiscali.it wrote:
>> Yes, Jan's right. You're effectively overriding the return values
>> with NULL.
>>
>> Although I think I know why you're doing it, because you want to
>> redirect the value to the child table so that it doesn't get inserted
>> into the pare
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
On 21 July 2010 09:17, Jan Otto wrote:
> hi,
>
> On Jul 21, 2010, at 10:02, "pdov...@tiscali.it" wrote:
>
>> 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 c
hi,
On Jul 21, 2010, at 10:02, "pdov...@tiscali.it"
wrote:
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
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;
On 20 July 2010 14:42, pdov...@tiscali.it wrote:
> 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
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
