On Sat, Feb 12, 2011 at 9:50 AM, Vladimir Kokovic <vladimir.koko...@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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
