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 MV
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 thi
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 t
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
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
"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 some
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 i
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 *
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 p
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 ad
Ü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
Ü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
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
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() re
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 n
>
> 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,
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
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
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 PRO
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
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 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
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
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 /
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 broadcas
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
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)--
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
defin
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
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
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 incl
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 :).
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
> compli
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
m
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
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 do
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* inclusion
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 developme
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 coverag
>
> 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 nee
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 effective
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 d
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 tha
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 surprisingly.
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
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 welcom
-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.
On Sun, Jul 16, 2006 at 06:49:26PM -0400, Andrew Dunstan wrote:
> We also classify buildfarm machines by 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 using it:
# perl -MConfig -e
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?
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,
51 matches
Mail list logo