[sqlite] Is this a bug ? How to rename a table and all dependencies ?

On Fri, 21 Aug 2015 22:58:51 +0200, "sqlite-mail" wrote: > That's why I think that expose a basic SQL ANSI catalog would make this kind > of work and others a lot easier. That would be nice to have in some development environment (you could develop one, if nobody else has done it), but in my

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

On 22 Aug 2015 at 11:01, Kees Nuyt wrote: > It even would be fine to me if all ALTER TABLE features would be > removed. I disagree with this, although I'd be satisfied if there were a separate library and API for such things. With an evolving application I need to have ALTER TABLE. Even the

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

That's why I think that expose a basic SQL ANSI catalog would make this kind of work and others a lot easier. ? > Fri Aug 21 2015 22:13:00 CEST from "Simon Slavin" >Subject: Re: [sqlite] Is this a bug ? How to rename a table and all >dependencies ? > > On 21 Aug 2015, at 9:07pm, Scott

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

On 21 Aug 2015, at 9:07pm, Scott Hess wrote: > That said, writing code to do this manually has potential to be error > prone. It might make sense under an ENABLE flag. It feels like an obvious > thing to have, not something out-of-scope like embedding a new language or > support for a new

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

On 21 Aug 2015, at 8:13pm, Scott Hess wrote: > Since renameTriggerFunc() > follows renameParentFunc(), my guess is that triggers are also handled. The documentation says that statements within TRIGGERs are not changed correctly: Perhaps

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

Thank you for your attention ! I'm pointing this here because postgresql do manage this case properly ! And I'm creating a tool to prototype database applications and I'm using sqlite as the primary database, when we are prototyping things can change drastically at any point and if we

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

Thanks for your attention! Only to remark on this I tested on postgresql and somehow it knows how deal with it ! "so few (none?)" Cheers ! ? > Fri Aug 21 2015 19:08:58 CEST from "J Decker" Subject: >Re: [sqlite] Is this a bug ? How to rename a table and all dependencies ? > > On

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

On 21 Aug 2015, at 7:02pm, sqlite-mail wrote: > I'm pointing this here because postgresql do manage this case properly ! If you want postgres, you know where to find it. Please don't forget that SQLite has to run on your smartphone and your SatNav device and your TV. It has different design

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

Then do you think this is a bug ? > Fri Aug 21 2015 18:57:33 CEST from "Simon Slavin" >Subject: Re: [sqlite] Is this a bug ? How to rename a table and all >dependencies ? > > On 21 Aug 2015, at 12:20pm, sqlite-mail wrote: > > >>Does anybody knows how to rename a table and all it's

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

On 21 Aug 2015, at 12:20pm, sqlite-mail wrote: > Does anybody knows how to rename a table and all it's dependencies in one go > ? Can't be done. Sorry. Simon.

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

On Fri, Aug 21, 2015 at 1:02 PM, sqlite-mail wrote: > Thank you for your attention ! > > I'm pointing this here because postgresql do manage this case properly ! > ?And is significantly larger and harder to install. PostgreSQL is not "lite"! I know. I use it and love it. ? > > And I'm

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

Hello ! Here I'm fixing some typos and I also tested on postgresql and there all views are updated properly then I'll say is a bug in sqlite. Does anybody knows how to rename a table and all it's dependencies in one go ? ? The problem: a database has several tables and views that

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

Hello ! Does anybody knows how to rename a table and all it's dependencies in one go ? ? The problem: a database has several tables and views that reference/use other tables something simplified like this: CREATE TABLE a(id integer primary key, name text); CREATE TABLE

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

On 8/21/15, sqlite-mail wrote: > Then do you think this is a bug ? The word "bug" means it gets the wrong answer. The absence of a feature is not a bug, unless that feature is a required part of the specification for the program. The ability to rename tables and all dependencies is not a

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

On Fri, Aug 21, 2015 at 1:02 PM, Simon Slavin wrote: > On 21 Aug 2015, at 8:13pm, Scott Hess wrote: > > Since renameTriggerFunc() > > follows renameParentFunc(), my guess is that triggers are also handled. > > The documentation says that statements within TRIGGERs are not changed > correctly: >

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

On Fri, Aug 21, 2015 at 11:06 AM, Simon Slavin wrote: > On 21 Aug 2015, at 7:02pm, sqlite-mail wrote: > > I'm pointing this here because postgresql do manage this case properly ! > > If you want postgres, you know where to find it. > > Please don't forget that SQLite has to run on your

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

(oops glitched my send) Try using a database modeling program such as TMS Software's Data Modeler or SQL Maestro Group's SQLite Maestro These handle the changes nicely. You use the programs for designing your databases, queries, views and such. It spits out SQL to run on your system that

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

Scott Doctor scott at scottdoctor.com -- On 8/21/2015 10:37 AM, sqlite-mail wrote: > Thanks for your attention! > > Only to remark on this I tested on postgresql and somehow it knows how deal > with it ! "so few (none?)" > > Cheers ! > > >> Fri Aug 21 2015

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

On Fri, Aug 21, 2015 at 10:04 AM, sqlite-mail wrote: > Then do you think this is a bug ? >> Fri Aug 21 2015 18:57:33 CEST from "Simon Slavin" >>Subject: Re: [sqlite] Is this a bug ? How to rename a table and all >>dependencies ? while it may be considered a nice thing; it's not common practice