From: | Andreas Tille <tillea(at)rki(dot)de> |
---|---|
To: | PostgreSQL SQL <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Explicite typecasting of functions |
Date: | 2002-08-15 07:13:00 |
Message-ID: | Pine.LNX.4.44.0208150908430.8253-100000@wr-linux02.rki.ivbb.bund.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Wed, 14 Aug 2002, Tom Lane wrote:
> I concur with Richard that Andreas needs to solve a different problem,
> but just for the record, the way you could do it is
>
> CREATE TABLE without mentioning the default
>
> CREATE FUNCTION
>
> ALTER TABLE ... SET DEFAULT
>
> Note however that pg_dump is not bright enough to deduce that you did
> this. It will dump the table definition first, with the DEFAULT clause,
> and so you'll have to do manual surgery on the dump file if you ever
> need to reload.
Hmmm, the original problem I wanted to solve using this function is that
pg_dump is not bright enough to store sequences. I use a development
machine to build the database do a pg_dump and after this I try to
put this dump to the production (readonly) server. This procedure
every time requires manual setting of the sequences. I tried to avoid
this by the function. Any better way to do this?
Kind regards
Andreas.
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2002-08-15 08:43:53 | Re: Explicite typecasting of functions |
Previous Message | Andreas Tille | 2002-08-15 07:08:39 | Re: Explicite typecasting of functions |