This article will show you how to drop a constraint, such as a foreign key constraint, 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 [...]

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 [...]

This 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