Commitd307a95

committed

Skip START WITH in sequence definition when it's the default value --

and hasn't been called yet.Fixes bug where it wasn't supplied (due to being NULL).Rod Taylor

1 parent50be3e5 commitd307a95Copy full SHA for d307a95

File tree

-4

lines changed

-4

lines changed

Lines changed: 8 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -12,7 +12,7 @@`
`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);`

Comments

(0)