Jodi Kanter wrote:
> I have a linking table that has only two fields in it and both are
> foreign keys to other tables. I'd like to ensure that there are never
> any duplicate rows in this table. I was planning on creating a
> multi-column unique index to satisfy this requirement. Is there a
> more
Title: ___
On Mon, 2004-08-02 at 11:32, Jodi Kanter wrote:
I have a linking table that has only two fields in it and both are foreign keys to other tables. I'd like to ensure that there are never any duplicate rows in this table. I was planning on creating a mul
Jodi Kanter wrote:
I have a linking table that has only two fields in it and both are
foreign keys to other tables. I'd like to ensure that there are never
any duplicate rows in this table. I was planning on creating a
multi-column unique index to satisfy this requirement. Is there a more
appro
I have a linking table that has only two fields in it and both are
foreign keys to other tables. I'd like to ensure that there are never
any duplicate rows in this table. I was planning on creating a
multi-column unique index to satisfy this requirement. Is there a more
appropriate way to accom
Scott Marlowe wrote:
> On Mon, 2004-08-02 at 07:08, Gaetano Mendola wrote:
>
>>-BEGIN PGP SIGNED MESSAGE-
>>Hash: SHA1
>>
>>Hi all,
>>I did the experiment of running only the autovacuum for one week without
>>running my daily autovacuum full and reindex on heavy updated/inserted
>>tables.
>
On Mon, 2004-08-02 at 07:08, Gaetano Mendola wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi all,
> I did the experiment of running only the autovacuum for one week without
> running my daily autovacuum full and reindex on heavy updated/inserted
> tables.
> Yesterday I reenabled th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 2 Aug 2004, Anjan Dave wrote:
> I recently upgraded from 7.2.4 to 7.4.1, but can't install the contrib
> rpm.
>
> # rpm -ivh postgresql-contrib-7.4.1-1PGDG.i386.rpm
>
> error: Failed dependencies:
>
> perl(Pg) is needed by pos
Hi,
I recently upgraded from 7.2.4 to 7.4.1, but can’t
install the contrib rpm.
# rpm -ivh postgresql-contrib-7.4.1-1PGDG.i386.rpm
error: Failed dependencies:
perl(Pg) is
needed by postgresql-contrib-7.4.1-1PGDG
I installed the ‘postgresql-pl-7.4.1-1PGDG.i386.rpm’
pack
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I did the experiment of running only the autovacuum for one week without
running my daily autovacuum full and reindex on heavy updated/inserted
tables.
Yesterday I reenabled the vacuum full and reindex and, as you can see
from the attachment, I
