Re: "too clever" when creating SQL functions

From: SZŰCS Gábor <surrano(at)mailbox(dot)hu>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: "too clever" when creating SQL functions
Date: 2003-05-08 11:15:10
Message-ID: 005501c31553$16ee7120$0a03a8c0@fejleszt2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dear Richard,

I had a look at a 7.2.1 dump, but it doesn't do that thing. It simply
creates triggers after all the data has been COPY-ed (i.e. at the end of the
file. Only rules and sequence setvals after that.

G.
--
while (!asleep()) sheep++;

---------------------------- cut here ------------------------------
----- Original Message -----
From: "Richard Huxton" <dev(at)archonet(dot)com>
Sent: Wednesday, May 07, 2003 9:10 PM

You might want to look at the output of pg_dump - IIRC that disables all
your
triggers (fk's etc) and re-enables them at the end. Might be what you're
after.
--
Richard Huxton

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Sullivan 2003-05-08 11:20:20 Re: An unresolved performance problem.
Previous Message Victor Yegorov 2003-05-08 09:57:45 Array dimension as integer