Possible bug in insert - empty string not allowed on coloumns with default?

Tue, 15 Oct 2002 15:19:49 -0700 

Hello again,

Table:

        CREATE TABLE PNCVS_headlines (
  pn_id serial NOT NULL,
  pn_sitename varchar(255) NOT NULL default '',
  pn_rssuser varchar(10) default NULL,
  pn_rsspasswd varchar(10) default NULL,
  pn_use_proxy int NOT NULL default '0',
  pn_rssurl varchar(255) NOT NULL default '',
  pn_maxrows int NOT NULL default '10',
  pn_siteurl varchar(255) NOT NULL default '',
  pn_options varchar(20) default '',
  PRIMARY KEY  (pn_id)
        )


SQL:
        INSERT INTO PNCVS_headlines VALUES 
        (2,'PostNuke',NULL,NULL,'','http://postnuke.com/backend.php',10,'','')

Error:
        Error in assignment;-3016 POS(61) Invalid numeric constant.


Works fine:
        INSERT INTO PNCVS_headlines VALUES 
        (2,'PostNuke',NULL,NULL,'0','http://postnuke.com/backend.php',10,'','')

Thanks for your comments,

-- 
Yours, Andrej Falout, http://www.falout.com/disclaimer.html
Visit the OpenSource alternative, Aubit 4gl: http://aubit4gl.sourceforge.net
PLEASE NOTE: All HTML email sent to me WILL BE DELETED AUTOMATICALLY WITHOUT 
READING.


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to