|
6 | 6 | * Portions Copyright (c) 1994, Regents of the University of California
|
7 | 7 | *
|
8 | 8 | *
|
9 |
| - * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dumpall.c,v 1.23 2003/07/23 08:47:30 petere Exp $ |
| 9 | + * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dumpall.c,v 1.24 2003/07/29 14:17:37 tgl Exp $ |
10 | 10 | *
|
11 | 11 | *-------------------------------------------------------------------------
|
12 | 12 | */
|
@@ -279,13 +279,13 @@ dumpUsers(PGconn *conn)
|
279 | 279 | if (server_version >=70100)
|
280 | 280 | res=executeQuery(conn,
|
281 | 281 | "SELECT usename, usesysid, passwd, usecreatedb, "
|
282 |
| -"usesuper,CAST(valuntil AS timestamp) " |
| 282 | +"usesuper, valuntil " |
283 | 283 | "FROM pg_shadow "
|
284 | 284 | "WHERE usesysid <> (SELECT datdba FROM pg_database WHERE datname = 'template0')");
|
285 | 285 | else
|
286 | 286 | res=executeQuery(conn,
|
287 | 287 | "SELECT usename, usesysid, passwd, usecreatedb, "
|
288 |
| -"usesuper,CAST(valuntil AS timestamp) " |
| 288 | +"usesuper, valuntil " |
289 | 289 | "FROM pg_shadow "
|
290 | 290 | "WHERE usesysid <> (SELECT datdba FROM pg_database WHERE datname = 'template1')");
|
291 | 291 |
|
|