diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-07-29 14:17:37 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-07-29 14:17:37 +0000 |
| commit | f353f8e83bb447039b437cbaa3895d215da34f82 (patch) | |
| tree | eb53b8ce765baede0d1d421bdd6557ce37c26ff8 /src | |
| parent | a5e804df71fe7a1233ff27225e713c6ad8ab1f0e (diff) | |
There is no reason to cast valuntil to timestamp, and a very good
reason not to: it fails for an 'invalid' abstime. Per bug report
of today's date.
Diffstat (limited to 'src')
| -rw-r--r-- | src/bin/pg_dump/pg_dumpall.c | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/bin/pg_dump/pg_dumpall.c b/src/bin/pg_dump/pg_dumpall.c index e56f2448fcd..a7502a7c144 100644 --- a/src/bin/pg_dump/pg_dumpall.c +++ b/src/bin/pg_dump/pg_dumpall.c @@ -6,7 +6,7 @@ * Portions Copyright (c) 1994, Regents of the University of California * * - * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dumpall.c,v 1.23 2003/07/23 08:47:30 petere Exp $ + * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dumpall.c,v 1.24 2003/07/29 14:17:37 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -279,13 +279,13 @@ dumpUsers(PGconn *conn) if (server_version >= 70100) res = executeQuery(conn, "SELECT usename, usesysid, passwd, usecreatedb, " - "usesuper, CAST(valuntil AS timestamp) " + "usesuper, valuntil " "FROM pg_shadow " "WHERE usesysid <> (SELECT datdba FROM pg_database WHERE datname = 'template0')"); else res = executeQuery(conn, "SELECT usename, usesysid, passwd, usecreatedb, " - "usesuper, CAST(valuntil AS timestamp) " + "usesuper, valuntil " "FROM pg_shadow " "WHERE usesysid <> (SELECT datdba FROM pg_database WHERE datname = 'template1')"); |