From 768916d753cbe9ff0fbcb2557435be54d8b7d5df Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Fri, 4 Jun 2004 04:09:40 +0000 Subject: This is a small fix in FAQ. It just clean up some old comments and change an old -not-working piece of code. --- doc/FAQ | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) (limited to 'doc/FAQ') diff --git a/doc/FAQ b/doc/FAQ index 4bdea83d119..29277550348 100644 --- a/doc/FAQ +++ b/doc/FAQ @@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Mon Mar 29 00:07:11 EST 2004 + Last updated: Fri Jun 4 00:09:16 EDT 2004 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -965,11 +965,11 @@ BYTEA bytea variable-length byte array (null-byte safe) all databases. If you want to change the OID to something else, or if you want to make a copy of the table, with the original OIDs, there is no reason you can't do it: - CREATE TABLE new_table(old_oid oid, mycol int); - SELECT old_oid, mycol INTO new FROM old; - COPY new TO '/tmp/pgtable'; - DELETE FROM new; - COPY new WITH OIDS FROM '/tmp/pgtable'; + CREATE TABLE new_table(mycol int); + SELECT oid AS old_oid, mycol INTO tmp_table FROM old_table; + COPY tmp_table TO '/tmp/pgtable'; + COPY new_table WITH OIDS FROM '/tmp/pgtable'; + DROP TABLE tmp_table; OIDs are stored as 4-byte integers, and will overflow at 4 billion. No one has reported this ever happening, and we plan to have the limit -- cgit v1.2.3