Re: [Gnumed-devel] psql complains when trying to insert into ref.billables

[Karsten Hilbert]

On Fri, Jul 06, 2012 at 01:21:10AM +0000, Jim Busser wrote:

> INSERT INTO ref.billable
> ( code,
>   term,
>   fk_data_source,
>   comment,
>   amount,
>   currency
> )
>   SELECT fee_item, description, 12, '', CAST(amount as numeric)/100, 'u0024' 
> FROM staging.fee_teleplan
> ;
> 
> 
> yields:
> 
> ERROR:  record "new" has no field "row_version"
> CONTEXT:  PL/pgSQL function "ft_ins_billable" line 2 at assignment

That is the same bug as with the failing DELETE. I'm
checking up on this one but haven't pinned it down just yet.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346