NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit2128e5c

Neil Conway

committed

In psql, when running a SELECT query using a cursor, flush the query

output after each FETCH. This ensures that incremental results areavailable to clients that are executing long-running SELECT queriesvia the FETCH_COUNT feature.

1 parentba82629 commit2128e5cCopy full SHA for 2128e5c

File tree

1 file changed

-1

lines changed

src/bin/psql
- common.c

1 file changed

-1

lines changed

`‎src/bin/psql/common.c`

Lines changed: 7 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -3,7 +3,7 @@`
`3`	`3`	`*`
`4`	`4`	`* Copyright (c) 2000-2007, PostgreSQL Global Development Group`
`5`	`5`	`*`
`6`		`- * $PostgreSQL: pgsql/src/bin/psql/common.c,v 1.134 2007/04/16 20:15:38 mha Exp $`
	`6`	`+ * $PostgreSQL: pgsql/src/bin/psql/common.c,v 1.135 2007/06/22 01:09:28 neilc Exp $`
`7`	`7`	`*/`
`8`	`8`	`#include"postgres_fe.h"`
`9`	`9`	`#include"common.h"`
`@@ -1076,6 +1076,12 @@ ExecQueryUsingCursor(const char query, double elapsed_msec)`
`1076`	`1076`
`1077`	`1077`	`printQuery(results,&my_popt,pset.queryFout,pset.logfile);`
`1078`	`1078`
	`1079`	`+/*`
	`1080`	`+ * Make sure to flush the output stream, so intermediate`
	`1081`	`+ * results are visible to the client immediately.`
	`1082`	`+ */`
	`1083`	`+fflush(pset.queryFout);`
	`1084`	`+`
`1079`	`1085`	`/* after the first result set, disallow header decoration */`
`1080`	`1086`	`my_popt.topt.start_table= false;`
`1081`	`1087`	`my_popt.topt.prior_records+=ntuples;`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit2128e5c

File tree

1 file changed

1 file changed

`‎src/bin/psql/common.c`

0 commit comments