Re: [sqlite] Re: Re: How to change or add fields to a table ?

2007-02-27 Thread P Kishor 

On 2/27/07, Stef Mientki <[EMAIL PROTECTED]> wrote:


>
>> On the other hand I fear that I can only change the name of the Table.
>> If the later is true, why isn't possible to change the name of a
>> column (shouldn't be difficult to implement) ?
>
> Please feel free to submit a patch.
Thank you, but I'm just a Newbie ;-)
It was certainly not to criticize SQLite,
(It's the first database I found without difficult couplings / logins,
so I really love it),
but I wondered if there was a special nifty reason to omit the renaming
of columns.



Stef,

Adding columns is allowed. Dropping columns is not allowed. You can
easily add a new column with the new name, and update it with the
value of the old column.

--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation http://www.osgeo.org/education/
-
collaborate, communicate, compete
=

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Re: Re: How to change or add fields to a table ?

2007-02-27 Thread Stef Mientki 





On the other hand I fear that I can only change the name of the Table.
If the later is true, why isn't possible to change the name of a
column (shouldn't be difficult to implement) ?


Please feel free to submit a patch.

Thank you, but I'm just a Newbie ;-)
It was certainly not to criticize SQLite,
(It's the first database I found without difficult couplings / logins, 
so I really love it),
but I wondered if there was a special nifty reason to omit the renaming 
of columns.


thanks again,
Stef Mientki


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Re: Re: How to change or add fields to a table ?

2007-02-27 Thread Igor Tandetnik 

Stef Mientki <[EMAIL PROTECTED]> wrote:

thanks Igor,
for the fast answer.
(should have found that myself ;-)

But there's a strange thing here I don't understand:
somewhere on the ALTER TABLE documentation it says:
  "to rename or add a new column ..."


It should be parsed this way:

... allows the user to rename, or add a new column to, an existing 
table.


That is, you can rename an existing table, or add a new column to an 
existing table.



On the other hand I fear that I can only change the name of the Table.
If the later is true, why isn't possible to change the name of a
column (shouldn't be difficult to implement) ?


Please feel free to submit a patch.

Igor Tandetnik 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-