I may have missed 1.4:
PostgreSQL 7.5devel on arm-unknown-netbsdelf1.6ZE, compiled by GCC gcc (GCC) 3.3.2-nb1
but all tests work there. I didn't manage to compile bison 1.875 under
NetBSD-1.6P/acorn32, as gcc 2.95.3 really didn't like it. Upgrading to
NetBSD-1.6ZE/acorn32 upgraded to gcc 3.3.2,
On Sun, Nov 09, 2003 at 09:51:31PM +0100, Peter Eisentraut wrote:
Patrick Welche writes:
PostgreSQL 7.5devel on arm-unknown-netbsdelf1.6ZE, compiled by GCC gcc (GCC)
3.3.2-nb1
Can you test 7.4?
Several days of compiling later..
All 93 tests passed.
with 7.4rc2 on NetBSD-1.6ZE
On Sat, Mar 13, 2004 at 10:36:23AM -0500, Fernando Nasser wrote:
Lamar Owen wrote:
Ok, riddle me this:
If I have PostgreSQL set to log to syslog facility LOCAL0, and a
local0.none on /var/log/messages and local0.* to /var/log/pgsql (assuming
only one postmaster, unfortunately) then you
I just cut and pasted someone's mac address:
patrimoine=# update ethernet set mac='00-00-39-AB-92-FO' where id=623;
UPDATE 1
patrimoine=# select mac from ethernet where id=623;
mac
---
00:00:39:ab:92:0f
(1 row)
Note the typo O instead of 0. I can see how that
On Thu, Nov 14, 2002 at 06:13:56PM +, Patrick Welche wrote:
On Wed, Nov 13, 2002 at 07:53:00PM +0100, Peter Eisentraut wrote:
Tom Lane writes:
We can't just wait around indefinitely for port reports that may or may
not ever appear. In any case, most of the 7.3 entries in the list
Believe it or not, I'm trying to compile today's cvs pgsql on a
Debian 2.2.19 system. Compilation dies while compiling pg_dump with
../../../src/interfaces/libpq/libpq.so: undefined reference to `atexit'
In the mail archives there is a mention of upgrading libc to
libc6-dev_2.2.5-3_i386.deb. As
On Wed, Nov 13, 2002 at 07:53:00PM +0100, Peter Eisentraut wrote:
Tom Lane writes:
We can't just wait around indefinitely for port reports that may or may
not ever appear. In any case, most of the 7.3 entries in the list
seem to be various flavors of *BSD; I think it's unlikely we broke
On Thu, Nov 14, 2002 at 08:55:22PM +, Patrick Welche wrote:
Believe it or not, I'm trying to compile today's cvs pgsql on a
Debian 2.2.19 system. Compilation dies while compiling pg_dump with
../../../src/interfaces/libpq/libpq.so: undefined reference to `atexit'
In the mail archives
On Thu, Nov 14, 2002 at 09:06:01AM -0500, Tom Lane wrote:
Magnus Naeslund(f) [EMAIL PROTECTED] writes:
OK OK, before anyone rubs my nose in it, i see the fork() failures :)
I'll see what's causing the fork() problems...
Too low processes-per-user limit, likely.
Success for
PostgreSQL
On Tue, Nov 19, 2002 at 10:53:59AM -0500, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
[remove this:]
-geometry/.*-netbsd=geometry-positive-zeros
as this acorn32 is running on a StrongARM processor, so has nothing to do
with libm387. Maybe get rid of the geometry-positive
On Wed, Nov 20, 2002 at 06:48:15PM +0100, Peter Eisentraut wrote:
Tom Lane writes:
AFAIK, all modern hardware claims compliance to the IEEE floating-point
arithmetic standard, so failure to print minus zero as minus zero is
very likely to be a software issue not hardware. That suggests
On Wed, Nov 20, 2002 at 01:21:47PM -0500, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
...
NetBSD 1.5 has revision 1.32, NetBSD 1.6 has revision 1.42
Ah-hah, so it is a version issue --- we could make the resultmap line
something like
geometry/.*-netbsd1.[0-5]=geometry
On Wed, Nov 20, 2002 at 01:51:28PM -0500, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
On Wed, Nov 20, 2002 at 01:21:47PM -0500, Tom Lane wrote:
Ah-hah, so it is a version issue --- we could make the resultmap line
something like
geometry/.*-netbsd1.[0-5]=geometry-positive
On Wed, Nov 20, 2002 at 09:33:41AM -0500, Bruce Momjian wrote:
Patrick Welche wrote:
On Tue, Nov 19, 2002 at 06:22:08PM +0100, Peter Eisentraut wrote:
He was testing 7.4devel. That's not the right one.
What's the difference? (Do I really want to wait another day while this
ancient
Just tried a make runcheck with source from Dec 4 15:13 GMT, and:
Core was generated by `postgres'.
Program terminated with signal 11, Segmentation fault.
#0 ExecGetTupType (node=0x8453978) at execProcnode.c:744
744 slot =
(gdb) print *((HashJoin *) node)-hashjoinstate
$4 = {jstate = {type = T_HashJoinState, cs_OuterTupleSlot = 0x0,
cs_ResultTupleSlot = 0x84527cc, cs_ExprContext = 0x8453e60,
cs_ProjInfo = 0x84546e0, cs_TupFromTlist = 0 '\000'}, hj_HashTable = 0x0,
hj_CurBucketNo = 0, hj_CurTuple = 0x0,
I must have had an old object file in the build tree... It's all happy
now.
Sorry for the noise,
Patrick
(geometry fails just because of the ordering of the rows in twenty)
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to
transatlantic=# select '23:59:59.72'::time(0) without time zone;
time
--
24:00:00
(1 row)
So dumping a table with times derived from the timestamp then fails on the
reload with:
psql:transatlantic.dat:43681: ERROR: copy: line 5818, Bad time external
representation '24:00:00'
I have a program which worked merrily under 1.3b1, but with 1.4devel
I get the first query working (so connection OK), and the second query,
which may well be wrong, getting me:
DEBUG: reaping dead processes
DEBUG: child process (pid 13025) was terminated by signal 11
LOG: server process (pid
Using cvs source of Dec 4 15:13:
test=# \d amount
Table public.amount
Column | Type | Modifiers
+-+
id | integer | not null default
On Tue, Feb 11, 2003 at 11:20:14AM -0500, Tom Lane wrote:
...
We could retarget to try to stay under SHMMAX=4M, which I think is
the next boundary that's significant in terms of real-world platforms
(isn't that the default SHMMAX on some BSDen?).
...
Assuming 1 page = 4k, and number of pages
On Thu, Feb 13, 2003 at 10:25:52AM -0500, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
The sad thing is that my readline wrapper for libedit doesn't wrap
replace_history_entry,
Well, is that a bug in your wrapper? Or must we add a configure test
for the presence
The sad thing is that my readline wrapper for libedit doesn't wrap
replace_history_entry, so I could use readline up until now, the tests
for readline succeed as the functions tested for exist, but
command.o: In function `do_edit':
/usr/src/local/pgsql/src/bin/psql/command.c:1652: undefined
On Sat, Feb 15, 2003 at 03:10:19PM -0600, Ross J. Reedstrom wrote:
On Fri, Feb 14, 2003 at 11:32:02AM -0500, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
On Thu, Feb 13, 2003 at 10:25:52AM -0500, Tom Lane wrote:
Well, is that a bug in your wrapper? Or must we add a configure
On Wed, Feb 19, 2003 at 07:31:35AM -0500, Dave Cramer wrote:
Bruce,
Can you chime in with your support here?
Dave
I have a large customer who is converting from informix to postgres and
they have made extensive use of
update table set (col...) = ( val...)
as a first pass would it
On Thu, May 02, 2002 at 01:14:34PM -0300, Marc G. Fournier wrote:
On 2 May 2002, Hannu Krosing wrote:
...
BTW, I think PostgreSQL does _not_ need any mission statement.
Nope, it doesn't ... never did before, don't know why it does suddenly ...
do any other open source projects have one?
On Thu, Aug 15, 2002 at 12:09:00AM -0400, Neil Conway wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
...
integrate or remove new libpqxx
integrate or add to gborg Pg:DBD
Seems like gborg is the place for these.
Yes, but I'd also like to see libpq++, perl5, and possibly some
On Thu, Mar 22, 2001 at 12:49:39PM -0500, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
These are parallel tests right? What's the failure diffs?
same as last time:
dragon:/home/centre/marc/src/postgresql-7.1RC1/src/test/regress more
results/opr_sanity.out
psql:
On Thu, Mar 22, 2001 at 10:27:44PM +0200, Marko Kreen wrote:
On Thu, Mar 22, 2001 at 07:58:04PM +, Patrick Welche wrote:
AFAIK geometry-positive-zeros works for all NetBSD platforms - the
above difference is only for i386 + fpu.
Seems that following patch is needed. Now It Works
On Fri, Mar 23, 2001 at 06:25:50AM +1100, Giles Lean wrote:
PS: AFAIK geometry-positive-zeros-bsd works for all NetBSD platforms - the
above difference is only for i386 + fpu.
It doesn't on NetBSD-1.5/alpha -- there geometry-positive-zeros is
correct.
Sorry, that should have read:
Did we decide that "most NetBSD/i386 users have fpus" in which case Marko's
patch should be applied?
Cheers,
Patrick
(just checked, it isn't in today's cvs)
On Thu, Mar 22, 2001 at 10:27:44PM +0200, Marko Kreen wrote:
On Thu, Mar 22, 2001 at 07:58:04PM +0000, Patrick Welche wrote
On Fri, Apr 13, 2001 at 01:25:45PM +, Thomas Lockhart wrote:
Did we decide that "most NetBSD/i386 users have fpus" in which case Marko's
patch should be applied?
I'm unclear on what y'all mean by "i386 + fpu", especially since NetBSD
seems to insist on calling every Intel processor a
On Mon, Apr 09, 2001 at 11:41:55AM -0700, Henry B. Hotz wrote:
At 1:50 AM -0400 4/6/01, Tom Lane wrote:
...
What version of libreadline do you have installed, and how does it
declare completion_matches()?
I have whatever is standard on NetBSD 1.5. I noticed that configure
found a
I just upgraded PostgreSQL from 21 March CVS (rc1?) to May 19 16:21 GMT CVS.
I found that all my cgi/fcg scripts which use libpq++ stopped working in
the vague sense of apache mentioning an internal server error. Relinking
them cured the problem (had to do this in haste = unfortunately no more
On Sat, May 12, 2001 at 08:00:42PM -0400, Tom Lane wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
* Translation: If we want to use gettext I can get started. I don't
think I'm interested in using any other interface.
I have no objection to the gettext API, but I was and still am
On Mon, May 14, 2001 at 09:36:56PM +0200, Peter Eisentraut wrote:
Patrick Welche writes:
I have no objection to the gettext API, but I was and still am concerned
about depending on GNU gettext's code, because of license conflicts.
There is a BSD-license gettext clone project
On Sat, May 19, 2001 at 08:03:50PM -0400, bpalmer wrote:
On OBSD from cvs source, clean checkout:
gcc -O2 -pipe -Wall -Wmissing-prototypes -Wmissing-declarations
-I../../../../src/include -DLIBDIR=\/usr/local/pgsql/lib\
-DDLSUFFIX=\.so\ -c -o dfmgr.o dfmgr.c
dfmgr.c: In function
On Thu, Jul 12, 2001 at 12:04:25PM +0900, Tatsuo Ishii wrote:
Has it ever been considered to (optionally) use the iconv interface for
character set conversion instead of rolling our own? It seems to be a lot
more flexible, has pluggable conversion modules (depending on the
On Thu, Jul 26, 2001 at 04:55:14PM +0700, Zudi Iswanto wrote:
I am developing application with c++
...
/tmp/ccy63XDd.o(.text+0x70): undefined reference to `PQsetdbLogin'
/tmp/ccy63XDd.o(.text+0x91): undefined reference to `PQstatus'
/tmp/ccy63XDd.o(.text+0xc4): undefined reference to
gcc -O2 -pipe -g -Wall -Wmissing-prototypes -Wmissing-declarations
-I../../../src/include -c -o hba.o hba.c
hba.c: In function `ident_unix':
hba.c:923: sizeof applied to an incomplete type
hba.c:960: dereferencing pointer to incomplete type
hba.c:965: dereferencing pointer to incomplete type
On Fri, Sep 07, 2001 at 10:14:27AM -0400, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
hba.c: In function `ident_unix':
hba.c:923: sizeof applied to an incomplete type
Now, the problem is sizeof(Cred), typedef struct cmsgcred Cred, and I don't
have a cmsgcred anywhere
On Fri, Sep 07, 2001 at 04:05:58PM -0400, Bruce Momjian wrote:
...
OK, I have modified the CVS CREDS code to work on FreeBSD and BSD/OS,
and hopefully NetBSD. I talked to Jason at Linuxworld and I think this
code should work. Please test the CVS version and let me know. OpenBSD
doesn't
On Wed, Sep 12, 2001 at 02:45:10PM +0200, Peter Eisentraut wrote:
Thomas Lockhart writes:
Keep in mind that he is a mathematician, and I'll guess that he won't
have much patience with folks who expect a result for a factorial of a
fractional number ;)
Real mathematicians will be
On Wed, Sep 19, 2001 at 10:14:44AM -0400, Marc G. Fournier wrote:
:pserver:[EMAIL PROTECTED]:/projects/cvsroot
While trying a cvs update, I get
? ChangeLogs/libecpg.so.3.1.1
? ChangeLogs/HTML
? ChangeLogs/GTAGS
? ChangeLogs/GPATH
? ChangeLogs/GRTAGS
? ChangeLogs/GSYMS
? ChangeLogs/libpqpp.h
On Fri, Sep 21, 2001 at 07:27:10PM +0200, HorĂ¡k Daniel wrote:
...
but still I am getting
cannot create_adm_p /tmp/cvs-serv24877/ChangeLogs
Permission denied
aol
Me Too!
/aol
---(end of broadcast)---
TIP 5: Have you checked our extensive
On Mon, Sep 24, 2001 at 10:22:28AM -0400, Marc G. Fournier wrote:
okay, somehow you have two different CVSROOT's configured?
/home/projects/pgsql/cvsroot was the old server, /projects/cvsroot is the
new one
Any hints? I had done a (csh)
cd /usr/src/local/pgsql
find . -name Root -print
On Mon, Sep 24, 2001 at 06:04:17PM +0100, Patrick Welche wrote:
...
and CVSROOT is not set as an environment variable... Also odd that it
appears there and there is no sign of home anywhere..
Got it: had /home/... in pgsql/src/backend/access/heap/CVS/Repository (!)
All OK now..
Cheers
On Sat, Sep 22, 2001 at 08:15:11PM -0500, Dominic J. Eidson wrote:
On Sat, 22 Sep 2001, Marc G. Fournier wrote:
anoncvs: :pserer:[EMAIL PROTECTED]:/projects/cvsroot
- passwd is blank, but postgresql should work just as well
I can confirm that this works.
Still no good for me:
On Mon, Jul 26, 2004 at 06:13:30PM +1000, Justin Clift wrote:
+ An SNMP agent to report on PostgreSQL's status and allows remote
control of the PostgreSQL daemon. From an Oracle perspective, this
would be the equivalent of Oracle Intelligent Agents, part of the core
features of the Oracle
On Tue, Nov 23, 2004 at 07:25:17AM -0500, D'Arcy J.M. Cain wrote:
The stderr was in the previous message. No gripes there either other
than in the startup after the failure.
Also see about getting a stack trace from one of the core dumps.
I did look at the core file and here is what I
I just ran pg_dumpall from today's CVS against a 14 April server - I got:
pg_dumpall: query failed: ERROR: type e does not exist
pg_dumpall: query was: SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS
spcowner, spclocation, spcacl FROM pg_catalog.pg_tablespace WHERE spcname NOT
LIKE
On Mon, Jul 18, 2005 at 03:01:31PM -0400, Tom Lane wrote:
Andrew - Supernews [EMAIL PROTECTED] writes:
WHERE spcname NOT LIKE E'pg\\_%');
It's not even correct as it stands - if you want to match a literal _
using LIKE then you would need E'pg_%' there.
Good point!
Would NOT
I think we still recommend using *new* pg_dump to dump *old* server when
upgrading. If one tries that with today's pg_dump (8.1beta1) against
a 8.1devel server of 6 May, i.e., predating roles, one gets:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: relation
On Thu, Sep 01, 2005 at 02:31:15PM -0400, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
I think we still recommend using *new* pg_dump to dump *old* server when
upgrading. If one tries that with today's pg_dump (8.1beta1) against
a 8.1devel server of 6 May, i.e., predating roles
On Thu, Sep 01, 2005 at 02:59:37PM -0400, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
I tried the fix mentioned in the earlier message to encourage
validation. Now dumping this fixed database, and loadinging it into the
new database gives:
ALTER FUNCTION
psql:./huge.db
Ilya Kovalenko posted some code at in a thread starting at
http://archives.postgresql.org/pgsql-hackers/2005-04/msg00417.php
which lead to the TODO item:
* Allow INET + INT4 to increment the host part of the address, or
throw an error on overflow
I think that the naively coded function
On Mon, Sep 05, 2005 at 01:52:45AM +0200, Petr Jelinek wrote:
Tom Lane wrote:
The hole in that argument is the assumption that there *is* a freely
available library that can be used (where freely == BSD license).
We wouldn't be having this discussion if we knew of one.
I see this
On Mon, Sep 05, 2005 at 03:02:55PM -0400, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
* Allow INET + INT4 to increment the host part of the address, or
throw an error on overflow
I think that the naively coded function attached does what is needed, e.g.,
What happened
On Mon, Sep 05, 2005 at 08:10:16PM +0100, Patrick Welche wrote:
On Mon, Sep 05, 2005 at 03:02:55PM -0400, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
* Allow INET + INT4 to increment the host part of the address, or
throw an error on overflow
I think that the naively
On Wed, Sep 07, 2005 at 02:48:00AM -, Andrew - Supernews wrote:
On 2005-09-06, Patrick Welche [EMAIL PROTECTED] wrote:
Now with:
test=# select '192.168.0.0/24'::inet + 1;
ERROR: Trying to increment a network (192.168.0.0/24) rather than a host
What possible justification
On Wed, Sep 07, 2005 at 09:45:17AM -0700, Josh Berkus wrote:
Nathan wrote:
Quite a list. I wonder what readline is doing there.
Readline is for PSQL command completion and history. As for the rest, they
are *optional* modules that apparently your RPM builder chose to include; I
On Fri, Sep 16, 2005 at 06:36:56AM -0400, Bruce Momjian wrote:
This has been saved for the 8.2 release:
It isn't actually a patch for application yet ;-) It is the function in
a state that is easy to test. I take it that as I have basically had
no comments back, I will just go ahead and make a
I am trying to write a C trigger. Essentially
TriggerData *in = (TriggerData *) fcinfo-context;
HeapTupleHeader tuple=in-tg_trigtuple-t_data;
Datum datum;
datum = GetAttributeByName(tuple, unit_id, isnull);
and that last line fails with
ERROR: cache lookup failed for type
I seem to have an unhappy postgresql:
(gdb) bt
#0 0xbd99871b in kill () from /usr/lib/libc.so.12
#1 0xbda217e7 in abort () from /usr/lib/libc.so.12
#2 0x0820c1fa in ExceptionalCondition (
conditionName=0x8298920 !(batchno hashtable-curbatch),
errorType=0x823919f FailedAssertion,
On Mon, Sep 19, 2005 at 06:12:54PM +0100, Patrick Welche wrote:
#15 0x081a4c2f in exec_simple_query (
query_string=0x834501c select timesliced, count(stats_id) from trans
left j
I just truncated one line early.. the query was:
# explain select timesliced, count(stats_id) from trans left
On Mon, Sep 19, 2005 at 03:59:35PM -0400, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
I seem to have an unhappy postgresql:
Let's see a test case, not a stack trace.
I haven't set up the minimalist test case yet, but the 2 tables involved
are incredibly simple. stats.id
On Mon, Jan 24, 2005 at 05:21:35PM -0400, Marc G. Fournier wrote:
On Sun, 23 Jan 2005, Benjamin Arai wrote:
What are the goals for 8.1?
Replace ARC ... anything else is a bonus ...
So the betting is that the patent will be granted..
Patrick
---(end of
On Mon, Feb 21, 2005 at 12:50:44PM +, [EMAIL PROTECTED] wrote:
host all all 127.0.0.1/0 trust
Should that not be 127.0.0.1/32 ? or even
host all all 127.0.0.1 255.255.255.255trust
?
Patrick
---(end of broadcast)---
TIP
On Mon, Apr 18, 2005 at 08:58:01PM -0400, Bruce Momjian wrote:
Would you modify this so it can go in /contrib or pgfoundry? Is there
general interest for this?
I was about to sit down and write the same function yesterday, when as if
by magic this appeared. In my case it is to loop over ip
On Mon, Mar 22, 2004 at 11:03:38PM -0500, Neil Conway wrote:
Christopher Kings-Lynne wrote:
This has not yet been fixed...
Attached is a patch for this issue. I've checked with Chris, and this
patch allows the regression tests to pass on his machine. I also
updated float8-exp-three-digits
On Thu, Apr 20, 2006 at 11:56:29AM -0400, Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us writes:
Don't we have some of these platforms on the build farm. Are they
failing?
canary, gazelle, and osprey all pass this test just fine. Before
accepting any
On Sat, Apr 29, 2006 at 10:24:48PM -0400, Bruce Momjian wrote:
FYI, 8.2 will have this and more based on this applied patch:
Add INET/CIDR operators: and, or, not, plus int8, minus int8, and inet
minus inet.
I know, I'm already using it :-)
Thanks,
Patrick
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
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
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, 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 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
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
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
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
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 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 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 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 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 -
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 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
On Fri, Mar 16, 2001 at 05:25:24PM -0500, Jan Wieck wrote:
Jan Wieck wrote:
...
Just to get some evidence at hand - could some owners of
different platforms compile and run the attached little C
source please?
...
Seems Tom is (unfortunately) right. The pipe blocks
On Thu, Jun 12, 2003 at 10:10:02PM -0400, Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
You have to love that swap + 1/2 ram option --- when you need four
possible options, there is something wrong with your approach. :-)
I'm still wondering what the
I'm getting far too many errors while trying to compile gram.c in the
backend/parser, that I must be missing something.. Story so far
gmake distclean
cvs update
configure --enable-debug --enable-cassert
gmake
gmake[3]: Entering directory `/usr/src/local/pgsql/src/backend/parser'
gcc -O2 -pipe -g
On Tue, Jul 15, 2003 at 11:21:51AM -0400, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
I'm getting far too many errors while trying to compile gram.c in the
backend/parser, that I must be missing something.
I think you need to force gram.c to be regenerated. Try removing
On Tue, Jul 15, 2003 at 12:42:45PM -0400, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
...
What string constant?! Will try again later...
Which flex version are you using? You need 2.5.4 --- the most recent
versions have broken backwards compatibility :-(. I'm not sure what
On Wed, Jul 16, 2003 at 11:58:01PM +0900, [EMAIL PROTECTED] wrote:
could you try lex/scan.l 1.13 i just committed?
Yes, that fixed it!
Cheers,
Patrick
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
1 - 100 of 122 matches
Mail list logo