PDA

View Full Version : select error

Santhi
06-26-02, 02:03
Hi help me ...

I am new to this database.I am not able to select the table in the front end.
It is giving me error table does not exist.I created new table in the database,
i am not able to view the newly created tables but i am able to view tables
which was created already.I changed the security permissions but it's giving
the same error.

thanks,
santhi
eperich
06-26-02, 09:53
when you are allowed to create tables
you can select them
what version?
please give me some more feedback.

Sql-statements and so on..
Santhi
06-28-02, 07:27
Thanks for ur reply.
I am using postgresql 7.1.
I created tables using wizard,
i am not able to use
select statement in the
front end.e.g
select * from tablename

Afterwards i dropped the table
and created in the psql.Now
i am able to use select statement
in the front end.Now it is
working fine.

Thanks
santhi
eperich
06-28-02, 08:37
THe error occurs if you create the table in the wizard abnd then you try to select te tablein the wizard?

AM i right?

in the psql it runs ok?

If this is the fact the server has no error but the wizard has ist

What wizard do you mean?
Santhi
06-29-02, 10:21
Wizard i mean that tabbed dialog box which is used to create the table
This we get when we right click on the database in the right side. we get
popup menu -create object as- table .i created table using this initially.

:)
eperich
07-02-02, 12:43
oh some self programmed GUI

Maybe the error is in there.

take a look at the logfile from postgres whether it throws an erro if you create the table with the wizard or not

This is the only thing I have at mind what you can do

I think it's a permission problem with the wizard