OID Wrap

Поиск
Список
Период
Сортировка
От mlw
Тема OID Wrap
Дата
Msg-id 3B24FE0A.640CA181@mohawksoft.com
обсуждение исходный текст
Ответы Re: OID Wrap  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: OID Wrap  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: bruc@stone.congenomics.com (Robert E. Bruccoleri)
Дата:
Сообщение: Re: Various silliness in heap_getnext and related routines
Следующее
От: Alex Pilosov
Дата:
Сообщение: Re: inet/cidr type comparisons