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 SCARICA TISCALI WIPHONE: parla e invia SMS gratis dal tuo cellulare. http://wiphone.tiscali.it -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
