On Wed, 2006-08-09 at 18:04 -0400, Tom Lane wrote:
> >> BTW, is anyone up for renaming the existing "preload_libraries"
> variable
> >> to "postmaster_load_libraries"? This would be more symmetrical
> with
> >> "backend_load_libraries", and so perhaps clearer about which does
> what
>
> > Makes s
On Wed, Aug 09, 2006 at 06:39:07PM -0400, Tom Lane wrote:
> I suppose Michael and Joachim are in bed, so I'll try committing this.
> If they don't like it they can fix it in the morning ...
Right we were. :-)
Thanks Tom.
Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at
On Wed, 2006-08-09 at 10:04 -0400, Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > Something Hannu wrote has just reminded me that
> > pg_current_xlog_location() returns the current Insert pointer rather
> > than the current Write pointer.
> > That would not be useful for streaming xl
You are correct the main part I'm worried about is the updates, being so far from the originals. fyi I
am partitioning the tables by the timestamp column,vacuum analyzing once per hour, creating one child
partition per day in a cron job. Because I'm using hibernate for database abstraction (statele
Mark Kirkwood <[EMAIL PROTECTED]> writes:
> Robert Treat wrote:
>> Wouldn't a thread reply saying something like "Bruce, can we add this as a
>> TODO with the following wording: blah blah blah" likely suffice?
That's pretty much how it's done now ...
> Yeah - and/or a patch to TODO or the rele
On Wed, 9 Aug 2006, Dave Page wrote:
Marc was setting up developer.postgresql.org as a developers wiki btw...
Dunno what happened to that.
Marc?
Two words: House Hunting ...
I have to download the stuff from pgFoundry tomorrow night, already have
the database server running locally ... wil
Stephen Frost <[EMAIL PROTECTED]> writes:
> Makes me curious if it really makes sense to keep trailing zeros...
AFAIR we consider them mainly as a display artifact. An application
that's declared a column as numeric(7,2) is likely to expect to see
exactly two digits after the decimal point.
> Ei
Robert Treat wrote:
On Wednesday 09 August 2006 12:12, Bruce Momjian wrote:
One possibility: have a 'holding area' (perhaps on a Wiki) where users
could add use-cases for these ideas. If there's 'enough demand' (however
one defines that), they get promoted to the TODO. Note that this is
somethin
* Tom Lane ([EMAIL PROTECTED]) wrote:
> Stephen Frost <[EMAIL PROTECTED]> writes:
> > It could say "not equal" pretty reasonably as the scale is
> > different.
>
> Nope, there are exactly three options: equal, less, greater.
> btree doesn't understand anything else.
Ah, yeah, I can see how someth
On Wednesday 09 August 2006 12:12, Bruce Momjian wrote:
> > One possibility: have a 'holding area' (perhaps on a Wiki) where users
> > could add use-cases for these ideas. If there's 'enough demand' (however
> > one defines that), they get promoted to the TODO. Note that this is
> > something geare
On 2006-08-10, Stephen Frost <[EMAIL PROTECTED]> wrote:
>> Yeah, because numeric_cmp says that 1.0 and 1.00 are equal (what else
>> could it say? "less" and "greater" are surely wrong). So you need to
>
> It could say "not equal" pretty reasonably as the scale is
> different.
The comparison func
Server:
Event Type: Information
Event Source: PostgreSQL
Event Category: None
Event ID: 0
Date: 8/9/2006
Time: 8:36:52 PM
User: N/A
Computer: DAD
Description:
2006-08-09 20:36:52 DEBUG: InitPostgres
Event Type: Information
Event Source:
Joshua D. Drake wrote:
Hello,
I had a customer call in today they are running Win2003 with 22 gig of
ram (that may be a mistype on their end, it may be 32gigs of ram).
They cranked up their postgresql max_connections to 500.
When PostgreSQL hits above 400, it dies and I don't mean a slow cra
Stephen Frost <[EMAIL PROTECTED]> writes:
> * Tom Lane ([EMAIL PROTECTED]) wrote:
>> Yeah, because numeric_cmp says that 1.0 and 1.00 are equal (what else
>> could it say? "less" and "greater" are surely wrong). So you need to
> It could say "not equal" pretty reasonably as the scale is
> differ
On Thu, 10 Aug 2006, Hannu Krosing wrote:
Ühel kenal päeval, N, 2006-08-10 kell 10:56, kirjutas Andrej Ricnik-Bay:
On 8/10/06, David Fetter <[EMAIL PROTECTED]> wrote:
Seconded!
We now have a quorum. ;)
Three people constitute a quorum here? That makes for a
very wonky democracy. :D
Has a
[EMAIL PROTECTED] wrote:
> is this also true of the cvsup server?
No, I think cvsup is served directly from the write-CVS. I've gotten
patches via CVSup that were just committed.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting,
Gene <[EMAIL PROTECTED]> writes:
> I have a table that inserts lots of rows (million+ per day) int8 as primary
> key, and I cluster by a timestamp which is approximately the timestamp of
> the insert beforehand and is therefore in increasing order and doesn't
> change. Most of the rows are updated
Tom Lane <[EMAIL PROTECTED]> writes:
Tom Lane <[EMAIL PROTECTED]> writes:
> stark <[EMAIL PROTECTED]> writes:
>> It seems odd to me that implicit casts are checked for when you call a
>> function but not when you're implicitly calling a function via a cast. As a
>> result there are a *lot* of re
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Tom Lane) wrote:
> Martijn van Oosterhout writes:
> > My main problem is that selectivity is the wrong measurement. What
> > users really want to be able to communicate is:
>
> > 1. If you join tables a and b on x, the number of resulting rows
Tom Lane wrote:
> [EMAIL PROTECTED] (Bruce Momjian) writes:
> > Move "#define inline __inline" from port/win32.h to c.h because Win32
> > interface builds like libpq need it.
>
> Huh? port/win32.h is #included by c.h (as pg_config_os.h), no?
> I don't see why it's necessary to clutter c.h with th
* Tom Lane ([EMAIL PROTECTED]) wrote:
> Stephen Frost <[EMAIL PROTECTED]> writes:
> > Sounds good to me. I'd like to talk a bit about the expected behavior
> > of a numeric hash function. This is the current behavior:
>
> You're hijacking the thread, tsk tsk.
Yeah, but Brian sits across the hal
Bruce,
I'll fix it in this week. Please wait a few days.
Thanks.
Bruce Momjian wrote:
> nagayasu-san,
>
> This looks good, but we would like the code added to
> /contrib/pgstattuple, rather than it being its own /contrib module. Can
> you make that adjustment? Thanks.
>
>
[EMAIL PROTECTED] (Bruce Momjian) writes:
> Move "#define inline __inline" from port/win32.h to c.h because Win32
> interface builds like libpq need it.
Huh? port/win32.h is #included by c.h (as pg_config_os.h), no?
I don't see why it's necessary to clutter c.h with this
platform-specific hack, w
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Is this being worked on?
I think we dealt with that already.
regards, tom lane
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Have we made a decision on this issue? Should I apply my patch that
> still forces a split unless 10% of the page has been freed?
I haven't gotten back to doing any more performance testing. Please
stick that patch on the pending queue, so we don't for
Have we made a decision on this issue? Should I apply my patch that
still forces a split unless 10% of the page has been freed?
---
Tom Lane wrote:
> ITAGAKI Takahiro <[EMAIL PROTECTED]> writes:
> > This is a revised patch
Is this being worked on?
---
Tom Lane wrote:
> Joshua Reich <[EMAIL PROTECTED]> writes:
> > I'm not sure exactly what to do here. I tried simply doing
> > CREATE TYPE cube;
>
> > But I still get NOTICE's to the effect of "r
nagayasu-san,
This looks good, but we would like the code added to
/contrib/pgstattuple, rather than it being its own /contrib module. Can
you make that adjustment? Thanks.
---
satoshi nagayasu wrote:
> Hi folks,
>
> As
Hiroshi Saito wrote:
> Hi.
>
> Probably, the problem is happened in 8.1.4 of an official archive.
> http://archives.postgresql.org/pgsql-patches/2006-05/msg00232.php
>
> It is already clear at include/port/win32.h.
> And it is used as pg_config_os.h.
Actually, the patch you referenced was plac
I have a table that inserts lots of rows (million+ per day) int8 as primary key, and I cluster by a timestamp which is approximately the timestamp of the insert beforehand and is therefore in increasing order and doesn't change. Most of the rows are updated about 3 times over time roughly within th
Hi.
Probably, the problem is happened in 8.1.4 of an official archive.
http://archives.postgresql.org/pgsql-patches/2006-05/msg00232.php
It is already clear at include/port/win32.h.
And it is used as pg_config_os.h.
Regards,
Hiroshi Saito
- Original Message -
From: "Tom Lane" <[EMA
Stephen Frost <[EMAIL PROTECTED]> writes:
> Sounds good to me. I'd like to talk a bit about the expected behavior
> of a numeric hash function. This is the current behavior:
You're hijacking the thread, tsk tsk.
> abc=# select * from test1;
>a1
>
>1.00
> 1.
> 1.0
>
Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
>> BTW, what time does the anonymous-cvs rsync normally finish? Right now
>> my build starts at 5 after, but I suspect that's the worst possible time
>> for it...
>
> Marc recently said it starts at 19 after, so somewhere near half past i
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> BTW, what time does the anonymous-cvs rsync normally finish? Right now
> my build starts at 5 after, but I suspect that's the worst possible time
> for it...
Marc recently said it starts at 19 after, so somewhere near half past is
probably the optimal t
* Tom Lane ([EMAIL PROTECTED]) wrote:
> "Brian C. DeRocher" <[EMAIL PROTECTED]> writes:
> > It appears that when you create a view of a union, numeric data types
> > loose their scale and precision.
>
> I think this is the same issue discussed here:
> http://archives.postgresql.org/pgsql-hackers/2
On Wed, Aug 09, 2006 at 06:39:07PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > So... do we want something like
> > override LDFLAGS := $(LDFLAGS_NO_L) -L../../ecpglib -L../../pgtypeslib
> > -L../../../libpq
>
> I suppose Michael and Joachim are in bed, so I'll try commi
Ühel kenal päeval, N, 2006-08-10 kell 10:56, kirjutas Andrej Ricnik-Bay:
> On 8/10/06, David Fetter <[EMAIL PROTECTED]> wrote:
>
> > > Seconded!
> > We now have a quorum. ;)
> Three people constitute a quorum here? That makes for a
> very wonky democracy. :D
Has always been more like a meritocra
Hello,
I had a customer call in today they are running Win2003 with 22 gig of
ram (that may be a mistype on their end, it may be 32gigs of ram).
They cranked up their postgresql max_connections to 500.
When PostgreSQL hits above 400, it dies and I don't mean a slow crawl
type death. A death
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
>>> (there is no UNLOAD statement, is there?).
>>
>> What we actually have at the moment is that you can LOAD a library
>> again, which causes an unload of the prior version and then loading the
>> new.
> Right, but you still end up with a plugin lo
On 8/10/06, David Fetter <[EMAIL PROTECTED]> wrote:
> Seconded!
We now have a quorum. ;)
Three people constitute a quorum here? That makes for a
very wonky democracy. :D
---(end of broadcast)---
TIP 4: Have you searched our list archives?
I'm not sure you'll be able to convince everyone that the penalty is so
negligible --- any high-rate access to shared memory is potentially very
expensive, see nearby threads for examples. Even if this is affordable
for the debugger, what of more-invasive plugins such as the performance
moni
+!
- Luke
On 8/9/06 11:48 AM, "David Fetter" <[EMAIL PROTECTED]> wrote:
> On Wed, Aug 09, 2006 at 01:58:14PM -0400, Jonah H. Harris wrote:
>> On 8/9/06, Devrim GUNDUZ <[EMAIL PROTECTED]> wrote:
>>> Congratulations for your new job.
>>
>> Seconded!
>
> We now have a quorum. ;)
>
> I vote yes!
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> So... do we want something like
> override LDFLAGS := $(LDFLAGS_NO_L) -L../../ecpglib -L../../pgtypeslib
> -L../../../libpq
I suppose Michael and Joachim are in bed, so I'll try committing this.
If they don't like it they can fix it in the morning ...
"Shoaib Mir" <[EMAIL PROTECTED]> writes:
> As a workaround if you dont want to make the change and delete "inline" from
> wchar.c then you can do the following change in the win32.mak file for
> libpq:
> "WIN32" /D "_WINDOWS" /D "inline=__inline" /Fp"$(INTDIR)\libpq.pch" /YX\
That's even stranger
"Brian C. DeRocher" <[EMAIL PROTECTED]> writes:
> It appears that when you create a view of a union, numeric data types
> loose their scale and precision.
I think this is the same issue discussed here:
http://archives.postgresql.org/pgsql-hackers/2004-12/msg00408.php
That was just before 8.0 rele
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
>> The other, probably more controversial bit of functionality is that there
>> needs to be a way to cause a backend to load a PL plugin shared library
>> without any cooperation from the connected client application.
> Ok, but you should know that t
On Wed, Aug 09, 2006 at 01:56:42PM -0700, Neil Conway wrote:
> On Wed, 2006-08-09 at 12:15 -0400, Bruce Momjian wrote:
> > Well, either people post the changes publically or I trust a few people.
> > I don't trust everyone or the TODO becomes a dumping ground, which I am
> > afraid might happen wit
On Wed, Aug 09, 2006 at 05:11:37PM -0400, Tom Lane wrote:
> > Jim C. Nasby wrote:
> >> Platypus just started failing...
> >> http://pgbuildfarm.org/cgi-bin/show_log.pl?nm=platypus&dt=2006-08-09%2010:05:01
>
> gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline
> -Wdeclaration-after-statem
[ redirecting to -hackers, as this seems utterly off-topic for -general ]
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Shoaib Mir wrote:
>> If you remove "inline" the build process goes fine and if you dont, it first
>> gives a few warning and in the end quits the build process with a fatal
>> erro
ISTM there are two separate bits of functionality that the core backend
needs to provide in support of PL plugins. The first is that we need a
"rendezvous" facility whereby two separately-loaded shared libraries can
connect and exchange data (a struct of function pointers for the immediate
OK, done.
---
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> Seems like this probably ought to round up not down:
>
> > I thought about that, but because statement_timeout is in millis,
> Jim C. Nasby wrote:
>> Platypus just started failing...
>> http://pgbuildfarm.org/cgi-bin/show_log.pl?nm=platypus&dt=2006-08-09%2010:05:01
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline
-Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -g
-I./../../include -I../..
Jim C. Nasby wrote:
On Wed, Aug 09, 2006 at 12:17:44PM -0400, Andrew Dunstan wrote:
Jim C. Nasby wrote:
Platypus just started failing...
http://pgbuildfarm.org/cgi-bin/show_log.pl?nm=platypus&dt=2006-08-09%2010:05:01
Rest of the farm is looking pretty green, though, so I'm not sure wha
On Wed, 2006-08-09 at 12:15 -0400, Bruce Momjian wrote:
> Well, either people post the changes publically or I trust a few people.
> I don't trust everyone or the TODO becomes a dumping ground, which I am
> afraid might happen with a wiki that anyone can update.
I think that's preventable, especia
Andrew Hammond wrote:
I am actually hoping that jabber.postgresql.org would help that in the
long run.
Jabber's ok, but why not go with SILC instead?
Because everything supports jabber, I only know of SILC and gaim that
support SILC :). Also Jabber is pretty much an accepted standard at this
Tom Lane wrote:
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
It would also be useful to have possible dependencies. I recently saw
a patch come across from Sun, that Tom commented on, something about
increase the size of some value to 64bit. I don't recall exactly.
Tom's comments although val
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Seems like this probably ought to round up not down:
> I thought about that, but because statement_timeout is in millis, and
> not micros, we can't have a value that gets rounded down. I am
> thinking a cleaner solution is to check f
On 8/9/06, Tom Lane <[EMAIL PROTECTED]> wrote:
UPDATE tries to place the new tuple on the same page it's already
on.
I think he meant for INSERT.
--
Jonah H. Harris, Software Architect | phone: 732.331.1300
EnterpriseDB Corporation| fax: 732.331.1301
33 Wood Ave S, 2nd Floor
Tom Lane wrote:
>
> I'd turn that around: I think you are arguing for a way to change GUC
> settings on-the-fly for a single existing session, without cooperation
> from the client.
Ok, implemented that way would solve it (partially)
Something like pg_set_guc(pid int4, varname text, value text)
On Wed, Aug 09, 2006 at 12:17:44PM -0400, Andrew Dunstan wrote:
> Jim C. Nasby wrote:
> >Platypus just started failing...
> >http://pgbuildfarm.org/cgi-bin/show_log.pl?nm=platypus&dt=2006-08-09%2010:05:01
> >
> >Rest of the farm is looking pretty green, though, so I'm not sure what
> >to make of it
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> ! /* WaitForSingleObjectEx() uses milliseconds */
> > ! waittime = timerCommArea.value.it_value.tv_usec
> > / 1000 + timerCommArea.value.it_value.tv_sec * 1000;
>
> Seems like this
Heikki Linnakangas <[EMAIL PROTECTED]> writes:
> While thinking about index-organized-tables and similar ideas, it
> occurred to me that there's some low-hanging-fruit: maintaining cluster
> order on inserts by trying to place new heap tuples close to other
> similar tuples.
Doesn't this happen
> I am actually hoping that jabber.postgresql.org would help that in the
> long run.
Jabber's ok, but why not go with SILC instead?
---(end of broadcast)---
TIP 6: explain analyze is your friend
Bruce Momjian <[EMAIL PROTECTED]> writes:
! /* WaitForSingleObjectEx() uses milliseconds */
> ! waittime = timerCommArea.value.it_value.tv_usec
> / 1000 + timerCommArea.value.it_value.tv_sec * 1000;
Seems like this probably ought to round
Andreas Pflug <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> The other, probably more controversial bit of functionality is that there
>> needs to be a way to cause a backend to load a PL plugin shared library
>> without any cooperation from the connected client application.
> A similar issue ap
Csaba Nagy wrote:
On Tue, 2006-08-08 at 12:36, Constantin Teodorescu wrote:
We have tried PGStatement#setPrepareThreshold with 1 as the threshold
but it's not a good solution.
Actually is worst. Considering that you have 5 different query plans,
you are selecting approx. random one of them, no
Ühel kenal päeval, K, 2006-08-09 kell 13:56, kirjutas Jim C. Nasby:
> On Wed, Aug 09, 2006 at 07:33:35AM +, Markus Schiltknecht wrote:
> > Hello Alfranio,
> >
> > alfranio correia junior wrote:
> > >Of course not...
> > >It is impossible to build a replication system entirely by only using
> >
On Wed, Aug 09, 2006 at 03:33:21PM -0400, Joshua Reich wrote:
> >(Not sure how we'd implement that, seeing that ANALYZE currently works
> >on one table at a time, but it's probably doable --- and it'd fix the
> >fundamental problem for correlation statistics, which is how not to try
> >to collect s
-Original Message-
From: "Jim C. Nasby" <[EMAIL PROTECTED]>
To: "Bruce Momjian" <[EMAIL PROTECTED]>
Cc: "Josh Berkus" ; "Christopher Browne" <[EMAIL
PROTECTED]>; "pgsql-hackers@postgresql.org"
Sent: 09/08/06 17:00
Subject: Re: [HACKERS] 8.2 features status
> One possibility: have a 'ho
(Not sure how we'd implement that, seeing that ANALYZE currently works
on one table at a time, but it's probably doable --- and it'd fix the
fundamental problem for correlation statistics, which is how not to try
to collect stats about an exponential number of combinations ...)
An exponential n
Jim C. Nasby wrote:
Been suggested before... the problem is actually doing something useful
with all that data that's collected, as well as how to collect it
without greatly impacting the system.
Identifying the best plan by means of actually running multiple plans and timing
them is useful.
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> It would also be useful to have possible dependencies. I recently saw
> a patch come across from Sun, that Tom commented on, something about
> increase the size of some value to 64bit. I don't recall exactly.
> Tom's comments although valid (as usual
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> On Wed, Aug 09, 2006 at 02:02:10PM +0200, Martijn van Oosterhout wrote:
>> Perhaps the way to go would be to allow users to declare columns often
>> used together and have ANALYSE collect information on correlation which
>> can be used later...
> One th
On Wed, Aug 09, 2006 at 02:02:10PM +0200, Martijn van Oosterhout wrote:
> On Wed, Aug 09, 2006 at 12:57:39PM +0200, Florian G. Pflug wrote:
> > Fixing the generic problem is surely the best _if_ there is a fix for
> > the generic problem at all. But if your where-conditions involves fields
> > from
Been suggested before... the problem is actually doing something useful
with all that data that's collected, as well as how to collect it
without greatly impacting the system.
On Tue, Aug 08, 2006 at 08:23:05AM -0700, Mark Dilger wrote:
> If this feature I'm proposing already exists, sorry for the
On Wed, Aug 09, 2006 at 07:33:35AM +, Markus Schiltknecht wrote:
> Hello Alfranio,
>
> alfranio correia junior wrote:
> >Of course not...
> >It is impossible to build a replication system entirely by only using
> >triggers...
>
> Hm, I don't think it's impossible, just unpractical. Anyway, if
On Wed, Aug 09, 2006 at 01:58:14PM -0400, Jonah H. Harris wrote:
> On 8/9/06, Devrim GUNDUZ <[EMAIL PROTECTED]> wrote:
> >Congratulations for your new job.
>
> Seconded!
We now have a quorum. ;)
I vote yes!
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778
Tom Lane wrote:
"Florian G. Pflug" <[EMAIL PROTECTED]> writes:
Image a complex, autogenerated query with looks something like this
select
from t1
join t2 on ...
join t3 on ...
join t4 on ...
...
...
where
.
This big, complicated expression looks different for every query - and
current
On Mon, Aug 07, 2006 at 10:47:39PM +0200, Lukas Smith wrote:
> Constantin Teodorescu wrote:
>
> >EXPLAIN VARIANTS SELECT .. (and so on) that will display the
> >different query plans analyzed by the planner and their "estimated time
> >values" , not just the "best guess" .
> >
> >assuming th
Jeff Davis <[EMAIL PROTECTED]> writes:
> I know this is a trivial question, but is there some kind of lock that
> would prevent the PG_fini for the plpgsql debugger from executing after
> "if(*plugin_ptr)" and before "((*plugin_ptr)->function_field)(...)"?
Backends are not multi-threaded.
On Wed, 2006-08-09 at 12:44 -0400, Tom Lane wrote:
> A plugin such as a plpgsql debugger would do this in its _PG_init()
> function:
>
> static PLpgSQL_plugin my_plugin = { ... function addresses ... };
>
> PLpgSQL_plugin **var_ptr;
>
> var_ptr = (PLpgSQL_plugin **) find_rendezvous_v
OK, so what do you want to do?
Oh, sure makes us deliver on our arguments. How very un open source of
you :).. Let me get with andrew and I will post back and actual
solidified idea.
Andrew and I are tabling this until I get back from LinuxWorld. We will
be discussing potential ideas to pr
Hello,
I will be basically unavailable from this Saturday until the 21st of
August. I will be spending a long week in SF at LinuxWorld West.
Please use email to contact me if it is important.
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Suppor
On 8/9/06, Devrim GUNDUZ <[EMAIL PROTECTED]> wrote:
Congratulations for your new job.
Seconded!
--
Jonah H. Harris, Software Architect | phone: 732.331.1300
EnterpriseDB Corporation| fax: 732.331.1301
33 Wood Ave S, 2nd Floor| [EMAIL PROTECTED]
Iselin, New Jersey 08830
On Wed, Aug 09, 2006 at 01:20:41PM -0400, Robert Treat wrote:
> Both time and varchar take an argument, but they have different typlen
> values.
> I don't think the docs are wrong here, I think they just don't tell me what I
> am looking for.
Oh, you're referring to typmod values. All those a
Hello Andrew,
On Wed, 2006-08-09 at 12:25 -0400, Andrew Dunstan wrote:
> On August 1st I started work for Anchorage Capital LLC as a Senior
> Software Engineer.
Congratulations for your new job.
Cheers,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Co
Tom Lane wrote:
> The other, probably more controversial bit of functionality is that there
> needs to be a way to cause a backend to load a PL plugin shared library
> without any cooperation from the connected client application. For
> interactive use of a PL debugger it might be sufficient to te
On Wednesday 09 August 2006 10:53, Martijn van Oosterhout wrote:
> On Wed, Aug 09, 2006 at 10:44:22AM -0400, Robert Treat wrote:
> > Is there a way to determine which datatypes take a length argument (eg.
> > varchar, time, etc...) by looking in the system catalogs? pg_type doesnt
> > seem to have
Jim C. Nasby wrote:
4. Syntax must be as closer as plpgsql (declaration, assingment etc)
rather than any syntax that we have to learn :-)
PostgreSQL support other languages than PL/pgSQL. We need universal syntax
for plperl and others too
Why? Don't those other languages have suppo
Bruce Momjian wrote:
I am keeping URLs in the TODO list. Why don't people submit
improvements to the TODO list, rather than adding more complexity by
making a separate wiki for every TODO item? If no one updates the TODO
item, what makes you think they are going to do somethin in a wiki?
W
David Fetter <[EMAIL PROTECTED]> writes:
> However, there are some oddities:
> postgres=# SELECT * FROM (VALUES (1,2)) AS foo(bar,baz);
> [ works ]
> postgres=# (VALUES (1,2)) AS foo(bar,baz);
> ERROR: syntax error at or near "AS"
This is per spec. Effectively, AS is part of the FROM-clause synt
3. Heck *your portion* of the TODO would be easily satisfied by having a
single line with a link that points to the specific wiki page.
But who is going to do that if no one has done anything in the past for
the TODO list. I keep asking that.
I believe that Andrew and I as well as a few others
From: "Jim C. Nasby" <[EMAIL PROTECTED]>
To: Pavel Stehule <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED], pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] proposal for PL packages for 8.3.
Date: Wed, 9 Aug 2006 11:27:01 -0500
On Wed, Aug 09, 2006 at 06:34:16AM +0200, Pavel Stehule wrote:
> >
Heikki Linnakangas wrote:
> Bruce Momjian wrote:
> > I am keeping URLs in the TODO list. Why don't people submit
> > improvements to the TODO list, rather than adding more complexity by
> > making a separate wiki for every TODO item? If no one updates the TODO
> > item, what makes you think they
Yesterday I suggested that we should redesign the PL plugin patch:
http://archives.postgresql.org/pgsql-patches/2006-07/msg00291.php
in view of the recently-committed patch to add initialization/
finalization support for all dynamic libraries loaded into the backend:
http://archives.postgresql.org/
Joshua D. Drake wrote:
> >> 1. Better descriptions about the todo/feature? E.g; feature specification
> >
> > I am not sure there is enough churn of TODO items to make larger
> > descriptions worth it. As it is, I have to link to new URLs as the TODO
> > item is clarified.
>
> Are you kidding? D
1. Better descriptions about the todo/feature? E.g; feature specification
I am not sure there is enough churn of TODO items to make larger
descriptions worth it. As it is, I have to link to new URLs as the TODO
item is clarified.
Are you kidding? Did you see the discussion just on the todo it
Joshua D. Drake wrote:
> Bruce Momjian wrote:
> > Joshua D. Drake wrote:
> Until you have used this, it seems strange. After you start it doesn't
> ;-)
> >>> Sure, but with openness comes cruft, which can be a problem too. Do we
> >>> want everyone's idea of a useful feature listed? I
On Wed, Aug 09, 2006 at 06:34:16AM +0200, Pavel Stehule wrote:
> > Is it would be nice , if packages have been ;
>
> > 1. Package level variables (Public variables)
>
> is very hard for imlementation, and it's actually impossible. Needs large
> changes in code
> > 2. Package member level vari
A number of people have asked me about this, so I'll just post the info
publicly.
On August 1st I started work for Anchorage Capital LLC as a Senior
Software Engineer. I am currently doing some urgent infrastructure work,
but in the longer term this job will involve some quite heavy lifting
1 - 100 of 157 matches
Mail list logo
