You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Bernd Ruehlicke (JIRA)" <de...@db.apache.org> on 2005/01/18 22:10:17 UTC
[jira] Commented: (DERBY-126) Documentation bug. Doc sais column default can be edited - it looks like it cannot
[ http://issues.apache.org/jira/browse/DERBY-126?page=comments#action_57736 ]
Bernd Ruehlicke commented on DERBY-126:
---------------------------------------
Oops - created this as a "Major" priority by accident - sorry.
Of course is this Minor - hope somebody can change this.
B-)
> Documentation bug. Doc sais 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
> Reporter: Bernd Ruehlicke
>
> 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:satheesh@Sourcery.Org]
> 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:BRuehlicke@lgc.com]
> 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
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira