I should have *myself* committed.
Thanks for the suggestions (and OID tip)! It turned out that my script was
not committing the transaction, so the insert was getting rolled-back.
Thanks Scott
On Oct 26, 2004, at 12:39 PM, Scott Frankel wrote:
I'm attempting to debug a script that should perform a simple INSERT of values,
but for some reason doesn't. The insert appears to occur without error, printing
"INSERT 18015 1 upon completion." Nonetheless, no data values appear to be
added to the table when queried in psql.
Questions:
- What does the status msg, "INSERT 18015 1," refer to?
- What is this output called? (So I can search the documentation for it.)
- Is there something clever I can access -- besides this list ;) -- so I can
peek inside INSERT 18015 1 to see what pgres is thinking about?
Note that when I perform the INSERT by hand in psql, the row of data is entered
without incident.
Thanks in advance! Scott
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match