Search Postgresql Archives

Using RETURNING with INSERT TRIGGER on 9.6 partitioned table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

I'm using partitioned tables with INSERT triggers on PostgreSQL 9.6,
and I have a question about using "RETURNING NEW" in those triggers.

I have found a note mentioning consideration and workaround
on using INSERT ... RETURNING on the partitioned table [1].

[1] INSERT RETURNING vs Partitioning - PostgreSQL wiki
    https://wiki.postgresql.org/wiki/INSERT_RETURNING_vs_Partitioning

However, according to my experience, using "RETURNING NEW"
in my insert trigger function looks working fine without the workadound.

So, here is a question.
Do we still need the workaround mentioned in the note?
If so, why?

Regards,
--
Satoshi Nagayasu <snaga@xxxxxxxxx>




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux