| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Gustavo Rosso <grosso(at)sadaic(dot)org(dot)ar> |
| Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
| Subject: | Re: emergencia |
| Date: | 2009-04-28 14:22:20 |
| Message-ID: | 20090428142220.GJ10358@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
Gustavo Rosso escribió:
> Gente estoy en problemas.
> Me aparecio hoy una tabla dañada, un select da este error:
>
> ERROR: could not read block 518 of relation 1663/16384/2002069: read
> only 4096 of 8192 bytes
A todo esto, la forma de saber qué tabla es esta es la siguiente:
select oid::regclass from pg_class where relfilenode = 2002069;
--
Alvaro Herrera http://www.amazon.com/gp/registry/3BP7BYG9PUGI8
"How strange it is to find the words "Perl" and "saner" in such close
proximity, with no apparent sense of irony. I doubt that Larry himself
could have managed it." (ncm, http://lwn.net/Articles/174769/)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gustavo Rosso | 2009-04-28 14:25:59 | Re: Error |
| Previous Message | Emanuel Calvo Franco | 2009-04-28 14:14:27 | Re: Error |