Connecting to a postgresql Database on the Local machine

[ted creedon]

1. What business functionality is not supported with postgresql?
2. The "not under active development" comment seems to conflict with e-mails
by others.
3. I hope the relational database interface will not be intentionally
disabled because:
A. Using a relational database should force a decent object oriented data
design upon the developers.
B. Gnucash's flexibility would be severely compromised.

4. I have a Microsoft's Visioin 2003 Enterprise ORM design package installed
on one of my windows boxes and would be glad to hand enter or otherwise
participate in an object oriented data design workshop. (I actually have the
Visio reverese engineered gnucash/postgresql data design but haven't had
time to study it).
5. Suggest reading "Informational Modeling and Relational Databases",
Halpin, isbn 1 55860 672 6.
6. http://office.microsoft.com/en-us/assistance/CH010266601033.aspx
7. http://www.orm.net/halpin.html

tedc



-----Original Message-----
From: gnucash-user-bounces at gnucash.org
[mailto:gnucash-user-bounces at gnucash.org] On Behalf Of Vincent Ngundi
Sent: Wednesday, March 23, 2005 10:46 PM
To: mevanecek at yahoo.com
Cc: GnuCash
Subject: Re: Connecting to a postgresql Database on the Local machine

Thanks Matthew, I'll try that out...

Vincent.


On Thu, 2005-03-24 at 03:44, Matthew Vanecek wrote:
> <quote who="Josh Sled">
> > On Wed, 2005-03-16 at 09:32, Vincent Ngundi wrote:
> >
> >> Just wanted to ask, has anyone ever successfully used GnuCash with 
> >> a PostgreSQL database in Linux(I'm using Redhat 9).
> >
> > I would venture to guess a very small number of people.
> >
> >
> >> I keep getting the following error when I try to save as either:
> >>
> >> postgres://localhost/template1?user="username"
> >> postgres://localhost/template1"
> >
> > That sounds like a funny name for a gnucash database...
> >
> > How did you create 'template1'?
> >
> > What is in the table 'gncVersion'?
> >
> >
> >
> >> Please help me out!
> >
> > The postgres backend isn't really supported.  Specifically, none of 
> > the active devs use it, it doesn't support all the features of 
> > GnuCash [scheduled transactions and business objects especially], 
> > and we intend to replace it.
> >
> > The best help you're going to get is from yourself and the sources.
> >
> > ...jsled
> >
> 
> Don't use template1--that's the default database Postgresql creates.  
> Use the name of a database that does not exist, and let Gnucash create 
> the database internally.  Connecting to an existing empty database 
> (i.e., a database that does not contain any Gnucash tables) is not 
> supported and will generate that (somewhat deceptive) error.
> 
> The Postgresql backend is not under active development.  E.g., it does 
> not support scheduled transactions or any of the business functionality.
> 
> ciao,

_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user