sosedoff / pgweb

Cross-platform client for PostgreSQL databases
https://sosedoff.github.io/pgweb
MIT License
8.63k stars 732 forks source link

Rows tab no longer works on tables with uppercase characters #412

Closed transcranial closed 5 years ago

transcranial commented 5 years ago

Rows tab was working in 0.10.0. Broke in 0.11.0 for tables with uppercase characters in its name. Other tabs as well as "Table Information" continue to work fine.

For example, on a table named "SequelizeMeta" (created by sequelize for migrations):

image

sosedoff commented 5 years ago

Can't reproduce in 0.11.1 (latest) on OSX and with Heroku test database. Need more info: OS, Postgres version.

transcranial commented 5 years ago

Using docker compose:

version: '3'
services:
  postgres:
    image: postgres:9.6-alpine
    ports:
      - 5432:5432
  pgweb:
    restart: always
    image: sosedoff/pgweb:0.11.1
    ports:
      - 8081:8081
    links:
      - postgres:postgres
    environment:
      - DATABASE_URL=postgres://postgres:postgres@postgres:5432/postgres?sslmode=disable
    depends_on:
      - postgres

Create table using:

CREATE TABLE "testTable" (
  id    integer PRIMARY KEY,
  name   varchar(40)
);

Click on "Rows" tab, get following message:

ERROR: pq: relation "public.testtable" does not exist

Also tried combos of: postgres:10.6-alpine postgres:11.1-alpine and sosedoff/pgweb:0.11.0 sosedoff/pgweb:0.10.0.

"Rows" tab works fine on sosedoff/pgweb:0.10.0.

sosedoff commented 5 years ago

Alright, thanks for the info. I'll try to fix this today.

sosedoff commented 5 years ago

Fixed in 0.11.2.