[GENERAL] How to find non-unique indexes in system tables

2007-11-06 Thread Eric Johnson
I can find all the check constraints, primary keys and foreign keys in the information schema, but I cannot find the non-unique indexes. Is there anyplace to get that information (name, columns, etc)? Sorry if this is an FAQ. I couldn't find it with Google. -- Eric Johnson "

Re: [GENERAL] Using contrib/fulltext on multiple tables.

2003-08-01 Thread Eric Johnson
Sure thing, I'll get subscribed to -bugs and send it! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tom Lane Sent: Friday, August 01, 2003 11:06 PM To: Eric Johnson Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Using contrib/fulltext on multiple t

[GENERAL] Using contrib/fulltext on multiple tables.

2003-08-01 Thread Eric Johnson
I am running into a problem with using contrib/fulltext on several tables. Here's the details... I have one sql script which drops everything and recreates the database structure, then populates it with some test data. In this script I create tables a,b and c and setup the triggers for fulltext i