© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•13mo ago•
80 replies
Bubu

Permission denied for sequence q_conversation_generation_msg_id_seq

Hi,

My code is returning this error since a few days while it was working before and continue to works locally. Did something change?

SELECT 
    schemaname,
    sequencename,
    sequenceowner
FROM 
    pg_sequences 
WHERE 
    sequencename = 'q_conversation_generation_msg_id_seq';
---
| schemaname | sequencename                         | sequenceowner |
| ---------- | ------------------------------------ | ------------- |
| pgmq       | q_conversation_generation_msg_id_seq | postgres      |
SELECT 
    schemaname,
    sequencename,
    sequenceowner
FROM 
    pg_sequences 
WHERE 
    sequencename = 'q_conversation_generation_msg_id_seq';
---
| schemaname | sequencename                         | sequenceowner |
| ---------- | ------------------------------------ | ------------- |
| pgmq       | q_conversation_generation_msg_id_seq | postgres      |


    os.getenv("SUPABASE_URL"),
            os.getenv("SUPABASE_KEY"),
            options=ClientOptions(schema="pgmq_public")
        )
        
        message = {
            'type': 'conversation_generation',
            'email': user.user.email,
            'model_instance_id': model_instance_response.data[0]['instance_id']
        }

        generation_task_response = supabase_queue_client.rpc('send', { 'queue_name': QUEUE_CONVERSATION_GENERATION, 'message': message}).execute()
        if not generation_task_response.data:
            return jsonify({'error': 'Error creating the generation task'}), 500
    os.getenv("SUPABASE_URL"),
            os.getenv("SUPABASE_KEY"),
            options=ClientOptions(schema="pgmq_public")
        )
        
        message = {
            'type': 'conversation_generation',
            'email': user.user.email,
            'model_instance_id': model_instance_response.data[0]['instance_id']
        }

        generation_task_response = supabase_queue_client.rpc('send', { 'queue_name': QUEUE_CONVERSATION_GENERATION, 'message': message}).execute()
        if not generation_task_response.data:
            return jsonify({'error': 'Error creating the generation task'}), 500
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

keep getting `permission denied for sequence xxx_msg_id_seq`
SupabaseSSupabase / help-and-questions
13mo ago
"permission denied for sequence http_request_queue_id_seq"
SupabaseSSupabase / help-and-questions
7mo ago
permission denied for sequence net.http_request_queue_id_seq
SupabaseSSupabase / help-and-questions
4w ago
Permission denied
SupabaseSSupabase / help-and-questions
3y ago
Next page