Re: [GENERAL] Referencing created tables fails with message that they do not exist!
On Sun, Feb 27, 2005 at 06:50:50PM -0500, Tommy Svensson wrote: > SELECT * FROM ; > SELECT * FROM public.; > SELECT * FROM .public.; > > All result in the message "The relation does not exist!" or "The > relation public. does not exist!". Could you copy and paste the *exact* commands and error messages and send them to the list? That might help us see what's going on. > The tables do actually get created. I can se them in DBVisualizer. If you run psql, what does \d show? (Again, please copy and paste the exact output.) Is it possible that you created the tables in mixed case and didn't quote their names when you tried to query them? If so, then you might want to read "Identifiers and Key Words" in the "SQL Syntax" chapter of the documentation. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 8: explain analyze is your friend
[GENERAL] Referencing created tables fails with message that they do not exist!
I have just installed Postgresql and tried it for the first time. One very serious problem I ran into was when actually trying to use created tables. Creating a simple table without any foreign keys works OK, but after creating the table it is not possible to do a select on it! I tried the following variants: SELECT * FROM ; SELECT * FROM public.; SELECT * FROM .public.; All result in the message "The relation does not exist!" or "The relation public. does not exist!". Creating a new table with a foreign key referencing the first table is also impossible due to exactly the same error message! This behaviour is the same using DBVisualizer/jdbc or psql. So the question is how do you actually reference the tables you have created so that postgres will find them ? The tables do actually get created. I can se them in DBVisualizer. I'm using version 7.4.5 on Linux Mandrake 10.1. Best Regards, Tommy Svensson ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org