phpLens
 home  products examples manual  faq support forum  contact news  login store

Forums: phplens   adodb
Forums:   ADOdb Help & Dev:   Replies 
New ReplySearch
Topic: Postgres DataDict DROP TABLE needs a CASCADE
author: Spider   created: 14-08-2005 07:47:13 PM
Hi John & all,

I have been having trouble with 'REPLACE' on CreateTableSQL for postgres, and it appears the following fix will cure many issues related to that:

--- datadict/datadict-postgres.inc.php 18 Jun 2005 00:19:00 -0000 1.1.1.1
+++ datadict/datadict-postgres.inc.php 14 Aug 2005 23:47:48 -0000
@@ -15,6 +15,7 @@

class ADODB2_postgres extends ADODB_DataDict {

+ var $dropTable = 'DROP TABLE %s CASCADE';
var $databaseType = 'postgres';
var $seqField = false;
var $seqPrefix = 'SEQ_';

Does this seems like a general fix that can be applied back to the mainline?

- spider
Topic: Re:Postgres DataDict DROP TABLE needs a CASCADE
author: John Lim   created: 15-08-2005 04:44:29 AM
Added. Thx Spider.
Page 1
New ReplySearch

View Source

email: contact#phplens.com (change # to @)     telephone (malaysia): 60-3-7947 2888     fax (malaysia): 60-3-7947 2800