Re: [sqlite] pragma table_info on a table in attached db

2008-08-20 Thread Kees Nuyt
On Thu, 21 Aug 2008 02:18:39 +0530, Mrinal wrote: >>As Dennis said, that looks like a bug. > > Created a new ticket (number 3320: > http://www.sqlite.org/cvstrac/tktview?tn=3320) > which has been fixed now. Wow, that's fast. >- Mrinal. -- ( Kees Nuyt ) c[_]

Re: [sqlite] pragma table_info on a table in attached db

2008-08-20 Thread Mrinal Kant
>As Dennis said, that looks like a bug. Created a new ticket (number 3320: http://www.sqlite.org/cvstrac/tktview?tn=3320) which has been fixed now. - Mrinal. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/li

Re: [sqlite] pragma table_info on a table in attached db

2008-08-20 Thread Kees Nuyt
On Wed, 20 Aug 2008 06:33:17 +0530, Mrinal wrote: >>Try: >>PRAGMA [database.]table_info(table-name); > >> ( Kees Nuyt > >Thankyou Kees for the solution yw. >But, I am facing another problem [...] As Dennis said, that looks like a bug. I just confirmed SQLite 3.6.0 behaves the same way. Appa

Re: [sqlite] pragma table_info on a table in attached db

2008-08-20 Thread Dennis Cote
Mrinal Kant wrote: >> Try: >> PRAGMA [database.]table_info(table-name); > >> ( Kees Nuyt > > Thankyou Kees for the solution > But, I am facing another problem which is as follows: I open an sqlite > db and create a table "trial". pragma main.table_info(trial) shows > correct info. Then I create

[sqlite] pragma table_info on a table in attached db

2008-08-19 Thread Mrinal Kant
>Try: >PRAGMA [database.]table_info(table-name); > ( Kees Nuyt Thankyou Kees for the solution But, I am facing another problem which is as follows: I open an sqlite db and create a table "trial". pragma main.table_info(trial) shows correct info. Then I create a temp table with the same name "tr

Re: [sqlite] pragma table_info on a table in attached db

2008-08-18 Thread Kees Nuyt
On Tue, 19 Aug 2008 01:14:43 +0530, Mrinal wrote: >pragma table_info(dbname.tablename) syntax is not allowed. Is there >some other way to get the table_info for tables in attached db which >bear the same name as another table in either the main, temp or a >previously attached db? >F.e. >I connect

[sqlite] pragma table_info on a table in attached db

2008-08-18 Thread Mrinal Kant
pragma table_info(dbname.tablename) syntax is not allowed. Is there some other way to get the table_info for tables in attached db which bear the same name as another table in either the main, temp or a previously attached db? F.e. I connect to db1.sqlite which contains a table called t1. Then I at