© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
9 replies
Dan H

Something's funky with Postgres Triggers

Hi Folks, when trying to create a trigger if I use
CREATE OR REPLACE TRIGGER
CREATE OR REPLACE TRIGGER
there's a syntax error for
TRIGGER
TRIGGER
but if I remove
OR REPLACE
OR REPLACE
then it works perfectly.

According to
SELECT version()
SELECT version()
I'm using postgres 14 so I don't understand why it's not working.

Supabase Cloud
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Postgres triggers
SupabaseSSupabase / help-and-questions
4y ago
Triggers disable realtime?
SupabaseSSupabase / help-and-questions
4y ago
Database restoration triggers
SupabaseSSupabase / help-and-questions
4mo ago
triggers in database
SupabaseSSupabase / help-and-questions
3y ago