On Sun, 19 Feb 2006, Thomas Hallgren wrote:
Marc G. Fournier wrote:
I've repeatedly asked for help moving my PL/Java stuff over to pgfoundry
and offered my help in the process, claiming that the CVS repository and
the mailing list are what really matters. I'd be fairly upset if gborg was
Marc G. Fournier wrote:
I've repeatedly asked for help moving my PL/Java stuff over to
pgfoundry and offered my help in the process, claiming that the CVS
repository and the mailing list are what really matters. I'd be
fairly upset if gborg was shut down without that happening. FTP
archive
> Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> > I suggest that PQescapeString() should have a parameter to specify the
> > encoding of "to".
>
> You mean the encoding of "from", no?
Oops, "from", yes.
> But actually I'd argue that
> letting the client programmer supply the encoding is still a pre
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> I suggest that PQescapeString() should have a parameter to specify the
> encoding of "to".
You mean the encoding of "from", no? But actually I'd argue that
letting the client programmer supply the encoding is still a pretty
dangerous practice. Your exam
On Sat, 18 Feb 2006, Joshua D. Drake wrote:
don't feel upset, that time I already learned how to control missile :)
Ack, you were one of those in the missile silo's?? Definitely not a job
I'd envy anyone :(
I doubt that if her were still doing it, that he would be allowed to tell us
;)
elein <[EMAIL PROTECTED]> writes:
> I've got a domain based on a text type.
> I've overridden the equal operator with
> lower(text) = lower(text).
This won't work, you need to make a type instead.
> If this is the way domains really are, I would strongly suggest
> expanding create domain to merge
On Sat, 18 Feb 2006, Marc G. Fournier wrote:
On Sat, 18 Feb 2006, Oleg Bartunov wrote:
On Sat, 18 Feb 2006, Marc G. Fournier wrote:
On Fri, 17 Feb 2006, Joshua D. Drake wrote:
Anyone able to beat that?
Sorry, I was still in Junior High in '82 :( Man, you are *old* :)
At Marc hand
I believe PQescapeString() has an important design bug and it casues a
security risk.
The function's signature is:
size_t PQescapeString (char *to, const char *from, size_t length);
As you might notice, it's impossible to specify encoding of "to". As a
result, it turns every occurrences of 0x
I've got a domain based on a text type.
I've overridden the equal operator with
lower(text) = lower(text).
I created a table containing my new domain type
and can see that the equals operator is not
being used to determine uniqueness.
What do I need to do to force the UNIQUE constraint
to use the
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED]
("Joshua D. Drake") transmitted:
>>>
>>> Slony-I would move there fairly quickly upon availability of SVN; a
>>> lot of our folks would be pretty keen on storing things in SVN.
>>> *That* is about the only thing holding off mi
On Sat, 18 Feb 2006, Thomas Hallgren wrote:
Bruce Momjian wrote:
Having run had both pgfoundary and gborg for several years, I think we
have to conclude that any clean migration is never going to happen, so
let's just pick a server and announce date, and shut one of them off.
Just before shutt
On Sat, 18 Feb 2006, Joshua D. Drake wrote:
Slony-I would move there fairly quickly upon availability of SVN; a
lot of our folks would be pretty keen on storing things in SVN.
*That* is about the only thing holding off migration for at least one
project...
SVN is installed on the pgFoundry
Slony-I would move there fairly quickly upon availability of SVN; a
lot of our folks would be pretty keen on storing things in SVN.
*That* is about the only thing holding off migration for at least one
project...
SVN is installed on the pgFoundry server, but I think getting
pgFoundry to use
On Sat, 18 Feb 2006, Christopher Browne wrote:
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Andrew Dunstan)
would write:
If we could get to be running pgFoundry on the latest GForge, with
PHP/CGI enabled project web pages, a database per project available,
SVN as well as CVS, and
don't feel upset, that time I already learned how to control missile :)
Ack, you were one of those in the missile silo's?? Definitely not a
job I'd envy anyone :(
I doubt that if her were still doing it, that he would be allowed to
tell us ;)
Joshua D. Drake
Marc G. Fournier
On Sat, 18 Feb 2006, Oleg Bartunov wrote:
On Sat, 18 Feb 2006, Marc G. Fournier wrote:
On Fri, 17 Feb 2006, Joshua D. Drake wrote:
Anyone able to beat that?
Sorry, I was still in Junior High in '82 :( Man, you are *old* :)
At Marc hands himself a foot gun... I was 9 years old in 82
On Sat, 18 Feb 2006, Lamar Owen wrote:
So, as to Usenet, earliest documented date is May 1992. Ran a leaf node
with Waffle for a while, then an AT&T 3B1 later, running C News and
SMail.
The skypod.UUCP email that I posted earlier was on a friends 3B2 machine
... my first Unix account :)
--
Joshua D. Drake wrote:
>>> damn, now *I* feel old :)
>>>
>>>
>> I *GRADUATED* High School in 1975.
>>
> Can you still walk without a cane?
>
> /me laughs as Larry chases after him with his cane, swearing about
> whipper snappers.
>
>> Started posting on UseNet in 1988.
>>
>> LER
Quite well,
damn, now *I* feel old :)
I *GRADUATED* High School in 1975.
Can you still walk without a cane?
/me laughs as Larry chases after him with his cane, swearing about
whipper snappers.
Started posting on UseNet in 1988.
LER
--
The PostgreSQL Company - Command Prompt, Inc. 1.
Marc G. Fournier wrote:
> On Fri, 17 Feb 2006, Joshua D. Drake wrote:
>
>>
Anyone able to beat that?
>>>
>>> Sorry, I was still in Junior High in '82 :( Man, you are *old* :)
>>>
>>
>> At Marc hands himself a foot gun... I was 9 years old in 82.
>
> damn, now *I* feel old :)
Bruce Momjian wrote:
Tom Lane wrote:
Thomas Hallgren <[EMAIL PROTECTED]> writes:
Bruce Momjian wrote:
Having run had both pgfoundary and gborg for several years, I think we
have to conclude that any clean migration is never going to happen, so
let's just pick a server and announce date, and
This is not "get everything everyone wants before shutting down a site"
time. We should move to one site, and if the new site is not to
someone's liking, there is always sourceforge and other hosting sites.
I do agree with Bruce here but... we need to make sure that
we give everyone their d
Christopher Browne wrote:
> Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Andrew Dunstan)
> would write:
> > If we could get to be running pgFoundry on the latest GForge, with
> > PHP/CGI enabled project web pages, a database per project available,
> > SVN as well as CVS, and a known
Christopher Browne wrote:
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Andrew Dunstan)
would write:
If we could get to be running pgFoundry on the latest GForge, with
PHP/CGI enabled project web pages, a database per project available,
SVN as well as CVS, and a known stable mai
A long time ago, in a galaxy far, far away, pgman@candle.pha.pa.us (Bruce
Momjian) wrote:
> Tom Lane wrote:
>> Thomas Hallgren <[EMAIL PROTECTED]> writes:
>> > Bruce Momjian wrote:
>> >> Having run had both pgfoundary and gborg for several years, I think we
>> >> have to conclude that any clean mi
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Andrew Dunstan)
would write:
> If we could get to be running pgFoundry on the latest GForge, with
> PHP/CGI enabled project web pages, a database per project available,
> SVN as well as CVS, and a known stable mailman release we'd be in
>
Andrew Dunstan wrote:
> If we could get to be running pgFoundry on the latest GForge, with
> PHP/CGI enabled project web pages, a database per project available, SVN
> as well as CVS, and a known stable mailman release we'd be in excellent
> shape.
>
> I'd rather move forwards than back.
I don
Tom Lane wrote:
> Thomas Hallgren <[EMAIL PROTECTED]> writes:
> > Bruce Momjian wrote:
> >> Having run had both pgfoundary and gborg for several years, I think we
> >> have to conclude that any clean migration is never going to happen, so
> >> let's just pick a server and announce date, and shut on
On Fri, Feb 03, 2006 at 08:05:48AM -0500, Mark Woodward wrote:
> Like I said, in this thread of posts, yes there are ways of doing this,
> and I've been doing it for years. It is just one of the rough eges that I
> think could be smoother.
>
> (in php)
> pg_connect("dbname=geo host=dbserver");
>
On Sat, Feb 18, 2006 at 12:19:39PM -0700, Michael Fuhr wrote:
> On Sat, Feb 18, 2006 at 07:52:22PM +0100, Martijn van Oosterhout wrote:
> > A little while ago there was someone asking for tools to make it easier
> > to connect to multiple servers. It occured to me that it might be
> > useful to hav
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> This needs a LOT more prominence. We probably need to refer to these
> things on the manual pages for each of the libpq clients we have.
> Haven't we learned that lesson from .pgpass ? The number of people who
> read the libpq docs is probably vanishi
Michael Fuhr wrote:
On Sat, Feb 18, 2006 at 07:52:22PM +0100, Martijn van Oosterhout wrote:
A little while ago there was someone asking for tools to make it easier
to connect to multiple servers. It occured to me that it might be
useful to have a config file the way ssh does it:
Som
Martin Pitt <[EMAIL PROTECTED]> writes:
> Tom Lane [2006-02-18 13:32 -0500]:
>> Martin Pitt <[EMAIL PROTECTED]> writes:
>>> The core problem is that we want to not restore objects (mainly
>>> tables) in the destination database which already exist.
>>
>> Why is this a problem? It's already the def
On Sat, Feb 18, 2006 at 07:52:22PM +0100, Martijn van Oosterhout wrote:
> A little while ago there was someone asking for tools to make it easier
> to connect to multiple servers. It occured to me that it might be
> useful to have a config file the way ssh does it:
Something like pg_service.conf?
Joshua D. Drake wrote:
Indeed, we haven't made any particular effort to encourage gborg
projects to move. I think it's a bit premature to hold a gun to
their heads.
Well that is not exactly true. We have been encouraging gborg projects
to move for at least a year.
What we haven't done
Martijn van Oosterhout wrote:
> A little while ago there was someone asking for tools to make it
> easier to connect to multiple servers. It occured to me that it might
> be useful to have a config file the way ssh does it:
That looks suspiciously like the service facility that we already have.
-
On Sat, 18 Feb 2006, Tom Lane wrote:
> "Milen A. Radev" <[EMAIL PROTECTED]> writes:
> > Milorad Poluga :
> >>> SELECT '10 years 1 mons 1 days'::interval - '9 years 10 mons 15
> >>> days'::interval
> >>> ?column?
> >>> ---
> >>> 3 mons -14 days
> >>>
> >>> Why not '2 mons
Hi Tom!
Tom Lane [2006-02-18 13:32 -0500]:
> Martin Pitt <[EMAIL PROTECTED]> writes:
> > The core problem is that we want to not restore objects (mainly
> > tables) in the destination database which already exist.
>
> Why is this a problem? It's already the default behavior --- the
> creation co
Indeed, we haven't made any particular effort to encourage gborg
projects to move. I think it's a bit premature to hold a gun to
their heads.
Well that is not exactly true. We have been encouraging gborg projects
to move for at least a year.
What we haven't done is provided an easy means t
Hi,
A little while ago there was someone asking for tools to make it easier
to connect to multiple servers. It occured to me that it might be
useful to have a config file the way ssh does it:
Host production
ServerName db1
DBName main
Usernameblah
Passwordblah
UseSSL
On Sat, Feb 18, 2006 at 09:31:18AM -0500, Bruce Momjian wrote:
> Having run had both pgfoundary and gborg for several years, I think we
> have to conclude that any clean migration is never going to happen, so
> let's just pick a server and announce date, and shut one of them off.
Well, first you n
Thomas Hallgren <[EMAIL PROTECTED]> writes:
> Bruce Momjian wrote:
>> Having run had both pgfoundary and gborg for several years, I think we
>> have to conclude that any clean migration is never going to happen, so
>> let's just pick a server and announce date, and shut one of them off.
> I've rep
Martin Pitt <[EMAIL PROTECTED]> writes:
> The core problem is that we want to not restore objects (mainly
> tables) in the destination database which already exist.
Why is this a problem? It's already the default behavior --- the
creation commands fail but pg_restore keeps going.
"Milen A. Radev" <[EMAIL PROTECTED]> writes:
> Milorad Poluga напиÑа:
>>> SELECT '10 years 1 mons 1 days'::interval - '9 years 10 mons 15
>>> days'::interval
>>> ?column?
>>> ---
>>> 3 mons -14 days
>>>
>>> Why not '2 mons 16 days' ?
> Please read the last paragraph
Lamar Owen <[EMAIL PROTECTED]> writes:
> So, Tom, did you enjoy being linked with the Backbone Cabal? What part did
> you play in the Great Renaming?
CMU was never part of the Usenet backbone, really. The backbone was the
sites that did the bulk of the work in passing news to places that had
to
On Saturday 18 February 2006 12:16, Michael Fuhr wrote:
> On Sat, Feb 18, 2006 at 09:28:58AM -0500, Lamar Owen wrote:
> > In 1982 I was doing hexadecimal machine code on that TRS-80 Model III,
> > whose non-disk boot lines you quote. My favorite Z80 joke:
> > 01
> > 110100
> > 21
> > EDB0
On Sat, Feb 18, 2006 at 09:28:58AM -0500, Lamar Owen wrote:
> In 1982 I was doing hexadecimal machine code on that TRS-80 Model III, whose
> non-disk boot lines you quote. My favorite Z80 joke:
> 01
> 110100
> 21
> EDB0
> (Punchline: one-track mind.)
Heh heh :-) Did plenty of that, tho
At 08:37 PM 2/15/2006, Dann Corbit wrote:
Adding some randomness to the selection of the pivot is a known
technique to fix the oddball partitions problem.
True, but it makes QuickSort slower than say MergeSort because of the
expense of the PRNG being called ~O(lgN) times during a sort.
How
Josh,
On 2/18/06 7:38 AM, "Luke Lonergan" <[EMAIL PROTECTED]> wrote:
> I figure they'll have to do quite a lot to make progress in their chosen
> market, including:
>
> - SQL*Net protocol compatibility
> - Oracle Number datatype support
> - ROWID unique row identifier
> - Oracle Redo/Undo log fo
Josh,
On 2/18/06 7:15 AM, "Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
> EnterpriseDB is a fork of PostgreSQL that contains a reasonable level of
> pl/SQL (Oracle) compatibility.
> My understanding (and I could be wrong) is that they support packages,
> in, inout paramters etc.. in
> the same syn
I also wonder where their project is too - they seem publicly opaque about
progress, etc. From the web site's statements it looks like they've written
a tool to tune the postgresql.conf file from which they claim a 50%
speed-up, but that's not new or unique "fork-level" functionality.
Ente
Bruce Momjian wrote:
Having run had both pgfoundary and gborg for several years, I think we
have to conclude that any clean migration is never going to happen, so
let's just pick a server and announce date, and shut one of them off.
Just before shutting it off, we should dump the existing projec
On Friday 17 February 2006 20:44, Michael Fuhr wrote:
> On Fri, Feb 17, 2006 at 09:35:32PM -0400, Marc G. Fournier wrote:
> > Sorry, I was still in Junior High in '82 :( Man, you are *old* :)
>
> Anybody know some reasonable postgresql.conf settings for a system
> that starts up with
>
> Cass?
>
Having run had both pgfoundary and gborg for several years, I think we
have to conclude that any clean migration is never going to happen, so
let's just pick a server and announce date, and shut one of them off.
Just before shutting it off, we should dump the existing project
information to an FTP
Hi PostgreSQL developers!
On [1], Stephen and I are currently discussing how to provide seamless
automatic version upgrades of PostgreSQL databases with third party
modules like PostGIS.
The core problem is that we want to not restore objects (mainly
tables) in the destination database which alre
Jonah H. Harris said:
> /me was 1 year old in 1982
>
my *son* (whose name is Tom btw ;-) ) was 3 yrs old in '82 ...
:-)
As for the "first used Usenet" thing, I am fairly sure I used it or
something very like it during "The VAX years", probably around '87. The
earliest record I can find is '91 th
Joshua D. Drake schrieb:
>
>>>
>>>
>>> Anyone able to beat that?
>>
>>
>> Sorry, I was still in Junior High in '82 :( Man, you are *old* :)
>>
>
> At Marc hands himself a foot gun... I was 9 years old in 82.
cool. You too? :-) 1973 must have been a great year .-)
Tino
-Original Message-
From: [EMAIL PROTECTED] on behalf of Joshua D. Drake
Sent: Sat 2/18/2006 4:09 AM
To: Marc G. Fournier
Cc: Tom Lane; Bruce Momjian; PostgreSQL-development
Subject: Re: [HACKERS] Updated email signature
>>
>>
>> Anyone able to beat that?
>
> Sorry, I was still in Juni
58 matches
Mail list logo