Home > mailing lists

Partitioning: avoid insert in master table - Mailing list pgsql-novice

From	Sergio Sinuco
Subject	Partitioning: avoid insert in master table
Date	January 3, 2012 22:30:29
Msg-id	CAHn1vgH_ConTmAYf5OQwv-=9-zRX+mOaWYjxLRP1s-tgxkcR0A@mail.gmail.com Whole thread Raw
Responses	Re: Partitioning: avoid insert in master table
List	pgsql-novice

Tree view

Hi everyone. I have problems with the trigger in master table in a basic table partitioning. The trigger is "ON BEFORE INSERT" and return NULL, but the row is inserted in the master and child table. I'm using Postgresql 8.4. What can I do?

Thanks,

Sergio Sinuco.

pgsql-novice by date:

From: avalon78 geek
Date: 03 January 2012, 11:24:47
Subject: Re: ERROR: invalid input syntax for integer: SQL state: 22P02

From: Thom Brown
Date: 03 January 2012, 23:19:23
Subject: Re: error tryiing to insert with collate

Partitioning: avoid insert in master table - Mailing list pgsql-novice

Previous

Next