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 > 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?
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? Try 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 compatible structure. -- Oliver Elphick [EMAIL PROTECTED] 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." Mark 8:38 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
