Re: [GENERAL] Odd duplicate database

2009-01-14 Thread Alvaro Herrera
Madison Kelly wrote: > Tom Lane wrote: >> Madison Kelly writes: >>> PS - If I've run into a PgSQL bug, is there anything I can provide to help? >> >> A sequence that reproduces it would be the best thing ... > > I guess the trick is, I have no idea what's happened or what I did to > cause it to

Re: [GENERAL] Odd duplicate database

2009-01-14 Thread Madison Kelly
Tom Lane wrote: Madison Kelly writes: PS - If I've run into a PgSQL bug, is there anything I can provide to help? A sequence that reproduces it would be the best thing ... regards, tom lane I guess the trick is, I have no idea what's happened or what I did to cause

Re: [GENERAL] Odd duplicate database

2009-01-14 Thread Tom Lane
Madison Kelly writes: > PS - If I've run into a PgSQL bug, is there anything I can provide to help? A sequence that reproduces it would be the best thing ... regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Odd duplicate database

2009-01-14 Thread Madison Kelly
Tom Lane wrote: Madison Kelly writes: Alvaro Herrera wrote: Please send along select xmin, xmax, ctid, cmin, cmax, datname from pg_database; template1=# select xmin, xmax, ctid, cmin, cmax, datname from pg_database; xmin | xmax | ctid | cmin | cmax | datname --+--++

Re: [GENERAL] Odd duplicate database

2009-01-14 Thread Tom Lane
Madison Kelly writes: > Alvaro Herrera wrote: >> Please send along >> select xmin, xmax, ctid, cmin, cmax, datname from pg_database; > template1=# select xmin, xmax, ctid, cmin, cmax, datname from pg_database; > xmin | xmax | ctid | cmin | cmax | datname > --+--++--+-

Re: [GENERAL] Odd duplicate database

2009-01-14 Thread Madison Kelly
Alvaro Herrera wrote: Madison Kelly wrote: Forgot to mention, this is PostgreSQL 8.3.5 on Linux (Ubuntu 8.10, hey, it's a devel machine!). :) Huh. Please send along select xmin, xmax, ctid, cmin, cmax, datname from pg_database; template1=# select xmin, xmax, ctid, cmin, cmax, datname from

Re: [GENERAL] Odd duplicate database

2009-01-14 Thread Alvaro Herrera
Madison Kelly wrote: > Forgot to mention, this is PostgreSQL 8.3.5 on Linux (Ubuntu 8.10, hey, > it's a devel machine!). :) Huh. Please send along select xmin, xmax, ctid, cmin, cmax, datname from pg_database; -- Alvaro Herrerahttp://www.CommandPrompt.com/ Pos

Re: [GENERAL] Odd duplicate database

2009-01-14 Thread Alvaro Herrera
Madison Kelly wrote: > Hi all, > > My devel server has some wierdness happening. I tried to drop the > database (reload from a copy from the production server) and I got this > weird error: I guess this is an old release, and you haven't been vacuuming pg_database regularly, yes? -- Alvaro

Re: [GENERAL] Odd duplicate database

2009-01-14 Thread Madison Kelly
Forgot to mention, this is PostgreSQL 8.3.5 on Linux (Ubuntu 8.10, hey, it's a devel machine!). :) Madi Madison Kelly wrote: Hi all, My devel server has some wierdness happening. I tried to drop the database (reload from a copy from the production server) and I got this weird error: pg_