VS Plugin not working, on 'Retrieve Data' -- Table does not exists. - Githubissues

microsoft / vscode-postgresql

PostgreSQL extension for VSCODE

Other

392 stars 50 forks source link

VS Plugin not working, on 'Retrieve Data' -- Table does not exists. #85

Open ZooDoo4U opened 3 years ago

ZooDoo4U commented 3 years ago

PGSQL Extension Version: 4.1.3.1
VSCode Version: VS 2019 (Community Version 16.7.2)
OS Version: Windows 7

Steps to Reproduce:

Setup Postgres for my ASP.net Identity database.
Installed the extension for working with Postgres from the View::Server.
Connected to my "asp.net" database, able to view tables/views as expected.
Now from the Server explorer right mouse click on a table "Retrieve Data" expected to get the data...

Actual result: (how does the table not exist i used the context menu to 'Retrieve Data')

Microsoft Visual Studio

SQL Execution Error.

Executed SQL statement: SELECT Id, UserName, NormalizedUserName, Email, NormalizedEmail, EmailConfirmed, PasswordHash, SecurityStamp, ConcurrencyStamp, PhoneNumber, PhoneNumberConfirmed, TwoFactorEnabled, LockoutEnd, LockoutEnabled, AccessFailedCount, FirstName, LastName, C... Error Source: Npgsql Error Message: 42P01: relation "aspnetusers" does not exist

OK Help