quick question

Started by Christopher Kings-Lynnealmost 23 years ago2 messages
#1Christopher Kings-Lynne
chriskl@familyhealth.com.au

Hi Guys,

Were the pgattribute.attstorage and pg_type.typstorage fields available in
7.1?

Also, if they existed in 7.2, but the ALTER TABLE/SET STORAGE command didn't
exist, should I still dump it if they are dumping a 7.2 database?

Chris

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Christopher Kings-Lynne (#1)
Re: quick question

"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:

Were the pgattribute.attstorage and pg_type.typstorage fields available in
7.1?

Yes, but typstorage did not appear in 7.0, which you're also supposed to
think about if you're hacking pg_dump. (AFAICT attstorage was always
'p' in 7.0.)

Also, if they existed in 7.2, but the ALTER TABLE/SET STORAGE command didn't
exist, should I still dump it if they are dumping a 7.2 database?

Sure. Dump something if attstorage != typstorage of relevant pg_type
entry. Version needn't enter into it, I think.

regards, tom lane