Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 0 down vote favorite

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;
share|improve this question
You need to isolate where this is happening and update your question. – Mike Toews May 1 '12 at 22:07
That's part of my question: I don't have any information more than what I wrote. How can I get precise information about it? – Antonin May 1 '12 at 22:11
Duplicate of stackoverflow.com/q/10404853/939860. Seems off topic on GIS, too. – Erwin Brandstetter May 1 '12 at 22:25

closed as off topic by Mike Toews, underdark♦ May 1 '12 at 23:05

Questions on Geographic Information Systems Stack Exchange are expected to relate to geographic information systems within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.

Browse other questions tagged or ask your own question.