[SQL] Event recurrence - in database or in application code ????

2002-08-20 Thread Darrin Domoney
One of the features that I am attempting to implement in the system that I am building is the capability to schedule events (with recurrence). My question to those of you that are more experienced in postgresql is whether you would implement this functionality in the database level using triggers

Re: [ADMIN] [SQL] Urgent - SQL Unique constraint error (long)

2002-08-19 Thread Darrin Domoney
will allow persons to shift from class to class if their roles change. Darrin Inheritance would have made things so much easier . -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Stephan Szabo Sent: August 19, 2002 1:56 PM To: Darrin Domoney Cc: [EMAIL

Re: [SQL] [NOVICE] Urgent - SQL Unique constraint error (long)

2002-08-19 Thread Darrin Domoney
lf Of paul butler Sent: August 19, 2002 1:11 PM To: [EMAIL PROTECTED] Subject: Re: [NOVICE] Urgent - SQL Unique constraint error (long) From: "Darrin Domoney" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>

Re: [SQL] Urgent - SQL Unique constraint error (long)

2002-08-19 Thread Darrin Domoney
---Original Message- From: Stephan Szabo [mailto:[EMAIL PROTECTED]] Sent: August 19, 2002 12:41 PM To: Darrin Domoney Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [SQL] Urgent - SQL Unique constraint error (long) On Mon, 19 Aug 2002, Darrin Domoney wrote: > An admitte

[SQL] Urgent - SQL Unique constraint error (long)

2002-08-19 Thread Darrin Domoney
An admitted newbie to postgresql I am trying to commit a new design my development server using pgAdminII. Everything appears to work OK but I am having real grief with my SQL generating errors - most of which I have cleared myself but one that I am unsure how to handle: UNIQUE constraint for