db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jean T. Anderson (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-126) Documentation bug. Doc says column default can be edited - it looks like it cannot
Date Thu, 09 Jun 2005 00:01:24 GMT
     [ http://issues.apache.org/jira/browse/DERBY-126?page=all ]

Jean T. Anderson updated DERBY-126:
-----------------------------------

      Component: Documentation
    Description: 
>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-)


  was:
>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-)


    Environment: 

Set component to "Documentation" to keep it on the doc radar.

> 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: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
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message