Displaying 2 results from an estimated 2 matches for "postgresqltutorial".
2019 May 22
3
Dict issue with PostgreSQL for last_login plugin (duplicate key)
On 21/05/2019 15:45, mabi via dovecot wrote:
> ??????? Original Message ???????
> On Monday, May 20, 2019 12:37 AM, John Fawcett via dovecot
> <dovecot at dovecot.org> wrote:
>
>> So looking into this with a postgresql databse to work with: the
>> above query does not work. You have to specify either the column name
>> or the constraint name that you expect to
2019 May 23
0
more generic approach as for userdb? (was: Dict issue with PostgreSQL for last_login plugin (duplicate key))
...ySQL which could be
> easily added to the code, but closer inspection shows that the
> PostgreSql syntax requires specification of either a constraint name or
> the index column(s) for the primary/unique keys.
You mean the "target" in ON CONFLICT target action, right?
http://www.postgresqltutorial.com/postgresql-upsert/
> Constraint names are nowhere specified in the dictionary map syntax and
> it's not possible either to identify with 100% certainty the primary key
> column(s).
One could dive into Postgres-specifics to get it, but there are other
SQLs, too; the quota plugin...