Re: Unable to dump database using pg_dump

From: Adam Dear <adear(at)usnx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, pgsql-general(at)postgresql(dot)org
Subject: Re: Unable to dump database using pg_dump
Date: 2008-06-11 23:40:26
Message-ID: 4850626A.9090202@usnx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

madisoncounty=# select ctid,xmin,xmax,cmin,cmax,usename from pg_shadow;
ctid | xmin | xmax | cmin | cmax | usename
-------+------+------+------+------+---------------
(0,1) | 1 | 596 | 596 | 1 | postgres
(0,2) | 2 | 1 | 1 | 0 | postgres
(0,5) | 2 | 0 | 0 | 0 | madisoncounty
(3 rows)

Tom Lane wrote:
> Adam Dear <adear(at)usnx(dot)net> writes:
>> The record is still there.
>
> Hmph. Could we see all the system columns from that table?
> select ctid,xmin,xmax,cmin,cmax,usename from pg_shadow;
>
> regards, tom lane
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Celso Pinto 2008-06-12 00:12:13 Re: array column and b-tree index allowing only 8191 bytes
Previous Message Tom Lane 2008-06-11 23:32:29 Re: Unable to dump database using pg_dump