"CREATE TABLE IF NOT EXISTS" results in a false-positive error if table already exists
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 25/100
- Issue type
- Bug
- Clarity
- Needs clarification
- Activity status
- Stale
- Tech stack
- postgresql, typescript
Research direction
The report names no source file or test entry point. Reproduce the Entity Framework migration script with an existing __EFMigrationsHistory table, then trace how the PostgreSQL action handles the NOTICE and verify that this expected notice no longer causes the build to fail.
Written by the indexing model from the issue text.
Description
Take a script like the auto-generated migration history table creation by Entity Framework:
CREATE TABLE IF NOT EXISTS "__EFMigrationsHistory" (
"MigrationId" character varying(150) NOT NULL,
"ProductVersion" character varying(32) NOT NULL,
CONSTRAINT "PK___EFMigrationsHistory" PRIMARY KEY ("MigrationId")
);
This results in a false error if the table actually already exists:
psql:/home/runner/work/somethingsomething.sql:5: NOTICE: relation "__EFMigrationsHistory" already exists, skipping
[...]
Error: Error occurred while running action:
Error: error in file: /home/runner/work/somethingsomething.sql
psql:/home/runner/work/somethingsomething.sql:5: NOTICE: relation "__EFMigrationsHistory" already exists, skipping
Which subsequently and wrongly fails the build.
- Dominant language
- TypeScript
- Stars
- 25
- Forks
- 22
- PR merge metrics
- No merged PRs in 30d
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from Azure/postgresql
-
need-to-triage
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
Azure/postgresql#58 ·
-
need-to-triage
Difficulty 3/5 1-2 days Newbie friendliness 35/100
Azure/postgresql#55 ·
-
need-to-triage
Difficulty 5/5 Over a week Newbie friendliness 20/100
Azure/postgresql#53 · 1 comment ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 45/100
Azure/postgresql#48 · 2 comments · 2 reactions ·
-
need-to-triage
Difficulty 5/5 Over a week Newbie friendliness 15/100
Azure/postgresql#41 ·
All issues in Azure/postgresql
Similar issues
-
VerificationGate: ATTRIBUTION quote guard never matches a normal quotation (\b around the quote) Open
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
danielmiessler/LifeOS#2234 ·
-
T: Bug
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 65/100
-
Difficulty 1/5 Under an hour Newbie friendliness 85/100
-
Mend: dependency security vulnerability untriaged
Difficulty 2/5 1-3 hours Newbie friendliness 70/100