Re: [HACKERS] Internationalized error messages

2001-03-13 Thread Patrick Welche
On Fri, Mar 09, 2001 at 03:48:33PM -0500, Tom Lane wrote: Peter Eisentraut [EMAIL PROTECTED] writes: Well, SQL defines these. Do we want to make our own list? However, numeric codes also have the advantage that some hierarchy is possible. E.g., the "22" in "2200G" is actually the

[HACKERS] epoch

2001-03-06 Thread Patrick Welche
Trying example from: http://www.postgresql.org/devel-corner/docs/user/functions-datetime.html patrimoine=# SELECT EXTRACT(EPOCH FROM TIMESTAMP '2001-02-16 20:38:40'); ERROR: parser: parse error at or near "epoch" patrimoine=# select version(); version

Re: [ODBC] Re: [HACKERS] Release in 2 weeks ...

2001-03-02 Thread Patrick Welche
On Wed, Feb 28, 2001 at 08:53:31AM +0900, Hiroshi Inoue wrote: ... I think I've fixed this bug at least for MS-Access. You could get the latest win32 driver from ftp://ftp.greatbridge.org/pub/pgadmin/stable/psqlodbc.zip . Please try it. How can I just install that file? (ie., M$ Access -

Re: [HACKERS] beta3 Solaris 7 (SPARC) port report [ Was: Looking for . . . ]

