This article will show you how to drop a contraint, such as a foreign key contraint, on a PostgresSQL 8.x database.
Login to the PostgresSQL command-line interface
psql -U [username] [database_name]
Show a list of constraints on a particular table
\d [table_name]
To Delete (or Drop) the constraint, use the command:
ALTER TABLE [table_name] DROP CONSTRAINT [constraint_name];
Do you have a Solaris 10 (x86 or SPARC) box that you are able to connect to by IP address, but not by hostname? You might have spent hours trying to resolve this issue like me, but here is the quick and easy solution!
Assigning a hostname to a Solaris 10 machine
Login to the command-line terminal [...]
Click here to read the full postThis article will show you how to restart the sshd service on Solaris 10.
To Restart the SSH Service
Login to the command-line terminal
Run the command:
svcadm restart svc:/network/ssh:default
Click here to read the full post