Re: [GENERAL] Autograph Annoucement (ERD Tool)

2008-04-04 Thread Colin Fox
Colin Wetherbee wrote: > Colin Wetherbee wrote: >> Also, is there a way to forcibly remove tables and views from the >> output? In all.xml, I only list the tables I want, but in addition >> to those, I also get my PostGIS tables and all the views I've created >> within the schema. > > And... > > I

Re: [GENERAL] Autograph Annoucement (ERD Tool)

2008-04-04 Thread Colin Fox
Colin Wetherbee wrote: > >> >> Can you look at the PS file, and make sure that you're at least getting >> a legitimate postscript diagram? > > It turned out I had incorrectly added my schema information. > > Works now, with NetPBM. > > Cool tool! Glad you like it. I've found it personally indispens

Re: [GENERAL] Autograph Annoucement (ERD Tool)

2008-04-03 Thread Colin Fox
Colin Wetherbee wrote: > Colin Wetherbee wrote: >> Colin Fox wrote: >>> Autograph is really just an XSL stylesheet, used in combination with >>> graphviz, xsltproc, convert and the downloadXml.py program from Scott >>> Kirkwood's xmltoddl package. >>

Re: [GENERAL] Autograph Annoucement (ERD Tool)

2008-04-03 Thread Colin Fox
brian wrote: > Colin Fox wrote: >> Hello everyone. >> >> There were a number of people asking about ERD tools here a while ago, >> so I decided to publish one that I've put together. >> >> It's called Autograph, and you can find it on the pg found

Re: [GENERAL] Autograph Annoucement (ERD Tool)

2008-04-03 Thread Colin Fox
Colin Wetherbee wrote: > Colin Wetherbee wrote: >> Colin Fox wrote: >>> Autograph is really just an XSL stylesheet, used in combination with >>> graphviz, xsltproc, convert and the downloadXml.py program from Scott >>> Kirkwood's xmltoddl package. >>

[GENERAL] Autograph Annoucement (ERD Tool)

2008-04-03 Thread Colin Fox
Hello everyone. There were a number of people asking about ERD tools here a while ago, so I decided to publish one that I've put together. It's called Autograph, and you can find it on the pg foundry: http://pgfoundry.org/projects/autograph/ Autograph is really just an XSL stylesheet, used in c

Re: [GENERAL] ER Diagram design tools (Linux)

2008-03-08 Thread Colin Fox
David Fetter wrote: > On Fri, Mar 07, 2008 at 01:22:49PM -0800, Colin Fox wrote: > >> I've created a pg_foundry project for this. >> >> Assuming the project gets approved, I'll post the link here. >> > > Wouldn't it be better just to

Re: [GENERAL] ER Diagram design tools (Linux)

2008-03-07 Thread Colin Fox
appreciated ;) > > On Fri, Mar 7, 2008 at 2:44 PM, Colin Fox <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > Conor McTernan wrote: > > I was wondering if anyone knows of any good ER Diagram tools for > > Postgres that run on Linux. &g

Re: [GENERAL] ER Diagram design tools (Linux)

2008-03-07 Thread Colin Fox
Conor McTernan wrote: > I was wondering if anyone knows of any good ER Diagram tools for > Postgres that run on Linux. > > I have been using DBDesigner by FabForce for a couple of years, but > development has stopped while MySQL workbench is being built (for > windows only). Neither of these applic

Re: [GENERAL] plpgsql trigger function with arguments

2004-03-09 Thread Colin Fox
r The TG_OP variable contains 'INSERT','UPDATE' or 'DELETE'. -- Colin Fox President CF Consulting Inc. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[GENERAL] Trigger using 'if NEW = OLD'

2004-03-09 Thread Colin Fox
eve by the documentation and other postings I've seen archived on the web that this should be possible. Am I doing something wrong, or do I have to do it the long way around (field by field comparison)? Thanks, cf -- Colin Fox President CF Consulting Inc. ---(e