Michael Fuhr [EMAIL PROTECTED] writes:
On Mon, Jul 17, 2006 at 12:25:09AM -0500, Jaime Casanova wrote:
i found this on the Monitoring section:
o Allow protocol-level BIND parameter values to be logged
http://archives.postgresql.org/pgsql-hackers/2006-02/msg00165.php
But i don't understand
unsubscribe
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Am Montag, 17. Juli 2006 03:18 schrieb Joshua D. Drake:
We were going to submit plPHP to core for inclusion but it is not ready
yet.
Is there enough interest in plRuby to get it where it needs to be for
possible inclusion into core?
Considering that PL/Java effectively just got shot down, I
Am Freitag, den 14.07.2006, 16:26 +0200 schrieb Bernd Helmle:
--On Freitag, Juli 14, 2006 01:23:11 +0200 Peter Eisentraut
[EMAIL PROTECTED] wrote:
. multiple values clauses for INSERT
Susanne Ebrecht [EMAIL PROTECTED] was last heard to work on
it. Updates, Susanne?
I've talked
On Sun, Jul 16, 2006 at 06:49:26PM -0400, Andrew Dunstan wrote:
We also classify buildfarm machines by os, os_version, compiler,
compiler_version and config.guess doesn't give us that, unfortunately.
It would seem to be a lot easier to use the values from perl itself,
given you're already
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
http://archives.postgresql.org/pgsql-www/2006-07/msg00061.php
Yeah. I think the TODO item is intended to point to what is now
http://archives.postgresql.org/pgsql-hackers/2006-02/msg00163.php
or one of the earlier messages in that thread.
Hello all,
I'm working with pl/python and I'd like to use the set returning
function feature.
I'm not working in a debug python, so the iterator bug is not a problem me.
Can someone point me to some plpython.c setof enabled sources?
Hint to build them in an ubuntu dapper environment are welcome
Hello
What are the possibilities (if any) for continuous dataflow streaming
with PostgreSQL v.8.1 ? Something like TelegraphCQ project,but it was
for v.7.3.Is there any alternatives for the latest version of
PostgreSQL ?
Sincerely
--
Dragan Zubac
I'm fairly familiar with it :-)
The trouble is that it gives info set at the time perl was compiled,
which doesn't help with the problem where a machine has been upgraded.
For example, on this FC3 machine it reports a different kernel version
from the one I have upgraded to, not
Peter Eisentraut wrote:
Am Montag, 17. Juli 2006 03:18 schrieb Joshua D. Drake:
We were going to submit plPHP to core for inclusion but it is not ready
yet.
Is there enough interest in plRuby to get it where it needs to be for
possible inclusion into core?
Considering
On Mon, Jul 17, 2006 at 09:06:34AM -0400, Andrew Dunstan wrote:
I'm fairly familiar with it :-)
The trouble is that it gives info set at the time perl was compiled,
which doesn't help with the problem where a machine has been upgraded.
For example, on this FC3 machine it reports a
Peter Eisentraut wrote:
Am Montag, 17. Juli 2006 03:18 schrieb Joshua D. Drake:
We were going to submit plPHP to core for inclusion but it is not ready
yet.
Is there enough interest in plRuby to get it where it needs to be for
possible inclusion into core?
Considering that PL/Java
On UNIX systems uname may work pretty well. But I guess each
system may
have slightly different options. What'll probably happen is that you
end up with a big if() statement testing $Config{osname} wtih
each case
having specific code to determine the specifics. But for that you need
Andrew Dunstan wrote:
But the reasons that applied to PL/Java (masses of non-C code was the
main one) probably don't apply in these 2 cases.
I don't think it's the amount of non-C code; it's the amount of code
that no one understands. Plus, an argument *for* inclusion was build
farm
Joshua D. Drake wrote:
PLRuby is written in C.
Specifically on the matter of PL/Ruby -- and if you're trying to be such
an advocate about it, you should at least spell it right -- I have
never seen the author particularly active within this community, so I
have my doubts whether the
Peter Eisentraut wrote:
Andrew Dunstan wrote:
But the reasons that applied to PL/Java (masses of non-C code was the
main one) probably don't apply in these 2 cases.
I don't think it's the amount of non-C code; it's the amount of code
that no one understands. Plus, an argument *for*
Peter Eisentraut wrote:
Joshua D. Drake wrote:
PLRuby is written in C.
Specifically on the matter of PL/Ruby -- and if you're trying to be such
an advocate about it, you should at least spell it right -- I have
never seen the author particularly active within this community, so I
have my
Peter Eisentraut wrote:
Andrew Dunstan wrote:
But the reasons that applied to PL/Java (masses of non-C code was the
main one) probably don't apply in these 2 cases.
I don't think it's the amount of non-C code; it's the amount of code
that no one understands. Plus, an argument *for*
And lastly, if we are not going to include these in core, I repeat what
I said before: we need to undertake some *serious* evangelising to major
packagers to get them to build more than just the core among their
standard packages.
Andrew I keep seeing this, but what major packagers are we
Dragan,
What are the possibilities (if any) for continuous dataflow streaming with
PostgreSQL v.8.1 ? Something like TelegraphCQ project,but it was for
v.7.3.Is there any alternatives for the latest version of PostgreSQL ?
The TelegraphCQ team has stopped public development. So it's pretty
Peter,
I don't think it's the amount of non-C code; it's the amount of code
that no one understands. Plus, an argument *for* inclusion was build
farm coverage, which I understand will be solved in a different way,
applicable to all external modules. Another argument was buzzword
However, the lack of a maintainer who is an active participant in the
community is a serious drawback ... probably even a fatal one. Josh, is
there a reason why the PL/Ruby hacker doesn't want to play with us?
I don't think it is, doesn't want to play with us. I think he just
doesn't :).
On Mon, 2006-07-17 at 10:11 -0700, Josh Berkus wrote:
On the other hand, if we include PL/Perl, Tcl and Python but exclude Ruby
from the main package we are effectively making a statement to Ruby users
that their language is inferior in our consideration.
Hardly -- no more so than not
Hi,
I use the cube datatype a fair bit, and one thing I have always wanted
is the ability to do this:
pg=# select cube_from_arrays('{1,2,3}'::float[], '{3,5,6}'::float[]);
cube_from_arrays
-
(1, 2, 3),(3, 5, 6)
(1 row)
That is - build a cube by specifying 2 arrays, one
Joshua Reich [EMAIL PROTECTED] writes:
... build a cube by specifying 2 arrays, one for the UR
coordinate, one for LL.
I hope people find this useful, and if so, we can add it to contrib/cube.
Seems useful, but it needs work: it will fail on toasted arrays or
arrays containing nulls. I'd
Ah-hah, I see it. pgwin32_select() uses WaitForMultipleObjectsEx() with
an event for the socket read-ready plus an event for signal arrival.
It returns EINTR if the return code from WaitForMultipleObjectsEx shows
the signal-arrival event as fired. However, WaitForMultipleObjectsEx is
I would like to implement Mark change-on-restart-only values in
postgresql.conf item. Anybody works on this? Does it mean add extra
comment to postgresql.conf for variable which has PG_POSTMASTER context?
Zdenek
---(end of broadcast)---
Zdenek,
I would like to implement Mark change-on-restart-only values in
postgresql.conf item. Anybody works on this? Does it mean add extra
comment to postgresql.conf for variable which has PG_POSTMASTER context?
Somehow I thought you'd already submitted a patch?
--
--Josh
Josh Berkus
Neil,
(FWIW, I'd be fairly comfortable hacking on PL/Ruby, as I have some
prior experience with Ruby and its C API.)
Well, if you're willing to be a maintainer, that removes a major roadblock.
--
--Josh
Josh Berkus
PostgreSQL @ Sun
San Francisco
---(end of
FYI, I updated pginclude/README to explain the complexity of
removing includes from include files:
pgfixinclude
sort include references
run multiple times:
pgcompinclude
pgrminclude /src/include
pgrminclude /
Josh Berkus wrote:
Zdenek,
I would like to implement Mark change-on-restart-only values in
postgresql.conf item. Anybody works on this? Does it mean add extra
comment to postgresql.conf for variable which has PG_POSTMASTER context?
Somehow I thought you'd already submitted a patch?
I sent
On Mon, Jul 17, 2006 at 11:06:50AM -0400, Bort, Paul wrote:
If you can open a command shell you can get the OS version with the
'ver' command under Windows:
C:\ver
Microsoft Windows XP [Version 5.1.2600]
How do you do this from a program though. Under UNIX uname() is a
function call as
On Mon, Jul 17, 2006 at 12:18:46PM -0400, Andrew Dunstan wrote:
Well, I am not making any promises right now about when buildfarm will
support external modules.
I've been playing with the idea of having a subdirectory named extras
with descriptor files describing how to fetch a project and
On Jul 17, 2006, at 12:57 PM, Martijn van Oosterhout wrote:
On Mon, Jul 17, 2006 at 11:06:50AM -0400, Bort, Paul wrote:
If you can open a command shell you can get the OS version with the
'ver' command under Windows:
C:\ver
Microsoft Windows XP [Version 5.1.2600]
How do you do this from a
Tom: Thanks for the out-of-band posting to the documentation. I think
the new version (attached) addresses your issues.
What is the general process for submitting patches? Is there a URL
someone can point me towards to learn more?
Thanks,
Josh Reich
Tom Lane wrote:
Joshua Reich [EMAIL
Matteo Bertini wrote:
Hello all,
I'm working with pl/python and I'd like to use the set returning
function feature.
I'm not working in a debug python, so the iterator bug is not a problem me.
Can someone point me to some plpython.c setof enabled sources?
Hint to build them in an ubuntu
Josh,
What is the general process for submitting patches? Is there a URL
someone can point me towards to learn more?
Send them in an e-mail to pgsql-patches.
--
--Josh
Josh Berkus
PostgreSQL @ Sun
San Francisco
---(end of broadcast)---
TIP 9:
How do you do this from a program though. Under UNIX uname() is a
function call as well as a program. It returns the os name, version,
hostname and system type.
Multiple methods (TIMTOWTDI) depending on what you want:
my $verstring = `cmd.exe /c ver`;
# or
use Win32;
my ($string,
Hi PostgreSQL developers,
some time ago I started a discussion [1] here about modifying pg_dump
to not restore TABLE DATA objects if the corresponding TABLE oject
failed to be created (usually because it already exists, but it might
fail due to a different error like a nonexisting data type). We
korry [EMAIL PROTECTED] writes:
The problem is that, each time you go through
pgwin32_waitforsinglesocket(), you tie the *same* kernel object
(waitevent is static) to each socket.
The fix is pretty simple - just call WSAEventSelect( s, waitevent, 0 )
after WaitForMultipleObjectsEx() returns.
Andrew Dunstan wrote:
Bernd Helmle wrote:
--On Freitag, Juli 14, 2006 01:23:11 +0200 Peter Eisentraut
[EMAIL PROTECTED] wrote:
. multiple values clauses for INSERT
Susanne Ebrecht [EMAIL PROTECTED] was last heard to work on
it. Updates, Susanne?
I've talked to Susanne today and she's
Ühel kenal päeval, E, 2006-07-17 kell 22:54, kirjutas Tino Wildenhain:
Matteo Bertini wrote:
Hello all,
I'm working with pl/python and I'd like to use the set returning
function feature.
I'm not working in a debug python, so the iterator bug is not a problem me.
Can someone point
Ühel kenal päeval, E, 2006-07-17 kell 22:01, kirjutas Martijn van
Oosterhout:
On Mon, Jul 17, 2006 at 12:18:46PM -0400, Andrew Dunstan wrote:
Well, I am not making any promises right now about when buildfarm will
support external modules.
I've been playing with the idea of having a
On Mon, 17 Jul 2006, Andrew Dunstan wrote:
And lastly, if we are not going to include these in core, I repeat what
I said before: we need to undertake some *serious* evangelising to major
packagers to get them to build more than just the core among their
standard packages.
Just because an
On Tue, 18 Jul 2006, Hannu Krosing wrote:
Ühel kenal päeval, E, 2006-07-17 kell 22:01, kirjutas Martijn van
Oosterhout:
On Mon, Jul 17, 2006 at 12:18:46PM -0400, Andrew Dunstan wrote:
Well, I am not making any promises right now about when buildfarm will
support external modules.
I've been
Joshua Reich [EMAIL PROTECTED] writes:
if (PG_ARGISNULL(0) || PG_ARGISNULL(1))
{
ereport(ERROR,
(errcode(ERRCODE_ARRAY_ELEMENT_ERROR),
errmsg(Cannot work with NULL arrays)));
}
This is useless code if the function is declared STRICT, as C functions
most often are. What you *do* need to be
Bruce Momjian [EMAIL PROTECTED] writes:
FYI, 527 include were removed from non-header C files in this run. That
is not something that can be easily done manually.
It's not so easily done automatically, either :-(. I'm not sure why
this go-round was so much more painful than the last, but it
Magnus Hagander [EMAIL PROTECTED] writes:
Per discussion at the conference:
In order to run the regression tests on Windows without msys, pg_regress
needs to be reimplemnted in C.
This has some minor portability issues (macros with ... aren't portable,
for instance) but I think it's something
Anyone have an opinion on the portability of the regular expression
functions defined in POSIX 1003.2,
http://www.opengroup.org/onlinepubs/007908799/xsh/regcomp.html
? In particular, do you know of any platforms we support that don't
have them?
The reason I'm asking is that to convert pg_regress
Tom Lane wrote:
Anyone have an opinion on the portability of the regular expression
functions defined in POSIX 1003.2,
http://www.opengroup.org/onlinepubs/007908799/xsh/regcomp.html
? In particular, do you know of any platforms we support that don't
have them?
The reason I'm asking is that to
Andrew Dunstan [EMAIL PROTECTED] writes:
Tom Lane wrote:
Anyone have an opinion on the portability of the regular expression
functions defined in POSIX 1003.2,
Does Windows come with POSIX regex libs? I would be a bit surprised.
When we discussed this at the conference I suggested to Magnus
From: Tom Lane [EMAIL PROTECTED]
Andrew Dunstan [EMAIL PROTECTED] writes:
Tom Lane wrote:
Anyone have an opinion on the portability of the regular expression
functions defined in POSIX 1003.2,
Does Windows come with POSIX regex libs? I would be a bit surprised.
When we discussed this at
Hello,
I did some work on mutliple value insert. First: SELECT .. UNION ALL SELECT
is wrong idea. VALUES can contain DEFAULT keyword. Second: It's neccessery
general implementation of table values constructor like SQL:2003. Main
problem what I see is biger request on sources if we implement
53 matches
Mail list logo
