diff options
| author | Bruce Momjian <bruce@momjian.us> | 2003-09-01 16:47:58 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2003-09-01 16:47:58 +0000 |
| commit | 2fb6e84baef22c466fe7a53ca67f6e4ef5dbe9ff (patch) | |
| tree | 09b85da95ee034b062f9395e7ffee8ed474b7bbc | |
| parent | 05f4b03b239cbc69d32a8db966fcd63e35440b31 (diff) | |
| download | postgresql-2fb6e84baef22c466fe7a53ca67f6e4ef5dbe9ff.tar.gz postgresql-2fb6e84baef22c466fe7a53ca67f6e4ef5dbe9ff.zip | |
Add mention of OID wraparound.
| -rw-r--r-- | doc/FAQ | 5 | ||||
| -rw-r--r-- | doc/src/FAQ/FAQ.html | 5 |
2 files changed, 6 insertions, 4 deletions
@@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Fri Aug 29 21:40:10 EDT 2003 + Last updated: Mon Sep 1 12:47:42 EDT 2003 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -916,7 +916,8 @@ BYTEA bytea variable-length byte array (null-byte safe) Finally, you could use the OID returned from the INSERT statement to look up the default value, though this is probably the least portable - approach. In Perl, using DBI with Edmund Mergl's DBD::Pg module, the + approach, and the oid value will wrap around when it reaches 4 + billion. In Perl, using DBI with Edmund Mergl's DBD::Pg module, the oid value is made available via $sth->{pg_oid_status} after $sth->execute(). diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index 15455d041cf..10e269cf0d6 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -10,7 +10,7 @@ alink="#0000ff"> <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> - <P>Last updated: Fri Aug 29 21:40:10 EDT 2003</P> + <P>Last updated: Mon Sep 1 12:47:42 EDT 2003</P> <P>Current maintainer: Bruce Momjian (<A href= "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR> @@ -1152,7 +1152,8 @@ BYTEA bytea variable-length byte array (null-byte safe) Finally, you could use the <A href="#4.16"><SMALL>OID</SMALL></A> returned from the <SMALL>INSERT</SMALL> statement to look up the - default value, though this is probably the least portable approach. + default value, though this is probably the least portable approach, + and the oid value will wrap around when it reaches 4 billion. In Perl, using DBI with Edmund Mergl's DBD::Pg module, the oid value is made available via <I>$sth->{pg_oid_status}</I> after <I>$sth->execute()</I>. |