Re: Create a Foreign Table for PostgreSQL CSV Logs

From: Олег Самойлов <splarv(at)ya(dot)ru>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, Pg Docs <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: Create a Foreign Table for PostgreSQL CSV Logs
Date: 2020-08-24 13:17:56
Message-ID: F1235CD0-B7B4-4624-885C-EF02BFE7E177@ya.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

There must not be constraints at all. Constraints are needed to check incoming data to the table. But here table is read-only for database!

So all your constraints is totally useless.
> > could become:
> >
> > connection_from text check(connection_from ~ '^[^:]+:[0-9]+$) -- the host and
> > port of the client, colon-separated
> David J.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2020-08-24 14:22:17 Re: Document "59.2. Built-in Operator Classes" have a clerical error?
Previous Message Michael Paquier 2020-08-24 08:02:04 Re: Minor fixes for PostgreSQL 13 documentation