Dave Page wrote:
From what Tom has said in his reponse, I think the answer for you Didier
is to remap your integer columns to int8 instead of int4 and see what
happens. When I get a couple of minutes I will look at putting a Serials
as... Option in the type map.
Thanks Dave, for all of your i
Hi all,
Dave Page wrote:
If you really think the schema qualification has something to
do with it, try issuing the ADD FOREIGN KEY command manually
in psql, with and without schema name.
Well to be honest I'm having a hard time believing it, but having looked
at this in some depth, it's
Dear Tom, Dave,
Tom Lane wrote:
Ah-hah, and I'll bet that the column being linked to this one by the
foreign key constraint is still an integer?
It sure is ; being a PostgreSQL novice (BTW : many thanks to the whole
of the PG development team for such an excellent product), I got on this
t
Tom Lane kirjutas K, 22.01.2003 kell 22:30:
> Didier Moens <[EMAIL PROTECTED]> writes:
> > I did some extensive testing using PostgreSQL 7.3.1 (logs and results
> > available upon request), and the massive slowdown is NOT related to
> > qualified tablename syntax or (lack of) VACUUM ANALYZE, but
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
> Sent: 22 January 2003 20:30
> To: Didier Moens
> Cc: Dave Page; PostgreSQL Hackers Mailing List
> Subject: Re: [HACKERS] Foreign key wierdness
>
>
> > With two tables each containi
> -Original Message-
> From: Didier Moens [mailto:[EMAIL PROTECTED]]
> Sent: 22 January 2003 16:05
> To: Dave Page
> Cc: Tom Lane; PostgreSQL Hackers Mailing List
> Subject: Re: [HACKERS] Foreign key wierdness
>
>
> I did some extensive testing using Postgre
Didier Moens <[EMAIL PROTECTED]> writes:
> I did some extensive testing using PostgreSQL 7.3.1 (logs and results
> available upon request), and the massive slowdown is NOT related to
> qualified tablename syntax or (lack of) VACUUM ANALYZE, but to the
> following change :
> pgAdminII 1.4.2 :
>
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
> Sent: 20 January 2003 21:28
> To: Didier Moens
> Cc: Dave Page; PostgreSQL Hackers Mailing List
> Subject: Re: [HACKERS] Foreign key wierdness
>
>
> Didier Moens <[EMAIL PROTECTED]> w
Didier Moens <[EMAIL PROTECTED]> writes:
> I just formally tested on PostgreSQL 7.2.2 (logs sent to Dave), and the
> results are perfectly inline with those from 7.2.3 : a massive slowdown
> when upgrading from pgadminII 1.4.2 to 1.4.12.
I thought the complaint involved PG 7.3? There is no sche
> -Original Message-
> From: Hannu Krosing [mailto:[EMAIL PROTECTED]]
> Sent: 20 January 2003 18:05
> To: Dave Page
> Cc: Tom Lane; PostgreSQL Hackers Mailing List; Didier Moens
> Subject: Re: [HACKERS] Foreign key wierdness
>
>
> > I've been looki
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
> Sent: 20 January 2003 16:08
> To: Dave Page
> Cc: PostgreSQL Hackers Mailing List; Didier Moens
> Subject: Re: [HACKERS] Foreign key wierdness
>
>
> "Dave Page" <[EMAIL PROTECTE
On Mon, 2003-01-20 at 15:47, Dave Page wrote:
> > -Original Message-
> > From: Tom Lane [mailto:[EMAIL PROTECTED]]
> > Sent: 20 January 2003 15:28
> > To: Dave Page
> > Cc: PostgreSQL Hackers Mailing List; Didier Moens
> > Subject: Re: [HACKERS] Foreig
"Dave Page" <[EMAIL PROTECTED]> writes:
> Thing is Tom, this issue can be reproduced *every* time, without fail.
And have you vacuumed or analyzed yet? Or possibly you are short an
index or two (you really need indexes on both the referencing and
referenced columns).
> I've been looking at his f
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
> Sent: 20 January 2003 15:28
> To: Dave Page
> Cc: PostgreSQL Hackers Mailing List; Didier Moens
> Subject: Re: [HACKERS] Foreign key wierdness
>
>
> "Dave Page" <[EMAIL PR
"Dave Page" <[EMAIL PROTECTED]> writes:
> A pgAdmin user has noticed that Foreign Keys take significantly longer
> to create when migrating a database in pgAdmin in v1.4.12 than in
> v1.4.2.
The only reason ADD FOREIGN KEY would take a long time is if
(a) it has to wait awhile to get exclusive loc
Hi all,
A pgAdmin user has noticed that Foreign Keys take significantly longer
to create when migrating a database in pgAdmin in v1.4.12 than in
v1.4.2.
The only difference in the migration code between these releases, is
that pgAdmin now qualifies tables names with the schema name. The
following
16 matches
Mail list logo
