I managed to somehow screw up my postgresql 7.1 on a Red Hat Linux 7.1 system:
I can connect to the database, create tables and insert data in them, but I can't get anything out of them. If the table I'm trying to query doesn't exist, I get an error message. If it does, I don't get anything. \d commands in psql don't return anything. Uninstalling the rpms with the --erase option and reinstalling doesn't work. The system crashed when I was testing a JDBC application and has been that way since. Where should I look?
I can connect to the database, create tables and insert data in them, but I can't get anything out of them. If the table I'm trying to query doesn't exist, I get an error message. If it does, I don't get anything. \d commands in psql don't return anything. Uninstalling the rpms with the --erase option and reinstalling doesn't work. The system crashed when I was testing a JDBC application and has been that way since. Where should I look?