Gurjeet Singh wrote:
My main grudge is that if we are supporting almost all flovours of
nixens and compilers (close to 34 according to official website), then
why are we leaving Windows platform alone? This will bring in quite a
lot more developers.
You should look at MinGW as a development t
On 5/4/06, Gurjeet Singh <[EMAIL PROTECTED]> wrote:
My main grudge is that if we are supporting almost all flovours of
nixens and compilers (close to 34 according to official website), then
why are we leaving Windows platform alone? This will bring in quite a
lot more developers.
Sorry, but
Hi William(uniware), Chuck and Hackers,
I have been interested in doing complete PGSQL development in MSVC
for a long time now. With reference to one of Chuck's mails to
-hackers-win32 with the same subject, you said that you were able to
successfully compile PG 8.1 with some minor tweaks.
Bruce Momjian writes:
> My idea is to create a new SECURITY DEFINER function called
> serial_nextval(), and use that for SERIAL defaults.
You haven't thought about this at all. Who will own that function?
Surely we don't want to create a new one for every SERIAL column.
And even if we did, what
I have read this thread and I agree with Magnus that we have both new
and experienced users, and we need something simple like SERIAL for new
users.
I agree that having SERIAL be a macro is probably less that useless ---
you can create SERIAL easily, but to remove a table you have to
understand t
Martijn van Oosterhout writes:
> On Thu, May 04, 2006 at 03:21:56PM -0400, Tom Lane wrote:
>> AFAIK, everything that is in exports.txt was put there for a reason.
>> I'm happy with the situation as it stands (other than wanting to enforce
>> the exports.txt restriction on more platforms ...)
> In
On Thu, May 04, 2006 at 09:02:02PM +0200, Thomas Hallgren wrote:
> Tom Lane wrote:
> > > Why can PLs not handle pseudo-types?
> >
> >No one's done the work to figure out which ones are sensible to
> >support and then add the logic needed to support them.
> >
> PL/Java will handle the RECORD type co
On Thu, May 04, 2006 at 03:21:56PM -0400, Tom Lane wrote:
> AFAIK, everything that is in exports.txt was put there for a reason.
> I'm happy with the situation as it stands (other than wanting to enforce
> the exports.txt restriction on more platforms ...)
In that case, shouldn't we add to libpq-f
Natives getting restless... :)
Any plans for a release?
- Forwarded message from Bruno Wolff III <[EMAIL PROTECTED]> -
On Tue, May 02, 2006 at 14:20:03 -0400,
"Matthew T. O'Connor" wrote:
> Hey all, I was just wondering if there were any plans to get 8.1.4
> release in the near future
Moving to -hackers...
On Thu, May 04, 2006 at 09:17:31AM -0700, Stephan Szabo wrote:
> On Thu, 4 May 2006, Rich Doughty wrote:
>
> > I have a foreign key constraint that I'd like to alter. I'd rather not
> > drop and re-create it due to the size of the table involved. All I need
> > to do is add
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> After CVS-upping... yes, both lastpagecount and nextpage are now
> included. But unfortunately the README says next to nothing about what
> they mean...
Yeah, this needs a bit of work ... will have at it.
regards, tom lane
Thomas Hallgren <[EMAIL PROTECTED]> writes:
> PL/Java will handle the RECORD type correctly. I'm just finalizing a new,
> more flexible,
> type mapping implementation for PL/Java and it would be easy to add support
> for more pseudo
> types too. But what others would make sense?
If you've got
Martijn van Oosterhout writes:
> On Thu, May 04, 2006 at 12:47:39PM -0400, Tom Lane wrote:
>> Already done no? (at least on the platforms where we know how to
>> restrict it)
> These functions are all in the exports.txt. I was just wondering if we
> wanted to cut that list down any more...
AFAI
Tom Lane wrote:
Why can PLs not handle pseudo-types?
No one's done the work to figure out which ones are sensible to support
and then add the logic needed to support them.
PL/Java will handle the RECORD type correctly. I'm just finalizing a new, more flexible,
type mapping implementation for
On Thu, May 04, 2006 at 12:47:39PM -0400, Tom Lane wrote:
> Martijn van Oosterhout writes:
> > Comparing the lists of functions exported by libpq and those declared
> > by libpq-fe.h turns up a fair number of descrepancies. Most of these
> > functions are declared by internal header files. For cla
On Thu, May 04, 2006 at 01:20:32PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > On Wed, May 03, 2006 at 02:25:54PM -0400, Tom Lane wrote:
> >> Isn't this already dealt with by contrib/pg_freespacemap?
>
> > AFAIK that does nothing to tell you how much space is desired by
On Thu, May 04, 2006 at 12:37:48PM -0400, Rod Taylor wrote:
> On Thu, 2006-05-04 at 11:25 -0500, Larry Rosenman wrote:
> > Rod Taylor wrote:
> > > I don't know about anyone else, but the only time I look at that mess
> > > is to find poor tuple/table or tuple/index ratios and other
> > > indication
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> On Wed, May 03, 2006 at 02:25:54PM -0400, Tom Lane wrote:
>> Isn't this already dealt with by contrib/pg_freespacemap?
> AFAIK that does nothing to tell you how much space is desired by
> relations.
I thought the latest patch arranged to expose per-rel
Greg Stark <[EMAIL PROTECTED]> writes:
> Hm. This goes back to the earlier conversation about whether = should ever be
> true for two objects that aren't, well, equal. I thought there was some
> consensus at the time that sorting should impose a superficial ordering on
> items that compare equal bu
On Thu, May 04, 2006 at 08:46:54AM +0100, Simon Riggs wrote:
> On Tue, 2006-05-02 at 15:01 -0400, Alvaro Herrera wrote:
> > Just noticed a typo in newly added ginxlog.c. I don't have line
> > numbers, but in ginRedoSplit() it reads:
> >
> > PageSetLSN(rpage, lsn);
> > PageSetTLI(lpage, Th
On Wed, May 03, 2006 at 02:25:54PM -0400, Tom Lane wrote:
> > On Tue, May 02, 2006 at 05:49:33PM -0500, Jim C. Nasby wrote:
> >> Back in the discussion of this someone had mentioned capturing all the
> >> info that you'd get from a vacuum verbose; dead tuples, etc. What do
> >> people think about t
Markus Schiltknecht <[EMAIL PROTECTED]> writes:
> What exactly are pseudo types?
See
http://developer.postgresql.org/docs/postgres/extend-type-system.html
> Why can PLs not handle pseudo-types?
No one's done the work to figure out which ones are sensible to support
and then add the logic needed
Martijn van Oosterhout writes:
> Comparing the lists of functions exported by libpq and those declared
> by libpq-fe.h turns up a fair number of descrepancies. Most of these
> functions are declared by internal header files. For clarity I think we
> should clarify the situation, either explicity d
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Thanks for pointing that out. I should have realized that this was the same
> (or at least close to) issue I was thinking would be a problem initially, but
> then I started thinking that '=' promised more than it did and assumed that
> x = y implies fo
On Thu, 2006-05-04 at 11:25 -0500, Larry Rosenman wrote:
> Rod Taylor wrote:
> > I don't know about anyone else, but the only time I look at that mess
> > is to find poor tuple/table or tuple/index ratios and other
> > indications that vacuum isn't working as well as it should be.
> >
> > How abou
Rod Taylor wrote:
> I don't know about anyone else, but the only time I look at that mess
> is to find poor tuple/table or tuple/index ratios and other
> indications that vacuum isn't working as well as it should be.
>
> How about this instead:
>
> Log when the actual autovacuum_vacuum_scale_fact
I don't know about anyone else, but the only time I look at that mess is
to find poor tuple/table or tuple/index ratios and other indications
that vacuum isn't working as well as it should be.
How about this instead:
Log when the actual autovacuum_vacuum_scale_factor (dead space cleaned
up) was m
[EMAIL PROTECTED] ("Larry Rosenman") writes:
> Gentlepeople,
> Now that the patch is out for keeping the last
> autovacuum/vacuum/analyze/autoanalyze
> timestamp in the stats system is pending, what's the consensus view on
> what, if any,
> logging changes are wanted for autovacuum?
>
> I h
Hi,
I'm trying to write a PL/Python function which is to be called from a
rule. I'd need pass the OLD and NEW tuple records to the function.
Unfortunately that does not work: 'pl/python functions cannot take type
record'.
What I have figured out by reading the source code: OLD and NEW are
pseudo
Simon Riggs <[EMAIL PROTECTED]> writes:
> On Wed, 2006-05-03 at 16:15 -0400, Tom Lane wrote:
>> If dropdb() takes such a lock before it checks for active
>> backends, then the connection sequence can look like this:
> Many people never CREATE or DROP databases. They just do everything in
> the def
On Thu, May 04, 2006 at 02:39:33 -0400,
Tom Lane <[EMAIL PROTECTED]> wrote:
> Bruno Wolff III <[EMAIL PROTECTED]> writes:
> > ... it would be OK to rewrite
> > SELECT DISTINCT x ORDER BY foo(x)
> > as
> > SELECT DISTINCT ON (foo(x), x) x ORDER BY foo(x)
>
> This assumes that x = y implies foo(x)
Gentlepeople,
Now that the patch is out for keeping the last
autovacuum/vacuum/analyze/autoanalyze
timestamp in the stats system is pending, what's the consensus view on
what, if any,
logging changes are wanted for autovacuum?
I have the time and inclination to cut code quickly for it.
Th
Comparing the lists of functions exported by libpq and those declared
by libpq-fe.h turns up a fair number of descrepancies. Most of these
functions are declared by internal header files. For clarity I think we
should clarify the situation, either explicity declare them for
external users, or stop
On Tue, 2006-05-02 at 15:01 -0400, Alvaro Herrera wrote:
> Just noticed a typo in newly added ginxlog.c. I don't have line
> numbers, but in ginRedoSplit() it reads:
>
> PageSetLSN(rpage, lsn);
> PageSetTLI(lpage, ThisTimeLineID);
> MarkBufferDirty(rbuffer);
>
> PageSetLS
On Wed, 2006-05-03 at 16:15 -0400, Tom Lane wrote:
> This is motivated by Jim Buttafuoco's recent gripe about not being
> able to connect while a DROP DATABASE is in progress:
> http://archives.postgresql.org/pgsql-hackers/2006-05/msg00074.php
...
> If dropdb() takes such a lock before it checks
For you it will be easy to understand GiST interface looking into
src/backend/access/gist/gistproc.c. It implements RTree.
fernando esparza wrote:
Hello,
I'm finishing my career in computer engineering. To finish that I've
to develop a new implementation of R*-tree. My teacher Prof. Dr.
Seeger
On Thu, 4 May 2006, fernando esparza wrote:
Hello,
I'm finishing my career in computer engineering. To finish that I've
to develop a new implementation of R*-tree. My teacher Prof. Dr.
Seeger, http://dbs.mathematik.uni-marburg.de/Home/People/Professor has
already one done, now he wants me to ad
37 matches
Mail list logo
