should be fixed now ... let me know if there are any other problems ...
On Mon, 19 Apr 2004, Magnus Hagander wrote:
> The snapshots in ftp.postgresql.org/pub/dev/ (and mirrors) appears not
> to have updated since Apr 5th. These are supposed to be generated
> nightly, right? If so, they seem brok
Not sure if anyone reported to you but we fixed these in current CVS and
will have the fix in 7.4.3.
---
Cott Lang wrote:
> On Wed, 2004-02-11 at 16:25, Bruce Momjian wrote:
> >
> > Sure, shoot them over to hackers or patch
L J Bayuk wrote:
> Bruce Momjian wrote:
> > ...
> > OK, Marc has removed libpgtcl. I just removed the docs for them.
> >
> > Can someone comment on pgtclsh? The README says:
> >...
> >
> > Do we need to move that over to gborg? If so, you can pull it out of
> > 7.4 CVS.
> >
> > Anyone?
>
> A
Bruce Momjian wrote:
> ...
> OK, Marc has removed libpgtcl. I just removed the docs for them.
>
> Can someone comment on pgtclsh? The README says:
>...
>
> Do we need to move that over to gborg? If so, you can pull it out of
> 7.4 CVS.
>
> Anyone?
Already discussed:
http://archives.postgre
Dear Hackers
I apologize in advance if this posting is construed as spam.
As many of you are aware, the database research group at UC Berkeley
is building TelegraphCQ, a system for processing continuous queries
over data streams. TelegraphCQ was built with the PostgreSQL source
base.
We are lo
"Magnus Hagander" <[EMAIL PROTECTED]> writes:
> * Is it enough to explicitly store/save LC_COLLATE and LC_CTYPE, or does
> more of the locale stuff need to be stored?
The other LC_xxx settings will get fixed by GUC *only* if there are
explicit settings in postgresql.conf ... I don't think you can
char *argstring = flatten_set_variable_args(name, args);
+ printf("bjm: %s %s\n", name, argstring);
+ fflush(stdout);
Did you really mean to include that? :)
Chris
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
Christopher Kings-Lynne wrote:
> > char *argstring = flatten_set_variable_args(name, args);
> > + printf("bjm: %s %s\n", name, argstring);
> > + fflush(stdout);
> >
>
> Did you really mean to include that? :)
Nope, posted a followup that it was removed in a later commit.
--
Bruc
Bruce Momjian wrote:
> L J Bayuk wrote:
> > Bruce Momjian wrote:
> > >
> > > Bruce Momjian wrote:
> > > > Why is libpgtcl still in /src/interfaces? Isn't it now on gborg? Are
> > > > there two of them there now?
> > >
> > > I am still waiting for an answer on this. Does no one know?
> >
> > I
With initdb written now in C, we don't need a pg_encoding binary
anymore.
I have removed it from CVS. There were no mentions of it in the docs.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard dr
L J Bayuk wrote:
> Bruce Momjian wrote:
> >
> > Bruce Momjian wrote:
> > > Why is libpgtcl still in /src/interfaces? Isn't it now on gborg? Are
> > > there two of them there now?
> >
> > I am still waiting for an answer on this. Does no one know?
>
> I replied right away - to you and the list
Bruce Momjian wrote:
>
> Bruce Momjian wrote:
> > Why is libpgtcl still in /src/interfaces? Isn't it now on gborg? Are
> > there two of them there now?
>
> I am still waiting for an answer on this. Does no one know?
I replied right away - to you and the lists you posted to.
Never got it? It's
Fabien COELHO wrote:
> #
> # new syntax?
> #
>
> psql> BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;
> BEGIN
> psql> SHOW TRANSACTION ISOLATION LEVEL;
> transaction_isolation
> ---
> read committed
OK, fixed:
test=> BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;
Please ignore the 'bjm' debug code that was part of the patch. It has
been removed from CVS.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your
Hello!
Here is a temp fix for the locale issues on win32. It passes regression
tests, but is *NOT* ready to be applied (if nothing else, it at least
needs more error checking).
The issue is that locale settings were not inherited by the postgres
backends when they were execed... Instead, the loc
Brett Schwarz wrote:
> for the second part, yes, there are 2 on gborg: pgtcl
> and pgtclng
>
My question is whether they have all the CVS history and fixes in
libpgtcl so we can remove it from CVS.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED]
I tracked the problem down to the "penalty" function used to build the
tree. Basically, it compares the area of the bounding boxes.
There wasnt enough precision in the area calculations - instead of
giving 0.0 it would give numbers in the[+-]10^-6 range. This really
screwed up how the tree w
for the second part, yes, there are 2 on gborg: pgtcl
and pgtclng
--- Bruce Momjian <[EMAIL PROTECTED]> wrote:
> Bruce Momjian wrote:
> > Why is libpgtcl still in /src/interfaces? Isn't
> it now on gborg? Are
> > there two of them there now?
>
> I am still waiting for an answer on this. Does n
Jan Wieck <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Why do we have it at all? Seems like it would be at least as good to
>> make the T1-or-T2 decision in StrategyGetBuffer, rather than earlier.
> If it'd be possible. The problem is that it can get called multiple
> times during one logica
Tom Lane wrote:
Jan Wieck <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
I've got a problem with these variables in freelist.c:
static int strategy_cdb_found;
static int strategy_cdb_replace;
These two most definitely are per backend because they hold status
information a
On Mon, Apr 19, 2004 at 11:18:07AM -0400, Tom Lane wrote:
>
> What you'd need to do is determine which system headers are being
> #include'd by that config test, and then look through them to find
> struct addrinfo.
Well, I have this in /usr/include/netdb.h:
struct addrinfo {
int
Jan Wieck <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> I've got a problem with these variables in freelist.c:
>>
>> static int strategy_cdb_found;
>> static int strategy_cdb_replace;
> These two most definitely are per backend because they hold status
> information about
The snapshots in ftp.postgresql.org/pub/dev/ (and mirrors) appears not
to have updated since Apr 5th. These are supposed to be generated
nightly, right? If so, they seem broken.
//Magnus
---(end of broadcast)---
TIP 9: the planner will ignore your
Bruce Momjian wrote:
> Why is libpgtcl still in /src/interfaces? Isn't it now on gborg? Are
> there two of them there now?
I am still waiting for an answer on this. Does no one know?
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610
Tom Lane wrote:
Fabien COELHO <[EMAIL PROTECTED]> writes:
Ok. I understand that you suggest to Thomas that he should only touch
the search array to insert new pointers to guc description structures,
which may come from outside or be newly allocated, without touching the
existing static versions fo
As I was playing around with prelimiary stuff for regression testing the
CSV patch, I had a couple of ideas I thought I might float.
Context: many of the tests will write a table out and read it back into
a duplicate table and then perform a symmetric difference on the 2
tables. Making the quer
Andrew Dunstan wrote:
Jan Wieck wrote:
Christopher Kings-Lynne wrote:
... on projects.postgresql.org, or similar.They really aren't
doing any good in /contrib.
I've already set up a category "conversion tools" on pgFoundry, and
my idea was one project per target system.
I reckon that by
Tom Lane wrote:
I've got a problem with these variables in freelist.c:
static int strategy_cdb_found;
static int strategy_cdb_replace;
These two most definitely are per backend because they hold status
information about the blocks this backend specifically is mucking wi
Tom Lane wrote:
Andrew Sullivan <[EMAIL PROTECTED]> writes:
On Thu, Apr 15, 2004 at 07:52:59PM -0400, Tom Lane wrote:
I can see from your trace that you are using the getaddrinfo code from
libc, but where is configure finding a header that declares struct
addrinfo?
Hrm, I can't seem to tell. I s
It seems to me that new 'begin isolation level ...' syntax does not work
with current cvs head:
#
# old syntax:
#
psql> SELECT VERSION();
version
---
PostgreSQL 7.5devel on i686-pc-linux-gnu, compil
Shachar,
> I have a bunch of perl scripts, as well as one user-defined type, for
> porting from SQL Server. Where should I place these?
Give us a few days. We'll be announcing the opening of the new projects site
soon (like, wednesday).
Regrettably, the perfect feature for this sort of thing,
I've got a problem with these variables in freelist.c:
static int strategy_cdb_found;
static int strategy_cdb_replace;
static int strategy_get_from;
Why are these per-backend? Shouldn't they be in shared state?
regards, tom lane
--
Fabien COELHO <[EMAIL PROTECTED]> writes:
> Ok. I understand that you suggest to Thomas that he should only touch
> the search array to insert new pointers to guc description structures,
> which may come from outside or be newly allocated, without touching the
> existing static versions for interna
On Mon, Apr 19, 2004 at 11:18:07AM -0400, Tom Lane wrote:
> A shortcut is just to grep through /usr/include and its subdirectories
> for addrinfo. If you only find one definition, then you don't really
> need to worry too much. But if there's more than one you need to
> determine which is gettin
Dear Tom,
> > . All guc variables are described in static structures initialized at
> > loadtime. if it is to be extendable, it means that you have break this,
>
> No, you don't.
Well, sorry, I'm used to show my lack of imagination on the list;-)
> > . There is also a dynamic sorted array that
Fabien COELHO <[EMAIL PROTECTED]> writes:
> . All guc variables are described in static structures initialized at
> loadtime. if it is to be extendable, it means that you have break this,
No, you don't.
> . There is also a dynamic sorted array that allows to find all variables
> descriptions inde
Andrew Sullivan <[EMAIL PROTECTED]> writes:
> On Thu, Apr 15, 2004 at 07:52:59PM -0400, Tom Lane wrote:
>> I can see from your trace that you are using the getaddrinfo code from
>> libc, but where is configure finding a header that declares struct
>> addrinfo?
> Hrm, I can't seem to tell. I see t
On Mon, Apr 19, 2004 at 09:53:26AM -0400, Tom Lane wrote:
> Run some hardware diagnostics. This looks like your disk drive dropped
> some bits ...
That would be something, it would be the second disk in two weeks. It's
a brand new drive and I haven't had any other problems. (Heck, even the
other
Dear Thomas,
> I might have some time left to spend on the item "Allow external interfaces
> to extend the GUC variable set"
> filed under "Administration" on the TODO list. I'm thinking of an approach
> with the steps:
>
> 1) Increasing my own understanding of the GUC code
Well, I did that yest
George Cristian Birzan <[EMAIL PROTECTED]> writes:
> ERROR: xlog flush request 0/E25BA1C4 is not satisfied --- flushed only to =
> 0/841D994
> CONTEXT: writing block 1 of relation 17143/370747
> While the data is irrelevant (I can get that from the dump), this could
> be a bug in PostgreSQL, or
Hi,
I might have some time left to spend on the item "Allow external interfaces
to extend the GUC variable set"
filed under "Administration" on the TODO list. I'm thinking of an approach
with the steps:
1) Increasing my own understanding of the GUC code
2) Suggest a solution on this newsgroup
3) I
The proposed new sampling method
(http://archives.postgresql.org/pgsql-hackers/2004-04/msg00036.php and
http://archives.postgresql.org/pgsql-patches/2004-04/msg00045.php)
basically incorporates two independant changes:
(1) Two-stage sampling: Stage one collects a random sample of pages,
stage two
(Sorry, had a mail problem here this weekend.)
On Thu, Apr 15, 2004 at 07:52:59PM -0400, Tom Lane wrote:
>
> I can see from your trace that you are using the getaddrinfo code from
> libc, but where is configure finding a header that declares struct
> addrinfo?
Hrm, I can't seem to tell. I see t
- Begin Forwarded Message -
>From To:[EMAIL PROTECTED] Mon Apr 19 11:08:57 2004
Date: Mon, 19 Apr 2004 11:08:57 METDST
To: [EMAIL PROTECTED] (Tom Lane)
Subject: Re: [HACKERS] executing prepared select, missing RowDescription info
In-Reply-To: <[EMAIL PROTECTED]>; from "Tom
While it's a couple of weeks old, in case it hasn't been seen by "those
who need it", the folllowing thread on linux kernel discusses the
fsync-and-IDE-writecache interactions. There is also a comment on MacOS
X - I have no idea if that was already known, but I thought it might be
worth pointing ou
45 matches
Mail list logo