Re: basic debugging question

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 majordomo@postgresql.org)
>