Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

i3 fails when intarray is installed #25

Closed
NikolayS opened this issue Aug 20, 2018 · 0 comments
Closed

i3 fails when intarray is installed #25

NikolayS opened this issue Aug 20, 2018 · 0 comments
Assignees
Labels

Comments

@NikolayS
Copy link
Owner

test=# create extension intarray
test-# ;
CREATE EXTENSION
test=# :dba
Menu:
   0 – Node & Current DB Information: master/replica, lag, DB size, tmp files, etc
   1 – Databases: Size, Statistics
   2 – Table Sizes
   3 – Load Profile
  a1 – Current Activity: count of current connections grouped by database, user name, state
  b1 – Tables Bloat, rough estimation
  b2 – B-tree Indexes Bloat, rough estimation
  b3 – Tables Bloat, more precise (requires pgstattuple extension; expensive)
  b4 – B-tree Indexes Bloat, more precise (requires pgstattuple extension; expensive)
  b5 – Tables and Columns Without Stats (so bloat cannot be estimated)
  i1 – Unused/Rarely Used Indexes
  i2 – Unused/Redundant Indexes Do & Undo Migration DDL
  i3 – FKs with Missing/Bad Indexes
  p1 – [EXPERIMENTAL] Alignment Padding. How many bytes can be saved if columns are ordered better?
  s1 – Slowest Queries, by Total Time (requires pg_stat_statements extension)
  s2 – Slowest Queries Report (requires pg_stat_statements)
  t1 – Postgres parameters tuning
  v1 – Vacuum: Current Activity
   x – Turn Wide Mode ON (currently OFF): show more details, more columns
   q – Quit

Type your choice and press <Enter>:
i3
psql:/home/nikolay/postgres_dba/sql/i3_non_indexed_fks.sql:125: ERROR:  operator is not unique: smallint[] @> smallint[]
LINE 60: ...(indkey::int2[])[0:(array_length(key_cols,1) -1)] @> key_col...
                                                              ^
HINT:  Could not choose a best candidate operator. You might need to add explicit type casts.
Press <Enter> to continue…
@NikolayS NikolayS self-assigned this Nov 26, 2018
@NikolayS NikolayS added the bug label Nov 26, 2018
NikolayS added a commit that referenced this issue Nov 27, 2018
i3: Reformat SQL and fix collision with intarray #25
NikolayS added a commit that referenced this issue Feb 9, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant