Re: Global Sequences

On 2012-10-15 23:33, Simon Riggs wrote:
> So, proposal is to allow nextval() allocation to access a plugin,
> rather than simply write a WAL record and increment. If the plugin is
> loaded all sequences call it (not OIDs).
+1. It is currently impossible to alter nextvals behaviour, without 
making changes in core. It is possible to define an alternative 
implementation and try to force to use it by using the search_path, but 
serial datatypes are always bound to pg_catalog.nextval(). This would 
enable every distributed PostgreSQL system to make a cleaner 
implementation for global sequences than they currently have, and would 
also encourage reuse of distributed nextval implementations.

regards,
Yeb

-- 
Yeb Havinga
http://www.mgrid.net/
Mastering Medical Data