Re: [GENERAL] [SQL] ALTER TABLE ... DROP CONSTRAINT

2003-08-01 Thread Chad Thompson 






  Hi 
  all!
  
   Who can tell me what postgres version supports 
  ALTER TABLE... DROP CONSTRAINT without
  the need 
  of droping the table to remove a simple coinstraint. 
(link)
  
   
  \\\!/ 55 
  11 5080 
  9283 
  !_"""_! Elielson 
  Fontanezi 
  (O) (o) PRODAM 
  - Technical Support 
  Analyst---oOOO--(_)--OOOo--- 
  Success 
  usually comes to those who are too busy to be looking for 
  it. 
  0 
  0---( 
  )--( 
  ) 
  \ ( 
  ) 
  / 
  \_/ 
  \_/

7.3 supports the drop constraint. The 
only exception begin if you upgraded your database. It keeps the existing 
trigger like constraints if youve moved from 7.1 or 7.2. But these 
triggers can be dropped as well.

HTHChad

P.S. Great signature! 
:-)

Re: [GENERAL] [SQL] ALTER TABLE ... DROP CONSTRAINT

2003-08-01 Thread George Weaver 



It works in 7.3.2.

George

  - Original Message - 
  From: 
  Elielson Fontanezi 
  To: pgsql-general ; pgsql-sql 
  Sent: Wednesday, July 30, 2003 10:52 
  AM
  Subject: [SQL] ALTER TABLE ... DROP 
  CONSTRAINT
  
  Hi 
  all!
  
   Who can tell me what postgres version supports 
  ALTER TABLE... DROP CONSTRAINT without
  the need 
  of droping the table to remove a simple coinstraint. 
(link)
  
   
  \\\!/ 55 
  11 5080 
  9283 
  !_"""_! Elielson 
  Fontanezi 
  (O) (o) PRODAM 
  - Technical Support 
  Analyst---oOOO--(_)--OOOo--- 
  Success 
  usually comes to those who are too busy to be looking for 
  it. 
  0 
  0---( 
  )--( 
  ) 
  \ ( 
  ) 
  / 
  \_/ 
  \_/