Re: Create a Foreign Table for PostgreSQL CSV Logs - Mailing list pgsql-docs

From Олег Самойлов
Subject Re: Create a Foreign Table for PostgreSQL CSV Logs
Date
Msg-id F1235CD0-B7B4-4624-885C-EF02BFE7E177@ya.ru
Whole thread Raw
In response to Re: Create a Foreign Table for PostgreSQL CSV Logs  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Create a Foreign Table for PostgreSQL CSV Logs  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-docs
There must not be constraints at all. Constraints are needed to check incoming data to the table. But here table is
read-onlyfor 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.




pgsql-docs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Minor fixes for PostgreSQL 13 documentation
Next
From: Bruce Momjian
Date:
Subject: Re: Document "59.2. Built-in Operator Classes" have a clerical error?