Re: [GENERAL] Difference between UNIQUE constraint vs index

2007-02-28 Thread John Jawed
Informix: http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqls.doc/sqls285.htm AFAICS, Oracle as well. John On 2/28/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > In some databases if you know that an index just happens to be

Re: [GENERAL] Difference between UNIQUE constraint vs index

2007-02-27 Thread John Jawed
/27/07, Jim C. Nasby <[EMAIL PROTECTED]> wrote: On Tue, Feb 27, 2007 at 06:43:51PM -0600, John Jawed wrote: > Is there any difference as far as when the "uniqueness" of values is > checked in DML between a unique index vs a unique constraint? Or is > the only difference synt

[GENERAL] Difference between UNIQUE constraint vs index

2007-02-27 Thread John Jawed
Is there any difference as far as when the "uniqueness" of values is checked in DML between a unique index vs a unique constraint? Or is the only difference syntax between unique indices and constraints in PostgreSQL? John ---(end of broadcast)---

Re: [GENERAL] Ajax/PostgreSQL

2006-08-05 Thread John Jawed
If you take a peek at the CVS version of phpPgAdmin, you will see the "autocomplete" functionality for foreign keyed columns when doing "insert row" or "edit row". You can easily get started with that by using the pagila database and trying to insert some data into film_category. $ cvs -d:pserver

Re: [GENERAL] Auto Installation

2006-07-29 Thread John Jawed
On Gentoo Linux, you can run: $ emerge --config dev-db/postgresql It will setup the default database and tell you which kernel settings you need to tweak (kernel.sem,kernel.shmmax, etc). On 7/29/06, Habib Seifzadeh <[EMAIL PROTECTED]> wrote: > > Is there any installer that installs PostgreSQL

[GENERAL] [ppa][PATCHES] Argument handling improvements

2006-06-21 Thread John Jawed
Below are links for the patch and binary (image) files for argument handling improvements in ppa. You can view the original concept @ http://jawed.name/pgsql_soc. It provides support for both JS and JS deficient users. I tried to keep it within the coding guidelines set forth. I appreciate and l