a doubt in database restoring?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • aurekha
    New Member
    • Sep 2007
    • 34

    a doubt in database restoring?

    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??????
  • rski
    Recognized Expert Contributor
    • Dec 2006
    • 700

    #2
    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 :) )?

    Comment

    • aurekha
      New Member
      • Sep 2007
      • 34

      #3
      Thank you for your keen interest.......

      Comment

      Working...