Hi,
I'd recommend coping directly to child tables (partitions). It's much
faster.
Regards,
foo
Scott Marlowe wrote:
I believe triggers can do it.
On Sun, Aug 9, 2009 at 11:15 PM, cjm1010cjm1...@naver.com wrote:
hi~
I want to insert DATA by using the COPY making PARTITON TABLE. By the
thanks for reply
I am using rules with libpq instead of triggers now.
When INSERT was used, it was possible to insert it in CHILD TABLE well.
However, if COPY is used, it is possible to insert it only in PARENT TABLE.
Can triggers be used with libpq?
And, if trigger is used, can it straighten
On Mon, Aug 10, 2009 at 12:58 AM, cjm1010cjm1...@naver.com wrote:
thanks for reply
I am using rules with libpq instead of triggers now.
When INSERT was used, it was possible to insert it in CHILD TABLE well.
However, if COPY is used, it is possible to insert it only in PARENT TABLE.
Can
hi~
I want to insert DATA by using the COPY making PARTITON TABLE. By the way,
DATA is inserted only in PARENT TABLE.
Can DATA be inserted in CHILD TABLE by using the COPY?
Thanks,
JM CHAE
--
View this message in context:
I believe triggers can do it.
On Sun, Aug 9, 2009 at 11:15 PM, cjm1010cjm1...@naver.com wrote:
hi~
I want to insert DATA by using the COPY making PARTITON TABLE. By the way,
DATA is inserted only in PARENT TABLE.
Can DATA be inserted in CHILD TABLE by using the COPY?
--
Sent via