By the way. I took your advice and redesigned the tables and the function so that it is not needed to lock the table at all. I assume this work because of MVCC. Thanks, juan -----Original Message----- From: Martijn van Oosterhout [mailto:kleptog@xxxxxxxxx] Sent: Friday, February 04, 2005 1:56 PM To: Juan Casero (FL FLC) Cc: Postgresql General Subject: Re: plpgsql function errors On Fri, Feb 04, 2005 at 12:44:35PM -0600, Juan Casero (FL FLC) wrote: > Sorry about that. I did forget one parameter... > > customer_service=# select > trx_id('JUANCASERO3055128218',805,'CREDIT','02/02/05','1','1','Aventura' > ,'02/01/05','Tom'); > ERROR: function trx_id("unknown", integer, "unknown", "unknown", > "unknown", "unknown", "unknown", "unknown", "unknown") does not exist > HINT: No function matches the given name and argument types. You may > need to add explicit type casts. Please post the output of: \df+ trx_id That will tell you what parameters it expects. -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is > a tool for doing 5% of the work and then sitting around waiting for > someone else to do the other 95% so you can sue them. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
