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

[Christian S. <ch...@ar...>]

Hi,
aha, the problem is that if you have a field from type INET and you dont't
put a value in it, pgpPgAdmin shows a parse-Error.

The solution to the problem is, that I'm writing NULL in it. So it is like
empty. Hence the next step was, that i extend the INET-fields with DEFAULT
NULL so I don't have to type it every time when i insert data in a line.
Hmm, but DEFAULT NULL don't make sense and is not stored in a dumpfile. 

So I have to type NULL in every empty INET-field when I insert data.
But I think this is a phpPgAdmin-problem, because the frontend WEBMIN
doen't show this problem. (of course, it has other disadvantages.)

Regards,

	Chris
	



On Mon, 29 Oct 2001, Dan Wilson wrote:

> 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
> :
>