Has anyone encountered this problem before?
I perform an INSERTion and there weren't any complains
of error, so i assume that it has no error. When i
perform a SELECT there were 0 rows in the table.
This is just a simple table with (Integer,
Varchar(25),Varchar(50),Varchar(50)) type of data.
The error does not occur all the time, it only happens
once in a while.
Would appreciate if anyone can share their experience
and ways of getting around it with me.
Thank you in advance.
Mian
problem with insert for Postgresql, please help.
Moderator: General Moderators
- CoderGoblin
- DevNet Resident
- Posts: 1425
- Joined: Tue Mar 16, 2004 10:03 am
- Location: Aachen, Germany
Very hard to tell what the issue is with the information provided.
It is unlikely to be a pgsql problem, more likely to be a coding issue.
After the insert try a [pg_man]pg_affected_rows[/pg_man] to check if a row was really inserted.
Is your SELECT correct ?
Could we potentially see some of the code?
It is unlikely to be a pgsql problem, more likely to be a coding issue.
After the insert try a [pg_man]pg_affected_rows[/pg_man] to check if a row was really inserted.
Is your SELECT correct ?
Could we potentially see some of the code?