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

PG12: pg_attrdef.adsrc got dropped but is still queried for #138

Closed
scuwe opened this issue Sep 27, 2019 · 4 comments
Closed

PG12: pg_attrdef.adsrc got dropped but is still queried for #138

scuwe opened this issue Sep 27, 2019 · 4 comments
Labels
bug
Milestone
6.4.0

Comments

@scuwe
Copy link

scuwe commented Sep 27, 2019 •
edited
Loading

The EntityFramework data provider for .NET tries to query for the column pg_attrdef.adsrc and pg_constraint.consrc (system catalogue), which yields the following exception in Visual Studio during entity model generation:

Aufgrund der folgenden Ausnahme kann das Modell nicht generiert werden: 'System.Data.Entity.Core.EntityCommandExecutionException: Fehler beim Ausführen der Befehlsdefinition. Weitere Informationen finden Sie in der internen Ausnahme. ---> Npgsql.PostgresException: 42703: column ad.adsrc / pg_constraint.consrc does not exist

Probable reason: the table column pg_attrdef.adsrc & pg_constraint.consrc got dropped in a RC12: https://www.postgresql.org/docs/release/12.0/
@vadzvnik
Copy link

vadzvnik commented Oct 5, 2019 •
edited
Loading

I have the same issue now:
Unable to generate the model because of the following exception: 'System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> Npgsql.PostgresException: 42703: column ad.adsrc does not exist

@roji roji added this to the 3.2.2 milestone Oct 5, 2019
@roji roji added the bug label Oct 5, 2019
@roji roji modified the milestones: 3.2.2, 6.3.0 Oct 7, 2019
@roji
Copy link
Member

roji commented Oct 7, 2019

Thanks for raising this. I'll look into this while preparing the 6.3.0 GA release, and will also look into backporting to a 3.2.2 patch release. It will take a few more days though.

@YohDeadfall YohDeadfall mentioned this issue Nov 4, 2019
Closed
@Rumpelstinsk
Copy link

Until this is resolved, is there an alternative?

Thanks

@roji roji closed this as completed in d120f9b Nov 4, 2019
roji added a commit that referenced this issue Nov 4, 2019
@roji
Stop using pg_attrdef.adsrc, obsoleted in PG12
0f8a9df 
Use pg_get_expr() on adbin instead

Fixes #138

(cherry picked from commit d120f9b)
roji added a commit that referenced this issue Nov 4, 2019
@roji
Stop using pg_attrdef.adsrc, obsoleted in PG12
2093673 
Use pg_get_expr() on adbin instead

Fixes #138

(cherry picked from commit d120f9b)
@roji
Copy link
Member

roji commented Nov 4, 2019

Backported to 6.3.1 via 0f8a9df
Backported to 3.2.2 via 2093673

Will try to release soon to unblock this.

@roji roji modified the milestones: 6.3.0, 6.4.0 Dec 4, 2019
@githubfanster githubfanster mentioned this issue Jan 6, 2020
Closed
@aster-orthrinos aster-orthrinos mentioned this issue Jan 10, 2020
Closed
@roji roji mentioned this issue Jan 6, 2023
Closed
@roji roji mentioned this issue Feb 7, 2024
Closed
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
6.4.0
Development

No branches or pull requests
4 participants
@roji @vadzvnik @Rumpelstinsk @scuwe