|
12 | 12 | *by PostgreSQL |
13 | 13 | * |
14 | 14 | * IDENTIFICATION |
15 | | - * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.324 2003/03/27 16:43:07 momjian Exp $ |
| 15 | + * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.325 2003/03/31 20:48:45 momjian Exp $ |
16 | 16 | * |
17 | 17 | *------------------------------------------------------------------------- |
18 | 18 | */ |
@@ -6171,9 +6171,13 @@ dumpOneSequence(Archive *fout, TableInfo *tbinfo, |
6171 | 6171 |
|
6172 | 6172 | resetPQExpBuffer(query); |
6173 | 6173 | appendPQExpBuffer(query, |
6174 | | -"CREATE SEQUENCE %s\n START WITH %s\n INCREMENT BY %s\n", |
6175 | | -fmtId(tbinfo->relname), |
6176 | | - (called ?minv :last),incby); |
| 6174 | +"CREATE SEQUENCE %s\n", |
| 6175 | +fmtId(tbinfo->relname)); |
| 6176 | + |
| 6177 | +if (!called) |
| 6178 | +appendPQExpBuffer(query," START WITH %s\n",last); |
| 6179 | + |
| 6180 | +appendPQExpBuffer(query," INCREMENT BY %s\n",incby); |
6177 | 6181 |
|
6178 | 6182 | if (maxv) |
6179 | 6183 | appendPQExpBuffer(query," MAXVALUE %s\n",maxv); |
|