On Thursday 02 May 2002 07:54 pm, Darren Johnson wrote:
> >databases. I am trying to find out more information about how to do
> > automatic replication with postgresql.
>
> We did some research on this several months ago, and published the
> results here
>
> http://gborg.postgresql.org/genpage?re
I hope you won't make this standard practice. Because there are quite
significant differences that make upgrading from 7.1.x to 7.2 troublesome.
I can't name them offhand but they've appeared on the list from time to time.
For 6.5.x to 7.1.x I believe there are smaller differences, even so ther
Lol
This gets my vote ;-)
Dali
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] On Behalf Of Dann Corbit
> Sent: Friday, 3 May 2002 14:33
> To: PostgreSQL-development
> Subject: Re: [HACKERS] PostgreSQL mission statement?
>
>
> Mission Statement:
> "To KICK
Boban Acimovic was kind enough to give me access to a Solaris 8 system
to track down a reproducible server crash. What I find is that strxfrm
is buggy on that system. Given locale is_IS.ISO8859-1, the call
strxfrm(, "pg_amop_opc_strategy_index", 58)
was observed to scribble on 108 byte
Jim Mercer wrote:
>
> On Thu, May 02, 2002 at 09:45:45PM -0400, mlw wrote:
> > Jim Mercer wrote:
> > > On Thu, May 02, 2002 at 09:14:03PM -0400, mlw wrote:
> > > > Jim Mercer wrote:
> > > > > On Thu, May 02, 2002 at 08:41:30PM -0400, mlw wrote:
> > > > > > A mission statement is like a tie.
> > >
Mission Statement:
"To KICK Gluteus Maximus!"
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Thu, May 02, 2002 at 09:45:45PM -0400, mlw wrote:
> Jim Mercer wrote:
> > On Thu, May 02, 2002 at 09:14:03PM -0400, mlw wrote:
> > > Jim Mercer wrote:
> > > > On Thu, May 02, 2002 at 08:41:30PM -0400, mlw wrote:
> > > > > A mission statement is like a tie.
> > > > who on the list wears ties?
>
Thomas Lockhart <[EMAIL PROTECTED]> writes:
>> That is, '60' is read as so many hours, '1.5' is read as so many
>> seconds. This seems a tad inconsistent.
> They fulfill two separate use cases. Time zones can now be specified as
> intervals, and the default unit must be hours. A number with a de
Jim Mercer wrote:
>
> On Thu, May 02, 2002 at 09:14:03PM -0400, mlw wrote:
> > Jim Mercer wrote:
> > >
> > > On Thu, May 02, 2002 at 08:41:30PM -0400, mlw wrote:
> > > > A mission statement is like a tie.
> > >
> > > straw vote!
> > >
> > > who on the list wears ties?
> >
> > How many people who
On Thu, May 02, 2002 at 09:14:03PM -0400, mlw wrote:
> Jim Mercer wrote:
> >
> > On Thu, May 02, 2002 at 08:41:30PM -0400, mlw wrote:
> > > A mission statement is like a tie.
> >
> > straw vote!
> >
> > who on the list wears ties?
>
> How many people who make IT decisions wear ties?
too many.
Jim Mercer wrote:
>
> On Thu, May 02, 2002 at 08:41:30PM -0400, mlw wrote:
> > A mission statement is like a tie.
>
> straw vote!
>
> who on the list wears ties?
How many people who make IT decisions wear ties?
---(end of broadcast)---
TIP 6: Ha
Manfred Koizar <[EMAIL PROTECTED]> writes:
> Let me throw in one of my infamous wild ideas in an attempt to rescue
> my proposal: We have 4 32-bit-numbers: xmin, cmin, xmax, and cmax.
> The only case, where we need cmin *and* cmax, is, when xmin == xmax.
> So if we find a single bit to flag this
(redirected to -hackers)
> > * Is there anything open about the DLM spec or code? I.e., could it
> > actually be used in a project like PostgreSQL?
The code is not open (despite the OpenDLM name :/
> > * Is there any open source equivalent?
http://oss.software.ibm.com/dlm/
> > * Have you loo
...
> That is, '60' is read as so many hours, '1.5' is read as so many
> seconds. This seems a tad inconsistent.
They fulfill two separate use cases. Time zones can now be specified as
intervals, and the default unit must be hours. A number with a decimal
point is usually in units of seconds, an
On Thu, May 02, 2002 at 08:41:30PM -0400, mlw wrote:
> A mission statement is like a tie.
straw vote!
who on the list wears ties?
--
[ Jim Mercer[EMAIL PROTECTED] +1 416 410-5633 ]
[ I want to live forever, or die trying.]
---(end o
Mark kirkwood wrote:
>
> On Fri, 2002-05-03 at 04:25, mlw wrote:
>
> >
> > IMHO, if we can come up with a strong, positive statement, it would help MBA
> > trained CIOs and CTOs choose PostgreSQL. To them, it will show a professional
> > minded development group, it will be recognizable to them.
>databases. I am trying to find out more information about how to do automatic
>replication with postgresql.
>
We did some research on this several months ago, and published the
results here
http://gborg.postgresql.org/genpage?replication_research
>
>
>
> My questions are :
>
>
...
> Now, I do not wish to have a manifesto, but a short and sweet "this is who we
> are, and this is what we do" could be a positive thing.
"PostgreSQL is the most advanced open-source database available
anywhere"
has appeared in the docs for quite some time, and has appeared in other
mention
Tom,
thanks for answering.
On Thu, 02 May 2002 17:16:38 -0400, you wrote:
>The hole in this logic is that there can be multiple active scans with
>different values of CurrentCommandId (eg, within a function
>CurrentCommandId may be different than it is outside). If you overwrite
>cmin with cmax
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
>
> Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> > Your settings probably worked well under 7.1 but
> > doesn't in 7.2 due to the following change in
> > tcop/postgres.c.
>
> AFAIR, there is only a visible change of behavior
On 2 May 2002, Jason Earl wrote:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
>
> > On Wed, 1 May 2002, David Terrell wrote:
> >
> > > On Wed, May 01, 2002 at 02:24:30PM -0400, mlw wrote:
> > > > Just out of curiosity, does PostgreSQL have a mission statement?
> > > >
> > > > If so, where could
On Fri, 2002-05-03 at 04:25, mlw wrote:
>
> IMHO, if we can come up with a strong, positive statement, it would help MBA
> trained CIOs and CTOs choose PostgreSQL. To them, it will show a professional
> minded development group, it will be recognizable to them.
I am not so sure about that -
In
Scott Marlowe <[EMAIL PROTECTED]> writes:
> On Wed, 1 May 2002, David Terrell wrote:
>
> > On Wed, May 01, 2002 at 02:24:30PM -0400, mlw wrote:
> > > Just out of curiosity, does PostgreSQL have a mission statement?
> > >
> > > If so, where could I find it?
> > >
> > > If not, does anyone see a
Ian Barwick <[EMAIL PROTECTED]> writes:
> i.e. user "joe" can see which objects exist in schema "foo2", even though
> he has no USAGE privilege. (Is this behaviour intended?)
It's open for debate I suppose. Historically we have not worried about
preventing people from looking into the system tab
In current sources:
regression=# select '60'::interval;
interval
--
00:01
(1 row)
regression=# select '1.5'::interval;
interval
-
00:00:01.50
(1 row)
That is, '60' is read as so many hours, '1.5' is read as so many
seconds. This seems a tad inconsistent.
7.2 does the
Manfred Koizar <[EMAIL PROTECTED]> writes:
> (3d) t_xmin == t_xmax == current transaction. The tuple has been
> inserted and then deleted by the current transaction. Then I claim
> (but I'm not absolutely sure), that insert and delete cannot have
> happened in the same command,
> so t_cmin < t_c
> We as developers do not need mission statements, per se' but it is
often useful
> as something to point to.
It's comforting and useful to point to; in addition, developers
work on something because of personal "itches" (to coin a phrase)
that happen to broadly overlap with the group
> IMHO,
On 2 May 2002, Hannu Krosing wrote:
> The Politically Correct mission statement follows:
>
> The PostgreSQL community is committed to creating and maintaining a good
> but not the best, mostly reliable, open-source multi-purpose standards
> based database, and with it, promote free and open so
mlw wrote:
> "Marc G. Fournier" wrote:
>
> > > BTW, I think PostgreSQL does _not_ need any mission statement.
> >
> > Nope, it doesn't ... never did before, don't know why it does suddenly ...
> > do any other open source projects have one? Its kinda fun to see what ppl
> > banter around, but I c
Dear Team,
This sounds good to me. Especially the comment about software patents.
Software source code can be written with different variable names and
slightly different coding styles. But when a specific function needs
implementation, often there is only one logical approach. If that approac
On Thu, May 02, 2002 at 05:28:36PM +0300, Oleg Bartunov wrote:
> On Wed, 1 May 2002, Jeffrey W. Baker wrote:
>
> > On Tue, Apr 30, 2002 at 09:41:47PM +0300, Oleg Bartunov wrote:
> > > I think DBD::Pg driver very much depends on system tables.
> > > Hope, Jeffrey (current maintainer) is online.
>
On Thursday 02 May 2002 12:04 pm, Steve King wrote:
> Is it possible to install postgresql 7.2.1 on to a red hat 7.1
> installation?
Yes. Please read README.rpm-dist in /usr/share/doc/postgresql-7.2.1 for
details on how to rebuild from the source RPM. You can then install the RPMs
you just bu
I am a bit new to postgresql. I have used it in a few applications, however,
in the current application we are beginning to see a need for replicated
databases. I am trying to find out more information about how to do automatic
replication with postgresql.
I have gone through t
On Wed, 1 May 2002, David Terrell wrote:
> On Wed, May 01, 2002 at 02:24:30PM -0400, mlw wrote:
> > Just out of curiosity, does PostgreSQL have a mission statement?
> >
> > If so, where could I find it?
> >
> > If not, does anyone see a need?
>
> "Provide a really good database and have fun do
Hi,
having been chased away from pgsql-novice by Rasmus Mohr, I come here
to try my luck :-) I'm still new to this; so please be patient, if I
ask silly questions.
There has been a discussion recently about saving some bytes per tuple
header. Well, I have the suspicion, we can eliminate 4 byt
"Marc G. Fournier" wrote:
> > BTW, I think PostgreSQL does _not_ need any mission statement.
>
> Nope, it doesn't ... never did before, don't know why it does suddenly ...
> do any other open source projects have one? Its kinda fun to see what ppl
> banter around, but I can't see it being usef
[ please try not to take this too seriously ]
On Thu, May 02, 2002 at 01:11:41PM -0300, Marc G. Fournier wrote:
> altho in most contexts, I would agree with Jim as to the use of 'The
> Best', for any mission statement to say anything other then that, IMHO,
> shows a lack of commitment ... I agr
I have postgres 7.0 working on a red hat 7.1 installation, but now need to
upgrade to postgres 7.2.1 to have the benefit of non-locking vacuuming.
Is it possible to install postgresql 7.2.1 on to a red hat 7.1 installation?
I've been trying but it complains that it can't find dependencies
libssl.
On Thu, 2 May 2002, Nigel J. Andrews wrote:
>
>
> Is this an indication of a need for [EMAIL PROTECTED]? :)
already exists as pgsql-advocacy :)
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On 2 May 2002, Hannu Krosing wrote:
> On Thu, 2002-05-02 at 14:37, Jim Mercer wrote:
> > On Thu, May 02, 2002 at 08:15:15AM -0400, mlw wrote:
> > > Who's that? Anyone disagree?
> >
> > why does it have to be THE BEST ? that is insulting to the other projects
> > like MySQL which while "competito
Jean-Michel POURE wrote:
>
> The PostgreSQL community is committed to creating and maintaining the best,
> most reliable, open-source multi-purpose standards based database, and with
> it, promote free(dom) and open source software world wide.
>
> I hope you don't mind writing "free(dom)" with t
On Thu, 2 May 2002, mlw wrote:
> Jim Mercer wrote:
> >
> > On Thu, May 02, 2002 at 08:15:15AM -0400, mlw wrote:
> > > Jean-Michel POURE wrote:
> > > > Le Jeudi 2 Mai 2002 01:59, David Terrell a écrit :
> > > > > "Provide a really good database and have fun doing it"
> > > >
> > > > PostgreSQL Com
On Thu, 2 May 2002, Louis-David Mitterrand wrote:
>
> Hi,
>
> On 7.2.1 debian-unstable PG hangs when trying to drop a table which
> contains a field referencing another field in the same table as a
> foreign key.
>
> Is it legal/orhtodox to use a "references" on another field of the same
> table?
Hannu Krosing <[EMAIL PROTECTED]> writes:
> Is "PROC array slot number" something internal to postgres ?
Yes.
If we used PID then we'd eventually have 64K (or whatever the range of
PIDs is on your platform) different pg_temp_nnn entries cluttering
pg_namespace. But we only need MaxBackends diff
On Thursday 02 May 2002 08:56 am, Jim Mercer wrote:
> i think a mission statement full of boastfulness is just a sound bite, and
> will be dismissed as such.
> if you want the mission statement to have an impact, then it needs to be
> acceptable not only to those who fully embrace it, but also ac
On Wed, 1 May 2002, Jeffrey W. Baker wrote:
>> These changes may break DBD::Pg. What is the expected
>> time of this release? I will review my code for impact.
I think the current plan is to go beta in late summer. So there's
no tremendous hurry. I was just sending out a wake-up call ...
The PostgreSQL community is committed to creating and maintaining the best,
most reliable, open-source multi-purpose standards based database, and with
it, promote free(dom) and open source software world wide.
I hope you don't mind writing "free(dom)" with the idea of fighting patent
abuses.
C
Louis-David Mitterrand <[EMAIL PROTECTED]> writes:
> On 7.2.1 debian-unstable PG hangs when trying to drop a table which
> contains a field referencing another field in the same table as a
> foreign key.
I'm a little confused. Could you post a complete example?
regards,
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> Here are the precise conditions to trigger the scenario:
> (1) the backend is PostgreSQL 6.5.x
> (2) multibyte support is enabled (--enable-multibyte)
> (3) the database encoding is SQL_ASCII (other encodings are not
> affected by the bug).
> (4) th
Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> Your settings probably worked well under 7.1 but
> doesn't in 7.2 due to the following change in
> tcop/postgres.c.
AFAIR, there is only a visible change of behavior for
INSERT/UPDATE/DELETE queries, not for SELECTs. So I don't think
this change explai
On Wed, 1 May 2002, Jeffrey W. Baker wrote:
> On Tue, Apr 30, 2002 at 09:41:47PM +0300, Oleg Bartunov wrote:
> > I think DBD::Pg driver very much depends on system tables.
> > Hope, Jeffrey (current maintainer) is online.
>
> These changes may break DBD::Pg. What is the expected
> time of this r
Lincoln Yeoh <[EMAIL PROTECTED]> writes:
> OK I'm starting to get it :). Will the index behaviour be changed soon?
When someone steps up and does it. I've learned not to predict
schedules for this project.
> Hmm, then what are the row tuple forward links for? Why forward?
Updates in READ COMMI
On Thu, 2002-05-02 at 15:48, Tom Lane wrote:
> Hannu Krosing <[EMAIL PROTECTED]> writes:
> > On Thu, 2002-05-02 at 05:33, Tom Lane wrote:
> >> The temp schema is pg_temp_nnn where nnn is your BackendId (PROC array
> >> slot number). AFAIK there isn't any exported way to determine your
> >> Backen
Andrew Sullivan <[EMAIL PROTECTED]> writes:
> ... In any case, I can't offer a definite
> answer about the 64-bit qsort for now.
Do you need to profile it? It seemed that the 32-bit behavior for
many-equal-keys was so bad that it'd be easy to tell whether it's
fixed, just by rough overall timing
Hannu Krosing <[EMAIL PROTECTED]> writes:
> On Thu, 2002-05-02 at 05:33, Tom Lane wrote:
>> The temp schema is pg_temp_nnn where nnn is your BackendId (PROC array
>> slot number). AFAIK there isn't any exported way to determine your
>> BackendId from an SQL query.
> The non-portable way on Linux
> > I don't know about you, but I want PostgreSQL to be the best, be
THE most
> > reliable. Omitting "best" or "most" from the statement means that
we should
> > all just give up now, because PostgreSQL is pretty damn good
already.
>
> i think a mission statement full of boastfulness is just a sou
On Thursday 02 May 2002 05:33, Tom Lane wrote:
[on establishing whether a relation is in the search path]
> This doesn't yield much insight about cases where the match pattern
> includes a (partial?) schema-name specification, though. If I'm
> allowed to write something like "\z s*.t*" to find t
On Tue, Apr 30, 2002 at 09:41:47PM +0300, Oleg Bartunov wrote:
> I think DBD::Pg driver very much depends on system tables.
> Hope, Jeffrey (current maintainer) is online.
These changes may break DBD::Pg. What is the expected
time of this release? I will review my code for impact.
Thanks for t
The following steps should fix the configure and
compile problems that was occuring with installing
Postgres 7.2 on HPUX 11.11. using the gcc compiler
(See below for reference posts)
for compiling postgres 7.2 or 7.2.1 on HPUX11.11
run ./configure
=> checking types of arguments for accept()...
> Oops. How about:
>
> foo'; DROP TABLE t1; -- foo
>
> The last ' gets removed, leaving -- (81a2).
>
> So you get:
> select ... '(0x81a2)'; DROP TABLE t1; -- (0x81a2)
This surely works:-< Ok, you gave me an enough example that shows even
7.1.x and 7.0.x are not safe.
Included are patches for
On Thu, 2002-05-02 at 14:37, Jim Mercer wrote:
> On Thu, May 02, 2002 at 08:15:15AM -0400, mlw wrote:
> > Who's that? Anyone disagree?
>
> why does it have to be THE BEST ? that is insulting to the other projects
> like MySQL which while "competitors" are also a valid and useful benchmark
> for
On Thu, May 02, 2002 at 01:43:39PM +0100, Nigel J. Andrews wrote:
> I like:
>
> We'll store your data; if we think it'll be an interesting enough
> diversion for us.
gets my vote.
8^)
--
[ Jim Mercer[EMAIL PROTECTED] +1 416 410-5633 ]
[ I want to live forever, or die
On Thu, May 02, 2002 at 08:43:04AM -0400, mlw wrote:
> Jim Mercer wrote:
> > why does it have to be THE BEST ? that is insulting to the other projects
> > like MySQL which while "competitors" are also a valid and useful benchmark
> > for features, performance and keeping the postgresql community
Jim Mercer wrote:
>
> On Thu, May 02, 2002 at 08:15:15AM -0400, mlw wrote:
> > Jean-Michel POURE wrote:
> > > Le Jeudi 2 Mai 2002 01:59, David Terrell a écrit :
> > > > "Provide a really good database and have fun doing it"
> > >
> > > PostgreSQL Community is commited to providing Humanity with t
Is this an indication of a need for [EMAIL PROTECTED]? :)
I like:
We'll store your data; if we think it'll be an interesting enough
diversion for us.
--
Nigel Andrews
On Thu, 2 May 2002, mlw wrote:
> Jean-Michel POURE wrote:
> >
> > Le Jeudi 2 Mai 2002 01:59, David Terrell a écrit :
> >
Hi,
On 7.2.1 debian-unstable PG hangs when trying to drop a table which
contains a field referencing another field in the same table as a
foreign key.
Is it legal/orhtodox to use a "references" on another field of the same
table?
Strangely after restarting PG the drop succeeds without hangin
On Thu, May 02, 2002 at 08:15:15AM -0400, mlw wrote:
> Jean-Michel POURE wrote:
> > Le Jeudi 2 Mai 2002 01:59, David Terrell a écrit :
> > > "Provide a really good database and have fun doing it"
> >
> > PostgreSQL Community is commited to providing Humanity with the best
> > multi-purpose, relia
Jean-Michel POURE wrote:
>
> Le Jeudi 2 Mai 2002 01:59, David Terrell a écrit :
> > "Provide a really good database and have fun doing it"
>
> PostgreSQL Community is commited to providing Humanity with the best
> multi-purpose, reliable, open-source and free database system.
The PostgreSQL co
mlw wrote:
>
> > "[EMAIL PROTECTED]" wrote:
> >
> > Dear Team,
> >
> > I have been monitoring this list for quite some time now and have been
> > studying PostGreSQL for a while. I also did some internet research on the
> > subject of "multi valued" database theory. I know that this is the basi
> "[EMAIL PROTECTED]" wrote:
>
> Dear Team,
>
> I have been monitoring this list for quite some time now and have been
> studying PostGreSQL for a while. I also did some internet research on the
> subject of "multi valued" database theory. I know that this is the basis for
> the "Pick" databas
Oops. How about:
foo'; DROP TABLE t1; -- foo
The last ' gets removed, leaving -- (81a2).
So you get:
select ... '(0x81a2)'; DROP TABLE t1; -- (0x81a2)
Would that work? Or do you need to put a semicolon after the --?
Alternatively would select (0x81a2) be a syntax error? If it isn't then
that
> Le Jeudi 2 Mai 2002 01:59, David Terrell a écrit :
> > "Provide a really good database and have fun doing it"
>
> PostgreSQL Community is commited to providing Humanity with the best
> multi-purpose, reliable, open-source and free database system.
>
How about "We can store your data" ?
Just
Le Jeudi 2 Mai 2002 01:59, David Terrell a écrit :
> "Provide a really good database and have fun doing it"
PostgreSQL Community is commited to providing Humanity with the best
multi-purpose, reliable, open-source and free database system.
---(end of broadcast)--
> Not tested: but how about the string being
> foo'; DROP TABLE T1; foo
>
> Would the last ' be eaten up then resulting in no error?
Even the last ' is eaten up, the remaining string is (81a2), which
would cause parser errors since they are not valid SQL, I think.
> Also normally a \ would be q
At 12:49 AM 5/2/02 -0400, Tom Lane wrote:
>Lincoln Yeoh <[EMAIL PROTECTED]> writes:
> > But does Postgresql visit the older tuples first moving to the newer ones,
> > or the newer ones first?
>
>It's going to visit them *all*. Reordering won't improve the
>performance.
Ack! I thought it went thr
Not tested: but how about the string being
foo'; DROP TABLE T1; foo
Would the last ' be eaten up then resulting in no error?
Also normally a \ would be quoted by \\ right? Would a foo\ result in an
unquoted \ ? An unquoted backslash may allow some possibilities.
There could be other ways to ge
There is a report from a debian user about a vulnerability in
PostgreSQL pre 7.2. Here is a possible attack scenario which allows to
execute ANY SQL in PostgreSQL.
A web application accepts an input as a part of SELECT qualification
clause. With the user input, the web server program would build
Hello:
I took a look at the SSL code in libpq/fe-misc.c and noticed what I
think is a small problem. A patch is included at the bottom of this
email against anoncvs TopOfTree this evening.
The SSL library buffers input data internally. Nowhere in libpq's code
is this buffer being checked v
Title: Message
Surely
the real strength of Pick, Unidata et al. is not so much the mv fields (which
can be relatively easily emulated using array types) but the data dictionaries
and the way the same field can be defined in multiple ways (data formats) with
different names, or that you can c
Dear Team,
I'm wide open to other ideas for the support of
robotic vision through tools already built into PostGreSQL. But you've
already admitted to certain speed limitations...and robotic vision is going to
require much more intense processing power. An MVD might allow the data
stream
80 matches
Mail list logo
