Re: [GENERAL] PostgreSQL, GnuCash

2004-08-01 Thread Christopher Browne
Oops! [EMAIL PROTECTED] (Kaarel) was seen spray-painting on a wall: > What could be the potential drawbacks of using PostgreSQL (perhaps its > big size)? "Big size" seems an unlikely thing to actually be true. Contrary to popular misconceptions, MySQL is certainly _not_ smaller than PostgreSQL.

Re: [GENERAL] PostgreSQL, GnuCash

2004-08-01 Thread Christopher Browne
Quoth [EMAIL PROTECTED] (Kaarel): > Would PostgreSQL be a good enough choise for GnuCash (or Quickbooks > or the likes) type of program? What could be the potential > drawbacks of using PostgreSQL (perhaps its big size)? What would be > a better database for that kind of job? The main plausible

Re: [GENERAL] EXPLAIN on DELETE statements

2004-08-01 Thread Grant McLean
On Wed, 2004-07-28 at 23:41, Janning Vygen wrote: > Hi, > > EXPLAIN on delete stamements works, but doesn't show me all the subsequent > deletes or checks which has to be done because of foreign keys > cascading/restricting. > > Is there a solution to show up which tables are checked and which

Re: [GENERAL] PostgreSQL, GnuCash

2004-08-01 Thread Peter Eisentraut
Kaarel wrote: > Would PostgreSQL be a good enough choise for GnuCash (or Quickbooks > or the likes) type of program? I believe GnuCash runs on PostgreSQL, so yes. > What could be the potential drawbacks of using PostgreSQL (perhaps > its big size)? I don't think so. > What would be a better dat

[GENERAL] PostgreSQL, GnuCash

2004-08-01 Thread Kaarel
Would PostgreSQL be a good enough choise for GnuCash (or Quickbooks or the likes) type of program? What could be the potential drawbacks of using PostgreSQL (perhaps its big size)? What would be a better database for that kind of job? Kaarel ---(end of broadcast)-

Re: [GENERAL] Where are all the users?

2004-08-01 Thread gnari
From: "Kay-Uwe.Genz" <[EMAIL PROTECTED]> > > Am 01.08.2004 um 10:44 schrieb Kay-Uwe Genz: > > > Hi @ all, > > > > I want to reference the User-ID PG use as an FOREIGN KEY in a tabel of > > my DB. But I saw that pg_user is a view. Where are the information I > > need? template1=# \d pg_user gn

Re: [GENERAL] Where are all the users?

2004-08-01 Thread Kay-Uwe . Genz
Am 01.08.2004 um 10:44 schrieb Kay-Uwe Genz: Hi @ all, I want to reference the User-ID PG use as an FOREIGN KEY in a tabel of my DB. But I saw that pg_user is a view. Where are the information I need? Thank for your help Kay-Uwe Genz ---(end of broadcast)

Re: [GENERAL] Fwd: [NOVICE] contrib/xml make error on Mac OS X 10.3.4

2004-08-01 Thread Peter Eisentraut
Joel Rodrigues wrote: > The files do exist, for example: > /usr/include/libxml2/libxml/xpath.h Try make all CPPFLAGS=-I/usr/include/libxml2 -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 9: the planner

[GENERAL] Fwd: [NOVICE] contrib/xml make error on Mac OS X 10.3.4

2004-08-01 Thread Joel Rodrigues
Thought I'd try this on the pgsql-general list. Begin forwarded message: This is what happens : make gcc -no-cpp-precomp -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -I. -I../../src/include -c -o pgxml_dom.o pgxml_dom.c pgxml_dom.c:11:26: libxml/xpath.h: No such f