doctrine/archived-orm
1
0
Fork 0
mirror of https://github.com/doctrine/orm.git synced 2026-03-24 06:52:09 +01:00
Code Issues 5.3k Packages Projects Releases 100 Wiki Activity

DDC-1172: Schema tool does not drop sequences on table drop for PostgreSql platform #1471

New Issue
Open
opened 2026-01-22 13:15:25 +01:00 by admin · 0 comments
admin commented 2026-01-22 13:15:25 +01:00
Owner
Copy Link

Originally created by @doctrinebot on GitHub (May 26, 2011).

Originally assigned to: @beberlei on GitHub.

Jira issue originally created by user gedrox:

When recreating database using

$schemaTool->createSchema($metaDatas);```

the second line fails with error that the sequence "tbl*id*seq" already exists. It's because the sequence is created without an owner column and schema tool doesn't include "drop sequence" statements in the drop SQL.

I've created a patch which fixes the problem for my environment. Revision numbers in patch is from the local SVN. Doctrine base is 2.0.5.
Originally created by @doctrinebot on GitHub (May 26, 2011). Originally assigned to: @beberlei on GitHub. Jira issue originally created by user gedrox: When recreating database using `````` $schemaTool->dropSchema($metaDatas); $schemaTool->createSchema($metaDatas);``` the second line fails with error that the sequence "tbl*id*seq" already exists. It's because the sequence is created without an owner column and schema tool doesn't include "drop sequence" statements in the drop SQL. I've created a patch which fixes the problem for my environment. Revision numbers in patch is from the local SVN. Doctrine base is 2.0.5. ``````
admin added the Bug label 2026-01-22 13:15:25 +01:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
BC Break
Bug
Can't Fix
Deprecation
Documentation
DQL
Duplicate
Failing Test
Hacktoberfest
Improvement
Improvement
Incomplete
Invalid
Missing Tests
New Feature
PR Created
pull-request
Mirrored from GitHub Pull Request
 Question
Regression
Status: Waiting feedback
Waiting feedback
WIP
Won't Fix
No Label Bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
admin
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#1471
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?