Alex Turner wrote:
Support for windows 98 was infact extended to June 2006:
http://support.microsoft.com/gp/lifean1
Right
And it was extended again last year as it was supposed to extend this
last June, and Last June, etc. We will see if it is not extended again
But if you are run
Scott Marlowe wrote:
On Wed, 2005-10-05 at 20:37, CSN wrote:
Just so I know (and am armed ;) ), are there any new
comparable features in MySQL 5.0 that aren't in
PostgreSQL up to the forthcoming 8.1? AFAIK, PG just
lacks updatable views (which are on the TODO).
Instance Manager: Uni
Tony Caduto wrote:
On Wednesday 12 October 2005 17:06 pm, Brian Mathis wrote:
Hello,
I am getting ready to install a new server for a new postgres install, and
I'm looking for a little advice. The server is a dual opteron system, and I
plan on using CentOS 4.1 x86_64 for the OS. I'm going t
Scott Marlowe wrote:
On Wed, 2005-10-12 at 16:16, Chris Travers wrote:
Denis G Dudhia wrote:
Hello There...
I am new to PostgreSQL.
I usually check out negative sides of any software or system, before
implementing it or using it.
Compared to MySQL, I can't think of any dow
On Wednesday 12 October 2005 17:06 pm, Brian Mathis wrote:
> Hello,
>
> I am getting ready to install a new server for a new postgres install, and
> I'm looking for a little advice. The server is a dual opteron system, and I
> plan on using CentOS 4.1 x86_64 for the OS. I'm going to do my best to m
Like all of our beta periods, this one has been going smoothly ... but,
unlike other ones, we're seeing most bugs found very early in the cycle,
so right now its looking like a total of 3 Betas might be all that it
takes to get us to the Release.
With that in mind, we have just released our
> Stupid question here ... if Oracle came at us with "the Software Patent
> crap", is there any "reasonable time" provided to remove it? We've
> already shown in the past that that isn't a big hurdle, with the ARC
> stuff, so am just curiuos as to how big a thing the Patent stuff is, or
> does
Marc G. Fournier wrote:
On Wed, 12 Oct 2005, Joshua D. Drake wrote:
PostgreSQL doesn't suffer from that. Our only real, substantiated
concern that I can see is the potential for the Software Patent crap.
Stupid question here ... if Oracle came at us with "the Software
Patent crap", is ther
On Wed, 12 Oct 2005, Joshua D. Drake wrote:
PostgreSQL doesn't suffer from that. Our only real, substantiated
concern that I can see is the potential for the Software Patent crap.
Stupid question here ... if Oracle came at us with "the Software Patent
crap", is there any "reasonable time" pro
Right. Though there are attacks, there are no fatal attacks. MySQL has
to make money, so they can have fatal attacks.
---
Tom Lane wrote:
> Matthew Terenzio <[EMAIL PROTECTED]> writes:
> > As much as I respect Marc and Pos
Matthew Terenzio <[EMAIL PROTECTED]> writes:
> As much as I respect Marc and Postgresql.org, I can't see Oracle hiring
> him away as a "killer" threat to the community. People would set up
> camp somewhere else, like Command Prompt. It would hurt things for a
> while but the software is too impo
Bruce Momjian wrote:
Matthew Terenzio wrote:
As much as I respect Marc and Postgresql.org, I can't see Oracle hiring
him away as a "killer" threat to the community. People would set up
camp somewhere else, like Command Prompt. It would hurt things for a
while but the software is too import
jeff sacksteder wrote:
I'm going to be working with some rather large datasets and I want to
evaluate the effects of normalization/denormalization on disk space.
Is there a simple way to find the size on disk of a specific database?
To do so with the operating system is rather crude, since it
jeff sacksteder <[EMAIL PROTECTED]> writes:
> I'm going to be working with some rather large datasets and I want to
> evaluate the effects of normalization/denormalization on disk space. Is
> there a simple way to find the size on disk of a specific database?
Look into the functions offered by con
Matthew Terenzio wrote:
> As much as I respect Marc and Postgresql.org, I can't see Oracle hiring
> him away as a "killer" threat to the community. People would set up
> camp somewhere else, like Command Prompt. It would hurt things for a
> while but the software is too important to too many to
I'm going to be working with some rather large datasets and I want to
evaluate the effects of normalization/denormalization on disk space. Is
there a simple way to find the size on disk of a specific database? To
do so with the operating system is rather crude, since it know nothing
about what prop
As much as I respect Marc and Postgresql.org, I can't see Oracle hiring
him away as a "killer" threat to the community. People would set up
camp somewhere else, like Command Prompt. It would hurt things for a
while but the software is too important to too many to be killed by a
domain name or p
Wow, I must be missing something, because I cannot even dream up a case
where I think I might find a use for the mysql INTERVAL() function, far
less actually NEED it :)
Terry
Michael Fuhr wrote:
On Wed, Oct 12, 2005 at 04:49:59PM -0500, Scott Marlowe wrote:
On Wed, 2005-10-12 at 16:16, Chr
On Wed, Oct 12, 2005 at 04:49:59PM -0500, Scott Marlowe wrote:
> On Wed, 2005-10-12 at 16:16, Chris Travers wrote:
> > Compared to MySQL, I can't think of any downsides. All relevant
> > usability issues have been solved, though there are some functions like
> > INTERVAL that are not supported (
On Wed, 12 Oct 2005, Jan Wieck wrote:
On 10/12/2005 6:18 PM, Marc G. Fournier wrote:
On Wed, 12 Oct 2005, Jussi Mikkola wrote:
Hi,
Well, if the PostgreSQL developers would be hired away from the project
with big money, would that not mean, that the project would be a good path
to earn a l
On Wed, 12 Oct 2005, Jan Wieck wrote:
Oracle could even develop an exceptional interest in keeping PostgreSQL
alive as it's "future DB engineer forge".
Jan,
Or, to demonstrate that it's not a monopoly. There will be two choices:
Oracle and postgres.
Rich
--
Dr. Richard B. Shepard, Preside
On 10/12/2005 6:18 PM, Marc G. Fournier wrote:
On Wed, 12 Oct 2005, Jussi Mikkola wrote:
Hi,
Well, if the PostgreSQL developers would be hired away from the project with
big money, would that not mean, that the project would be a good path to earn
a lot of money. So, new talented developers
try something like:
select x,sum(case when id<5 then 1 else 0 end),sum(case when id>10 then 1 else
0 end from test2 group by x;
-- Original Message ---
From: peter pilsl <[EMAIL PROTECTED]>
To: Martín Marqués , PostgreSQL List
Sent: Wed, 12 Oct 2005 22:24:48 +0200
Subject: Re
Hello,
I am getting ready to install a new server for a new postgres install,
and I'm looking for a little advice. The server is a dual opteron
system, and I plan on using CentOS 4.1 x86_64 for the OS. I'm
going to do my best to make it s pure 64 bit system.
Does anyone have any experience runn
On 11 Oct 2005 17:36:59 -0500, Hrishi Joshi <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I need to define a Unique index on 3 non-PK fields (composite key) on my
> table in PostgreSQL 8.0.3.
>
> The problem is, if any of those 3 fields is Null, PostgreSQL allows
> duplicate rows to be inserted. While searc
On Wed, 12 Oct 2005, Jussi Mikkola wrote:
Hi,
Well, if the PostgreSQL developers would be hired away from the project with
big money, would that not mean, that the project would be a good path to earn
a lot of money. So, new talented developers could join the project and see
that as a path t
On Tuesday 11 October 2005 14:59, Scott Marlowe wrote:
> On Tue, 2005-10-11 at 10:50, Gary Horton wrote:
> > I'm needing to convince my boss that we should upgrade from 7.3.4 to
> > 8.x Postgresql. I've already enumerated the upsides, but now we need
> > to consider the risks...I wonder if anyone c
On Wed, 2005-10-12 at 16:16, Chris Travers wrote:
> Denis G Dudhia wrote:
>
> > Hello There...
> >
> > I am new to PostgreSQL.
> >
> > I usually check out negative sides of any software or system, before
> > implementing it or using it.
> >
> Compared to MySQL, I can't think of any downsides. Al
On Thursday 29 September 2005 01:28, pkondratev wrote:
> Hi,
> two questions
> 1. Why on page http://www.postgresql.org/community/lists/ no reference
> to [EMAIL PROTECTED]
Oversight, fixed now in CVS, will appear on next site build.
As a reminder for everyone, questions about website content /
Denis G Dudhia wrote:
Hello There...
I am new to PostgreSQL.
I usually check out negative sides of any software or system, before
implementing it or using it.
Compared to MySQL, I can't think of any downsides. All relevant
usability issues have been solved, though there are some functions
Martín Marqués wrote:
I'm not sure what exactly it is you want, but check this:
SELECT count(*) FROM tab WHERE expresion
There you get a count of tuples that satisfy the expresion. What NULL values
are you talking about? Can you hand an example?
thnx.
# select * from test2;
x | id
---
Hi, I need to execute some queries that do not return any value
for example "DELETE * FROM foo". This queries take a lot of time and I
can't put them together in a single query.
If I use the non-blocking function PQsendQuery() I have to wait until
the execution of the first query terminates befo
El Mié 12 Oct 2005 15:42, peter pilsl escribió:
> the count-aggreate counts every expression that does not evaluate to null.
>
> I would like to have a count that counts all values that are true.
>
> Do I really need to make a count( case when expression then 't' else
> null) to implement this?
I'
am 12.10.2005, um 20:42:02 +0200 mailte peter pilsl folgendes:
>
> the count-aggreate counts every expression that does not evaluate to null.
>
> I would like to have a count that counts all values that are true.
>
> Do I really need to make a count( case when expression then 't' else null)
>
the count-aggreate counts every expression that does not evaluate to null.
I would like to have a count that counts all values that are true.
Do I really need to make a count( case when expression then 't' else
null) to implement this?
thnx,
peter
--
mag. peter pilsl
goldfisch.at
IT-manage
Hi,
Well, if the PostgreSQL developers would be hired away from the project
with big money, would that not mean, that the project would be a good
path to earn a lot of money. So, new talented developers could join the
project and see that as a path to high salary jobs??
Rgs,
Jussi
Bruce M
Ned,
> and it looks like postgres.net got picked up by some
> guy who's sitting on it.
yeah, I'm not sure what he wants. Postgres.net currently directs people to
PostgreSQL.org, and I've offered the contact of record money to buy it off
him, with no response.
--
--Josh
Josh Berkus
Aglio Dat
Hello,
I am trying to store images (bin files) from delphi (ADO components) to
postgresql, I found data type bytea for that, but I could not make it
work. May be anyone has sample of delphi code?
thx
Lukas
--
This message has been scanned for viruses and
dangerous content, and is believed to
[EMAIL PROTECTED] wrote on 10/11/2005 09:59:16 PM:
> Jan Wieck <[EMAIL PROTECTED]> writes:
> > And look at it, all Oracle would have to do is to be so open source
> > friendly that they make InnoDB GPL only. Can you imagine the confusion
> > in the MySQL fan club if Oracle releases the next GPL
On Wednesday 12 October 2005 12:38 pm, Reid Thompson wrote:
> http://linux.sys-con.com/read/139427_2.htm
>
>
> reid
Oh that's just friggin' annoying. :) Just how many more distractions, popups
can a website have... not enough for them I guess.
---(end of broadcast)---
http://linux.sys-con.com/read/139427_2.htm
reid
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Wed, Oct 12, 2005 at 12:40:29PM +0200, Florian Ledoux wrote:
> I would like to track (timestamp and error number) in the database or
> in text files the exceptions that occur in my PL/pgSQL functions.
>
> 1. How can I retrieve the SQLCODE in a 8.0.3 PG server ?
You can't, at least not that I'm
I run pg_autovacuum as user postgres: owner of the database processes and an
unprivileged user (nologin)
""Zlatko Matiæ"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
For pg_dump minimum privilages is to have select right on tables.
For vacuumdb, one must be owner of tables or
On Wed, Oct 12, 2005 at 09:30:50PM +0800, Lincoln Yeoh wrote:
> will "lock sometable nowait" help?
>
> http://developer.postgresql.org/docs/postgres/sql-lock.html
>
> If it fails, something is in progress.
And if it succeeds then it might hurt the performance of concurrent
transactions, dependin
Shot in the dark: Check your clock.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611 US
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] O
Hi list,
I downloaded Postgresql 8.0.4, and tried to compile on Slackware 10.2.
However, the configure runs fine, but when I run 'make' (or 'gmake') after
that, it executes the configure again (and again, and again...), without
actually making the application.
Any ideas?
Cheers,
D.Kniep
Bruce Momjian wrote:
Marc Fournier owns the PostgreSQL trademark and domain names.
Minor point here, but the following domain names:
postgresql.com
postgres.com
postgres.org
... were contributed back to the project by the late Great Bridge LLC, and are
registered to the PGDG - with Tom as
The TODO has has an open item to all multiple -t options and other
complexity.
---
Dan Armbrust wrote:
> Dan Armbrust wrote:
> > Bricklen Anderson wrote:
> >
> >>
> >> pg_dump --help
> >> ...
> >> -n, --schema=SCHEMA
Michael Fuhr wrote:
On Mon, Oct 10, 2005 at 09:51:48AM -0500, Scott Marlowe wrote:
I'll take one Tom Lane or Jan Wieck or (all the other postgresql
hackers go here) over 1,000 MySQL hackers.
... I hope their employers appreciate what they've got.
Is there a good way of telling their employe
On Wed, Oct 12, 2005 at 12:24:41PM +0400, Sergey Karin wrote:
> But if I do something like this:
> kosten=# select t::text from foo;
> ERROR: cannot cast type bit to text
>
> I get an error. Okay the system cannot cast bit to text...
> But this is the big problem for me... Is there a way to cast
will "lock sometable nowait" help?
http://developer.postgresql.org/docs/postgres/sql-lock.html
If it fails, something is in progress.
I believe there are also statement timeouts.
Regards,
Link.
At 11:56 AM 10/12/2005 +, Carlos Benkendorf wrote:
We have applications that are sometimes loc
> Hello.
>
> It seems that for all automated tasks (backup, autovacuum
> etc.) passwords should be provided by pgpass file.
> But, anyone can read pgpass file
>
> How can I make it secure that nobody can read it, except
> programs for backup and autovacuum ?
Set filesystem permissions on
Binary data in bit(n) has no text equivalent, and so cannot be "cast" as text.
It has an "external representation", e.g. B'10010101', but this is not
the same as a cast. In some cases, where there bit(n) has (n mod 8) = 0
and the bitstring happens to be valid ascii in the text range, one could
sa
On Tue, 11 Oct 2005 at 21:57, Gregory Youngblood wrote:
> SuSE 10 is the "commercial" release from Novell. It contains
> additional packages not in the opensuse.org open source version.
> There is an eval cd and dvd set that can be downloaded of the
> "commercial" release - though I do not beli
On Wed, Oct 12, 2005 at 11:34:58AM +0200, Zlatko Mati? wrote:
> Hello.
>
> It seems that for all automated tasks (backup, autovacuum etc.) passwords
> should be provided by pgpass file.
> But, anyone can read pgpass file
>
> How can I make it secure that nobody can read it, except programs f
Hello.
It seems that for all automated tasks (backup,
autovacuum etc.) passwords should be provided by pgpass file.
But, anyone can read pgpass file
How can I make it secure that nobody can read it,
except programs for backup and autovacuum ?
Thanks,
Zlatko
On Mon, Oct 10, 2005 at 09:20:47AM -0600, Michael Fuhr wrote:
> project. I hope their employers appreciate what they've got.
Well, I can tell you that Afilias does.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The fact that technology doesn't work is no bar to success in the marketplace.
We have applications that are sometimes locked by a long time application and I would like to avoid these by coding something to discover if the rows are locked before working with them.
Both applications use only inserts in a table with a primary key.
I´m sure that it is not the rigth approach
Thanks for the clarification. The problem turned out to be more trivial.
I was not doing something like: employee.f1 := 'value of f1 column'; as
you suggested, but declaring "employee" as record I did not pay
attention to the fact that I use a scheme named employee in the store
proc. My guess is th
Hello,
I would like to track (timestamp and error number) in the database or
in text files the exceptions that occur in my PL/pgSQL functions.
1. How can I retrieve the SQLCODE in a 8.0.3 PG server ?
2. How can I trace the exception in a table although an implicit
rollback is done when a exceptio
On Wed, 2005-10-12 at 19:26 +1000, Neil Dugan wrote:
> I thought it would only be needed if you where distributing the source for
> Postgresql.
>
> Does the copyright get distributed with the binary Debian packages?
> I haven't been able to find it on my Linux box.
The copyright of all Debian
On Wed, Oct 12, 2005 at 07:26:48PM +1000, Neil Dugan wrote:
> I thought it would only be needed if you where distributing the source for
> Postgresql.
>
> Does the copyright get distributed with the binary Debian packages?
> I haven't been able to find it on my Linux box.
Yes it does, in all b
On Thursday 06 October 2005 08:34, Jim C. Nasby wrote:
> On Wed, Oct 05, 2005 at 04:14:03PM -0400, Andrew Sullivan wrote:
> > On Wed, Oct 05, 2005 at 09:49:06PM +1000, Neil Dugan wrote:
> > > If I was to develop a 'C' project that only used the libpg.so library
> > > and the rest was my own stuff w
OK. but, is it required that the user is a superuser, owner of tables or
just needs to have select rights on tables?
Thanks,
Zlatko
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Zlatko Matić" <[EMAIL PROTECTED]>
Cc: "Matthew T. O'Connor" ;
Sent: Tuesday, October 11,
Hi, List!
kosten=# select version();
version
---
PostgreSQL 8.0.0rc5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3
(1 row)
kosten=# create table foo(t bit(4));
CREATE TABLE
kosten=#
No, I'm on Windows...
- Original Message -
From: "Jim C. Nasby" <[EMAIL PROTECTED]>
To: "Tom Lane" <[EMAIL PROTECTED]>
Cc: "Zlatko Mati?" <[EMAIL PROTECTED]>; "Matthew T. O'Connor"
;
Sent: Wednesday, October 12, 2005 1:14 AM
Subject: Re: [GENERAL] user privilages for executing pg_aut
If I put password in pgpass file it's still a plain text. How to hide it ?
- Original Message -
From: "Jim C. Nasby" <[EMAIL PROTECTED]>
To: "Tom Lane" <[EMAIL PROTECTED]>
Cc: "Zlatko Mati?" <[EMAIL PROTECTED]>; "Matthew T. O'Connor"
;
Sent: Wednesday, October 12, 2005 1:14 AM
Subjec
First, this does not have to do anything with PostgreSQL and I guess
this newsgroup is a bad place to ask PHP/xampp questions.
Second, if you are to lazy to install that few applications that xampp
wraps in some click-and-forget install-package, why should we be less
lazy and debug your broken
On Tue, 2005-10-11 at 18:52 -0400, Bruce Momjian wrote:
> Oracle certainly will not win, and I think they know that
I think this too and that's why I'm here.
Best Regards, Simon Riggs
---(end of broadcast)---
TIP 4: Have you searched our list
On Wed, Oct 12, 2005 at 04:11:00AM +, Carlos Benkendorf wrote:
> How can I know which rows are locked?
There's no query that says "show me all rows that are locked"; even
if there was, it would be out of date by the time you got the
results. PostgreSQL 8.1 will enhance pg_locks to show tuple
70 matches
Mail list logo
