I created a table with a column "integer".
I'm populating this table with a PostgreSQL database dump, and basically, it inserts new data from SQL commands:
INSERT INTO my_table (..., my_column, ...) VALUES (..., 342, ...
The message I get is
Query result with 1 rows discarded.
Query returned successfully: 1 rows affected
As a result, all other columns are populated as expected, but this one is empty.
What could be the source of the error? I know the original database is working properly. The only value that is not explicitly an integer is "NULL". The other commands at the beginning of the dump, appart from the INSERT commands are:
SET statement_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = off; SET check_function_bodies = false; SELECT pg_catalog.setval('my_table_gid_seq', 1, false); SET search_path = public, pg_catalog;