Re: [ppa-users] Insert Line in Table with enpty fields: -> Parser Error

[Dan W. <kil...@us...>]

Whether you can insert a null into a field depends on whether the column is
defined as NOT NULL or not.

The error that you are getting doesn't look like a NULL value problem
though.  Postgres is seeing a parse error....though I can't see a syntax
error.  Is this your exact query?

If not, show us your exact query and we might be able to figure it out.

-Dan

: Hi,
: i am new and I hope I am right here.
:
: Is it possible to insert a line to a table, which has some empty fields ?
: (e.g INSERT INTO "db" ("name", "adress") VALUES ('hugo', '');
: phpPgAdmin says   ERROR: could not parse  ""
: "" ... are the empty fields, but why is here a parse error ?
: Do I have to fill up every fild ? (it is NOT declared as "not null")
:
: Is there a solution to my problem ?
:
: Thanks for you help,
:
: Christian
:
:
:
: _______________________________________________
: phpPgAdmin-users mailing list
: php...@li...
: https://lists.sourceforge.net/lists/listinfo/phppgadmin-users
: