OID Wrap

You guys said you've never seen it.
You said you wanted to know if anyone has ever run into it!

Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms      \h for help with SQL commands      \? for help on internal slash commands
    \g or terminate with semicolon to execute query      \q to quit
 

cdinfo=# create view test as select * from zsong  ;
ERROR:  pg_atoi: error reading "2156109797": Numerical result out of
range
cdinfo=# vacuum analyze zsong ;
VACUUM
cdinfo=# create view test as select * from zsong  ;
ERROR:  pg_atoi: error reading "2156109823": Numerical result out of
range
cdinfo=# create view test as select * from zsong  ;
ERROR:  pg_atoi: error reading "2156109840": Numerical result out of
range
cdinfo=# vaanalyze zsong ;
cdinfo=# \d zsong         Table "zsong"Attribute |   Type    | Modifier
-----------+-----------+----------muzenbr   | integer   |disc      | integer   |trk       | integer   |song      |
varchar()|artistid  | integer   |acd       | varchar() |trackid   | integer   |datasrc   | integer   |extid     |
integer  |
 

cdinfo=# select max(oid) from zsong ;    max
--------------2138857719
(1 row)