On Sat, 15 Jan 2005, Tom Lane wrote:
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:which there are more then 3 attributes ... but, of course, there is nothing for the one I just manually added to pg_class ... should this just be duplicated for 5773277?
No, just do update pg_attribute set attrelid = 5773277 where attrelid = 8709051; and repeat for each toast table you need to fix.
Wow ... as painful as that whole thing is/was ... it looks like I might actually have covered all the system tables that needed to be modified ... 'select * from email'; actually seems to show correct data now, without errors ...
Only 9 more to repeat this with ...
Thanks ...
---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
