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 08:53:35 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Constraint doesn't droped with the table.

2. I'm droped Oracle's table.

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

4. NOCHECK CONSTRAINT ALL doesn't seem to work

5. Doesn't FK Constraint imply an index?

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

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

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

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

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

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

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


 
Powered by phpBB® Forum Software