-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 Junior High
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
---(end of
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 though.
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
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
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?
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
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.
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 syntactical
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 format
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.
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, though
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
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
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 in section 8.5.1.4 of the
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.
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 repeatedly
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
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
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
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 commands
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 16 days' ?
Please read the last
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.
--
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
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 default behavior
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:
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 vanishingly
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 have a
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);
Could
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 one of them
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't
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 migration is
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
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
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
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
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
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 :)
I *GRADUATED* High School
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.
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, thank you.
LER
--
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 ATT 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 :)
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
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, 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,
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, 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
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
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 migration for
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
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
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
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 with
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
;)
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 example
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 pretty
dangerous
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
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
57 matches
Mail list logo
