Given the following trivial trigger example:
-- create language plpgsql;
create table foo (a integer, b text, c timestamp);
create function foo_insert() returns trigger as $$
begin
raise notice '%', new;
return null;
end;
$$ language plpgsql;
create trigger foo_ins
On Sat, Feb 09, 2008 at 12:29:10PM -0500, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
I am surprised to see
NOTICE: (1,two,Sat 09 Feb 16:47:44.514503 2008)
This is the expected formatting for a composite type. Read
http://www.postgresql.org/docs/8.3/static/rowtypes.html
I know that it doesn't matter as configure is in CVS, so there is no
need for mere mortals to regenerate it, but why is
RCS file: /projects/cvsroot/pgsql/configure.in,v
revision 1.538
date: 2007/11/26 12:31:07; author: petere; state: Exp; lines: +2 -2
Require a specific Autoconf
With today's CVS code (originally noticed with 8.2beta3), on a PC where
INT_MAX=0x7FFF=2147483647
postgres=# select version();
version
Is this a bug, or don't I understand coalesce()?
create table test (a int, b int);
insert into test values (1,null);
insert into test values (2,1);
insert into test values (2,2);
select * from test; -- returns:
select sum(b) from test where a=1; -- null
On Tue, Dec 12, 2006 at 03:33:04PM +, Heikki Linnakangas wrote:
BTW: This type of questions really belong to pgsql-general or
pgsql-novice, this list is for discussing development of PostgreSQL itself.
^^
Indeed - I am truly feeling like a novice now...
Cheers,
Patrick
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
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 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
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
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
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
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 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
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 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
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 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 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, 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, 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, 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 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
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 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
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
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 Mon, Oct 27, 2003 at 11:32:45PM -0500, Tom Lane wrote:
Have gcc use -g, add --disable-debug, rename?
Personally I don't like the idea of this behavior defaulting differently
depending on which compiler you use. I can see the practical arguments
for doing so, but it still rubs me the
On Fri, Oct 03, 2003 at 03:00:36PM +0100, Patrick Welche wrote:
On Fri, Oct 03, 2003 at 12:59:19PM +0200, Michael Meskes wrote:
On Mon, Sep 29, 2003 at 06:41:48PM +0100, Patrick Welche wrote:
Today's cvs doesn't compile. I think it is due to
cvs diff -r1.7 -r1.8 src/interfaces/ecpg
On Fri, Oct 03, 2003 at 12:59:19PM +0200, Michael Meskes wrote:
On Mon, Sep 29, 2003 at 06:41:48PM +0100, Patrick Welche wrote:
Today's cvs doesn't compile. I think it is due to
cvs diff -r1.7 -r1.8 src/interfaces/ecpg/include/datetime.h
I have dtime_t defined in my sys/types.h. The old
On Mon, Sep 29, 2003 at 11:50:23PM +0200, Peter Eisentraut wrote:
Tom Lane writes:
At the very least we need to set a strings freeze soon, so the
translators can catch up. Peter, are you getting close to done with the
message revisions you've been making?
Yes, I think we're ready for
On Mon, Sep 29, 2003 at 08:08:01PM +0200, Michael Meskes wrote:
On Mon, Sep 29, 2003 at 06:41:48PM +0100, Patrick Welche wrote:
Today's cvs doesn't compile. I think it is due to
Forgot one question. WHich platform do you use?
NetBSD - to quote cvs blame:
1.42 (eeh 30-Dec-99): typedef
Today's cvs doesn't compile. I think it is due to
cvs diff -r1.7 -r1.8 src/interfaces/ecpg/include/datetime.h
I have dtime_t defined in my sys/types.h. The old version of datetime.h used
#define dtime_t timestamp, the new one uses a typedef. Is there actually
a reason to keep dtime_t, or would
On Fri, Sep 26, 2003 at 02:49:30PM -0300, Marc G. Fournier wrote:
...
if we are talking two computers sitting next to each other on a switch,
you'd expect those to be low ... but if you were talking about two
seperate geographical locations (and yes, I realize you are adding lag to
the mix
On Mon, Sep 22, 2003 at 02:21:43PM -0400, Alvaro Herrera wrote:
On Mon, Sep 22, 2003 at 05:03:28PM +0100, Patrick Welche wrote:
On Mon, Sep 22, 2003 at 11:33:30AM -0400, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
I hope I guessed the right syntax...
% pg_filedump -R
There was a thread on missing pg_clog files caused due to dodgy practices in
glibc *last year*. I am seeing something similar *now* with a server
PostgreSQL 7.4beta1 on i386-unknown-netbsdelf1.6X, compiled by GCC 2.95.3
accessed by a similar client and a client
PostgreSQL 7.4devel on
On Mon, Sep 22, 2003 at 10:50:22AM -0400, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
select * from olddata02_03vac offset 2573719 limit 1;
ERROR: could not access status of transaction 1664158221
DETAIL: open of file /usr/local/pgsql/data/pg_clog/0633 failed: No such file
On Mon, Sep 22, 2003 at 11:33:30AM -0400, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
I hope I guessed the right syntax...
% pg_filedump -R 71716 data/base/17148/283342
Yes, but this doesn't give all the available info. Add -i and -f
options. A plain -d dump might
On Mon, Sep 15, 2003 at 08:09:22PM +0200, Peter Eisentraut wrote:
Neil Conway writes:
On Thu, 2003-09-04 at 13:14, Kurt Roeckx wrote:
tablecmds.c: In function `validateForeignKeyConstraint':
tablecmds.c:3546: warning: dereferencing type-punned pointer will break
strict-aliasing
On Wed, Jul 30, 2003 at 12:38:54AM -0400, Bruce Momjian wrote:
[ CC to Kurt and Steven on bsdi list.]
Guys, I just replied to this email on the BSDi email list. The issue is
that someone found that some(most?) IDE drives have write cache enabled,
though the drives do not preserve the
On Wed, Jul 23, 2003 at 12:53:34PM -0400, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
On a different note, I also wonder about:
M src/backend/parser/gram.c
It seems that you checkout the source with no gram.c. Build it, thus creating
gram.c. Next time you cvs update
cvs server: Updating src/bin/scripts/po
cvs server: failed to create lock directory for
`/projects/cvsroot/pgsql-server/src/bin/scripts/po'
(/projects/cvsroot/pgsql-server/src/bin/scripts/po/#cvs.lock): Permission denied
cvs server: failed to obtain dir lock in repository
On Wed, Jul 23, 2003 at 11:34:04AM -0300, The Hermit Hacker wrote:
try it now ... I think its a pathing problem with a cron entry ... just
fixed that, so should be okay now ...
...
cvs [server aborted]: read lock failed - giving up
Yup - that's all fine thanks!
On a different note, I
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
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 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
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 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 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 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
Using cvs source of Dec 4 15:13:
test=# \d amount
Table public.amount
Column | Type | Modifiers
+-+
id | integer | not null default
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
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'
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
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 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 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
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, 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, 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 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 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 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 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 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 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
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 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
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
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 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 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 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
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
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 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:
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
1 - 100 of 122 matches
Mail list logo
