'Error: There is not enough information to infer relation' with PostgresAdapter

[Asterohobit]

Link to reproduction

No response

Describe the Bug

With nested blocks, Postgres/Drizzle cannot create implicit tables. For example, my collection GlobalElements (elements that are the same for all pages) holds a Block called FooterBlock, which can contain a FooterLinksBlock. When trying to access the collection GlobalElements via the Admin Panel, an Error is thrown:
ERROR (payload): Error: There is not enough information to infer relation "global_elements._blocks_footerLinksBlock"

Have you encountered this error before? A quick internet search suggested is has to do with defining relations one-sided, but this is not the case here as everything happens implicitly.

To Reproduce

1. Create a collection with a field like this: { name: "footer", type: "blocks", required: true, blocks: [FooterBlock], },
2. Create the FooterBlock that contains a field like this: { name: "content", type: "blocks", blocks: [FooterLinksBlock, GridBlock], required: true, },
3. Access the collection via the Admin Panel, the error is thrown in the local terminal.

Payload Version

2.0.0

Adapters and Plugins

db-postgres