39
In my LiveCode Server app I'm getting a dberr returned on insertion but no explicit error code.
I went on a terminal and did the insertion by hand as user Postgres.
%My_Dbase=# INSERT INTO new-table (first_name, last_name, anonymous) VALUES ('batman', 'Moonboy', TRUE);
The psql process returns:
INSERT 0 1
What does this line mean? Besides the primary table I also have a sequence to increment the primary key ID (int) of the main table.
If I check the data, the data is inserted, the primary key is increment by one and everything seems fine, I'm not sure why my app is returning an error (could be a bug in the app or my code).
But if I knew what INSERT 0 1 meant, that would help me assure myself that:
- Yes, the insertion was done without errors, or
- No, the
0 1indicates an error of some sort.
If anyone has a link to the PostgreSQL doc which tells what these server response params are, I will study it... I have looked everywhere.