hat I should go for timestamp without timezone instead,
witch is okay because all timezones are the same. However, what happens
with daylight saving calculations. Is it still take into account??
Many thaks for that great product!
Regards
--
Olivier PRENANT Tel:+33-5-61
> the same time zone then your application should probably not notice an
> effect.
>
>- Thomas
>
--
Olivier PRENANT Tel:+33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE
Hi every one.
I just moved (at last!) to 7.2.1. Works like a charm...
I'm suprised though by the number of WAL files.
I have 8 files where postgresql.conf says WAL_FILES=4.
What did I miss ? (I have no outstanding transaction)
FWIW, t's on UW711.
Regards,
--
Olivi
for your explanation.
On Mon, 27 May 2002, Bruce Momjian wrote:
> Date: Mon, 27 May 2002 17:17:58 -0400 (EDT)
> From: Bruce Momjian <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: pgsql-hackers list <[EMAIL PROTECTED]>
> Subject: Re: [HACKERS] WAL FILES
>
> Oli
Sorry to bother, but it seems my last to messages (one to the news and
one yesterday to the pghackers list) did'nt go through..
The problem related to difficulties with plperl and 7.3 on UW 711
Regards
--
Olivier PRENANT Tel:+33-5-61-50-97-00 (Work)
Quartier d
Hi,
I think I figured why I can't buil plperl on unixware 711/OpenUnix 800.
It seems Makefile.shlib has changed between 722 and 73 and -z text has
been added. However with this on, it fails to build libperl.so
Maybe I'm wrong, but could someone consider this patch.
Regards,
-
S] Bug in Makefile.shlib
>
> - Original Message -
> From: "Olivier PRENANT" <[EMAIL PROTECTED]>
> Sent: September 04, 2002 12:18 PM
>
> > I think I figured why I can't buil plperl on unixware 711/OpenUnix 800.
> >
> > It seems Makefile.shl
ROTECTED]>
> Subject: Re: [HACKERS] Bug in Makefile.shlib
>
> On Wed, 2002-09-04 at 12:28, Tom Lane wrote:
> > Olivier PRENANT <[EMAIL PROTECTED]> writes:
> > > I think I figured why I can't buil plperl on unixware 711/OpenUnix 800.
> >
> > > It see
-0500
> From: Larry Rosenman <[EMAIL PROTECTED]>
> To: Tom Lane <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED], pgsql-hackers list <[EMAIL PROTECTED]>
> Subject: Re: [HACKERS] Bug in Makefile.shlib
>
> On Wed, 2002-09-04 at 12:28, Tom Lane wrote:
> > Olivier P
Lane wrote:
> Date: Wed, 04 Sep 2002 17:14:13 -0400
> From: Tom Lane <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: Larry Rosenman <[EMAIL PROTECTED]>,
> pgsql-hackers list <[EMAIL PROTECTED]>
> Subject: Re: [HACKERS] Bug in Makefile.shlib
>
> Oliv
To: Tom Lane <[EMAIL PROTECTED]>, [EMAIL PROTECTED],
> Olivier PRENANT <[EMAIL PROTECTED]>
> Subject: Re: [HACKERS] PL/Perl?
>
> On Wed, 2002-09-04 at 19:41, Larry Rosenman wrote:
> > On Wed, 2002-09-04 at 17:54, Tom Lane wrote:
> > > Larry Rosenman &
On Mon, 21 Oct 2002, Tom Lane wrote:
> Date: Mon, 21 Oct 2002 12:52:10 -0400
> From: Tom Lane <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: pgsql-hackers list <[EMAIL PROTECTED]>
> Subject: Re: [HACKERS] Please help
>
> Olivier PRENANT <[EMAIL PROT
L PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] 7.3b3 ok on unixware 71[12] here
>
> On Wed, 2002-10-30 at 12:16, Olivier PRENANT wrote:
> > On 30 Oct 2002, Larry Rosenman wrote:
> >
> > > Date: 30 Oct 2002 12:14:01 -0600
> > > From: Larry Rosenm
Date: Mon, 21 Oct 2002 11:35:33 -0400
> From: Tom Lane <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: pgsql-hackers list <[EMAIL PROTECTED]>
> Subject: Re: [HACKERS] Please help
>
> Olivier PRENANT <[EMAIL PROTECTED]> writes:
> > It seems that conne
rom: Tom Lane <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: pgsql-hackers list <[EMAIL PROTECTED]>
> Subject: Re: [HACKERS] Please help
>
> Olivier PRENANT <[EMAIL PROTECTED]> writes:
> > Without modifying anything, postgresql (since today) has a strange
>
a clue of what to
do. It DID work on pg 723 though...
Regards,
--
Olivier PRENANT Tel:+33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Ema
On 30 Oct 2002, Larry Rosenman wrote:
> Date: 30 Oct 2002 12:14:01 -0600
> From: Larry Rosenman <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] 7.3b3 ok on unixware 71[12] here
>
> On Wed, 2002-10-30 at 12:08, Olivier PRE
;
> To: Billy G. Allie <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a
> patch.
>
> We already have success messages from Olivier Prenant for 7.3B4 on 8.0.0,
> and me for 7.1.3
PostgreSQL supported platform report and a
>
>
>
> --On Thursday, November 07, 2002 13:32:18 +0100 Olivier PRENANT
> <[EMAIL PROTECTED]> wrote:
>
> > That's true!
> >
> > But I had to export CFLAGS=-Xb to compile (this should be in port Makefile
&
compiler...
> >>
> Didn't for me :-(
>
> Wierd.
BTW, this is on 7.1.1 not (yet) on 8.0.0
I'll let you know hopefully today.
(How did you get 713 when it's due for december?) Can I have a copy?
>
>
> >
> > --
> > Olivier
]
> Subject: Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a
>
> Olivier PRENANT <[EMAIL PROTECTED]> writes:
> > Huh! I just tried to compile 7.3b5 without CFLAGS=-Xb, it still bugs the
> > compiler...
>
> It won't get better if you don't sh
ECTED]
> >> Cc: Larry Rosenman <[EMAIL PROTECTED]>, Billy G. Allie <[EMAIL PROTECTED]>,
> >> [EMAIL PROTECTED], [EMAIL PROTECTED]
> >> Subject: Re: [PORTS] [HACKERS] PostgreSQL supported platform report and
> >> a
> >>
> >> Olivi
IL PROTECTED]
> Cc: Larry Rosenman <[EMAIL PROTECTED]>, Billy G. Allie <[EMAIL PROTECTED]>,
> [EMAIL PROTECTED], [EMAIL PROTECTED]
> Subject: Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a
>
> Olivier PRENANT <[EMAIL PROTECTED]> writes:
> >
ut to double check it on 7.1.3.
>
> Olivier, is this the 7.1.1b FS Compiler?
>
> I wonder if a bug fix made it in...
>
> Wierd.
>
>
>
> --On Thursday, November 07, 2002 17:34:49 +0100 Olivier PRENANT
> <[EMAIL PROTECTED]> wrote:
>
> > I see the la
ebugging and optimization mutually exclusive; -O disabled
>
> It still passes here. I really wonder if they fixed something in the 4.1
> compiler. IIRC
> the 7.1.1b compiler is 4.0.
>
> Truly wierd.
>
> LER
>
>
> --On Thursday, November 07, 2002 17:40:24 +0100
Many thanks Larry,
Sorry I had omited the -Xb (no secret dance) in my report...
On Thu, 7 Nov 2002, Larry Rosenman wrote:
> Date: Thu, 07 Nov 2002 15:17:28 -0600
> From: Larry Rosenman <[EMAIL PROTECTED]>
> To: Peter Eisentraut <[EMAIL PROTECTED]>, Olivier PRENANT <[EMA
troot[pg_proc_proname_nsp_index]: fixing root page
ERROR: bt_fixroot: not valid old root page.
What could be causing that (I've tested on uw 711 with no problem)
Many thanks in advance
--
Olivier PRENANT Tel:+33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97
Dear Tom
On Thu, 26 Dec 2002, Tom Lane wrote:
> Date: Thu, 26 Dec 2002 13:44:51 -0500
> From: Tom Lane <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: pgsql-hackers list <[EMAIL PROTECTED]>
> Subject: Re: [HACKERS] Problems with 7.3.1
>
> Olivier P
wrote:
> Date: Thu, 26 Dec 2002 13:44:51 -0500
> From: Tom Lane <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: pgsql-hackers list <[EMAIL PROTECTED]>
> Subject: Re: [HACKERS] Problems with 7.3.1
>
> Olivier PRENANT <[EMAIL PROTECTED]> writes:
> > Compi
OTECTED]>
> To: [EMAIL PROTECTED]
> Cc: pgsql-hackers list <[EMAIL PROTECTED]>
> Subject: Re: [HACKERS] Problems with 7.3.1
>
> Olivier PRENANT <[EMAIL PROTECTED]> writes:
> > I tried postgresql 7.3 and 7.3.1 and they both fail regressin when
> > creating plpgs
, Tom Lane wrote:
> Date: Fri, 27 Dec 2002 11:34:01 -0500
> From: Tom Lane <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: pgsql-hackers list <[EMAIL PROTECTED]>
> Subject: Re: [HACKERS] Problems with 7.3.1
>
> Olivier PRENANT <[EMAIL PROTECTED]> writes:
&
u searched our list archives?
>
> http://archives.postgresql.org
>
--
Olivier PRENANT Tel:+33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE
n't event check for ant and so on.
So far, I've tried with sh, ksh and bash to no avail.
Just can't uindertsand. What am I doing wrong??
the paths are ok and I succeeded a few weeks ago ... What could cause?
TIA
--
Olivier PRENANT Tel:+33-5-61-50-97-00 (W
l could'nt generate correctly
CREATE FUNCTION when function has been created using the form
CREATE FUNCTION foo(x) RETURNS type AS '/foo.so','foo2' LANGUAGE C;
pg_dumps "forgets" the 'foo2' part: that being a pain in the a... when
reloading...
Regards
RETURNS text AS '/encrypt.so';
WHY on earth does
SELECT post_crypt('test'),sql_crypt('test','PY')
NOT GIVE the same result???
Please help,
This is most urgent (My customer can't use this function anymore); it
worked OK with 7.0.3!!
Regards,
this:
>
> int ulen = VARSIZE(user)-VARHDRSZ;
> char utmp[ulen+]; // This works in newer GCC, cool.
> memcpy(utmp,VARDATA(user), len);
> utmp[ulen]=0;
> crypted=crypt(utmp,salt);
>
> Strings are not gurenteed to be NULL teminated.
>
>
> Olivier PRENANT wrote:
Hi,
I've just noticed that (after a upgrade from 7.0.3 to 7.1) the following
did'nt work anymore:
create tabla a (n1 serial, n2 int);
grant all on a to nobody;
insert into a (n2) value (1);
n1.nextval: you don't have permission to set sequence n1
It worked on 7.0.3
Regard
Hi Tom,
Thanks for your quick reply. However, I knew (and did that). My post were
more ... philosophical:
Shoudn't postgres extend priviledges to the sequences generated by a
create table ???
Regards,
On Fri, 11 May 2001, Tom Lane wrote:
> Olivier PRENANT <[EMAIL PROTECTED]> wr
On Sat, 12 May 2001, Tom Lane wrote:
> Olivier PRENANT <[EMAIL PROTECTED]> writes:
> > Shoudn't postgres extend priviledges to the sequences generated by a
> > create table ???
>
> That's not clear. The sequence is an independent object. Had you
> ex
s me think it's a psql bug is that select * from pg_databases
show 1 template0 and 1 template1.
For what it's worth, it on unixware 711.
BTW, when is the release due for? I'm VERY impatient. This is the best
I've seen.
Regards,,
--
Olivier PRENANT Tel:+33
Sorry to folowup on my own post
Problem solved: real and test db don't run on the same machine.
On the test one, postgres had the same uid as pg_shadow.usesysid for the
user...
Sorry to have bothered you all.
Reagrds
On Wed, 10 Jan 2001, Olivier PRENANT wrote:
> Hi,
>
As I said previously.. I apologies, this was all my fault.
Please discard...
Oh my, When will we have an RC???
On Wed, 10 Jan 2001, Larry Rosenman wrote:
> * Olivier PRENANT <[EMAIL PROTECTED]> [010110 12:47]:
> > Hi,
> >
> > I just recompiled 7.1 beta from cu
seems quite easy with php; But how can I do it from psql??
> >
> > TIA
> >
> > --
> > Olivier PRENANT Tel:+33-5-61-50-97-00 (Work)
> > Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
> &
Hi,
Beeing very impressed by TOAST, I wonder how I can insert BLOB from a flat
file.
It seems quite easy with php; But how can I do it from psql??
TIA
--
Olivier PRENANT Tel:+33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
e you thinking of??
>
> Lack of large object support for new TOAST columns is going to be a big
> 7.1 complaint. I was thinking of using the same functions as our large
> object stuff, but remove the OID requirement.
>
>
--
Olivier PRENANT Tel:+33
ation error on
src/backend/libpq/crypt.c because of multiply defined symbol des_encrypt
Regards,
--
Olivier PRENANT Tel:+33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (G
On Tue, 27 Feb 2001, Larry Rosenman wrote:
> * Olivier PRENANT <[EMAIL PROTECTED]> [010227 13:30]:
> > Hi all,
> >
> > I've been trying to play with beta5 today on unixware 711. I have 2
> > problems:
> >
> > 1) enabling --with-tcl yields t
Sorry to follow-up on my own post; int8 test passes if open-ssl is not
used.
weird!!
Regards,
On Wed, 28 Feb 2001, Olivier PRENANT wrote:
> Hi,
>
> Testing beta5 on unixware7 gives an error on int8 test while beta4 (I've
> just retested it) works ok regressions.diff f
--+---
! 4567890123456789 | -4567890123456789
123 | 456
! (2 rows)
-- This should fail, because q2 isn't a name of an EXCEPT output column
SELECT q1 FROM int8_tbl EXCEPT SELECT q2 FROM int8_tbl ORDER BY q2 LIMIT 1;
--- 367,375
S
On Wed, 28 Feb 2001, Tom Lane wrote:
> Olivier PRENANT <[EMAIL PROTECTED]> writes:
> > Sorry to follow-up on my own post; int8 test passes if open-ssl is not
> > used.
>
> That's difficult to believe, because int8.c doesn't include anything
> that even k
ted in or if there is someplace I
> can submit these to, please let me know.
>
> Thanks,
> Matthew
>
>
> ---(end of broadcast)---
> TIP 4: Don't 'kill -9' the postmaster
>
--
Olivier PRENANT
m right to me that pg_dumpall
replace template1 but maybe I'm wrong on this one.
Thanks for your tim and help
--
Olivier PRENANT Tel:+33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE
Larry Rosenman wrote:
--On Tuesday, September 02, 2003 11:35:25 -0400 Bruce Momjian
<[EMAIL PROTECTED]> wrote:
Larry Rosenman wrote:
--On Tuesday, September 02, 2003 11:20:14 -0400 Bruce Momjian
<[EMAIL PROTECTED]> wrote:
> Peter Eisentraut wrote:
>> Lee Kindness writes:
>>
>> > You don't..
Olivier PRENANT wrote:
Larry Rosenman wrote:
I am inclined to think yes. It would prevent uglification of the code
by not having to special-case Unixware.
However, I was able to read the libc sources to confirm thread-safety.
Because you can not see the source, would you try a threaded
Hi,
Is there a problem? I haven't received anything today...
--
Olivier PRENANT Tel:+33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Ema
55 matches
Mail list logo