db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tfisc...@apache.org
Subject cvs commit: db-torque/src/generator/src/templates/sql/base/postgresql drop.vm
Date Sun, 17 Apr 2005 09:58:59 GMT
tfischer    2005/04/17 02:58:59

  Modified:    xdocs    postgres-howto.xml changes.xml
               src/generator/src/templates/sql/base/postgresql drop.vm
  Log:
  use the CASCADE option for dropping tables in PostgreSQL
  
  Revision  Changes    Path
  1.8       +28 -3     db-torque/xdocs/postgres-howto.xml
  
  Index: postgres-howto.xml
  ===================================================================
  RCS file: /home/cvs/db-torque/xdocs/postgres-howto.xml,v
  retrieving revision 1.7
  retrieving revision 1.8
  diff -u -r1.7 -r1.8
  --- postgres-howto.xml	19 Aug 2004 02:24:49 -0000	1.7
  +++ postgres-howto.xml	17 Apr 2005 09:58:59 -0000	1.8
  @@ -8,11 +8,36 @@
   
   <body>
   
  -<section name="Introductory note">
  +  <section name="PostgreSQL versions">
  +    <p>
  +      The generator templates in Torque 3.2 are optimized for 
  +      PostgreSQL 7.3 and later.
  +      To use an older version of PostgreSQL, do the following:
  +    </p>
  +    
  +    <p>
  +      In the generator, locate the template 
  +      templates/sql/base/postgresql/drop.vm 
  +      and replace the line
  +    </p>
  +    
  +    <source>
  +DROP TABLE $table.Name CASCADE;</source>
  +    
  +    <p>
  +      by
  +    </p>
  +    
  +    <source>
  +DROP TABLE $table.Name;</source>
  +      
  +  </section>
  +
  +<section name="Note">
   
   <p>
  -This HOWTO was written some time ago and was targeted at the
  -version of Torque that was coupled with the 
  +The following sections of this HOWTO were written some time ago 
  +and were targeted at the version of Torque that was coupled with the 
   <a href="http://jakarta.apache.org/turbine/">Turbine</a> application framework.
   Contributions towards updating the information below can be submitted to the 
   <a href="mailto:torque-dev@db.apache.org">Torque Dev mailing list</a>.
  
  
  
  1.152     +5 -0      db-torque/xdocs/changes.xml
  
  Index: changes.xml
  ===================================================================
  RCS file: /home/cvs/db-torque/xdocs/changes.xml,v
  retrieving revision 1.151
  retrieving revision 1.152
  diff -u -r1.151 -r1.152
  --- changes.xml	30 Mar 2005 12:40:41 -0000	1.151
  +++ changes.xml	17 Apr 2005 09:58:59 -0000	1.152
  @@ -29,6 +29,11 @@
   
     <release version="3.2-dev" date="in CVS">
       <action type="fix" dev="tfischer">
  +      Use the cascade option for dropping tables in PostgreSQL.
  +      This allows to drop tables which have foreign keys.
  +      Cascade is supported since PostgreSQL 7.3
  +    </action>
  +    <action type="fix" dev="tfischer">
         Added missing templates for msaccess. I did not test it,
         so no idea whether msaccess is actually supported.
       </action>
  
  
  
  1.5       +1 -1      db-torque/src/generator/src/templates/sql/base/postgresql/drop.vm
  
  Index: drop.vm
  ===================================================================
  RCS file: /home/cvs/db-torque/src/generator/src/templates/sql/base/postgresql/drop.vm,v
  retrieving revision 1.4
  retrieving revision 1.5
  diff -u -r1.4 -r1.5
  --- drop.vm	27 Mar 2005 07:52:12 -0000	1.4
  +++ drop.vm	17 Apr 2005 09:58:59 -0000	1.5
  @@ -1,4 +1,4 @@
  -DROP TABLE $table.Name;
  +DROP TABLE $table.Name CASCADE;
   #if ($table.IdMethod == "native")
   DROP SEQUENCE $table.SequenceName;
   #end
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message