Search Postgresql Archives

Re: How do I drop a Complicated Constraint Trigger After Delete Execute Procedure?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Yes.  I do want to keep that information in the bug : assigned_to=user_id
Yes. I'm embrassed to say it's still in 7.1.3. I know, I know that I need to upgrade, but I do need to fix a problem now.
\d+ bug returns
                                     Table "bug"
   Attribute   |  Type   |                   Modifier                   | Descript                  ion
---------------+---------+----------------------------------------------+---------                  ----
 bug_id        | integer | not null default nextval('bug_pk_seq'::text) |
 group_id      | integer | not null default '0'                         |
 status_id     | integer | not null default '0'                         |
 priority      | integer | not null default '0'                         |
 category_id   | integer | not null default '0'                         |
 submitted_by  | integer | not null default '0'                         |
 assigned_to   | integer | not null default '0'                         |
 date          | integer | not null default '0'                         |
 summary       | text    |                                              |
 details       | text    |                                              |
 close_date    | integer |                                              |
 bug_group_id  | integer | not null default '0'                         |
 resolution_id | integer | not null default '0'                         |
Indices: bug_group_id,
         bug_groupid_assignedto_statusid,
         bug_groupid_statusid,
         bug_pkey


-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxx] 
Sent: Wednesday, February 10, 2010 5:10 PM
To: pgsql-general@xxxxxxxxxxxxxx
Cc: Wang, Mary Y
Subject: Re:  How do I drop a Complicated Constraint Trigger After Delete Execute Procedure?

On Wednesday 10 February 2010 4:56:21 pm Wang, Mary Y wrote:
> Hi,
>
> Hmm. Things are still getting interesting around here.
>
> Here is my complicated problem.  I tried to delete a user from my 
> users table, but it said "ERROR:  bug_assigned_to_fk referential 
> integrity violation - key in users still referenced from bug" Ok.

Why not try deleting the information in bug that had assigned_to=user_id? Or do you want to keep that info in bug?

Is this still in version 7.1?

> Then I saw this statement in the .sql file.
> "CREATE CONSTRAINT TRIGGER "bug_assigned_to_fk" AFTER DELETE ON "users" 
> FROM "bug" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE 
> PROCEDURE "RI_FKey_noaction_del" ('bug_assigned_to_fk', 'bug', 
> 'users', 'FULL', 'assigned_to', 'user_id');" Then I used this command 
> to delete the constraint trigger:
> " drop trigger bug_assign_to_fk on bug;"
> I received error:
> "ERROR:  DropTrigger: there is no trigger bug_assign_to_fk on relation bug"
> I also tried
> "drop trigger bug_assign_to_fk on user;"
> I received this error:
> "ERROR:  DropTrigger: there is no trigger bug_assign_to_fk on relation 
> users"
>
> Here is the bug table.  Please NOTE there is no constraint listed in 
> the bug table.
>
> \d bug

How about \d+ bug ? 


> Mary



--
Adrian Klaver
adrian.klaver@xxxxxxxxx

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux