[ http://issues.apache.org/jira/browse/DERBY-126?page=comments#action_12313761 ]
Jeff Levitt commented on DERBY-126: ----------------------------------- Looking at this further, there are some strange names for some of these headings that don't appear in the original doc. I think they may have occurred when I converted to DITA, so I will create a patch to fix them. In the meantime, the "Modifying Columns" section DOES exist here, under the label "Messages". Is the information currently in the nightly build version of the docs under the area erroneously labeled "Messages" correct as related to this issue? > Documentation bug. Doc says column default can be edited - it looks like it > cannot > ---------------------------------------------------------------------------------- > > Key: DERBY-126 > URL: http://issues.apache.org/jira/browse/DERBY-126 > Project: Derby > Type: Bug > Components: Documentation > Reporter: Bernd Ruehlicke > Priority: Minor > > From the e-mail trail on the Derby Mailing list > I think that part of the documentation needs to be changed... Unless someone > actually shows Derby can support modifying default values or add a default to > an existing column, either myself or you :-) should file a JIRA > documentation bug to fix the documentation. > Under the modifying columns, the document says two options are > available....1) Increase a VARCHAR length 2) specify an interval between > identity columns. > Satheesh > Bernd Ruehlicke wrote: > Thanx - the intresting bit here is that the documentation under "Setting > defaults" on > http://incubator.apache.org/derby/manuals/reference/sqlj26.html#HDRSII-S > QLJ-21322 sais > > "You can specify a default value for a new column or add a default value > to an existing column (see Modifying Columns)." > > > i.e. "... or add a default value to an existing column" > > > That's what I am looking for. > > B-) > > > -----Original Message----- > From: Satheesh Bandaram [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 18, 2005 1:32 PM > To: Derby Discussion > Subject: Re: Add a default to an existing column ? > > I am not aware of a way to modify a default value in Derby. > You can add a default at the table creation time, but not > sure if you can add a default to an existing column. > > Satheesh > > Bernd Ruehlicke wrote: > > Hmm - scary silence followed this e-mail. > > To clarify the mail. > > I want to be able to modify a default value for a > column. > > > Anybody know what is supported in Derby and what isn't ? > > B-) > > > > -----Original Message----- > From: Bernd Ruehlicke [mailto:[EMAIL PROTECTED] > Sent: Monday, January 17, 2005 1:12 PM > To: Derby Discussion > Subject: Add a default to an existing column ? > > Hmm - the documentation states that you can add > a default > value to an existing column in > > http://incubator.apache.org/derby/manuals/reference/sqlj26.htm > l#HDRSII-SQLJ-21322 but I cannot find any > syntax which works for me. > > Questions: > > 1) What is the syntax if I want to add a > default value to a column ? > > 2) What is the syntax if I want to modify a > default value of > a colum ? (Is this possible at all ?) > > Thanx > B-) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
