documenting forbidden expressions in column defaults

From: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: documenting forbidden expressions in column defaults
Date: 2018-06-19 08:06:00
Message-ID: 2059e8f2-e6e6-7a9f-0de8-11eed291e641@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi.

The description of DEFAULT in the documentation currently says:

"The value is any variable-free expression (subqueries and
cross-references to other columns in the current table are not allowed)."

But the value cannot be an aggregate expression, a window function, or a
set-returning function either, so maybe we should list these items too?

Attached is a patch that fixes the text in two places where the above
description appears.

Thanks,
Amit

Attachment Content-Type Size
default-expression-forbids-desc-1.patch text/plain 1.8 KB

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2018-06-19 08:25:14 pg_verify_checksums review
Previous Message Michael Paquier 2018-06-19 07:54:45 Re: Partitioning with temp tables is broken