Thread: DbVisualizer and PG 7.3?
Hi everyone, Just came across an old email asking about DbVisualizer support and PG. Does anyone know if the problems that the PostgresQL JDBC driver used to have in passing along Referential Integrity information were fixed to the point that DbVisualizer worked well? :-) Regards and best wishes, Justin Clift -- "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
> Does anyone know if the problems that the PostgresQL JDBC driver used to > have in passing along Referential Integrity information were fixed to > the point that DbVisualizer worked well? Hi, I don't know if I'm answering well to your question, at least I don't have 7.3 running yet. But there was indeed a time where DBVis was unable to display the referential integrity constraints past a certain quantity of constraints. I'm now using version 3.0 and I can display all the constraints (30+) again. Hope this helps. -------- Francois Home page: http://www.monpetitcoin.com/ "We waste our time spending money we don't have to buy things we don't need to impress people we don't like"
Francois Suter wrote: <snip> > Hi, > > I don't know if I'm answering well to your question, at least I don't have > 7.3 running yet. But there was indeed a time where DBVis was unable to > display the referential integrity constraints past a certain quantity of > constraints. I'm now using version 3.0 and I can display all the constraints > (30+) again. Thanks Francois, That does help a lot. DbVisualizer 2.x was a great tool and it was a real shame that it had problems with our JDBC driver. It's very good news that it now works. Sounds like it might be easy to get good printouts of database schema's now. :-) Regards and best wishes, Justin Clift > Hope this helps. > > -------- > Francois > > Home page: http://www.monpetitcoin.com/ > "We waste our time spending money we don't have to buy things we don't need > to impress people we don't like" > -- "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
On 5/12/02 10:11 am, "Justin Clift" <justin@postgresql.org> wrote: > Francois Suter wrote: > <snip> >> Hi, >> >> I don't know if I'm answering well to your question, at least I don't have >> 7.3 running yet. But there was indeed a time where DBVis was unable to >> display the referential integrity constraints past a certain quantity of >> constraints. I'm now using version 3.0 and I can display all the constraints >> (30+) again. > > Thanks Francois, > > That does help a lot. DbVisualizer 2.x was a great tool and it was a > real shame that it had problems with our JDBC driver. It's very good > news that it now works. Sounds like it might be easy to get good > printouts of database schema's now. 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. adam -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
> 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 :-) -------- Francois Home page: http://www.monpetitcoin.com/ "We waste our time spending money we don't have to buy things we don't need to impress people we don't like"
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.
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