[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@domeus.de>
To: 'Adam Witney' <awitney@sghms.ac.uk>,    'Francois Suter' <dba@paragraf.ch>
CC: 'pgsql-general' <pgsql-general@postgresql.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@postgresql.org
[mailto:pgsql-general-owner@postgresql.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@paragraf.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@postgresql.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