|
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 |
|
|