Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Fix ordering of DROP TRIGGER statements in the filtered schema#588

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 ourterms of service andprivacy statement. We’ll occasionally send you account related emails.

Already on GitHub?Sign in to your account

Open
tsg wants to merge1 commit intomain
base:main
Choose a base branch
Loading
fromdrop_trigger_order_fix
Open
Show file tree
Hide file tree
Changes fromall commits
Commits
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Fix ordering of DROP TRIGGER statements in the filtered schema
  • Loading branch information
@tsg
tsg committedNov 8, 2025
commit6857680e70aaa23375a998a558786cc3fe88c36e
Original file line numberDiff line numberDiff line change
Expand Up@@ -470,6 +470,7 @@ func (s *SnapshotGenerator) parseDump(d []byte) *dump {
strings.HasPrefix(line, "CREATE UNIQUE INDEX"),
strings.HasPrefix(line, "CREATE CONSTRAINT"),
strings.HasPrefix(line, "CREATE TRIGGER"),
strings.HasPrefix(line, "DROP TRIGGER"),
strings.HasPrefix(line, "COMMENT ON CONSTRAINT"),
strings.HasPrefix(line, "COMMENT ON INDEX"),
strings.HasPrefix(line, "COMMENT ON TRIGGER"):
Expand Down
View file
Open in desktop
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,9 @@
\connect test

DROP TRIGGER IF EXISTS a_del_alternative_release ON musicbrainz.alternative_release;

DROP TRIGGER IF EXISTS a_del_alternative_medium_track ON musicbrainz.alternative_medium_track;

ALTER TABLE ONLY musicbrainz.alternative_medium
ADD CONSTRAINT alternative_medium_pkey PRIMARY KEY (id);

Expand Down
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -21,8 +21,6 @@ SET row_security = off;

ALTER TABLE IF EXISTS ONLY musicbrainz.alternative_medium DROP CONSTRAINT IF EXISTS alternative_medium_fk_medium;
ALTER TABLE IF EXISTS ONLY musicbrainz.alternative_medium DROP CONSTRAINT IF EXISTS alternative_medium_fk_alternative_release;
DROP TRIGGER IF EXISTS a_del_alternative_release ON musicbrainz.alternative_release;
DROP TRIGGER IF EXISTS a_del_alternative_medium_track ON musicbrainz.alternative_medium_track;
DROP INDEX IF EXISTS musicbrainz.alternative_release_idx_artist_credit;
DROP INDEX IF EXISTS musicbrainz.alternative_medium_idx_alternative_release;
ALTER TABLE IF EXISTS ONLY musicbrainz.alternative_medium_track DROP CONSTRAINT IF EXISTS alternative_medium_track_pkey;
Expand Down
Loading
[8]ページ先頭
©2009-2025 Movatter.jp