Re: basic debugging question
От | Oliver Elphick |
---|---|
Тема | Re: basic debugging question |
Дата | |
Msg-id | 1098821557.2414.36.camel@linda обсуждение исходный текст |
Ответ на | basic debugging question (Scott Frankel <leknarf@pacbell.net>) |
Список | pgsql-general |
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 olly@lfix.co.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." Mark 8:38
В списке pgsql-general по дате отправления: