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

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

Yes, that's it!
Thank you for helping,

		Christian


On Wed, 31 Oct 2001, Dan Wilson wrote:

> I just fixed this bug in the 2.4-dev code.  It is available in the cvs, you
> can wait for the next release or you can make the following change:
> 
> tbl_replace.php - line 33 -- should be the following now:
>    if (eregi("char|date|bool|time|inet", $field_type[$key])) {
> 
> (just add "inet" to the list of column types)
> 
> -Dan
> 
> 
> 
> : 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
> : > :
> : >
> :
> :
> : _______________________________________________
> : phpPgAdmin-users mailing list
> : php...@li...
> : https://lists.sourceforge.net/lists/listinfo/phppgadmin-users
> :
> 
> 
> _______________________________________________
> phpPgAdmin-users mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phppgadmin-users
>