OID Wrap - Mailing list pgsql-hackers

From mlw
Subject OID Wrap
Date
Msg-id 3B24FE0A.640CA181@mohawksoft.com
Whole thread Raw
Responses Re: OID Wrap  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: OID Wrap  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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)



pgsql-hackers by date:

Previous
From: bruc@stone.congenomics.com (Robert E. Bruccoleri)
Date:
Subject: Re: Various silliness in heap_getnext and related routines
Next
From: Alex Pilosov
Date:
Subject: Re: inet/cidr type comparisons