Skip site navigation (1) Skip section navigation (2)

BUG #2245: pg_dump doesn't dump expressions with sequence in DEFAULT setting for some column in table

From: "Nikolay Samokhvalov" <samokhvalov(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2245: pg_dump doesn't dump expressions with sequence in DEFAULT setting for some column in table
Date: 2006-02-07 12:35:50
Message-ID: 20060207123550.9017DF0AC7@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2245
Logged by:          Nikolay Samokhvalov
Email address:      samokhvalov(at)gmail(dot)com
PostgreSQL version: 8.1.2
Operating system:   Linux Fedora Core 4
Description:        pg_dump doesn't dump expressions with sequence in
DEFAULT setting for some column in table
Details: 

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').

(Surely, '*10' is just an example, I know, that I can increase the INCREMENT
parameter for the sequence.)

I suppose it's a bug.

More details:
http://archives.postgresql.org/pgsql-general/2006-02/msg00251.php

Responses

pgsql-bugs by date

Next:From: Andreas ErberDate: 2006-02-07 14:02:23
Subject: Re: BUG #2240: length() with geometric types
Previous:From: KF TaiDate: 2006-02-07 08:19:39
Subject: BUG #2244: silent installation to set password never expires

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group