[GENERAL] Snow Leopard bison/flex build problem

2009-09-07 Thread Robert Creager
Upgraded to Snow Leopard Saturday, and am having problems building now. The build logs are here http://buildfarm.postgresql.org/cgi-bin/show_status.pl?member=polecat And the failing part is here: make -C preproc all make -C ../../../../src/port all make[5]: Nothing to be done for `all'. "/usr/b

[GENERAL] PostgreSQL and ClearQuest?

2005-08-09 Thread Robert Creager
Anyone done it? Is it possible? Currently running the free SQLAnywhere version included with CQ. I suspect my hopes will be extinguished shortly :-( Cheers, Rob -- 08:11:07 up 26 days, 11:46, 5 users, load average: 2.52, 2.19, 2.20 Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004 pgpT

Re: [GENERAL] question about "delete performance"

2005-01-23 Thread Robert Creager
When grilled further on (Mon, 24 Jan 2005 12:29:12 +0800), Öܵ½¾© <[EMAIL PROTECTED]> confessed: > I have a table with 500,000 records which has some invalid records, I had > wrote a program to check it, by the program I get all OIDs of the redundant > records, so I use "delete from tableXXX wher

Re: [GENERAL] Dazed and Confused

2004-02-16 Thread Robert Creager
When grilled further on (Mon, 16 Feb 2004 07:39:25 -0500), Terry Lee Tucker <[EMAIL PROTECTED]> confessed: > as in, \i cust/cust_preupd_func.plsql, I get an error. The error is: > psql:logs/logs_preupd_func.plsql:132: ERROR: ProcedureCreate: cannot change > return type of existing function. >

Re: [GENERAL] Cron-job for checking up on pg_autovacuum

2003-11-29 Thread Robert Creager
When grilled further on (Tue, 25 Nov 2003 11:19:32 -0500), "Matthew T. O'Connor" <[EMAIL PROTECTED]> confessed: > I know I heard from at least one person who said they were running it > from there inittab with respawn, which seems like overkill. Nah, it works great (it was me). I just had an un

Re: [GENERAL] 7.4b4 domain usage and select question

2003-10-18 Thread Robert Creager
When grilled further on (Sat, 18 Oct 2003 15:46:55 -0400), Tom Lane <[EMAIL PROTECTED]> confessed: > Robert Creager <[EMAIL PROTECTED]> writes: > > But, I cannot turn of logging of the duration! It's set to > > log_min_duration_statement = 0, > > -1 turn

Re: [GENERAL] 7.4b4 domain usage and select question

2003-10-18 Thread Robert Creager
When grilled further on (Sat, 18 Oct 2003 13:12:41 -0400), Tom Lane <[EMAIL PROTECTED]> confessed: > Robert Creager <[EMAIL PROTECTED]> writes: > > select * from test_table where field_1 = '1'; -- fails > > The last select fails with 'operator is not uniq

[GENERAL] 7.4b4 domain usage and select question

2003-10-18 Thread Robert Creager
I'm using 7.4b4 with domains, and am having a problem with selecting without casting. create domain test_domain as integer check( (value notnull) and (value >= 1) ); create table test_table( field_1 test_domain, field_2 integer ); insert into test_table values( 1, 1 ); insert into test_table valu

Re: [GENERAL] Divide by zero...

2003-09-30 Thread Robert Creager
When grilled further on (Tue, 30 Sep 2003 09:26:19 -0400), Mike Leahy <[EMAIL PROTECTED]> confessed: > I have a query that calculates various using variables from a survey > database. As with any survey, there are many instantces of null values. I'm > wondering if there is any way to escape th

Re: [GENERAL] State of Beta 2

2003-09-16 Thread Robert Creager
Once upon a time (Tue, 16 Sep 2003 12:59:37 -0700) "Joshua D. Drake" <[EMAIL PROTECTED]> uttered something amazingly similar to: > If someone is willing to pony up 2000.00 per month for a period of at > least 6 months, I will dedicated one of my programmers to the task. So > if you want it bad e

Re: [GENERAL] How to prevent vacuum and reindex from deadlocking.

2003-08-14 Thread Robert Creager
On Mon, 11 Aug 2003 10:11:37 -0400 Tom Lane <[EMAIL PROTECTED]> said something like: > Robert Creager <[EMAIL PROTECTED]> writes: > > Opps, if it helps, the log of the deadlock: > > > Aug 10 14:19:36 thunder postgres[18735]: [2-1] ERROR: deadlock detected > >

Re: [GENERAL] How to prevent vacuum and reindex from deadlocking.

2003-08-14 Thread Robert Creager
On Sun, 10 Aug 2003 14:50:10 -0600 Robert Creager <[EMAIL PROTECTED]> said something like: > > I'm running 7.4Beta1 with pg_autovacuum. In one of my operations > which is executed frequently, a REINDEX is done after a COPY. Well, > VACUUM's are being executed by

[GENERAL] 7.4Beta1 "failed to create socket: Address family not supported byprotocol"

2003-08-14 Thread Robert Creager
I'm receiving the following error during startup: Aug 10 14:11:27 thunder postgres[18613]: [1-1] LOG: failed to create socket: Address family not supported by protocol Aug 10 14:11:27 thunder postgres[18619]: [2-1] LOG: database system was shut down at 2003-08-10 14:11:11 MDT Aug 10 14:11:27