Re: [BUGS] pg_dump/pg_restore with time zone displacement out of range

2012-05-30 Thread Tom Lane
Patric Bechtel writes: > My platform: Ubuntu 12.04, PostgreSQL 9.2beta1, tried it with 9.1 with same > result. > postgresql.conf is stock, except for timezone, which is set to Asia/Manila. > $ createdb -U postgres tztest > $ psql tztest postgres > tztest=# create table foo (bar int, baz timestam

Re: [BUGS] pg_dump/pg_restore

2002-11-24 Thread Colin Stearman
m Lane" <[EMAIL PROTECTED]> To: "Colin Stearman" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, November 24, 2002 12:57 PM Subject: Re: [BUGS] pg_dump/pg_restore "Colin Stearman" <[EMAIL PROTECTED]> writes: > 1. Large objects dumped, deleted t

Re: [BUGS] pg_dump/pg_restore

2002-11-24 Thread Tom Lane
"Colin Stearman" <[EMAIL PROTECTED]> writes: > 1. Large objects dumped, deleted then restored do not retain their original= > OIDs. Big problem as we reference their OIDs in tables. They're not supposed to (indeed cannot). pg_restore is supposed to arrange for references to large-object OIDs to