| 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: | Whole Thread | Raw Message | 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 |