To: "Oliver Crosby" <ryusei@gmail.com>,
	"Sven Willenberger" <sven@dmv.com>
Cc: "Dawid Kuroczko" <qnex42@gmail.com>,
	"Kevin Grittner" <Kevin.Grittner@wicourts.gov>, jd@commandprompt.com,
	pgsql-performance@postgresql.org
Subject: Re: Looking for tips
References: <s2dd0700.023@gwmta.wicourts.gov>
	<1efd553a0507191308219a098b@mail.gmail.com>
	<758d5e7f0507191319636afaa3@mail.gmail.com>
	<1efd553a050719132836c31b78@mail.gmail.com>
	<1121805961.3674.25.camel@lanshark.dmv.com>
	<1efd553a050719140462d41468@mail.gmail.com>
Message-ID: <op.st6nlincth1vuj@localhost>
Date: Wed, 20 Jul 2005 01:01:56 +0200
From: PFC <lists@boutiquenumerique.com>
Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?=
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
In-Reply-To: <1efd553a050719140462d41468@mail.gmail.com>
User-Agent: Opera M2/8.0 (Linux, build 1095)


	You could have a program pre-parse your log and put it in a format  
understandable by COPY, then load it in a temporary table and write a part  
of your application simply as a plpgsql function, reading from this table  
and doing queries (or a plperl function)...

> So... (bear with me here.. trying to make sense of this)..
> With triggers there's a way I can do the parsing I need to on a log
> file and react to completed events in non-sequential order (you can
> ignore that part.. it's just how we piece together different related
> events) and then have perl/DBD::Pg invoke a copy command (which, from
> what I can tell, has to operate on a file...) and the copy command can
> feed the ID I need back to perl so I can work with it...
> If that doesn't hurt my brain, then I'm at least kinda confused...
> Anyway. Heading home now. I'll think about this more tonight/tomorrow.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>