Home : Products : DBMan SQL : Discussion :

Products: DBMan SQL: Discussion: Re: [TheStone] New Install: Edit Log

Here is the list of edits for this post
Re: [TheStone] New Install
I just did a new install of DBMan SQL 2.03. Everything seems to be working fine, but when I try to use an existing (PostgreSQL) table as described in this thread, something goes wrong.

This is what I do:
- from the admin page, I click 'Tables' in the header navigation.
- In the 'Tools' box, I click 'Create Table'.
- I get a page where I am asked to enter a table name. I choose the name of a table that is already in the database. In this case 'affiliates'.
- I get a page called 'Create New Table affiliates' which column definitions where I expected it to recognize my existing table.

I don't know what went wrong, but it seems that DBMan can not find the existing table for some reason. What am I doing wrong?

Furthermore, when I try to create a non existing table, the table gets created, but I get the following error:

Quote:
failed: Failed to execute query: 'DESCRIBE jasper_test2' Reason: ERROR: parser: parse error at or near "describe"!

The table is not listed in the list with existing tables (I only get 'Sample', 'homes' and 'image_galary'), but when I try to create a table with the same name using 'Create Table' again, I get the error 'Table jasper_test2 already exists'.
Note that PostgreSQL does not know the describe command. Am I doing something wrong or does DBMan not fully support PostgreSQL?

Thanks for your help, Jasper

http://www.bookings.org

Last edited by:

jaspercram: Sep 24, 2002, 7:55 AM

Edit Log: