[PATCHES] pgarchives: merge schema.sql into Django's model

From: Célestin Matte <celestin(dot)matte(at)cmatte(dot)me>
To: PostgreSQL WWW <pgsql-www(at)lists(dot)postgresql(dot)org>
Subject: [PATCHES] pgarchives: merge schema.sql into Django's model
Date: 2022-02-03 13:30:22
Message-ID: 12eb75f0-3fc2-14f3-0931-4f29e145f182@cmatte.me
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-www

As discussed in previous threads before [1, 2], database creations file are currently split between the Django model and a SQL file. Discrepancy in the database's definition exists between them. As a consequence, the database cannot be created easily.
This series of patches merge schema.sql into Django's model, and adds specific postgres components that cannot be handled by Django's ORM using RunSQL() in a migration file.

Please also note that I integrated several other patches to avoid multiple migration files:
- I allowed message.parentid to be null, as discussed in [1]. This can cause Internal Server Errors in views.py, which are fixed by the second patch.
- I used BinaryFields for bytea columns (message.rawtxt and attachments.attachment), which seems to be the way to integrate bytea into Django

It may be a good opportunity to remove all mentions of pg_dict, pg_stop and associated file. I'm not sure of the consequences of this. According to [2], these are the remains of an aborted idea.
Also, what does tsparer bring? Can the installation of pgarchives be simplified by replacing it with pg_catalog.english?

[1]: https://www.postgresql.org/message-id/CABUevEyFpYPEHh0AAyTAsgymRKOOVA1SY_pDHPCbBQQ9BawfTA%40mail.gmail.com
[2]: https://www.postgresql.org/message-id/CABUevEy_i1xAKscMv4KZ0%3DbE8050bBcQfWaNyjwZZBofZx7JgQ%40mail.gmail.com
--
Célestin Matte

Attachment Content-Type Size
0001-Merge-schema.sql-into-Django-s-model.patch text/x-patch 15.8 KB
0002-Avoid-possible-crash-in-views.py-when-parentid-is-nu.patch text/x-patch 1.0 KB

Responses

Browse pgsql-www by date

  From Date Subject
Next Message Célestin Matte 2022-02-03 13:51:59 Re: [PATCH] pgarchives: Bugfix: missing ids in pglister_sync
Previous Message Jian He 2022-02-03 07:28:56 add tar file download in docs.