Re: [HACKERS] Feature Request

2006-02-20 Thread Adam Witney
On 20/2/06 1:26 pm, Peter Eisentraut [EMAIL PROTECTED] wrote: Am Montag, 20. Februar 2006 14:15 schrieb Q Beukes: Hey, This might not be much, but can there maybe be a future feature for having a shortcut to set search_path='schema-name'; similiar to \c dbname ?? pei=# \set X 'set

Re: [HACKERS] Feature Request

2006-02-20 Thread Adam Witney
ALTER USER bob SET search_path ...? Sorry I didn't mean the search_path example, but I was thinking I could setup a short cut for a common query, eg: \set logins SQL query :logins Could save this such that the short cut is available every time I open psql? Thanks Adam -- This message

[HACKERS] 8.1RC1 fails opr_sanity on osx

2005-10-31 Thread Adam Witney
Just the one fail on OSX 10.3.9 opr_sanity ... FAILED Is this a known problem, or something specific to my machine... I can post regression.diffs (quite long) if required ... Thanks Adam -- This message has been scanned for viruses and dangerous content by MailScanner, and

Re: [HACKERS] 8.1RC1 fails opr_sanity on osx

2005-10-31 Thread Adam Witney
On 31/10/05 1:32 pm, Bruce Momjian pgman@candle.pha.pa.us wrote: Adam Witney wrote: Just the one fail on OSX 10.3.9 opr_sanity ... FAILED Is this a known problem, or something specific to my machine... I can post regression.diffs (quite long) if required ... Uh

Re: [HACKERS] 8.1RC1 fails opr_sanity on osx

2005-10-31 Thread Adam Witney
On 31/10/05 2:13 pm, Bruce Momjian pgman@candle.pha.pa.us wrote: Adam Witney wrote: On 31/10/05 1:32 pm, Bruce Momjian pgman@candle.pha.pa.us wrote: Adam Witney wrote: Just the one fail on OSX 10.3.9 opr_sanity ... FAILED Is this a known problem, or something specific

Re: [HACKERS] problem installing 8.0.0beta5 on OS X 10.3

2004-11-25 Thread Adam Witney
You shouldn't need to edit configure. I compiled 8.0b5 on 10.3.6 with no problems yesterday I am no expert, but this error seems to have come up on other platforms... Here was the response in the mailing lists before http://archives.postgresql.org/pgsql-ports/2004-07/msg1.php You may also

Re: [HACKERS] Adding a suffix array index

2004-11-19 Thread Adam Witney
Hi Troels, This is not related to the database aspects of your question... But there are more than 4 possible letters in DNA sequences, 16 in fact. Depending on the accuracy of the DNA sequences you are storing, you may come across ambiguity DNA bases, so your type will have to take these into

[HACKERS] 8.0.0beta1 initdb failure on OSX 10.3.5

2004-08-10 Thread Adam Witney
Hi, just built and tried the regressions tests, but it fails here: == initializing database system == ./pg_regress: line 470: 10212 Trace/BPT trap $bindir/initdb -D $PGDATA -L $datadir --noclean $initdb_options $LOGDIR/initdb.log 21 pg_regress: initdb

[HACKERS] One regression failure with 7.4.1 on Debian 3.0r2

2003-12-23 Thread Adam Witney
I have one regression failure on 7.4.1, which does not occur with 7.4 [EMAIL PROTECTED] more src/test/regress/regression.diffs *** ./expected/random.out Thu Feb 13 05:24:04 2003 --- ./results/random.outTue Dec 23 20:19:40 2003 *** *** 25,31 GROUP BY random

[HACKERS] 7.4 make failure on OSX

2003-11-17 Thread Adam Witney
Hi, I suspect this a problem local to my machine, but I cannot compile with the --with-java option... It fails like so driver: [copy] Copying 1 file to /usr/local/install/postgresql-7.4/src/interfaces/jdbc/org/postgresql [echo] Configured build for the JDBC3 edition driver with SSL

Re: [HACKERS] 7.4 make failure on OSX ... Please ignore

