Insert into non-existing table raises empty APIErrror

[bukacdan]

Insert into non-existing table raises empty APIErrror

Description

If client.table("table_name") does not exist (e.g. typo), insert and upsert operations raise empty APIError.

To Reproduce

1. Create reference to non-existing table
2. Attempt to insert data
3. Raises empty error with no information provided.

 def __init__(self, client: AsyncClient, user: AuthUser):
        self.client = client
        self.repository = self.client.table("not_existing_table")
        self.user = user

        try:
            insert_response = await self.repository.upsert(
                [mod.dict() for mod in db_models],
                count=CountMethod.exact,
                on_conflict="id",
                default_to_null=False,
            ).execute()
        except APIError as e:
            logger.error(f"Failed to bulk insert", user=self.user.id, **e.__dict__)
            # HERE the error is empty

Expected behavior

The error should contain information about the table not present in the scheme.

Screenshots

System information

• OS: macOS
• Version of supabase-py: ^2.6.0

[silentworks]

The library doesn't give any information beyond what PostgREST which is the underlying server gives. This change would need to be suggested to the PostgREST repo https://github.com/PostgREST/postgrest.

[silentworks]

Closing this as it's a PostgREST issue and not a Supabase Python library issue.