Chris <[EMAIL PROTECTED]> writes:
> Quick test:
> create table a(a int primary key, b int, c varchar(200));
> insert into a(a, b, c) values (1,1,'one');
> insert into a(a, b, c) values (2,2,'two');
> insert into a(a, b, c) values (3,1,'one');
> insert into a(a, b, c) values (4,2,'two');
> mysql>
Tom Lane wrote:
Chris <[EMAIL PROTECTED]> writes:
eg mysql doesn't force you to group by all columns being selected - I
can do:
select field1, field2, field3 from table group by field1;
and have it valid in mysql (but of course postgres will tell you it's
not valid and need to add grouping fo
Chris <[EMAIL PROTECTED]> writes:
> eg mysql doesn't force you to group by all columns being selected - I
> can do:
> select field1, field2, field3 from table group by field1;
> and have it valid in mysql (but of course postgres will tell you it's
> not valid and need to add grouping for field2 a
On Wednesday 2006-02-15 18:42, Leonard Soetedjo wrote:
> On Wednesday 15 February 2006 01:38, Tom Lane wrote:
> > merlyn@stonehenge.com (Randal L. Schwartz) writes:
> > > Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
> > > "other" way that MySQL could have transactions if
Then, even if you do write something to use postgresql a lot of hosts
don't support it anyway ('mysql is good enough').. so you're stuck.
Well, I guess the moment all the hoster's have to buy commercial licenses for
providing a database they'll switch to PG in no time - or charge more for the
On Wednesday 15 February 2006 18:49, Chris wrote:
> > And since MySQL already has got the upperhand in terms of marketing,
> > Oracle would buy MySQL to make it as the low-end alternative. Never mind
> > the lack/immature features in MySQL such as stored proc or trigger.
>
> Mysql 5 has stored pro
And since MySQL already has got the upperhand in terms of marketing, Oracle
would buy MySQL to make it as the low-end alternative. Never mind the
lack/immature features in MySQL such as stored proc or trigger.
Mysql 5 has stored procedures and triggers.
The fact that you have to change betw
On Thursday 16 February 2006 10:15, Steve Manes wrote:
> Leonard Soetedjo wrote:
> > Is it possible that Oracle is trying to buy MySQL to kill off other open
> > source competitor, e.g. PostgreSQL? MySQL has a strong number of users
> > and therefore it is a good deal for Oracle to buy MySQL. The
Leonard Soetedjo wrote:
Is it possible that Oracle is trying to buy MySQL to kill off other open
source competitor, e.g. PostgreSQL? MySQL has a strong number of users and
therefore it is a good deal for Oracle to buy MySQL. Then by doing that,
Oracle will market MySQL as the low-end alternat
* Chad ([EMAIL PROTECTED]) wrote:
> course the product you own is called "MySQL". Do MySQL or any MySQL
> customers need a commercial license for BDB? I think not. MySQL does
> not as all its code is open source. As for MySQL customers, unless they
> are making direct API calls into BDB (which most
On Wednesday 15 February 2006 01:38, Tom Lane wrote:
merlyn@stonehenge.com (Randal L. Schwartz) writes:
Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
"other" way that MySQL could have transactions if Oracle decided to
restrict InnoDB tables (after purchasing Innobase la
On Thu, 16 Feb 2006, Leonard Soetedjo wrote:
On Wednesday 15 February 2006 01:38, Tom Lane wrote:
merlyn@stonehenge.com (Randal L. Schwartz) writes:
Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
"other" way that MySQL could have transactions if Oracle decided to
restr
On Wednesday 15 February 2006 01:38, Tom Lane wrote:
> merlyn@stonehenge.com (Randal L. Schwartz) writes:
> > Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
> > "other" way that MySQL could have transactions if Oracle decided to
> > restrict InnoDB tables (after purchasing
Quoth [EMAIL PROTECTED] (Rick Gigger):
> Why doesn't mysql just forget the whole dual licensing of the server
> thing and just tell everyone to use the GPL versions of everything.
> Then dual license the client libraries which I would think they
> already own outright. I think this is what forces
On 2006-02-15, "Jimmy Choi" <[EMAIL PROTECTED]> wrote:
> I find that it doesn't work (i.e. index is not used and a sequential
> scan is needed), if I have the following instead:
>
> SELECT * FROM foo WHERE id = ANY (ARRAY[1,2]);
>
> Is this expected? The reason I would like the last case to work
of interest perhaps...
http://news.zdnet.com/2100-9593_22-6040197.html?tag=zdnn.alert
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
"Jimmy Choi" <[EMAIL PROTECTED]> writes:
> I find that it doesn't work (i.e. index is not used and a sequential
> scan is needed), if I have the following instead:
> SELECT * FROM foo WHERE id = ANY (ARRAY[1,2]);
> Is this expected?
Yes. That construct isn't indexable, period, in any existing re
Why doesn't mysql just forget the whole dual licensing of the server
thing and just tell everyone to use the GPL versions of everything.
Then dual license the client libraries which I would think they
already own outright. I think this is what forces most people to
need a commercial licen
Hello,
From Section 11.4 of the Postgres 8.1 documentation, a new optimization
is shipped in the latest release.
"... a query like WHERE x = 42 OR x = 47 OR x = 53 OR x = 99 could be
broken down into four separate scans of an index on x, each scan using
one of the query clauses. The results of t
Colin Shreffler <[EMAIL PROTECTED]> writes:
> I have tried entering the following record in the file, but it does not
> grant me access.
(1) did you remember to sighup the postmaster after changing the file?
(2) what error message do you get *exactly*? What shows up in the
postmaster log file?
I am not able to successfully create an entry in the pg_hba.conf file to
enable remote access to my postgres database.
The postmaster process HAS been initialized to accept tcp/ip connections.
I have tried entering the following record in the file, but it does not
grant me access.
host all
"Ken Winter" <[EMAIL PROTECTED]> writes:
> Yes, that's what I'm trying to do. My problem has been: how to enter the
> equivalent of '2006-02-15 10:22:46-05' when the time I want to enter and
> convert to EST is a variable value or now().
This still shows a problem in your grasp of what's going on
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 15, 2006 10:25 AM
> To: [EMAIL PROTECTED]
> Cc: 'PostgreSQL pg-general List'
> Subject: Re: [GENERAL] Does PG really lack a time zone for India?
>
> "Ken Winter" <[EMAIL PROTECTED]> writes:
> > Brie
On Wed, Feb 15, 2006 at 02:45:07PM -0600, Scott Marlowe wrote:
> Yeah, plus, besides PostgreSQL's front-end C api (libpqxx) there's the
> backend api, which can be programmed with the C language directly, and
> used to do things like write triggers and all that.
>
> I'm not sure what more Chad cou
On Wed, Feb 15, 2006 at 01:02:03PM -0800, Ben wrote:
> Well, in all fairness, MySQL probably gives the right answer most of the
> time, always really fast (except for some use cases).
"Probably gives the right answer most of the time."
I'm not sure whether to laugh or cry.
--
Michael Fuhr
---
Well, in all fairness, MySQL probably gives the right answer most of the time,
always really fast (except for some use cases).
On Wed, 15 Feb 2006, Randal L. Schwartz wrote:
"Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> * Change to use no page locks for table scanning operations
On Tue, Feb 14, 2006 at 10:55:33AM -0500, Emi Lu wrote:
> May I know whether plpgsql supports "switch / case " or I have to use IF
> /ELSIF please?
http://www.postgresql.org/docs/8.1/static/plpgsql-control-structures.html#PLPGSQL-CONDITIONALS
does not list something like the switch / case constr
Bart Golda wrote:
Hi,
We have a problem with PostgreSQL 8.1 on a production server (Windows
2003 Server, Xeon 3GHz, 1GB)); application placed on it run for a month
without problems. It was great. But yesterday...
Any connection to the server, from application or pgAdmin (both
previously working
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom>* Change to use no page locks for table scanning operations.
Tom> Maybe I'm misunderstanding, but that sure sounds like they intend to
Tom> dumb down BDB so that it no longer works well in concurrent situations,
Tom> in order to save a f
I developed, and have been using, this[1] and it's been working fine for me. :)
http://open-ils.org/blog/?p=28
On 15 Feb 2006 10:10:29 -0800, rob <[EMAIL PROTECTED]> wrote:
> Hello,
>
>
>
> Looking for advice on creating as dynamic a datalogging scheme as I can
> using plpgsql.
>
>
> The idea wou
On Wed, 2006-02-15 at 14:34, TJ O'Donnell wrote:
> "Chad" <[EMAIL PROTECTED]> wrote:
> "What we need now is an open source DB with clean APIs into various
> places in the software stack (eg we need a Berkeley DB kind of API
> under the hood into something like Postgres) A full bells and whistles
>
Vivek Khera <[EMAIL PROTECTED]> writes:
> http://dev.mysql.com/doc/refman/5.1/en/bdb-restrictions.html
> I especially like the third restriction. How on earth do people live
> with this software?
The preceding page is amusing too:
http://dev.mysql.com/doc/refman/5.1/en/bdb-todo.html
I find th
> I have a fairly large (about 30Gb) PostgreSQL 8.1 database
> running on Windows 2003 Server.
> I noticed that CPU utilization on the server is 100% for past
> few days, and postgres process is taking up most of that CPU
> (95%-100%). There is only one connection to the database at
> the time
On 2/15/06, Nikola Ivanov <[EMAIL PROTECTED]> wrote:
> I found the pid of the postgres process that was consuming all the CPU. I
> turned the stats back on (and reloaded the conf file), but when I query
> pg_stat_activity I get nothing back. No records.
did you restart server? I think stats colle
"Chad" <[EMAIL PROTECTED]> wrote:
"What we need now is an open source DB with clean APIs into various
places in the software stack (eg we need a Berkeley DB kind of API
under the hood into something like Postgres) A full bells and whistles
relational DB with these low level ACCESS APIs will be a p
On Feb 14, 2006, at 3:45 PM, Peter Eisentraut wrote:
http://dev.mysql.com/doc/refman/5.1/en/bdb-storage-engine.html
For kicks, I decided to read that... lead me to this page:
http://dev.mysql.com/doc/refman/5.1/en/bdb-restrictions.html
I especially like the third restriction. How on earth
Randal L. Schwartz wrote:
Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
"other" way that MySQL could have transactions if Oracle decided to
restrict InnoDB tables (after purchasing Innobase last year).
Does this mean the other shoe has dropped for MySQL AB?
I think th
On Wed, 2006-02-15 at 11:05, Chad wrote:
> I am not concerned about Sleepycat revoking their open source license
> for future versions of BDB. I am less concerned about them revoking
> licenses for current and older releases. That would be impossible.
> However this "deal" troubles me and I cant qu
I am not concerned about Sleepycat revoking their open source license
for future versions of BDB. I am less concerned about them revoking
licenses for current and older releases. That would be impossible.
However this "deal" troubles me and I cant quite put my finger on why.
I'll try to tease it ou
Hi,
We have a problem with PostgreSQL 8.1 on a production server (Windows
2003 Server, Xeon 3GHz, 1GB)); application placed on it run for a month
without problems. It was great. But yesterday...
Any connection to the server, from application or pgAdmin (both
previously working fine), is slow. I m
Hello,
Looking for advice on creating as dynamic a datalogging scheme as I can
using plpgsql.
The idea would be to have a trigger function that I could drop on any
table in my database. Then on update, the function would iterate
through each field, and check to see if NEW. <>
OLD.. Then a fu
> Is there a way do discover when was the last time a table or database
> vacuumed?
No, but you might look at the contrib pgstattuple function. The function
will give detailed information on the state of the table on disk.
michael
---(end of broadcast)--
Tom Lane wrote:
"Matthew T. O'Connor" writes:
PostgreSQL 8.1.0 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC)
3.3.3 20040412 (Red Hat Linux 3.3.3-7)
... and this should definitely make you nervous. We don't release
update versions for idle amusement. Get onto 8.1.3 and see if
"Matthew T. O'Connor" writes:
> no tables in it. I logged into my server and reran the vacuumdb -a -z
> command and it went though with no problem. I also checked my log file
> and it shows that there have been 25 out of memory errors on my server
> today.
> My question is: Is this normal?
We tried this recently. You have to use lower(a) like lower(b) for
the index to work.
Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED]
ClickSpace Interactive Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB T2G
n 14 Feb 2006 06:46:48 -0800, Nik <[EMAIL PROTECTED]> wrote:
> I turned off stats collector, and any row stat collectors, and I
> increased the number of check points since I have been getting the
> error about check point switches being to frequent. Postgres now uses a
> bit less CPU (60-90%), wh
Nik wrote:
> I noticed that CPU utilization on the server is 100% for past few
100% CPU usage is not a problem. When the number of waiting processes
goes up, then you have a reason to start being concerned.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
-
Hello all,
I run a nightly "vacuumdb -a -z" on my production server. The output of
the command is emailed to me every night. Today while checking my email
I received this:
vacuumdb: vacuuming database "postgres"
vacuumdb: vacuuming of database "postgres" failed: ERROR: out of memory
DETAIL
From pg_controldata
Latest checkpoint NextXID: 746940488
Under the database tree that is displayed in pgAdmin, when I click on
the database, an error dialog pops up with this message "An error has
occured: FATAL: database "db2" does not exist". Even if I disconnect and
reconnect, the database
I have a fairly large (about 30Gb) PostgreSQL 8.1 database running on
Windows 2003 Server.
I noticed that CPU utilization on the server is 100% for past few days,
and postgres process is taking up most of that CPU (95%-100%). There is
only one connection to the database at the time and that one is
Comments inline.
On Wed, Feb 15, 2006 at 09:49:57AM -0500, Tom Lane wrote:
> I think defining the problem as "let's get rid of australian_timezones"
> would be a serious mistake. The basic problem here is that we can't
> have a one-size-fits-all list of timezone abbreviations. We've
> certainly
Steve Manes wrote:
Marc G. Fournier wrote:
As of this moment, if Oracle buys Zend, they could effectively kill
PHP ... the core engine that PHP is built around is a Zend engine, so
if they were to revoke the license for that, PHP would be dead ...
kinda like MySQL with InnoDB ... now, there wa
Marc G. Fournier wrote:
As of this moment, if Oracle buys Zend, they could effectively kill PHP
... the core engine that PHP is built around is a Zend engine, so if
they were to revoke the license for that, PHP would be dead ... kinda
like MySQL with InnoDB ... now, there was talk at one point
"Ken Winter" <[EMAIL PROTECTED]> writes:
> Briefly, what I'm trying to do is build a (web-front-ended) system that
> translates a "now()" entry into a timestamptz column into "now" at a
> specified time zone (which is looked up from the database).
> Why? Say there's a payment deadline recorded
Tom ~
Thanks for yet another prompt and helpful response. May I submit a
follow-up question?
Briefly, what I'm trying to do is build a (web-front-ended) system that
translates a "now()" entry into a timestamptz column into "now" at a
specified time zone (which is looked up from the database).
andrew <[EMAIL PROTECTED]> writes:
> Within the same query. The function takes a tuple as its input
> parameter. It will be used in the where clause. So I think it will be
> called one time for each read tuple, right? I want to maintain a
> structure to store the information about the tuples that h
Martijn van Oosterhout writes:
> I really wish we could clear up this stuff with the australian
> timezones. I'd love a poll as to how often they're used because I don't
> think most people want them.
I think defining the problem as "let's get rid of australian_timezones"
would be a serious mista
On Wed, Feb 15, 2006 at 03:47:54PM +0200, Igor Shevchenko wrote:
> Here's a problem I'm facing:
>
> I have a "mimetype" table with all mimetypes my app has to deal with. I'm in
> a
> process of adding a fulltext indexing (tsearch2) into my DB and I want to
> specify a per-mimetype conversion fu
Hi All,
Sorry if this was answered before, I was unable to find anything in archives.
Here's a problem I'm facing:
I have a "mimetype" table with all mimetypes my app has to deal with. I'm in a
process of adding a fulltext indexing (tsearch2) into my DB and I want to
specify a per-mimetype con
Hello, Is there a way do discover when was the last time a table or database vacuumed? Thanks in advance! Reimer
Yahoo! Acesso Grátis
Internet rápida e grátis. Instale o discador agora!
I've started writing some scripts to set up incremental backup to my
taste. I just discovered something and thought I would revisit this
thread briefly.
When you go to restore from a give base file system backup you need
to know the start WAL file that you need and the end WAL file that
Am 2006-02-09 11:13:22, schrieb Tyler MacDonald:
> Hmm, looks like a large noise:signal ratio there:
>
> http://lists.alioth.debian.org/pipermail/pkg-postgresql-public/2005-November/thread.html
>
> In fact, I'd go as far as to say that list would make an excellent
> spam honeypot. ;-
Thanks. But it is a little different. What I want is one output value
of every input tuple. But the output value is not only based on the
current input value but also some value that have been read before.
On 2/15/06, Martijn van Oosterhout wrote:
> On Wed, Feb 15, 2006 at 10:49:14AM +0100, andre
On Wed, Feb 15, 2006 at 10:49:14AM +0100, andrew wrote:
> Within the same query. The function takes a tuple as its input
> parameter. It will be used in the where clause. So I think it will be
> called one time for each read tuple, right? I want to maintain a
> structure to store the information ab
Within the same query. The function takes a tuple as its input
parameter. It will be used in the where clause. So I think it will be
called one time for each read tuple, right? I want to maintain a
structure to store the information about the tuples that have been
read so far. The output value of
On Wed, Feb 15, 2006 at 12:33:30AM -0500, Tom Lane wrote:
> The existence of duplicate timezone abbreviations is certainly a pain
> :-(. The solution I would like to see is to factor all the hardwired
> timezone abbreviations in datetktbl out into a configuration file that
> could be adjusted for
66 matches
Mail list logo
