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
>
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 bef
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 version
With today's CVS code (originally noticed with 8.2beta3), on a PC where
INT_MAX=0x7FFF=2147483647
postgres=# select version();
version
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
---
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
sel
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 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 patches in
On Thu, Apr 06, 2006 at 06:31:01AM -0500, Jim C. Nasby wrote:
> On Wed, Apr 05, 2006 at 11:55:15PM -0300, Marc G. Fournier wrote:
> > On Wed, 5 Apr 2006, Jim Nasby wrote:
> >
> > >One idea that comes to mind is to come up with a list of popular OSS
> > >projects that we'd like to see add PostgreS
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-
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
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_
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",
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 t
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
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 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.
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 err
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 w
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 thi
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 atta
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
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
> >
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 "pg_catalog.p
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!
>
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 E'
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 1
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 broadca
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 wha
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 O
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) t
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.
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, s
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 th
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
> > >
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
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 r
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
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 just
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:
> > > &g
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
&
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/pgs
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 i686-pc-l
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
> > > >
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,
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
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
`/projects/cvsroot/pgsq
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
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 compatib
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 forc
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 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 wonder
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 pa
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
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 conf
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 refere
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 nextval('p
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 1
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'
psql
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
(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,
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 =
hashjoinstate->jstate.cs_ResultTuple
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 re
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 re
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 l
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
>
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 sug
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 box compiles it given that the chances of it working under
7.4devel and not under 7.3rcN are small
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 li
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
P
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 `at
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 f
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 a
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
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 tha
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 po
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 on
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
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 -pri
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
Me Too!
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
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 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
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 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 Cr
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
gm
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 `PQe
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
> > impleme
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
in
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 functi
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.
> > >
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 sti
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 proces
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 +,
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 rea
1 - 100 of 128 matches
Mail list logo
