diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2009-12-22 23:27:41 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2009-12-22 23:27:41 +0000 |
| commit | de0d75ea2416eb86f9d686432bd8961b04a8d9eb (patch) | |
| tree | d69c8545584a109f0a3ea5bf3e71c0a6e53379eb /src | |
| parent | c7e4be59ae389f73b5d5145603eb8e4f2ba5a748 (diff) | |
| download | postgresql-de0d75ea2416eb86f9d686432bd8961b04a8d9eb.tar.gz postgresql-de0d75ea2416eb86f9d686432bd8961b04a8d9eb.zip | |
In CREATE SEQUENCE dump, put MINVALUE before MAXVALUE so it reads better.
Diffstat (limited to 'src')
| -rw-r--r-- | src/bin/pg_dump/pg_dump.c | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c index b231e9ae5bf..6d6ac1fafe6 100644 --- a/src/bin/pg_dump/pg_dump.c +++ b/src/bin/pg_dump/pg_dump.c @@ -12,7 +12,7 @@ * by PostgreSQL * * IDENTIFICATION - * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dump.c,v 1.558 2009/12/19 04:13:30 itagaki Exp $ + * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dump.c,v 1.559 2009/12/22 23:27:41 petere Exp $ * *------------------------------------------------------------------------- */ @@ -11254,16 +11254,16 @@ dumpSequence(Archive *fout, TableInfo *tbinfo) appendPQExpBuffer(query, " INCREMENT BY %s\n", incby); - if (maxv) - appendPQExpBuffer(query, " MAXVALUE %s\n", maxv); - else - appendPQExpBuffer(query, " NO MAXVALUE\n"); - if (minv) appendPQExpBuffer(query, " MINVALUE %s\n", minv); else appendPQExpBuffer(query, " NO MINVALUE\n"); + if (maxv) + appendPQExpBuffer(query, " MAXVALUE %s\n", maxv); + else + appendPQExpBuffer(query, " NO MAXVALUE\n"); + appendPQExpBuffer(query, " CACHE %s%s", cache, (cycled ? "\n CYCLE" : "")); |