Hi All,
I have a very annoying problem at one of my customers.
The phenomenon is the following:
I run all function refresh scripts (create or replace function exrpssions)
and trying to use them.
Sometimes it seems nothing has happend to the database and the functions.
They work just the same way a
On Sun, Nov 16, 2003 at 09:46:08AM -0500, Yuji Shinozaki wrote:
>
> Here's a question about that: Do dumps always occur
> in a predictable row order?
No, at least not between systems. I'm pretty sure that the same
system, if left unchanged between them, wil dump the tables in the
same order. T
You might consider comparing the schemas with pg_dump -s and diff (as was already suggested), then comparing the data with a (e.g.) perl DBI script connected to two databases simultaneously.
If the two databases are truly descended from the same design (e.g., restored from the same dump), then
--- Rudi Starcevic wrote:
> I'm not trying to upset anyone just trying to help you get an answer for your
> issues.
Who knows what you're trying to do? You did not provide any answers and why you
decided to quote the *same* email *twice* if it was sent only *once* I may
never know.
Anyway, tha
On Sun, 16 Nov 2003, ow wrote:
> --- ow <[EMAIL PROTECTED]> wrote:
> > Perhaps I should clarify.
> >
> > First, I ran pg_dump to extract schema and data *together*. Then I ran
> > pg_restore to restore the db. It took about 1 hour to create tables and copy
> > the data, then about 40 min to creat
On Mon, 17 Nov 2003 10:40:20 -0800 (PST)
Stephan Szabo <[EMAIL PROTECTED]> wrote:
>
> By the way, what does your schema look like? I created an 80M row fk
> table and 20K row pk table with an int4 key between them and indexes on
> the two key fields. It took about 25 minutes on my not terribly
On Mon, 17 Nov 2003, Jeff wrote:
> On Mon, 17 Nov 2003 10:40:20 -0800 (PST)
> Stephan Szabo <[EMAIL PROTECTED]> wrote:
>
> >
> > By the way, what does your schema look like? I created an 80M row fk
> > table and 20K row pk table with an int4 key between them and indexes on
> > the two key fields.
--- Jeff <[EMAIL PROTECTED]> wrote:
> On Mon, 17 Nov 2003 10:40:20 -0800 (PST)
> Stephan Szabo <[EMAIL PROTECTED]> wrote:
>
> >
> > By the way, what does your schema look like? I created an 80M row fk
> > table and 20K row pk table with an int4 key between them and indexes on
> > the two key fie
On Mon, 17 Nov 2003, ow wrote:
> --- Jeff <[EMAIL PROTECTED]> wrote:
> > On Mon, 17 Nov 2003 10:40:20 -0800 (PST)
> > Stephan Szabo <[EMAIL PROTECTED]> wrote:
> >
> > >
> > > By the way, what does your schema look like? I created an 80M row fk
> > > table and 20K row pk table with an int4 key be
--- Stephan Szabo <[EMAIL PROTECTED]> wrote:
>
> I assume you're also not modifying the pktable rows (since that would
> access the fk table based solely on the fk).
I do modify the fk table: inserts and updates (but pk is never updated). Also
do not delete records.
> Does the multi-field index
Hi,
What do you use for debugging PL/PGSQL code?
Regards,
Clifford Ilkay
Dinamis Corporation
3266 Yonge Street, Suite 1419
Toronto, Ontario
Canada M4N 3P6
Tel: 416-410-3326
---(end of broadcast)---
TIP 7: don't forget to increase your free space
On Mon, 17 Nov 2003, ow wrote:
> --- Stephan Szabo <[EMAIL PROTECTED]> wrote:
> >
> > I assume you're also not modifying the pktable rows (since that would
> > access the fk table based solely on the fk).
>
> I do modify the fk table: inserts and updates (but pk is never updated). Also
> do not de
CLIFFORD ILKAY wrote:
Hi,
What do you use for debugging PL/PGSQL code?
raise notice
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 8: explain analyze is your friend
--- Stephan Szabo <[EMAIL PROTECTED]> wrote:
> Well, I've been trying to deal with the particular case at hand, ie, get
> your load in a more reasonable amount of time assuming that you had more
> constraints and this was going to be a particular problem for you in the
> immediate term. I've menti
On Mon, 17 Nov 2003, ow wrote:
> --- Stephan Szabo <[EMAIL PROTECTED]> wrote:
> > Well, I've been trying to deal with the particular case at hand, ie, get
> > your load in a more reasonable amount of time assuming that you had more
> > constraints and this was going to be a particular problem for
--- Stephan Szabo <[EMAIL PROTECTED]> wrote:
> Like I said, it's been discussed and I would expect some form of this for
> 7.5 although I can't say for certain. Enough people were interested in
> the discussion that it's likely to happen with a little championing.
Does not appear like it's on th
I'm trying to avoid having to install 7.3, dump 7.2 and reload 7.3, then
install 7.4, dump 7.3 and install to 7.4 ... What's the chances of just using
the 7.4 pg_dumpall on the 7.2 database and having it work 100% ?
Also, I recall that when upgrading from 7.2 to 7.3 there was something that had
t
On Mon, 17 Nov 2003, ow wrote:
> --- Stephan Szabo <[EMAIL PROTECTED]> wrote:
> > Like I said, it's been discussed and I would expect some form of this for
> > 7.5 although I can't say for certain. Enough people were interested in
> > the discussion that it's likely to happen with a little champ
Stephan Szabo wrote:
>
> On Mon, 17 Nov 2003, ow wrote:
>
> > --- Stephan Szabo <[EMAIL PROTECTED]> wrote:
> > > Like I said, it's been discussed and I would expect some form of this for
> > > 7.5 although I can't say for certain. Enough people were interested in
> > > the discussion that it's l
Chris Gamache writes:
> I'm trying to avoid having to install 7.3, dump 7.2 and reload 7.3, then
> install 7.4, dump 7.3 and install to 7.4 ... What's the chances of just using
> the 7.4 pg_dumpall on the 7.2 database and having it work 100% ?
Pretty good. (At least no worse than going via 7.3.)
--- Bruce Momjian <[EMAIL PROTECTED]> wrote:
>
> Yep, we want to do something, but not sure what. We have:
>
> * Allow triggers to be disabled [trigger]
>
Will ppl remember some time from now that it also deals with FK constraints and
pg_restore/dump options?
Thanks
___
21 matches
Mail list logo