2003-11-17 Thread Adam Witney
Sorry, I did find the offending driver in the end... And it is running happily now. Sorry for the noise Adam Hi, I suspect this a problem local to my machine, but I cannot compile with the --with-java option... It fails like so driver: [copy] Copying 1 file to

[HACKERS] JDBC with 7.4RC2

2003-11-14 Thread Adam Witney
Should the jdbc driver compile ok with 7.4RC2? I configure like so ./configure --with-perl --with-java --with-libs=/sw/lib --with-includes=/sw/include But it fails with this compile: BUILD FAILED file:/usr/local/install/postgresql-7.4RC2/src/interfaces/jdbc/build.xml:114: Old driver was

Re: [HACKERS] Call for port reports

2003-10-24 Thread Adam Witney
On 24/10/03 4:37 pm, Bruce Momjian [EMAIL PROTECTED] wrote: It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. The current list is at: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html All

Re: [HACKERS] Beta4 Tag'd and Bundled ...

2003-10-07 Thread Adam Witney
Hi, Many of the regression tests are failing on my OSX 10.2.6 machine. I have put the regression.diffs file here http://bugs.sghms.ac.uk/downloads/regression.diffs Has this been seen before? Thanks adam Check her over and let me know if there are any problems ... will do a full general

Re: max_connections/shared_buffers (was Re: [HACKERS] Beta4 Tag'd and

2003-10-06 Thread Adam Witney
On 4/10/03 8:10 pm, Tom Lane [EMAIL PROTECTED] wrote: I said: Hm. The parallel regression tests require at least 20. I deliberately allowed initdb to select values as small as 10 on the theory that installing and not being able to run the parallel regression tests is better than not

Re: [HACKERS] Beta4 Tag'd and Bundled ...

2003-10-04 Thread Adam Witney
Hi, Many of the regression tests are failing on my OSX 10.2.6 machine. I have put the regression.diffs file here http://bugs.sghms.ac.uk/downloads/regression.diffs Has this been seen before? Thanks adam Check her over and let me know if there are any problems ... will do a full general

Re: [HACKERS] Beta4 Tag'd and Bundled ...

2003-10-04 Thread Adam Witney
On 4/10/03 5:16 pm, Tom Lane [EMAIL PROTECTED] wrote: Adam Witney [EMAIL PROTECTED] writes: Many of the regression tests are failing on my OSX 10.2.6 machine. I have put the regression.diffs file here http://bugs.sghms.ac.uk/downloads/regression.diffs Seems to be all ! psql: FATAL

Re: [HACKERS] contrib Makefile's and OS X

2003-02-21 Thread Adam Witney
PL/R compiles and installs ok on my OS X 10.2.4, the corresponding line is gcc -traditional-cpp -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -flat_namespace -bundle -undefined suppress plr.o pg_conversion.o pg_backend_support.o pg_userfuncs.o pg_rsupport.o -L/sw/lib -L/sw/lib/R/bin

Re: [HACKERS] 7.3b3 on MacOSX 10.2.1

2002-10-30 Thread Adam Witney
On 29/10/02 6:02 pm, Tom Lane [EMAIL PROTECTED] wrote: Adam Witney [EMAIL PROTECTED] writes: Just to update the list of supported platforms, 7.3b3 compiles and passes all the regression tests on MacOSX 10.2.1 Although don't know if this is relevant but this appears when running the tests

Re: [HACKERS] Request for supported platforms

2002-10-30 Thread Adam Witney
On 29/10/02 1:50 pm, Tom Lane [EMAIL PROTECTED] wrote: Bruce Momjian [EMAIL PROTECTED] writes: Strange. I just got report from another OSX 10.2.1 user saying regression tests passed: 10.2.1, Adam Witney ([EMAIL PROTECTED] The proper value seems to be: 15.3864610140472

[HACKERS] 7.3b3 on MacOSX 10.2.1

2002-10-28 Thread Adam Witney
Just to update the list of supported platforms, 7.3b3 compiles and passes all the regression tests on MacOSX 10.2.1 Although don't know if this is relevant but this appears when running the tests: parallel group (20 tests): ./pg_regress: fork: Resource temporarily unavailable ./pg_regress: