"Nikolay Samokhvalov" <[EMAIL PROTECTED]> writes: > I use some expression as DEFAULT setting for some column of some table. For > example, nextval('myseq') * 10. > Then, I pg_dump my database and restore it. I see 'nextval('myseq')' (w/o > '*10').
You mustn't fool with the default expression for a serial column. You should have declared this as a plain integer column with a handmade default expression. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq