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.

Sign up for GitHub

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

Jump to bottom

tables in public schema break indexes #75

Closed
Etomyutikos opened this issue Nov 4, 2017 · 0 comments · Fixed by #76
Closed

tables in public schema break indexes #75

Etomyutikos opened this issue Nov 4, 2017 · 0 comments · Fixed by #76
Labels
bug

Comments

@Etomyutikos
Copy link
Member

Because ::regclass returns the name of the table with the schema prepended except for tables in the public schema, parsing a Postgres table name fails.
Etomyutikos pushed a commit to codercom/gnorm that referenced this issue Nov 4, 2017
check for public schema before trimming table name
80e9a89 
resolves gnormal#75

In Postgres, calling ::regclass on a table OID will prefix that table
with the schema if the table exists outside of the search path.
Practically speaking, that means any table outside of "public".
@Etomyutikos Etomyutikos mentioned this issue Nov 4, 2017
Merged
@natefinch natefinch added the bug label Nov 4, 2017
natefinch pushed a commit that referenced this issue Nov 4, 2017
@Etomyutikos @natefinch
check for public schema before trimming table name (#76)
bb0f0f1 
resolves #75

In Postgres, calling ::regclass on a table OID will prefix that table
with the schema if the table exists outside of the search path.
Practically speaking, that means any table outside of "public".
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

check for public schema before trimming table name codercom/gnorm
2 participants
@Etomyutikos @natefinch