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

Identical table names in different schemas are merged during introspection #129

Closed
RobinBlomberg opened this issue Jul 27, 2022 · 2 comments
Labels
bug Something isn't working built-in dialect Related to a built-in dialect postgres Related to PostgreSQL

Comments

@RobinBlomberg
Copy link

RobinBlomberg commented Jul 27, 2022

If you have the following PostgreSQL tables:

CREATE TABLE "foo"."bar" ("fizz" timestamp);
CREATE TABLE "qux"."bar" ("buzz" numeric);

They get incorrectly introspected as (paraphrased):

[
  { schema: 'foo', name: 'bar', columns: [
    { name: 'fizz', dataType: 'timestamp' },
    { name: 'buzz', dataType: 'numeric' },
  ] },
  { schema: 'qux', name: 'bar', columns: [
    { name: 'fizz', dataType: 'timestamp' },
    { name: 'buzz', dataType: 'numeric' },
  ] },
]
@koskimas
Copy link
Member

Nice catch! I'll release a new version soon that has this fixed.

@koskimas
Copy link
Member

Fixed in 0.20.0

@igalklebanov igalklebanov added bug Something isn't working postgres Related to PostgreSQL built-in dialect Related to a built-in dialect labels Oct 11, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working built-in dialect Related to a built-in dialect postgres Related to PostgreSQL
Projects
None yet
Development

No branches or pull requests

3 participants