Stephan Bauer <stephan_bauer@gmx.de> writes:
> CREATE TABLE anzeigen (
> ...
> name varchar(30) NOT NULL,
> ...
> );
> The following statement _will_ be inserted:
> INSERT INTO anzeigen ( ... name ...)
> VALUES ( ..., '', ...);
> What is my problem?
An empty string '' is quite different from a NULL.
If you want to forbid empty strings you could add a constraint
expression, eg, CHECK (name <> '').
regards, tom lane