update-quotes.pl fails

[GoogleCodeExporter]

[trader@hostname bin]$ ./update-quotes.pl 
[INFO][Seeking update to], 888 L 2005-09-29 2009-12-24
[INFO][inserting]888.L, 2009/12/29, 111.6000, 111.6000, 110.0000, 111.3000,
236400, 111.3000
DBD::Pg::st execute failed: ERROR:  null value in column "name" violates
not-null constraint
CONTEXT:  SQL statement "insert into stocks ( symb, exch, first_quote,
last_quote ) values (  $1 ,  $2 ,  $3 ,  $3 )"
PL/pgSQL function "update_stock_dates" line 7 at SQL statement
SQL statement "SELECT  update_stock_dates( $1 ,  $2 ,  $3 )"
PL/pgSQL function "update_derived_tables" line 4 at perform at
./update-quotes.pl line 69.
ERROR:  null value in column "name" violates not-null constraint
CONTEXT:  SQL statement "insert into stocks ( symb, exch, first_quote,
last_quote ) values (  $1 ,  $2 ,  $3 ,  $3 )"
PL/pgSQL function "update_stock_dates" line 7 at SQL statement
SQL statement "SELECT  update_stock_dates( $1 ,  $2 ,  $3 )"
PL/pgSQL function "update_derived_tables" line 4 at perform at
./update-quotes.pl line 69.

What is the expected output? What do you see instead?
should insert and calculate the derived tables

Please use labels and text to provide additional information.

Original issue reported on code.google.com by peter.st...@1ab.ltd.uk on 16 Jan 2010 at 12:24

[GoogleCodeExporter]

Clarification of the error message

ERROR:  null value in column "name" violates not-null constraint
CONTEXT:  SQL statement "insert into stocks ( symb, exch, first_quote, 
last_quote )
values (  $1 ,  $2 ,  $3 ,  $3 )"
PL/pgSQL function "update_stock_dates" line 7 at SQL statement
SQL statement "SELECT  update_stock_dates( $1 ,  $2 ,  $3 )"
PL/pgSQL function "update_derived_tables" line 4 at perform at 
./update-quotes.pl
line 69.

Original comment by peter.st...@1ab.ltd.uk on 16 Jan 2010 at 12:30

[GoogleCodeExporter]

This issue was closed by revision r38.

Original comment by peter.st...@1ab.ltd.uk on 16 Jan 2010 at 1:41

• Changed state: Fixed