From: | mlw <markw(at)mohawksoft(dot)com> |
---|---|
To: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | OID Wrap |
Date: | 2001-06-11 17:21:14 |
Message-ID: | 3B24FE0A.640CA181@mohawksoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-06-11 17:22:20 | Catalog index cleanup blitz planned |
Previous Message | Alex Pilosov | 2001-06-11 17:16:01 | Re: inet/cidr type comparisons |