Commit106f2eb

committed

Cast pg_stat_progress_cluster.cluster_index_relid to oid

It's tracked internally as bigint, but when presented to the user itshould be oid.

1 parent9e360f0 commit106f2ebCopy full SHA for 106f2eb

File tree

-4

lines changed

-4

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -3937,7 +3937,7 @@ SELECT pg_stat_get_backend_pid(s.backendid) AS pid,`
`3937`	`3937`	`</row>`
`3938`	`3938`	`<row>`
`3939`	`3939`	`<entry><structfield>cluster_index_relid</structfield></entry>`
`3940`		`- <entry><type>bigint</type></entry>`
	`3940`	`+ <entry><type>oid</type></entry>`
`3941`	`3941`	`<entry>`
`3942`	`3942`	`If the table is being scanned using an index, this is the OID of the`
`3943`	`3943`	`index being used; otherwise, it is zero.`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -933,7 +933,7 @@ CREATE VIEW pg_stat_progress_cluster AS`
`933`	`933`	`WHEN6 THEN'rebuilding index'`
`934`	`934`	`WHEN7 THEN'performing final cleanup'`
`935`	`935`	`ENDAS phase,`
`936`		`-S.param3AS cluster_index_relid,`
	`936`	`+CAST(S.param3ASoid)AS cluster_index_relid,`
`937`	`937`	`S.param4AS heap_tuples_scanned,`
`938`	`938`	`S.param5AS heap_tuples_written,`
`939`	`939`	`S.param6AS heap_blks_total,`

Lines changed: 1 addition & 1 deletion

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1855,7 +1855,7 @@ pg_stat_progress_cluster\| SELECT s.pid,`
`1855`	`1855`	`WHEN 7 THEN 'performing final cleanup'::text`
`1856`	`1856`	`ELSE NULL::text`
`1857`	`1857`	`END AS phase,`
`1858`		`- s.param3 AS cluster_index_relid,`
	`1858`	`+(s.param3)::oid AS cluster_index_relid,`
`1859`	`1859`	`s.param4 AS heap_tuples_scanned,`
`1860`	`1860`	`s.param5 AS heap_tuples_written,`
`1861`	`1861`	`s.param6 AS heap_blks_total,`

Comments

(0)