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)
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
