Re: table constraints and performance - Mailing list pgsql-general

From Chris M
Subject Re: table constraints and performance
Date
Msg-id big171$2stv$1@news.hub.org
Whole thread Raw
In response to table constraints and performance  ("Brian Maguire" <bmaguire@vantage.com>)
List pgsql-general
What Franco Bruno Borghesi says is a goos idea.
You can prevent the user from duplicate submits.

If you want to keep some fields unique in a table, please
rely on the DBMS. PostgreSQL support primary key,
foreign key, unique index and other facilities to keep
data integrity. And I think it can do things better most
of the time.



pgsql-general by date:

Previous
From: Curt Sampson
Date:
Subject: Re: [HACKERS] Decent VACUUM (was: Buglist)
Next
From: Kaarel
Date:
Subject: Re: Books for PostgreSQL?