Michael Fuhr wrote:
> On Tue, Oct 04, 2005 at 08:29:23PM +0100, Jeff MacDonald wrote:
>>I did a backup from 7.3.2 using pg_dumpall.
>>When I did a restore all of my timestamps that were defaulted to now(); were
>>now defaulted to the time that I piped my dump back into postgres.
>>Meaning the now() was parsed instead of just being copied.
> Are you sure the default was now() and not 'now'? If you still
> have the 7.3.2 server running then check the table definitions.
> Aside from using psql's \d commands, you could do this:
> SELECT adrelid::regclass, adnum, adsrc
> FROM pg_attrdef
> ORDER BY adrelid, adnum;
> The 7.3 documentation warns against using 'now', and the 7.4 Release
> Notes mention a behavior change with respect to column defaults.
In response to
pgsql-bugs by date
|Next:||From: Jaime Casanova||Date: 2005-10-06 15:29:03|
|Subject: Re: BUG #1940: Troubles with ODBC Clientes XP|
|Previous:||From: Juan Carlos Moreno G.||Date: 2005-10-05 23:05:42|
|Subject: BUG #1940: Troubles with ODBC Clientes XP|