public inbox for [email protected]
help / color / mirror / Atom feedRETURN NULL in the sample of insert trigger on partitioned table
2+ messages / 2 participants
[nested] [flat]
* RETURN NULL in the sample of insert trigger on partitioned table
@ 2018-07-11 09:34 PG Doc comments form <[email protected]>
2018-08-07 17:57 ` Re: RETURN NULL in the sample of insert trigger on partitioned table Bruce Momjian <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2018-07-11 09:34 UTC (permalink / raw)
To: [email protected]; +Cc: [email protected]
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/static/ddl-partitioning.html
Description:
Why in provided samples of "insert" triggers on partitioned table at the end
of the triggers you provide "return NULL" not "return NEW"?
This causes, among other things, problems with the GET DIAGNOSTICS clause
var = ROW_COUNT clause.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: RETURN NULL in the sample of insert trigger on partitioned table
2018-07-11 09:34 RETURN NULL in the sample of insert trigger on partitioned table PG Doc comments form <[email protected]>
@ 2018-08-07 17:57 ` Bruce Momjian <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2018-08-07 17:57 UTC (permalink / raw)
To: [email protected]; [email protected]
On Wed, Jul 11, 2018 at 09:34:59AM +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.6/static/ddl-partitioning.html
> Description:
>
> Why in provided samples of "insert" triggers on partitioned table at the end
> of the triggers you provide "return NULL" not "return NEW"?
>
> This causes, among other things, problems with the GET DIAGNOSTICS clause
> var = ROW_COUNT clause.
Uh, you mean measurement_insert_trigger? Returning NEW would cause the
row to be inserted into the referenced table.
--
Bruce Momjian <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-08-07 17:57 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-07-11 09:34 RETURN NULL in the sample of insert trigger on partitioned table PG Doc comments form <[email protected]>
2018-08-07 17:57 ` Bruce Momjian <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox