On Sat, Feb 12, 2011 at 9:50 AM, Vladimir Kokovic
<vladimir.kokovic@gmail.com> wrote:
> Hi,
>
> pgAdmin GIT version.
>
> If I try to empty a varchar NOT NULL field(grid editor) and then leave
> the row, error message box appear:
>
> An error has occurred:
> ERROR: null value in column "slike" violates not-null constraint
Yes. Per the docs:
If an SQL NULL is to be written to the table, simply leave the field
empty. If you store a new row, this will let the server fill in the
default value for that column. If you store a change to an existing
row, the value NULL will explicitly be written.
To enter a newline into a field, press Ctrl-Enter.
If you want pgAdmin III to write an empty string to the table, you
enter the special string '' (two single quotes) in the field. If you
want to write a string containing solely two single quotes to the
table, you need to escape these quotes, by typing \'\'
See http://www.pgadmin.org/docs/1.12/editgrid.html
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
