Constraint doesn't droped with the table. 
Author Message
 Constraint doesn't droped with the table.

Hi all,

     Sorry if this is not the correct issue for this group.

     I have two tables

 -------------                                       --------------------
 |  Informe    |-|-----------------------<|  palavra_informe |
 -------------                                       -------------------

 I droped the table "palavra_informe" but when i execute the following TSQL
i
 get a message from the postgres saying:
 ERROR:  Relation 'palavra_informe' does not exist.

 TSQL:
 UPDATE Informe
 SET st_Destaque       = 'BRASLIA: ARTISTA MEXICANA PERMANECER EM HOSPITAL
 PBLICO DA CAPITAL AT O FINAL DA GRAVIDEZ (entrevistas)',
     id_Posicao        =  35 ,
     st_Ordem          = '0',
     st_Centimetragem  = NULL,
     dt_Minutagem      = to_timestamp('01/01/0001 00:00:00', 'DD/MM/YYYY
 HH24:MI:SS'),
     st_Fita           = NULL,
     dt_DataVeiculacao = to_timestamp('27/12/2001 20:00', 'DD/MM/YYYY
 HH24:MI:SS')
 WHERE id_Informe = 4795792;

 tks a lot.

 Rommel S Trindade.



Mon, 20 Sep 2004 09:20:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Constraint doesn't droped with the table.

2. I'm droped Oracle's table.

3. NOCHECK CONSTRAINT ALL doesn't seem to work

4. Use XA insert the table,some time table will be droped

5. Doesn't FK Constraint imply an index?

6. Bug: COPY IN doesn't test domain constraints

7. Bug: COPY IN doesn't test domain constraints

8. class doesn't support automation or doesn't support expected interface

9. Scheduling DTS doesn't fail but doesn't work

10. ORACLE DOESN'T COMPLY TO BASIC STANDARD SQL: SIMPLE QUERIES DOESN'T WORK

11. class doesn't support automation or doesn't support expected interface

12. Table's Field doesn't bind to HTML Control Element


 
Powered by phpBB® Forum Software