Table and column intellisense not working

[mfairley]

Bug report

Describe the bug

I'm not sure if this is an extension or language server issue but intellisense for table names and column names isn't working. I do get schema suggestions but not not for the table or column names. I also get hover information for the table, so it suggests the language server does have access to the information but it's just not displaying.

To Reproduce

Steps to reproduce the behavior, please provide code snippets or a repository:

1. Open a blank file
2. type select * from auth. and check if you get drop down suggestions

Expected behavior

A dropdown appears with the table names

Screenshots

System information

Version: 2.1.25 (Universal)
VSCode Version: 1.105.1
Commit: 7584ea888f7eb7bf76c9873a8f71b28f034a9820
Date: 2025-11-23T04:45:23.529Z
Electron: 37.7.0
Chromium: 138.0.7204.251
Node.js: 22.20.0
V8: 13.8.258.32-electron.0
OS: Darwin arm64 25.1.0

Additional context

Add any other context about the problem here.

[psteinroe]

hey @mfairley, thanks for reporting! I transferred this issue to the main repo. :)

[Isaachristian]

I am not sure if this is helpful, but I think I have been running into this issue with Neovim. I dug into it for a while, and it seems that the lsp is returning the wrong value for line in the textEdit.range.start and textEdit.range.end sections coming for the lsp (I am new to a lot of this so hopefully that made sense). For some reason, if i write the query at the top of the file, everything works fine, but as soon as I add a comment or second query, it starts sending the wrong values.

Running :lua vim.lsp.buf_request(0, 'textDocument/completion', vim.lsp.util.make_position_params(), function(err, result) vim.print(result) end) in Neovim gives all the lsp output for the current cursor position and it seems correct at the top of the file:

{ {
    insertTextFormat = 1,
    kind = 7,
    label = "public",
    labelDetails = {
      description = "Schema",
      detail = " Schema"
    },
    preselect = false,
    sortText = "00"
  }, {
    insertTextFormat = 1,
    kind = 7,
    label = "users",
    labelDetails = {
      description = "public",
      detail = " Table"
    },
    preselect = false,
    sortText = "01",
    textEdit = {
      newText = "users",
      range = {
        ["end"] = {
          character = 5,  -- correct
          line = 2        -- correct
        },
        start = {
          character = 5,
          line = 2
        }
      }
    }
  }, 
  -- many more options
}

But if I try to insert it at the middle of the file I get this:

{ {
    insertTextFormat = 1,
    kind = 7,
    label = "public",
    labelDetails = {
      description = "Schema",
      detail = " Schema"
    },
    preselect = false,
    sortText = "00"
  }, {
    insertTextFormat = 1,
    kind = 7,
    label = "users",
    labelDetails = {
      description = "public",
      detail = " Table"
    },
    preselect = false,
    sortText = "01",
    textEdit = {
      newText = "users",
      range = {
        ["end"] = {
          character = 14, -- this is correct
          line = 0 -- seems to be stuck at 0
        },
        start = {
          character = 14, -- this is correct
          line = 0 --seems to be stuck at 0
        }
      }
    }
  }, 
  -- many more options...
}

I suspect that the wrong locations are causing the table/column options to not display. Since the schema options don't have that info, they probably continue to be displayed. I hope this helps and I'd be happy to provide any more information if needed.

I am using version 0.17.2 of the postgres-language-server.

[mcunningham]

@Isaachristian - I think I've encountered a similar issue to you - opened up an issue #614

[juleswritescode]

Thanks for the great issue reports @Isaachristian and @mcunningham 👍🏻
It should be fixed in version 0.18.0 (released about an hour ago).
Please check again if it works!

@mfairley — is your problem also fixed?