2nd update on TOAST - Mailing list pgsql-hackers

From JanWieck@t-online.de (Jan Wieck)
Subject 2nd update on TOAST
Date
Msg-id 200007052001.WAA11676@hot.jw.home
Whole thread Raw
Responses Re: 2nd update on TOAST
Re: 2nd update on TOAST
List pgsql-hackers
Uh oh -
   on  one side I'm a happy camper. pg_dump already ignored pg_*   tables and since the TOAST  tables  are  named
pg_toast_...,  nothing  to  be done. I loaded my test DB with TOAST entries,   dumped and restored it.  Anything is
there,works  perfectly.
 
   But  then  I added the ALTER TABLE for unlimited rewrite rule   size to initdb and the problems started. I can
createa table   with  500+  attributes.  Also  I can create a view on it (the   rules size is 170K - whow). Anything
workspretty well,  just   a pg_dump output is garbage.
 
   Seems  the  dynamic  string buffers used in pg_dump aren't as   bullet proof as they  should.   I'm  still  busy
with other   things, so can someone please take a look on it?  Attached is   an SQL script that creates the table  and
the view  that  I   cannot dump.
 


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



pgsql-hackers by date:

Previous
From: Roland Roberts
Date:
Subject: Re: Per-database/schema settings
Next
From: darcy@druid.net (D'Arcy J.M. Cain)
Date:
Subject: Re: Repair plan for inet and cidr types