Re: [PATCH] pgarchives: Fix database install procedure: remove redundant tables in schema.sql - Mailing list pgsql-www

From Célestin Matte
Subject Re: [PATCH] pgarchives: Fix database install procedure: remove redundant tables in schema.sql
Date
Msg-id 71f7adb0-8588-a695-acad-f7034d3315d4@cmatte.me
Whole thread Raw
In response to [PATCH] pgarchives: Fix database install procedure: remove redundant tables in schema.sql  (Célestin Matte <celestin.matte@cmatte.me>)
Responses Re: [PATCH] pgarchives: Fix database install procedure: remove redundant tables in schema.sql  (Magnus Hagander <magnus@hagander.net>)
List pgsql-www
Hello,

Apologies, patch sent in previous email of this thread is incorrect. Please find correct patch attached.

In fact, the pgarchives repository is in a weird state, in which the migration adding two tables is missing
(0005_apiclient_threadsubscription.pywhen running makemigrations). My guess is that this is because these tables use
SERIALs,which django does not handle properly, and must by created using raw SQL. Am I right?
 
Is it something that should be fixed?


I would still need answers for the two questions asked in previous email:

> Additionally, I have two questions:
> - Where is the "tsparser" parser defined? (See commit e05f813b of pgarchives).
> It is used in schema.sql, but I haven't found its definition in the
> pgarchives, pglister or pgweb repositories. Is it an alias to
> pg_catalog.pg_ts_parser?
> (I have been able to complete the install procedure by reverting e05f813b,
> but I have no idea what the consequences are for the application)
> - Same question for /usr/share/postgresql/12/tsearch_data/pg_dict.stop
> I've found pg_dict.syn in pgweb, but not this file.
> 
> Cheers,
> 

Cheers,
-- 
Célestin Matte
Attachment

pgsql-www by date:

Previous
From: Célestin Matte
Date:
Subject: [PATCH] pgweb: Add SEARCH_DSN to example settings.py
Next
From: "Jonathan S. Katz"
Date:
Subject: Re: [PATCH] pgweb: Add SEARCH_DSN to example settings.py