"PostgresSLQ DB write error: column type 'name'"
Ugo
New Altair Community Member
Hi,
I would like to report an 'old' bug
. It seems to have been reported quite some time ago in the following 2 threads:
http://rapid-i.com/rapidforum/index.php/topic,2008.0.html
http://rapid-i.com/rapidforum/index.php/topic,3826.0.html
Currently I am crawling a site and recording the HTML pages in a DB. The problem is that in the case of PostgresSQL (version 9.1.7 in Linux 64bits) the column that contains the HTML data is created with the type 'name'. When saving the data, it is truncated. If I manually change the column type to 'varchar' and make the operator append the data then no data is truncated. I have updated the Postgres JDBC drivers to the latest versions (type 3 and 4) but this does not help.
I finally had to install the MySQL database. Using the exact same process but with a different connection, the data is stored correctly. The table is generated with 'VARCHAR(69)'. Maybe some other workaround is possible? Anyone have suggestions in order to use PostgresSQL "correctly"?.
TIA,
Hugo F
I would like to report an 'old' bug
. It seems to have been reported quite some time ago in the following 2 threads:http://rapid-i.com/rapidforum/index.php/topic,2008.0.html
http://rapid-i.com/rapidforum/index.php/topic,3826.0.html
Currently I am crawling a site and recording the HTML pages in a DB. The problem is that in the case of PostgresSQL (version 9.1.7 in Linux 64bits) the column that contains the HTML data is created with the type 'name'. When saving the data, it is truncated. If I manually change the column type to 'varchar' and make the operator append the data then no data is truncated. I have updated the Postgres JDBC drivers to the latest versions (type 3 and 4) but this does not help.
I finally had to install the MySQL database. Using the exact same process but with a different connection, the data is stored correctly. The table is generated with 'VARCHAR(69)'. Maybe some other workaround is possible? Anyone have suggestions in order to use PostgresSQL "correctly"?.
TIA,
Hugo F
Tagged:
0
Answers
-
Hi,
can you please post the XML of your process (like it is described here: http://rapid-i.com/rapidforum/index.php/topic,4654.0.html) so we can have a look at it?
Best,
Nils0