On 20 July 2010 14:42, pdovera@xxxxxxxxxx <pdovera@xxxxxxxxxx> 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'm doing something wrong? > > The partitioning works correctly with all kind of SQL commands: > select, delete, update and "normal" insert. > > I've read the manual and it reports this: > "The optional RETURNING clause causes INSERT to compute and return > value(s) based on each row actually inserted. This is primarily useful > for obtaining values that were supplied by defaults, such as a serial > sequence number. However, any expression using the table's columns is > allowed. The syntax of the RETURNING list is identical to that of the > output list of SELECT." > > but nothing about partitioning ... > > Regards, > Paolo > > PS: I'm using PostgreSQL 8.3.4 on x86 Linux box > > Yes, that should work even on partitioned tables. Could you provide some sample SQL you're using? Thom -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