2001-01-26 Thread Patrick Welche
On Thu, Jan 25, 2001 at 10:13:29PM -0500, Tom Lane wrote: Frank Joerdens [EMAIL PROTECTED] writes: I just did that and ran make check 4 times. 3 times went completely smoothly, once I had random fail. This is the same behaviour that I saw when running make installcheck (76 successful most

Re: AW: [HACKERS] like and optimization

2001-01-24 Thread Patrick Welche
On Mon, Jan 22, 2001 at 05:46:09PM -0500, Tom Lane wrote: ... Are there any BSD-license locale and/or timezone libraries that we might assimilate in this way? We could use an LGPL'd library if there is no other alternative, but I'd just as soon not open up the license issue. The "Citrus

Re: AW: [HACKERS] like and optimization

2001-01-24 Thread Patrick Welche
On Mon, Jan 22, 2001 at 03:09:03PM -0800, Nathan Myers wrote: ... Posix systems include a set of commands for dumping locales in a standard format, and building from them. Instead of shipping locales and code to operate on them, one might include a script to run these tools (where they

Re: [HACKERS] C++ interface build on FreeBSD 4.2 broken?

2001-01-23 Thread Patrick Welche
On Sat, Jan 20, 2001 at 08:06:51PM -0500, Tom Lane wrote: What I've done to solve the immediate C++ problem is to take the declaration of sys_nerr out of c.h entirely, and put it into the two C modules that actually need it. However, I'm still wondering whether we should not drop the

[HACKERS] Strange..

2001-01-23 Thread Patrick Welche
rfb=# insert into person (id,surname) values (2274,'Unknown!'); ERROR: Relation 'subject' does not exist Correct - where does subject come from?! rfb=# \d person Table "person" Attribute | Type | Modifier ---+---+-- id| bigint

[HACKERS] Strange.. solved

2001-01-23 Thread Patrick Welche
By comparing backups, I found CREATE CONSTRAINT TRIGGER "unnamed" AFTER INSERT OR UPDATE ON "person" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('unnamed', 'person', 'subject', 'UNSPECIFIED', 'subjectid', 'id'); Don't know where that came from, but

Re: [HACKERS] test/locale broken

2001-01-22 Thread Patrick Welche
On Fri, Jan 19, 2001 at 08:52:13PM +0100, Peter Eisentraut wrote: Patrick Welche writes: Just tried it for the first time: % cd src/test/locale % gmake all gmake: Circular test-pgsql-locale - all dependency dropped. cd: can't cd to pgsql-locale gmake: *** [test-pgsql-locale] Error

Re: [HACKERS] Re: Getting configure to notice link-time vs run-time failures

2001-01-19 Thread Patrick Welche
On Fri, Jan 19, 2001 at 12:46:53AM +0100, Peter Eisentraut wrote: Tom Lane writes: Gene and I looked into this, and the cause of the misbehavior is this: gcc on this installation is set to search /usr/local/lib (along with the usual system library directories). libz.so and

Re: [HACKERS] Possible performance improvement: buffer replacement policy

2001-01-19 Thread Patrick Welche
On Fri, Jan 19, 2001 at 12:03:58PM -0500, Bruce Momjian wrote: Tom, did we ever test this? I think we did and found that it was the same or worse, right? (Funnily enough, I just read that message:) To: Bruce Momjian [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject: Re: [HACKERS] Possible

[HACKERS] test/locale broken

2001-01-18 Thread Patrick Welche
Just tried it for the first time: % cd src/test/locale % gmake all gmake: Circular test-pgsql-locale - all dependency dropped. cd: can't cd to pgsql-locale gmake: *** [test-pgsql-locale] Error 2 I think the next stage is gmake test-koi8.. Cheers, Patrick

[HACKERS] charset.htm

2001-01-18 Thread Patrick Welche
From http://www.postgresql.org/devel-corner/docs/admin/charset.htm Once you have chosen a set of localization rules this way you must keep them fixed for any particular database cluster. That means that the locales that were active when you ran initdb must be kept the same when you

[HACKERS] global/pg_database ?

2001-01-06 Thread Patrick Welche
Posting again as even though I receive mail from hackers I am apparently not a member (registered correctly as [EMAIL PROTECTED] - from will say [EMAIL PROTECTED] - setting reply-to to [EMAIL PROTECTED] used to get around it..) psql: FATAL 1: cannot open

[HACKERS] initdb prob

2001-01-06 Thread Patrick Welche
Please ignore last 2 messages re psql: FATAL 1: cannot open /usr/local/pgsql/data/global/pg_database: No such file or directory - I had another old postmaster running... Cheers, Patrick

[HACKERS] initdb prob

2001-01-06 Thread Patrick Welche
psql: FATAL 1: cannot open /usr/local/pgsql/data/global/pg_database: No such file or directory and it's true.. % ls /usr/local/pgsql/data/global 1260126112621264126917127 17130 pg_control source from Jan 3 15:59 GMT configure

Re: [HACKERS] GNU readline and BSD license

2001-01-02 Thread Patrick Welche
On Sat, Dec 30, 2000 at 02:34:24AM +0100, Peter Eisentraut wrote: If libedit could be used as an alternative to readline depending on your operating system setup then there's nothing wrong with that. NetBSD already went the other way around and made libedit compatible with readline. I had

Re: [HACKERS] GNU readline and BSD license

2000-12-29 Thread Patrick Welche
On Sat, Dec 23, 2000 at 08:42:43AM -0800, Alfred Perlstein wrote: FreeBSD has a freely available library called 'libedit' that could be shipped with postgresql, it's under the BSD license. If you have access to a FreeBSD box see the editline(3) manpage, or go to:

Re: [HACKERS] failed runcheck

2000-10-25 Thread Patrick Welche
On Mon, Oct 23, 2000 at 10:26:39AM -0400, Tom Lane wrote: Could you dig into it a little further and try to determine where the NULL is coming from? All clear now! (I did do another cvs update in the meantime, but either way, I can't now repeat the previously repeatable core dump) Cheers,

Re: [HACKERS] failed runcheck

2000-10-23 Thread Patrick Welche
On Sat, Oct 21, 2000 at 01:48:39PM -0700, Vadim Mikheev wrote: Did you run make distclean? I've run regtests before committing changes. Just made sure - different computer - fresh cvs update/distclean/configure/make cd src/test/regress gmake clean gmake all gmake runcheck same coredump #1

[HACKERS] failed runcheck

2000-10-21 Thread Patrick Welche
First a core dump which can be relieved by: Index: catalog.c === RCS file: /home/projects/pgsql/cvsroot/pgsql/src/backend/catalog/catalog.c,v retrieving revision 1.34 diff -c -u -r1.34 catalog.c --- catalog.c 2000/10/16 14:52:02

<    1   2