Re: [GENERAL] invalid memory alloc request size 1765277700 Error Question

2012-02-24 Thread Garrett Murphy
Curious: was there some sort of hardware issue or anything like that preceding this issue? Version: PostgreSQL 8.4.6 on i386-apple-darwin, compiled by GCC i686-apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple Computer, Inc. build 5370), 32-bit There was an hardware crash. after that pg_dump

Re: [GENERAL] Joining one-to-one and one-to-many tables

2010-03-11 Thread Garrett Murphy
Jeff: I may not fully understand the situation or the data you're trying to retrieve, but if you're trying to get show me all trainers whose current status is Pending, I would go backwards to how you're doing it. If you're only concerned about those records with tr_date_name = Pending, then