[Fwd: Re: [GENERAL] DbVisualizer and PG 7.3?]

Hi everyone,

Has this been forwarded here yet? Csaba is reporting what looks to be a
bug in the JDBC driver.

:-(

Regards and best wishes,

Justin Clift

-------- Original Message --------
Subject: Re: [GENERAL] DbVisualizer and PG 7.3?
Date: Thu, 5 Dec 2002 14:26:38 +0100
From: Csaba Nagy <nagy(at)domeus(dot)de>
To: 'Adam Witney' <awitney(at)sghms(dot)ac(dot)uk>, 'Francois Suter' <dba(at)paragraf(dot)ch>
CC: 'pgsql-general' <pgsql-general(at)postgresql(dot)org>

If you want to try out something new (and possibly buggy), take a look at
this:
http://dprutean.tripod.com/
You can arrange your layout and save it and more, all of this through a web
interface, and the data is saved in plain XML... quite amazing.
I've got it working with Oracle, but I couldn't do schema import from
Postgres, it hangs for some reason.

The author says it's a Postgres JDBC bug, looks like the
java.sql.DatabaseMetaData#getCrossReference(String primaryCatalog, String
primarySchema, String primaryTable, String foreignCatalog, String
foreignSchema, String foreignTable) method hangs in any of the following
situations:
a) primaryTable is null;
b) foreignTable is null;
c) primaryTable == foreignTable;
The author sais these inputs are valid according to the JDBC spec.

Cheers,
Csaba.

le si foreignTable acceeasi valoare ( ca si cum ai vrea sa vezi daca o
tabela se autoreferentiaza ).
-----Ursprungliche Nachricht-----
Von: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]Im Auftrag von Adam Witney
Gesendet: Donnerstag, 5. Dezember 2002 11:40
An: Francois Suter
Cc: pgsql-general
Betreff: Re: [GENERAL] DbVisualizer and PG 7.3?

On 5/12/02 10:35 am, "Francois Suter" <dba(at)paragraf(dot)ch> wrote:

>> One problem I had with this was that if you arrange your tables around
the
>> screen then you couldn't save that 'view' of the tables and so when you
>> opened up the program again all the tables were back organised in one
line
>> or in one column. Otherwise it looked a really nice tool.
>
> True. That's an annoying limitation. And it doesn't seem like the paying
> version addresses that. Maybe we can suggest it for their TODO list if
it's
> not already there :-)

Yes, I spoke to them about it and they said it was planned for a future
version, but they did not know which future version!!

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi