[GENERAL] Auto-increment Numeric Primary keys

2000-06-18 Thread Vipin Samtani
How can I auto-increment numeric primary keys? So on a table called "Test1" with fields "ID" and "Name" when I do an INSERT, I only type INSERT INTO Test1 values ('Bob'); instead of INSERT INTO Test1 values (1, 'Bob'); Is this implemented in PostgreSQL 7? -Vipin

[GENERAL] ALTER TABLE to add Foreign Key Constraint

2000-06-17 Thread Vipin Samtani
I am trying to designate foreign keys after tables "distributors" and "addresses" have already been created with primary keys "distributor" and "address" respectively. I am attempting to use ALTER TABLE to accomplish this. I found this statement in the documentation ALTER TABLE distributors ADD

[GENERAL] Access Permission Denied

2000-06-15 Thread Vipin Samtani
I am getting the following error Warning: PostgresSQL query failed: ERROR: userinfo: Permission denied. when I try to connect to a database over the web. "userinfo" is the name of the table I am trying to query. I have tried nearly everything in the documentation provided to connect and I am

[GENERAL] [NOVICE] installation question

2000-04-09 Thread Vipin Samtani
hi, i am a novice user running Red Hat Linux Server 6. what files do i need to download to install PostGreSQL? vipin