[GENERAL] Anyone interested in a Pittsburgh-area Postgres users' group?

2004-05-02 Thread Tom Lane
I've gotten a couple of inquiries lately about a Postgres users' group in my home town of Pittsburgh PA. There is not one (unless it's very well camouflaged) but perhaps there is critical mass to create one. If you think you might come to meetings of such a group, let me know off-list. If I get

Re: [GENERAL] 1 foreign key to 2 different tables?

2004-05-02 Thread Ryan Riehle
Thanks for your input. Yes, there is a lot more to this part of the schema. The current stucture makes the most sense to us so far, after lots of thinking. If you are interested I can offer you more details about the structure, but for now I am looking for how to implement this type of constraint

Re: [GENERAL] 1 foreign key to 2 different tables?

2004-05-02 Thread Bruno Wolff III
On Sun, May 02, 2004 at 03:51:44 -0400, Ryan Riehle [EMAIL PROTECTED] wrote: Thanks for your input. Yes, there is a lot more to this part of the schema. The current stucture makes the most sense to us so far, after lots of thinking. If you are interested I can offer you more details about

Re: [GENERAL] Anyone interested in a Pittsburgh-area Postgres users'

2004-05-02 Thread Bill Moran
Tom Lane wrote: I've gotten a couple of inquiries lately about a Postgres users' group in my home town of Pittsburgh PA. There is not one (unless it's very well camouflaged) but perhaps there is critical mass to create one. If you think you might come to meetings of such a group, let me know

Re: [GENERAL] Vacuumdb Errors --Any ideas?

2004-05-02 Thread Keary Suska
on 5/1/04 3:11 PM, [EMAIL PROTECTED] purportedly said: Keary Suska [EMAIL PROTECTED] writes: I received the following errors from an automated full vacuum: vacuumdb: vacuuming of database milemgr failed: ERROR: tuple concurrently updated Hm, could you have had more than one of these

Re: [GENERAL] out of memory error

2004-05-02 Thread Kris Jurka
On Fri, 30 Apr 2004, Rachel McConnell wrote: Hello, I have a Java web application using Hibernate to connect to a PostgreSQL backend. I am seeing the below stack trace during processing of a set of data consisting of around 1000 objects; for a 200 object set I don't see the

Re: [GENERAL] pgsql folder and its contents

2004-05-02 Thread Alexander Cohen
I understand that, but i still really need some kind of reference on what files do what. Does anything of that sort exist? thanks! -- Alexander Cohen http://www.toomuchspace.com (819) 348-9237 (819) 432-3443 On May 1, 2004, at 5:01 PM, Peter Eisentraut wrote: Alexander Cohen wrote: Im looking to

Re: [GENERAL] pgsql folder and its contents

2004-05-02 Thread Peter Eisentraut
Alexander Cohen wrote: I understand that, but i still really need some kind of reference on what files do what. Does anything of that sort exist? Not really. Read the man pages for the programs, use strings to see what files they might open, use ldd to see what libraries are used, delete all

[GENERAL] unattended backupscript not working with 7.4.2, works in 7.1

2004-05-02 Thread Development - multi.art.studio
Hello to the List, i have a question about backing up my fresh updated databases :) after updating some of my databases, everything works fine, except my backupscripts. i run this script as root from cronjob with su - postgres -c ...script... it works fine with postgres 7.1, but in 7.4.2

Re: [GENERAL] unattended backupscript not working with 7.4.2, works in 7.1

2004-05-02 Thread Alvaro Herrera
On Mon, May 03, 2004 at 03:42:04AM +0200, Development - multi.art.studio wrote: i have a question about backing up my fresh updated databases :) after updating some of my databases, everything works fine, except my backupscripts. i run this script as root from cronjob with su - postgres -c

Re: [GENERAL] unattended backupscript not working with 7.4.2, works in 7.1

2004-05-02 Thread Tom Lane
Development - multi.art.studio [EMAIL PROTECTED] writes: after updating some of my databases, everything works fine, except my backupscripts. any suggestions? Set up a ~/.pgpass file for the account that's running the backup job. Or switch to a non-password-based authentication mechanism.

[GENERAL] is this valid

2004-05-02 Thread Dennis Gearon
If found this twice in the 7.3.2 User Manual: ALTER TABLE products ADD COLUMN description text CHECK (description ); Shouldn't there be TWO parenthesis marks? ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] is this valid

2004-05-02 Thread Tom Lane
Dennis Gearon [EMAIL PROTECTED] writes: If found this twice in the 7.3.2 User Manual: ALTER TABLE products ADD COLUMN description text CHECK (description ”); Where exactly? All I see is description '' ... regards, tom lane ---(end of