Re: [PATCHES] Doc update: ALTER SEQUENCE name RENAME TO can be rolled back

[Tom Lane]

Heikki Linnakangas <[EMAIL PROTECTED]> writes:
>  those changes take effect immediately and are not reversible.  However,
> !the OWNED BY and SET SCHEMA clauses are ordinary
>  catalog updates and can be rolled back.
  
>  those changes take effect immediately and are not reversible.  However,
> !the OWNED BY, SET SCHEMA and RENAME 
> clauses are ordinary
>  catalog updates and can be rolled back.

Good catch --- applied along with some other fixes.

regards, tom lane

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

[PATCHES] Doc update: ALTER SEQUENCE name RENAME TO can be rolled back

[Heikki Linnakangas]

-- 
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com
Index: doc/src/sgml/ref/alter_sequence.sgml
===
RCS file: /home/hlinnaka/pgcvsrepository/pgsql/doc/src/sgml/ref/alter_sequence.sgml,v
retrieving revision 1.17
diff -c -r1.17 alter_sequence.sgml
*** doc/src/sgml/ref/alter_sequence.sgml	3 Jul 2007 01:30:35 -	1.17
--- doc/src/sgml/ref/alter_sequence.sgml	3 Oct 2007 09:33:38 -
***
*** 224,230 
 same sequence, ALTER SEQUENCE's effects on the sequence
 generation parameters are never rolled back;
 those changes take effect immediately and are not reversible.  However,
!the OWNED BY and SET SCHEMA clauses are ordinary
 catalog updates and can be rolled back.

  
--- 224,230 
 same sequence, ALTER SEQUENCE's effects on the sequence
 generation parameters are never rolled back;
 those changes take effect immediately and are not reversible.  However,
!the OWNED BY, SET SCHEMA and RENAME clauses are ordinary
 catalog updates and can be rolled back.

  

---(end of broadcast)---
TIP 6: explain analyze is your friend