Re: [GENERAL] postmaster disconnects after heavy load inserts from plperlu -> waht to do?

2007-01-18 Thread Christian Maier
date of my Installation everything works now. Thanks Chris Tom Lane schrieb: > "Christian Maier" <[EMAIL PROTECTED]> writes: > > I have written a function to load yahoo quote data. abut after parsing > > the inserts will overload the server and disconnects. > >

[GENERAL] postmaster disconnects after heavy load inserts from plperlu -> waht to do?

2007-01-16 Thread Christian Maier
Hello! I have written a function to load yahoo quote data. abut after parsing the inserts will overload the server and disconnects. What sould I do to avound this? THX Christian Maier PS Here the function: CREATE OR REPLACE FUNCTION get_yahoo(VARCHAR(20), BIGINT, VARCHAR(3)) RETURNS INTEGER AS

[GENERAL] plperl trigger problem

2006-12-20 Thread Christian Maier
Sorry I have not found a plperl group so I hope the useres of this group can help me. I have some csv data and some columns are in a bad format. this means that some float values are formatet as " ." if the are 0. So I have made an before insert trigger that looks for these values and replaces