Commit3ee2f25

committed

Change type of pg_statistic_ext.stxstattarget

Change from int32 to int16, to match attstattarget (changed in90189ee).Reviewed-by: Tomas Vondra <tomas.vondra@enterprisedb.com>Discussion:https://www.postgresql.org/message-id/flat/d6069765-5971-04d3-c10d-e4f7b2e9c459%40eisentraut.org

1 parent8e278b6 commit3ee2f25Copy full SHA for 3ee2f25

File tree

-5

lines changed

-5

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -7622,7 +7622,7 @@ SCRAM-SHA-256$<replaceable><iteration count></replaceable>:<replaceable>&l`
`7622`	`7622`
`7623`	`7623`	`<row>`
`7624`	`7624`	`<entry role="catalog_table_entry"><para role="column_definition">`
`7625`		`- <structfield>stxstattarget</structfield> <type>int4</type>`
	`7625`	`+ <structfield>stxstattarget</structfield> <type>int2</type>`
`7626`	`7626`	`</para>`
`7627`	`7627`	`<para>`
`7628`	`7628`	`<structfield>stxstattarget</structfield> controls the level of detail`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -498,7 +498,7 @@ CreateStatistics(CreateStatsStmt *stmt)`
`498`	`498`	`values[Anum_pg_statistic_ext_stxrelid-1]=ObjectIdGetDatum(relid);`
`499`	`499`	`values[Anum_pg_statistic_ext_stxname-1]=NameGetDatum(&stxname);`
`500`	`500`	`values[Anum_pg_statistic_ext_stxnamespace-1]=ObjectIdGetDatum(namespaceId);`
`501`		`-values[Anum_pg_statistic_ext_stxstattarget-1]=Int32GetDatum(-1);`
	`501`	`+values[Anum_pg_statistic_ext_stxstattarget-1]=Int16GetDatum(-1);`
`502`	`502`	`values[Anum_pg_statistic_ext_stxowner-1]=ObjectIdGetDatum(stxowner);`
`503`	`503`	`values[Anum_pg_statistic_ext_stxkeys-1]=PointerGetDatum(stxkeys);`
`504`	`504`	`values[Anum_pg_statistic_ext_stxkind-1]=PointerGetDatum(stxkind);`
`@@ -676,7 +676,7 @@ AlterStatistics(AlterStatsStmt *stmt)`
`676`	`676`
`677`	`677`	`/* replace the stxstattarget column */`
`678`	`678`	`repl_repl[Anum_pg_statistic_ext_stxstattarget-1]= true;`
`679`		`-repl_val[Anum_pg_statistic_ext_stxstattarget-1]=Int32GetDatum(newtarget);`
	`679`	`+repl_val[Anum_pg_statistic_ext_stxstattarget-1]=Int16GetDatum(newtarget);`
`680`	`680`
`681`	`681`	`newtup=heap_modify_tuple(oldtup,RelationGetDescr(rel),`
`682`	`682`	`repl_val,repl_null,repl_repl);`

Lines changed: 1 addition & 1 deletion

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -43,7 +43,7 @@ CATALOG(pg_statistic_ext,3381,StatisticExtRelationId)`
`43`	`43`	`* object's namespace */`
`44`	`44`
`45`	`45`	`OidstxownerBKI_LOOKUP(pg_authid);/* statistics object's owner */`
`46`		`-int32stxstattargetBKI_DEFAULT(-1);/* statistics target */`
	`46`	`+int16stxstattargetBKI_DEFAULT(-1);/* statistics target */`
`47`	`47`
`48`	`48`	`/*`
`49`	`49`	`* variable-length fields start here, but we allow direct access to`

Comments

(0)