Re: [PATCHES] ALTER TABLE .. OWNER TO and sequences

2004-09-23 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: Here is a patch regarding ALTER TABLE ... OWNER and the sequences that were created by a SERIAL column. Applied with some changes. I tightened up the checks on the pg_depend entries, just for paranoia's sake. (At the moment I don't think there could be

[PATCHES] ALTER TABLE .. OWNER TO and sequences

2004-09-22 Thread Alvaro Herrera
Patchers, Here is a patch regarding ALTER TABLE ... OWNER and the sequences that were created by a SERIAL column. It uses pg_depend to find SERIAL sequences, and recurses the ChangeOwner to them. Additionally, it forbids directly changing the owner of a SERIAL sequence (the error message of