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

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

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
: