[HACKERS] Encoding conversions in psql

2004-01-11 Thread Mathijs Brands
Howdy, Can anyone explain to me when psql tries to convert between encodings? It seems to disregard encodings set with SET CLIENT_ENCODING. The following reproduces the behaviour I'm seeing: 1. create an UNICODE database 2. run the following: set client_encoding to latin1; create tabl

Re: [HACKERS] MS interview

2001-08-16 Thread Mathijs Brands
On Wed, Aug 15, 2001 at 10:39:24AM +0200, John Anderson allegedly wrote: > AFAIK, OLAP backends essentially provide a cache of denormalised data > that provide fast access (no need to re-run complex queries) to large > data sets, and a set of aggregate functions to analyse the data. > > There's a

Re: [HACKERS] Solaris source code

2001-07-10 Thread Mathijs Brands
On Mon, Jul 09, 2001 at 02:03:16PM -0700, Nathan Myers allegedly wrote: > On Mon, Jul 09, 2001 at 02:24:17PM +0200, Mathijs Brands wrote: > > On Thu, Jul 05, 2001 at 02:03:31PM -0700, Naomi Walker allegedly wrote: > > > At 04:30 PM 7/5/01 -0400, Bruce Momjian wrote: > >

Re: [HACKERS] Solaris source code

2001-07-09 Thread Mathijs Brands
On Thu, Jul 05, 2001 at 02:03:31PM -0700, Naomi Walker allegedly wrote: > At 04:30 PM 7/5/01 -0400, Bruce Momjian wrote: > >I have purchased the Solaris source code from Sun for $80. (I could > >have downloaded it for free after faxing them an 11 page contract, but I > >decided I wanted the CD's.

Re: [HACKERS] Solaris source code

2001-07-09 Thread Mathijs Brands
On Thu, Jul 05, 2001 at 04:30:40PM -0400, Bruce Momjian allegedly wrote: > I have purchased the Solaris source code from Sun for $80. (I could > have downloaded it for free after faxing them an 11 page contract, but I > decided I wanted the CD's.) See the slashdot story at: > > http://sla

Re: [HACKERS] pg_dump, formats & blobs

2001-04-13 Thread Mathijs Brands
On Sat, Apr 14, 2001 at 11:44:18AM +1000, Philip Warner allegedly wrote: > At 01:14 14/04/01 +0200, Mathijs Brands wrote: > ... > >sol2:~$ pg_dump -b -Fc -f blaat.bk blaat > >sol2:~$ pg_restore -l blaat.bk > ... > >; > >; Archive created at Sat Apr 14 01:03:02 20

[HACKERS] pg_dump, formats & blobs

2001-04-13 Thread Mathijs Brands
Hi I've been experimenting with 7.1rc4 for a couple of hours. I was messing with blobs, and the new toast setup worked quite nicely. One thing I especially liked was the fact that by having pg_dump create a dumpfile in the custom or tar format, I could also backup all blobs in one go. Unfortunat

[HACKERS] Call for platforms (Solaris)

2001-04-06 Thread Mathijs Brands
Hi I've been running RC3 regression tests, starting with a FreeBSD 4.2-STABLE and a Solaris 7 Sparc box. Both tests ran without any problems. I tried Solaris 8 Sparc next: it still suffered from the same unix socket problems. I had a look at the code and it seems to me that the use of unix socket

Re: [HACKERS] Re: RC3 ...

2001-04-06 Thread Mathijs Brands
On Fri, Apr 06, 2001 at 09:23:35PM -0400, Bruce Momjian allegedly wrote: > > > Thomas, will you be doing .pdf files? I have had requests to put that > > > in the Debian documentation package. > > > > afaik, I don't have the means to generate pdf directly. Pointers would > > be appreciated, if the

Re: [HACKERS] Configure problems on Solaris 2.7, pgsql 7.02 and 7.03

2001-04-04 Thread Mathijs Brands
On Wed, Apr 04, 2001 at 06:46:12PM +0300, Martín Marqués allegedly wrote: > Why are you running configure inside src/? I'm not sure if the 7.0.x had the > configure on the src/ dir or the root. It's in the src dir with 7.0.x alright. > You could take a look at 7.1RC[2-3], which looks pretty sta

Re: [HACKERS] All's quiet ... RC3 packaging ...

2001-04-04 Thread Mathijs Brands
On Wed, Apr 04, 2001 at 10:56:27AM -0400, Tom Lane allegedly wrote: > The Hermit Hacker <[EMAIL PROTECTED]> writes: > > On Wed, 4 Apr 2001, Tom Lane wrote: > >> I think we've got to remove that failing horology test before we wrap RC3. > > > can we comment out the test for now, so that its still

Re: [HACKERS] Third call for platform testing (linux 2.4.x)

2001-03-30 Thread Mathijs Brands
On Sat, Mar 31, 2001 at 12:02:35PM +1200, Franck Martin allegedly wrote: > I still don't see an entry for Linux 2.4.x > > Cheers. This should fix that: == All 76 tests passed. == rm regress.o make[2]: Leaving directory `/usr/exp/tmp/postgresql-7.1RC1/sr

Re: [HACKERS] Third call for platform testing

2001-03-30 Thread Mathijs Brands
On Fri, Mar 30, 2001 at 03:17:06PM +, Thomas Lockhart allegedly wrote: > And here are the up-to-date platforms; thanks for the reports: > Solaris 2.7 Sparc 7.1 2001-03-22, Marc Fournier Marc, was this done without unix sockets? Mathijs -- It's not that perl programmers are idiots, it's

[HACKERS] Re: Re: [PORTS] pgmonitor and Solaris

2001-03-30 Thread Mathijs Brands
On Fri, Mar 30, 2001 at 11:07:25AM +0100, Pete Forman allegedly wrote: > I've done a quick survey of the Suns available to me to see whether > sendmail updates the ps display. The summary is: > >1) Require "/usr/ucb/ps w" at least. /usr/bin/ps has no options > that I can find to displ

Re: [HACKERS] Re: [PORTS] pgmonitor and Solaris

2001-03-28 Thread Mathijs Brands
On Wed, Mar 28, 2001 at 07:12:39PM -0500, Tom Lane allegedly wrote: > Mathijs Brands <[EMAIL PROTECTED]> writes: > > mathijs297 0.1 0.2 6120 3352 pts/1S 01:59:18 0:00 >/opt/pgsql/bin/./postgres mathijs localhost template1 idle > > The interesting point about t

Re: [HACKERS] Re: [PORTS] pgmonitor and Solaris

2001-03-28 Thread Mathijs Brands
On Wed, Mar 28, 2001 at 06:48:27PM -0500, Tom Lane allegedly wrote: > Mathijs Brands <[EMAIL PROTECTED]> writes: > > PS_USE_CLOBBER_ARGV -is- used on Solaris. I just checked. > > Hm. But 7.1 postgres backends fail to change their ps display? > Does sendmail change its ps

Re: [HACKERS] Re: [PORTS] pgmonitor and Solaris

2001-03-28 Thread Mathijs Brands
On Thu, Mar 29, 2001 at 12:30:06AM +0200, Mathijs Brands allegedly wrote: > On Wed, Mar 28, 2001 at 04:56:15PM -0500, Bruce Momjian allegedly wrote: > > [ Charset ISO-8859-1 unsupported, converting... ] > > > whats wrong with /usr/ucb/ps auxw | grep $PGUSER > > > >

Re: [HACKERS] Re: [PORTS] pgmonitor and Solaris

2001-03-28 Thread Mathijs Brands
On Wed, Mar 28, 2001 at 04:56:15PM -0500, Bruce Momjian allegedly wrote: > [ Charset ISO-8859-1 unsupported, converting... ] > > whats wrong with /usr/ucb/ps auxw | grep $PGUSER > > > > to get only the processes for PG? > > I can do that if there is no other option, but on my BSDI machine, > re

Re: [HACKERS] Spinlocks on SGI's

2001-03-27 Thread Mathijs Brands
On Tue, Mar 27, 2001 at 11:06:20AM -0400, The Hermit Hacker allegedly wrote: > On Tue, 27 Mar 2001, Robert E. Bruccoleri wrote: > > Dear Marc, > > > On Tue, 27 Mar 2001, Robert E. Bruccoleri wrote: > > > > > > > I contributed the first working s_lock.c code for the SGI's over three > > > > years a

Solaris 7 SPARC passes tests (was Re: [HACKERS] Re: [BUGS] Tests randomly failed)

2001-03-27 Thread Mathijs Brands
On Wed, Mar 28, 2001 at 02:40:00AM +0200, Mathijs Brands allegedly wrote: > On Tue, Mar 27, 2001 at 07:17:47PM +0200, Peter Eisentraut allegedly wrote: > > Tom Lane writes: > > > > > Alexander Klimov <[EMAIL PROTECTED]> writes: > > > > Yes, it was reall

Re: [HACKERS] Re: [BUGS] Tests randomly failed

2001-03-27 Thread Mathijs Brands
On Tue, Mar 27, 2001 at 07:17:47PM +0200, Peter Eisentraut allegedly wrote: > Tom Lane writes: > > > Alexander Klimov <[EMAIL PROTECTED]> writes: > > > Yes, it was really just incidence -- I try again, and 15 of 15 `make > > > check' passed with TCP sockets, but only 3 of 15 passed with UNIX > >

Solaris problems (was Re: [HACKERS] SPARC Solaris 8 OK)

2001-03-27 Thread Mathijs Brands
On Tue, Mar 27, 2001 at 10:34:13AM -0600, Brian P Millett allegedly wrote: > == > All 76 tests passed. > == > > vlad: uname -a > SunOS vlad 5.8 Generic_108528-06 sun4u sparc SUNW,Ultra-5_10 > > Reading specs from /opt/sfw/lib/gcc-lib/sparc-sun-solaris2.8/

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Mathijs Brands
On Tue, Mar 27, 2001 at 09:57:45AM -0500, Bruce Momjian allegedly wrote: > We just fixed that yesterday. Can you grab the most recent CVS and give > it a try? Even if you fix this it won't work (I tried it). Robert mailed why. Check the URL below for more information. It crashes on semctl :( ht

Re: [HACKERS] Spinlocks on SGI's

2001-03-27 Thread Mathijs Brands
On Tue, Mar 27, 2001 at 08:59:45AM -0500, Robert E. Bruccoleri allegedly wrote: > I contributed the first working s_lock.c code for the SGI's over three > years ago (using the test_and_set library calls). It's been working > for me ever since in a heavy multi-user environment. Please don't > chang

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Mathijs Brands
On Tue, Mar 27, 2001 at 06:36:37AM -0500, D'Arcy J.M. Cain allegedly wrote: > Thus spake Tom Ivar Helbekkmo > > > We need some NetBSD folks to speak up! > > I have successfully compiled it from CVS sources on my NetBSD -current but > I can't find the tar file for RC1 to try it with the package sy

Regression test on FBSD 3.3 & 4.2, IRIX 6.5 (was Re: [HACKERS] Re: Call for platforms)

2001-03-26 Thread Mathijs Brands
On Mon, Mar 26, 2001 at 07:09:38PM -0500, Tom Lane allegedly wrote: > Thomas Lockhart <[EMAIL PROTECTED]> writes: > > That is not already available from the Irix support code? > > What we have for IRIX is > > #if defined(__sgi) > /* > * SGI IRIX 5 > * slock_t is defined as a unsigned long. We

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Mathijs Brands
On Tue, Mar 27, 2001 at 12:01:24PM +1000, Justin Clift allegedly wrote: > I know that Sourceforge has been adding all sorts of machines to their > compile farm. > > Maybe it would be worthwhile taking a look if they have platforms we > don't? > > Regards and best wishes, > > Justin Clift Compa

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Mathijs Brands
On Mon, Mar 26, 2001 at 06:35:59PM -0500, Tom Lane allegedly wrote: > Thomas Lockhart <[EMAIL PROTECTED]> writes: > >> Anyway, the last CVS update to port/ultrix.h that appears to have come > >> from someone actually using Ultrix was rev 1.2 on 7-May-97, which > >> predates the very existence of s

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Mathijs Brands
On Mon, Mar 26, 2001 at 05:41:31PM -0500, Vince Vielhaber allegedly wrote: > On Tue, 27 Mar 2001, Mathijs Brands wrote: > > Hi > > > > Is there a list somewhere listing the platforms 7.1 is being > > tested on right now? I'd be able to run regression tests on

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Mathijs Brands
Hi Is there a list somewhere listing the platforms 7.1 is being tested on right now? I'd be able to run regression tests on the following platforms, if necessary: FreeBSD 3.3 (x86) FreeBSD 4.2 (x86) Linux (x86 - 2.2 & 2.4 kernels, Redhat & Debian distro's) Solaris 7 (SPARC) Solaris 8 (

Re: [SQL] Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB?

2001-03-12 Thread Mathijs Brands
On Sun, Mar 04, 2001 at 10:01:37AM +0800, xuyifeng allegedly wrote: > - Original Message - > From: The Hermit Hacker <[EMAIL PROTECTED]> > To: Jaruwan Laongmal <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Friday, March 02, 2001 8:04 PM > Subject: Re: [HACKERS

Re: [HACKERS] Re: [SQL] PostgreSQL crashes on me :(

2000-12-19 Thread Mathijs Brands
Hello all, I would like to thank Tom, Ian and the other pgsql wizards for their prompt response. This must surely be open source at it's best :) I've worked around the situation by running a small script that continually monitors postgres and takes appropriate action if postgres shuts down. I'm