Connecting Tech Pros Worldwide Forums | Help | Site Map

a doubt in database restoring?

Member
 
Join Date: Sep 2007
Posts: 32
#1: Nov 4 '08
Hi all,
in pgsql,
while restoring the data using \i option,
i am getting sometimes..as
INSERT 0 1
INSERT 0 1
INSERT 0 1
and sometimes.... as

INSERT 18890 1
INSERT 18891 1
INSERT 18892 1
INSERT 18893 1
INSERT 18894 1
INSERT 18895 1
what does the above digits refers to????????????
any help will be gladly accepted??????

Moderator
 
Join Date: Dec 2006
Location: Europe
Posts: 293
#2: Nov 4 '08

re: a doubt in database restoring?


Second digit is a number if rows that INSERT starement put into table.
Fist number is a row id (called in postgres 'oid'), it's uniqe row identifier. If table has been created with option 'with oids' (or such option was setting in postgresql.conf file) then every row in a table has such unique identifier (that identifier is displayed after INSERT statement) if not rows didn't have oid's and INSERT displey 0.
Is is clear (it may not because of my english :) )?
Member
 
Join Date: Sep 2007
Posts: 32
#3: Nov 5 '08

re: a doubt in database restoring?


Thank you for your keen interest.......
Reply