Bug or feature?

[exo]

Hi!
This message for team of developers.
Please, reproduce following steps:
1. Open "Create table window" and create any table with some columns.
2. "Apply"
3. Close this window.
4. Repeat step 1, but create table with same name and other columns' names.
5. Don't press Apply, press View SQL.
6. What do you see? Why I see "alter" instead of "create"?

When I work with many databases with many tables I can try to create table with present name. But I should get error message and shouldn't lose data in this table.

IMHO, it is serious bug.

 

[exo]

Addition: one month ago we lose data from 2 columns in one important table and had need to recover database from backup.

 

[Marco Kalter]

This is indeed unexpected. We'll add a warning for this situation.

 

[exo]

Today is 28.08.2008.
it is about a year has passed after a previous message, but the problem is not corrected. Why?

 

[Marco Kalter]

This is on the to-do list for 8.0.

 

[Marco van der Linden]

May sound strange, but IMHO this is more a problem of the developer than the tool. Under preferences/user interface/appearance you can set connection indicators so you can easily see which database you're working on. Especially when you are working on more than one DB you have to make sure where you're logged on. Things like this have happened to me in the past, and I always blamed myself rather than the tool, whether that be SQL*Plus, that amfibian tool or PLD.

Just my two cents

@Marco: Although, by the way, I would like the connection indicator to be somewhat more prominent, like the whole toolbar.

 

[Marco Kalter]

@Marco: Although, by the way, I would like the connection indicator to be somewhat more prominent, like the whole toolbar.

You can also set the application background color and/or the editor background color as connection indicator.

 

[Marco van der Linden]

You can also set the application background color and/or the editor background color as connection indicator.

I tried that once, but if you have a lot of different instances you run into problems as there are only so many colours which you can use as background colour for editors without suffering severe headaches . Besides, using different background colours interferes with syntax highlighting. So that would require being able to define syntax highlighting at instance level. Setting application background colour is useless for me as I use the desktop command line parameter extensively, so I hardly 'see' the application background.