Looks like a locale problem to me, Mario...
That comma is a non-USA (or oz, uk, canada) decimal separator...
Chris
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Mario Weilguni
> Sent: Monday, 2 September 2002 2:55 PM
> To: Hackers
> Subject: [HA
Hi,
I've tried to evaluate the compatibility of the current CVS version to our current
7.2.1 version, and noticed that 7.2.x dumps are not compatible with 7.3, not even in
cleartext format.
Timestamps in 7.2.x are this format: 2002-07-04 15:19:11.363562+02
7.3 expects a timestamp per default i
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> Whatver happened to Rod's work on the BETWEEN command?
It got applied, some people reported failures, it was hastily backed
out, and no one seems to have followed up on it.
At this point I'd say it's not happening for 7.3 ...
Thanks. Done.
---
Christopher Kings-Lynne wrote:
> You can probably nail some TODOs:
>
> * Add OR REPLACE clauses to non-FUNCTION object creation
> * Allow autocommit so always in a transaction block
> * Cache most recent
Christopher Kings-Lynne wrote:
> Whatver happened to Rod's work on the BETWEEN command? I remember he got to
> the stage of realising a lot of execetor changes had to be made...?
The problem was that the optimizer wouldn't recognize it as an
optimizable/indexable case so it would be worse than w
You can probably nail some TODOs:
* Add OR REPLACE clauses to non-FUNCTION object creation
* Allow autocommit so always in a transaction block
* Cache most recent query plan(s) (Neil) [prepare]
Chris
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of
Christopher Kings-Lynne wrote:
> Well WARNING is kinda standard - I have seen the like in other projects.
> Well, at least this way they'll read it and then hopefully port over to
> tsearch or at least they can make an informed decision to stick with
> fulltextindex. It is pretty crummy tho - the
Well WARNING is kinda standard - I have seen the like in other projects.
Well, at least this way they'll read it and then hopefully port over to
tsearch or at least they can make an informed decision to stick with
fulltextindex. It is pretty crummy tho - they shouldn't be using it.
NOTICE might
Whatver happened to Rod's work on the BETWEEN command? I remember he got to
the stage of realising a lot of execetor changes had to be made...?
Chris
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
su
WARNING does seem like a strong word, though I can't come up with a word
that would make sure they read it, maybe SUGGESTION?
---
Christopher Kings-Lynne wrote:
> Thanks - what do people think of the WARNING file? Please h
I have finished going through my email box and applying patches from the
patches queue. There is one patch left in the queue related to tcl
notification of connection failure. Tom wants to look at that.
I am running tests now on the code.
Tomorrow, I will run pgindent and create the HISTORY fi
Thanks - what do people think of the WARNING file? Please have a read and
comment perhaps?
Chris
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Bruce Momjian
> - CVS
> Sent: Monday, 2 September 2002 2:27 PM
> To: [EMAIL PROTECTED]
> Subject: [COM
I'm still getting conversion test failures on RH 7.2, 7.3, and Null beta.
My confiugre arguments are:
./configure --prefix=/opt/postgresql --with-java --with-python --with-openssl
--enable-syslog --enable-debug --enable-cassert
--enable-depend
It appears that the functions are not being loade
Patch applied. Thanks.
---
mlw wrote:
> This built and worked on my system.
> famous last words, huh?
>
>
> Bruce Momjian wrote:
> >
> > Can someone address the intagg issue here, or is the code OK?
> >
> > --
All regression tests now pass perfectly for me. Thanks.
Chris
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Bruce Momjian
> Sent: Monday, 2 September 2002 1:21 PM
> To: Christopher Kings-Lynne
> Cc: Tom Lane; Hackers
> Subject: Re: [HACKERS] RUL
Yes, I think the key issue is whether we have a better chance of
preventing radical changes during beta if we go a few days during code
freeze to make sure everything is bolted down.
Marc doesn't want to do that, so we won't.
-
On Mon, 02 Sep 2002 01:20:51 -0400, Tom Lane wrote:
>
> My two cents: once we ship beta1 we should try really really hard to
> avoid forcing an initdb cycle before final release. We can make all the
> portability fixes and code fixes we like, but we have to avoid
> disk-file-contents changes and
Yep, that's it!
---
Joe Conway wrote:
> Bruce Momjian wrote:
> > Allow easy display of usernames in a group (pg_hba.conf uses groups now)
>
> Hows this:
>
> parts=# select * from pg_group ;
> groname | grosysid |gro
Bruce Momjian wrote:
> Allow easy display of usernames in a group (pg_hba.conf uses groups now)
Hows this:
parts=# select * from pg_group ;
groname | grosysid |grolist
-+--+---
grp | 100 | {100,101,102}
grp2| 101 | {102}
(2 rows)
parts=# s
OK, attached patch applied. I made a few changes. I added a mention
they may want to enable LOG_PID because there is no guarantee that the
statement and error will appear next to each other in the log file. I
also renamed 'query' to 'statement' to be more precise.
Also, is there any way to di
How about adding 'set autocommit=on' to the top of each script?
---
Sean Chittenden wrote:
-- Start of PGP signed section.
> This is pretty chump and easy to get around, but it took me a sec to
> figure this out. Anyway, t
Sean Chittenden <[EMAIL PROTECTED]> writes:
> This is pretty chump and easy to get around, but it took me a sec to
> figure this out. Anyway, the short and skinny being that with the new
> AutoCommit GUC turned off, create(lang|db) won't work until you bail
> out of the transaction. A quick hack
OK, patch attached that adds ORDER BY to the problem regression query.
---
Christopher Kings-Lynne wrote:
> > That seems substantially the same plan as I see here. I guess
> > that the different output order must reflect a
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
>> Now, if you just want to roll together what we have and send out that,
>> that is fine, but there are going to be significant cleanups in beta2.
> This is what I'm figuring ... if we roll and send out a beta1 right off,
> more ppl will look at it
How do I get a list of what tsearch considers a stop word?
eg. 'and', 'or', 'the', 'up', 'down', etc. There seem to be heaps of
them...!
Chris
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send
On Mon, 2 Sep 2002, Tom Lane wrote:
> As of CVS tip I have changed this to create a table without OIDs.
> ...
> If anyone is really annoyed about this, we could probably find a
> solution; but I'm not inclined to expend effort on it unless there's
> someone out there who's seriously unhappy. Com
Up to now, if you created a table with
SELECT ... INTO foo FROM ...
then the new table "foo" would have OIDs.
As of CVS tip I have changed this to create a table without OIDs.
I'd have preferred not to make such a change at the last minute,
but the hack we had in place was quite broken.
On Fri, 30 Aug 2002, Nigel J. Andrews wrote:
> I think I must be one of those 'old school' types. I use
>
> find | xargs grep
>
> often followed by tags in Emacs.
You might find that Gnu id-tools is a much faster way of
doing this, especially for large amounts of source code.
cjs
--
Cu
Marc G. Fournier wrote:
> On Mon, 2 Sep 2002, Bruce Momjian wrote:
>
> > Yes, I am just concerned we may actually adjust functionality after
> > beta1 if we haven't tied everything down, and that may be a problem.
>
> Why? Nobody should be using a beta for production anyway ... until we go
> to
On Mon, 2 Sep 2002, Bruce Momjian wrote:
> Yes, I am just concerned we may actually adjust functionality after
> beta1 if we haven't tied everything down, and that may be a problem.
Why? Nobody should be using a beta for production anyway ... until we go
to RC1, functionality can change if its
Bruce Momjian wrote:
> Tom Lane wrote:
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > Any status on this? I know we talked about it but never came to a
> > > good solution. Is it TODO?
> >
> > I think it's more like MUSTFIX ... but it's a bug not a feature
> > addition, so it'd fair game t
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Any status on this? I know we talked about it but never came to a
> > good solution. Is it TODO?
>
> I think it's more like MUSTFIX ... but it's a bug not a feature
> addition, so it'd fair game to work on in beta, no?
Yes. I wil
Marc G. Fournier wrote:
> On Sun, 1 Sep 2002, Bruce Momjian wrote:
>
> >
> > We are definitely more organized for this beta because we are picking
> > the hour for beta start. ;-)
> >
> > The issue is that we can't just close beta and roll out a beta1 tarball.
> > There will be patch questions,
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Any status on this? I know we talked about it but never came to a
> good solution. Is it TODO?
I think it's more like MUSTFIX ... but it's a bug not a feature
addition, so it'd fair game to work on in beta, no?
regards, tom la
Your patch has been added to the PostgreSQL unapplied patches list at:
http://207.106.42.251/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---
mlw wrote:
> This built and worked on my system.
On Sun, 1 Sep 2002, Bruce Momjian wrote:
>
> We are definitely more organized for this beta because we are picking
> the hour for beta start. ;-)
>
> The issue is that we can't just close beta and roll out a beta1 tarball.
> There will be patch questions, doc questions, and general build
> quest
Can someone address the intagg issue here, or is the code OK?
---
Tom Lane wrote:
> Joe Conway and I have just committed some changes in the internal
> representation of Postgres arrays: an element-type-OID field is added t
OK, we are rolling out schemas in 7.3. We better figure out if we have
the best solution for this.
---
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Have we addressed this? I don't think so.
>
> No, it'
Any status on this? I know we talked about it but never came to a
good solution. Is it TODO?
---
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Is this fixed, and if not, can I have some TODO text?
>
> I
Done and committed with clean compile.
---
Bruce Momjian wrote:
>
> Peter, did you go around and remove sys/types.h from all the include
> files now that it is in c.h?
>
> -
Right now, I am going through my email box trying to resolve any open
patches or items. Once I am done I will let people know. Hopefully
tomorrow we can deal with cleanups and documentation, as well as
anything we missed.
--
Bruce Momjian| http://candle.pha.pa.us
[
No, we don't. Right now you have to add log_connections, then link the
query pid back to the user connection. Not sure how else we would do it
because log_duration has to do the same linking. Ideas?
---
Christopher Kings
Do we have log_username as an option? Would log the username that tried to
execute each query?
Would be a useful option!
Chris
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Bruce Momjian
> - CVS
> Sent: Monday, 2 September 2002 7:26 AM
> To: [E
Scott Shattuck wrote:
> A couple of admin nice-to-have's based on the last few weeks of 24x7
> operation are:
>
> Allow DBA/Database Owner to log in even when max_connections has been
> reached so they can determine which queries are hung via
> pg_stat_activity etc. and perform any other needed w
Hello All,
I'm new to this list...and PostgreSQL. I've got my server all up and
running...and I am porting an application that had been using MSSQL as
its backend.
When I use my app to browse around (i.e., SELECTS), everything is
behaving nicely. I am not having such luck with UPDATEs.
I a
OK, seems we have wildly different values for MemSet for different
machines. I am going to up the MEMSET_LOOP_LIMIT value to 1024 because
it seems to be the best value on most machines. We can revisit this in
7.4.
I wonder if a configure test is going to be required for this
evenutally. I thi
We are definitely more organized for this beta because we are picking
the hour for beta start. ;-)
The issue is that we can't just close beta and roll out a beta1 tarball.
There will be patch questions, doc questions, and general build
questions that could take days to resolve before we are 100
I think we need the bison beta on postgresql.org, and we shipped using
that.
---
Michael Meskes wrote:
> Hi,
>
> any idea what we do with ecpg for the upcoming freeze? Do we use the
> beta version of bison? If so, do we m
Thanks, got it.
---
J. R. Nield wrote:
> It is called by a special child process of the postmaster after a
> signal. Search for PMSIGNAL_DO_CHECKPOINT in xlog.c and in postmaster.c.
> The checkpoint process gets started out
On Sun, 1 Sep 2002, Marc G. Fournier wrote:
> On Sun, 1 Sep 2002, Nigel J. Andrews wrote:
>
> >
> > On Mon, 2 Sep 2002, Gavin Sherry wrote:
> >
> > > On Sun, 1 Sep 2002, Nigel J. Andrews wrote:
> > >
> > > > When is the beta freeze?
> > >
> > > Today.
> > >
> >
> > Oops, my fault for being impre
On Sun, 1 Sep 2002, Nigel J. Andrews wrote:
>
> On Mon, 2 Sep 2002, Gavin Sherry wrote:
>
> > On Sun, 1 Sep 2002, Nigel J. Andrews wrote:
> >
> > > When is the beta freeze?
> >
> > Today.
> >
>
> Oops, my fault for being imprecise.
>
> I was wondering what time of day with timezone. Someone sugge
Nigel J. Andrews wrote:
> Oops, my fault for being imprecise.
>
> I was wondering what time of day with timezone. Someone suggested end of today
> but that means different times to different people.
Bruce's message said end of day, EDT.
Joe
---(end of broadcast)---
> Oops, my fault for being imprecise.
>
> I was wondering what time of day with timezone. Someone suggested end of today
> but that means different times to different people.
This is what Marc said yesterday:
Yup, I believe that it is the case that both the US and Canada
"celebrate"
labour day
On Mon, 2 Sep 2002, Gavin Sherry wrote:
> On Sun, 1 Sep 2002, Nigel J. Andrews wrote:
>
> > When is the beta freeze?
>
> Today.
>
Oops, my fault for being imprecise.
I was wondering what time of day with timezone. Someone suggested end of today
but that means different times to different pe
On Sun, 1 Sep 2002, Nigel J. Andrews wrote:
>
>
> When is the beta freeze?
Today.
Gavin
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
me
When is the beta freeze?
I've just started looking at a ToDo list item and hope it won't take too
long. However, I've got other things to do and this is the first I've looked in
this area. An idea about time left to complete it would be good so I decide if
I'm wasting my time and effort at the
Hi,
any idea what we do with ecpg for the upcoming freeze? Do we use the
beta version of bison? If so, do we merge the branch back into main?
I just synced the parsers and found one more problem. The embedded SQL
commands EXECUTE and PREPARE do collide with the backend commands. No
idea so far h
57 matches
Mail list logo
