Tom Lane wrote: > ioguix <[EMAIL PROTECTED]> writes: > > br3619=# CREATE SEQUENCE sample_seq_to_rename; > > CREATE SEQUENCE > > br3619=# select sequence_name from sample_seq_to_rename; > > sequence_name > > ---------------------- > > sample_seq_to_rename > > (1 ligne) > > > br3619=# ALTER TABLE sample_seq_to_rename RENAME TO sample_seq; > > ALTER TABLE > > br3619=# select sequence_name from sample_seq; > > sequence_name > > ---------------------- > > sample_seq_to_rename > > (1 ligne) > > This is something we are unlikely to change, because it would have to be > a nontransactional update, which means it'd be out of sync if the ALTER > rolls back after making it. That cure seems hardly better than the > disease. > > I seem to recall some prior discussions about rearranging the > representation of sequences to allow separation of transactional and > nontransactional updates, but I don't remember if there were any > non-cosmetic reasons to do it. This one seems pretty cosmetic ...
The reason we were exploring that at all was because somebody wanted to be able to get all the current values from sequences in a single query. So we wanted to group them all in a single catalog, but that required non-transactional updates to it. I am amused by the fact that we store the sequence name in the sequence itself though. -- Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4 www.google.com: interfaz de línea de órdenes para la web. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
