'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

[DanRibbens]

Those won't be fixed in v2 because it would require changes that could be considered breaking. It was resolved in v3. Our recommendation is to update to the latest v3 version.

[github-actions]

This issue has been automatically locked.
Please open a new issue if this issue persists with any additional detail.