Re: [GENERAL] partitioned table insert triggers

2008-06-22 Thread Reece Hart
On Mon, 2008-06-23 at 10:18 +0900, ITAGAKI Takahiro wrote: > You need to do so in 8.3: > EXECUTE 'INSERT INTO ' || ctable || > ' VALUES( (' || quote_literal(new) || '::' || ptable || > ').*)'; > > In 8.4, the next release, you will be able to use a better way: > EXECUTE 'INSER

Re: [GENERAL] partitioned table insert triggers

2008-06-22 Thread ITAGAKI Takahiro
Reece Hart <[EMAIL PROTECTED]> wrote: > c := 'INSERT INTO ' || ctable || ' VALUES (NEW.*)'; > Now that my only idea is gone, the question for y'all is: how? > > ?(Okay, I actually do have one more idea: construct the insert values > list with quote_literal. I'm hoping there's a bett

Re: [GENERAL] postgres generates too much processes per minute

2008-06-22 Thread Josh Tolley
On Thu, Jun 19, 2008 at 8:17 AM, Bill Moran <[EMAIL PROTECTED]> wrote: > In response to "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>: > >> Hello, >> >> i have the problem that postgres ist starting and stopping several (up >> to 4) processes per minute, so that the error log in windows is >> running fu

Re: [GENERAL] Dump and restore problem

2008-06-22 Thread David
On Sun, Jun 22, 2008 at 3:11 AM, Stuart Luppescu <[EMAIL PROTECTED]> wrote: > On 木, 2008-06-19 at 11:57 +0200, David wrote: >> > pg_restore: [tar archiver] could not open TOC file for input: No >> such >> > file or directory >> >> It sounds like the tar file is no longer being created. >> >> Try ma