Re: unable to dump database, toast errors - Mailing list pgsql-general

From Lonni J Friedman
Subject Re: unable to dump database, toast errors
Date
Msg-id Pine.LNX.4.44.0304041148420.5816-100000@beefcake.hdqt.vasoftware.com
Whole thread Raw
In response to Re: unable to dump database, toast errors  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Fri, 4 Apr 2003, Tom Lane wrote:
> Lonni J Friedman <lfriedman@vasoftware.com> writes:
> > I hope tha this means significantly more to you, than it does to me.
>
> It's not real useful :-(.  Can you rebuild with debug symbols enabled
> and try again?

ok, here goes:
(gdb) bt
#0  0x4013b771 in _IO_vfprintf (s=0x40218180, format=0x805e2d9
"%-*s%s%-*s", ap=0xbffff81c) at vfprintf.c:1524
#1  0x40143ce7 in fprintf (stream=0x40218180, format=0x805e2d9
"%-*s%s%-*s") at fprintf.c:32
#2  0x080521ea in print_aligned_text (title=0x0, headers=0x8062ff0,
cells=0x8063000, footers=0x8063010, opt_align=0x8063088 "l",
opt_barebones=0 '\000', opt_border=1, fout=0x40218180) at print.c:329
#3  0x08053522 in printTable (title=0x0, headers=0x8062ff0,
cells=0x8063000, footers=0x8063010, align=0x8063088 "l", opt=0x8062b30,
fout=0x40218180) at print.c:1123
#4  0x08053888 in printQuery (result=0x80705e0, opt=0x8062b30,
fout=0x40218180) at print.c:1257
#5  0x0804d9f2 in SendQuery (query=0x806a100 "select bin_data from
artifact_file LIMIT 1 OFFSET 31;") at common.c:488
#6  0x0804f126 in MainLoop (source=0x40218000) at mainloop.c:425
#7  0x080504cc in main (argc=2, argv=0xbffffab4) at startup.c:305
#8  0x40100507 in __libc_start_main (main=0x804fe64 <main>, argc=2,
ubp_av=0xbffffab4, init=0x8049b18 <_init>, fini=0x8057790 <_fini>,
rtld_fini=0x4000dc14 <_dl_fini>, stack_end=0xbffffaac) at
../sysdeps/generic/libc-start.c:129

> Also, are you using any nondefault options for formatting psql's output?

not as far as i know.  i just run 'psql <DB_NAME>' and then:
select bin_data from artifact_file LIMIT1 OFFSET 31;

hope this provides you with what you need to help me. thanks.


pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: Getting consecutive sequence values
Next
From: "Wayne Armstrong"
Date:
Subject: Re: feature request - adding columns with default value