Re: Enpty field, grid editor, NOT NULL

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