Re: Blank Numeric Column For INSERT - Mailing list pgsql-general

From Tom Lane
Subject Re: Blank Numeric Column For INSERT
Date
Msg-id 2663.1322079444@sss.pgh.pa.us
Whole thread Raw
In response to Re: Blank Numeric Column For INSERT  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Blank Numeric Column For INSERT  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
Rich Shepard <rshepard@appl-ecosys.com> writes:
>    Mine do, too. But, that's not what postgres wants to see in the .sql file.

In an insert command, you need to either write NULL or omit the column
from the column list; empty expressions aren't syntactically correct.
(Note that the latter option actually results in inserting the column's
default, not necessarily null...)

            regards, tom lane

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Blank Numeric Column For INSERT
Next
From: Jay Levitt
Date:
Subject: PGError: ERROR: could not open relation with OID?