Re: [GENERAL] automatic verifications

2003-12-19 Thread Melanie Bergeron
Thanks for your help Melanie ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] CHECK versus a Table for an enumeration

2003-12-22 Thread Melanie Bergeron
Hi all! I want to know what's better between these 2 solutions : CREATE TABLE user ( ... user_type text CHECK(user_type='Root' OR user_type = 'Admin' OR user_type = 'Standard')); or the following : CREATE TABLE user_type( user_type_id integer PRIMARY KEY, user_type_desc text); CREA

Re: [GENERAL] Add Primary/Foreign Key in 7.3.2

2003-12-22 Thread Melanie Bergeron
You can do this by doing ALTER TABLE mytable ADD CONSTRAINT myconstraint FOREIGN KEY (table_id) REFERENCES myothertable(table_id); Melanie Brian C. Doyle wrote: Hello all, I was wondering if there is any way to add a primary and/or foreign keys to existing tables in 7.3.2

[GENERAL] unsubscribe

2004-01-12 Thread Melanie Bergeron
unsubscribe ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[GENERAL] problem starting postmaster as a service

2004-01-15 Thread Melanie Bergeron
Hi all! I have a big problem installing postmaster as a service under Windows XP with cygwin. I already installed postgresql on 2 machines without problems but this machine really seem to don't like postgresql ;) I do exactly the procedure indicated in the README file but I always got the sa