On Mon, 19 Mar 2001, Josh Berkus wrote:
> Stephan,
>
> > Yeah, it doesn't play nice with alter table at all. :(
> > Actually, for recreating -- All you really need to do is kill the
> > three triggers that it creates (drop trigger should work) and use
> > alter table to add them again.
>
> How
"Josh Berkus" <[EMAIL PROTECTED]> writes:
>As such, I'd like to manually create my own foriegn key triggers
> instead, once I'm done tinkering with the DB structure. Can anyone
> provide me with an example of this?
pg_dump some tables with foreign keys ...
regard
Stephan,
> Yeah, it doesn't play nice with alter table at all. :(
> Actually, for recreating -- All you really need to do is kill the
> three triggers that it creates (drop trigger should work) and use
> alter table to add them again.
How can I drop them if they are triggers? I've been doing
t
On Mon, 19 Mar 2001, Josh Berkus wrote:
> Tom, Stephan. List folks:
>
> I'm having a great deal of trouble with the automated constraint
> triggers as implemented in 7.1 beta 3. I find that if I establish a
> foriegn key through the CREATE TABLE statement, things start to blow up
> if I mo
Tom, Stephan. List folks:
I'm having a great deal of trouble with the automated constraint
triggers as implemented in 7.1 beta 3. I find that if I establish a
foriegn key through the CREATE TABLE statement, things start to blow up
if I modify any of the tables involved, and there's no eas
