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
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
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 -
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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:
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,
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
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
101 - 122 of 122 matches
Mail list logo