On Wed, 2008-04-30 at 13:07 -0400, Tom Lane wrote:
> Oh, that's really strange. Could we see
>
> select ctid,xmin,* from pg_database
itvtrackdata=> select ctid,xmin,* from pg_database;
ctid | xmin | datname | datdba | encoding | datistemplate |
datallowconn | datconnlimit | datlastsysoid | datvacuumxid | datfrozenxid |
dattablespace | datconfig | datacl
-------+----------+------------------+--------+----------+---------------+--------------+--------------+---------------+--------------+--------------+---------------+-----------+------------------------
(0,1) | 564 | postgres | 10 | 6 | f | t
| -1 | 10792 | 499 | 499 |
1663 | |
(0,2) | 577 | itvtrackdata | 16384 | 6 | f | t
| -1 | 10792 | 499 | 499 |
1663 | |
(0,3) | 605 | itvtrackdatauser | 16384 | 6 | f | t
| -1 | 10792 | 499 | 499 |
1663 | |
(0,5) | 18350176 | itvtrackdatapos | 16384 | 6 | f | t
| -1 | 10792 | 499 | 499 |
1663 | |
(0,6) | 557 | template1 | 10 | 6 | t | t
| -1 | 10792 | 499 | 499 |
1663 | | {postgres=CT/postgres}
(0,7) | 558 | template0 | 10 | 6 | t | f
| -1 | 10792 | 499 | 499 |
1663 | | {postgres=CT/postgres}
(6 rows)
itvtrackdata=>
--Ian
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin