Re: [Fwd: Re: [Fwd: Re: [GENERAL] DbVisualizer and PG 7.3? - Mailing list pgsql-jdbc

I'm not the one who is affected, one of my colleagues is developing the DB
visualizer in his spare time, but he's not using Postgres (he's Oracle dba).
I was just thinking he's application could be used with Postgres too, as it
is a Java app based on JDBC.
I will forward him this answer, see what he has to say :-)
For the null catalog issue I have no idea if it makes sense, but I can say
that a table can reference itself, this one makes perfect sense.
E.g.:

CREATE TABLE employees (
    empid bigint,
    boss bigint references employees(empid)
    ... (other employee data)
);

Thanks,
Csaba.

-----Ursprungliche Nachricht-----
Von: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org]Im Auftrag von Justin Clift
Gesendet: Freitag, 6. Dezember 2002 03:40
An: Csaba Nagy
Cc: 'Adam Witney'; Dave Cramer; pgsql-jdbc@postgresql.org
Betreff: [Fwd: Re: [JDBC] [Fwd: Re: [GENERAL] DbVisualizer and PG 7.3?]]


Hi Csaba,

Is this helpful?

:-)

Regards and best wishes,

Justin Clift


-------- Original Message --------
Subject: Re: [JDBC] [Fwd: Re: [GENERAL] DbVisualizer and PG 7.3?]
Date: 05 Dec 2002 20:25:40 -0500
From: Dave Cramer <davec@fastcrypt.com>
Organization: Cramer Consulting
To: Justin Clift <justin@postgresql.org>
CC: pgsql-jdbc@postgresql.org <pgsql-jdbc@postgresql.org>
References: <3DEFD237.7030804@postgresql.org>

Justin,

This is from the spec.


         primaryCatalog - a catalog name; "" retrieves those without a
         catalog; null means drop catalog name from the selection
         criteria
         primarySchema - a schema name; "" retrieves those without a
         schema
         primaryTable - the table name that exports the key
         foreignCatalog - a catalog name; "" retrieves those without a
         catalog; null means drop catalog name from the selection
         criteria
         foreignSchema - a schema name; "" retrieves those without a
         schema
         foreignTable - the table name that imports the key


         No where do I see primary table can be null, or foreign table
         can be null and what cross reference would there be if
         primary=foreign?

         Dave

On Thu, 2002-12-05 at 17:24, Justin Clift wrote:
 > 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
--
Dave Cramer <davec@fastcrypt.com>
Cramer Consulting


--
"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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)