|
From: Stathis.Rege <st...@re...> - 2003-05-20 11:24:25
|
Hi Collin and Denis I possibly have an immediate solution for this problem. 1. Try to install the sqsc-isqlj plugin located in www.rege.org/isqlj/. 2. Start a session. and write the following statement jdbc.getDatabase().dropTable( "foo_%"); #sql[session] { create table foo_1 ( ....... ); create table foo_2 ( ....... ); } 3. Select all of the code and press Control J. Propably you will have the feature you wanted. This will happen because i allready implemented a small parser able to run mixed Java and SQL. I made also a plugin for SquirrelSql client. Inside this parser exists a Database class which has the dropTable method. I know that i did not documented, i have no excuse. I will do my best when i will have some time. Best regards Stathis Alexopoulos -----Original Message----- From: squ...@li... [mailto:squ...@li...]On Behalf Of Colin Bell Sent: Tuesday, May 20, 2003 8:52 AM To: 'Denis Grannell' Cc: squ...@li... Subject: RE: [Squirrel-sql-users] Bug when displaying user defined data types? Hi Denis, I've just installed PostgreSQL under Cygwin and installed the sample ISBN data types. The current CVS version of SQuirreL will display columns of these data types if you have "SQL Other" checked in the "Format" tab in Session Properties. So it should work for you in the 1.2 beta when it is released. Col -----Original Message----- From: Denis Grannell [mailto:dgr...@we...] Sent: Monday, 12 May 2003 6:33 To: squ...@li... Subject: [Squirrel-sql-users] Bug when displaying user defined data types? Hi Folks, I've just noticed a problem displaying a Postgres user-defined data type in Squirrel 1.1 Final. I have a data type of 'ISBN' which I can display correctly with other clients (psql or a php script) but Squirrel is displaying it as 'other'. The output looks like this: psql output squirrel output ============= =============== isbn_table isbn_table 1-56592-286-7 <Other> 0-14-043789-4 <other 0-88687-800-4 <Other> 0-575-05054-3 <Other> . . . . cheers, Denis Denis Grannell, Kapuzinerstr. 45, D-80469 Muenchen Tel: +49 89 201 3672 Fax: +49 89 202 2875 _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ------------------------------------------------------- Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara The only event dedicated to issues related to Linux enterprise solutions www.enterpriselinuxforum.com _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users ------------------------------------------------------- This SF.net email is sponsored by: ObjectStore. If flattening out C++ or Java code to make your application fit in a relational database is painful, don't do it! Check out ObjectStore. Now part of Progress Software. http://www.objectstore.net/sourceforge _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
