On Tue, 2004-10-26 at 12:39 -0700, Scott Frankel wrote:
> I'm attempting to debug a script that should perform a simple INSERT of
> 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.
> - What does the status msg, "INSERT 18015 1," refer to?
It means one row was added to some table and the row's oid is 18015.
> - 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?
SELECT * FROM <tablename> WHERE oid = 18015;
If that returns nothing, the row must have been added to some other
table, which would imply the existence of another table with a
Oliver Elphick olly(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
"Whosoever therefore shall be ashamed of me and of my
words in this adulterous and sinful generation; of him
also shall the Son of man be ashamed, when he cometh
in the glory of his Father with the holy angels."
In response to
pgsql-general by date
|Next:||From: Tino Wildenhain||Date: 2004-10-26 20:18:32|
|Subject: Re: basic debugging question|
|Previous:||From: Martijn van Oosterhout||Date: 2004-10-26 20:11:15|
|Subject: Re: Bug or stupidity|