On 10/9/05, Rick Morris [EMAIL PROTECTED] wrote:
Marc G. Fournier wrote:
Stupid question, but what does MySQL bring to the equation?
MySQL brings to the table an impressive AI interface that knows what you
really meant to do and thus does away with those pesky error messages.
After all,
On 10/6/05, suresh ramasamy [EMAIL PROTECTED] wrote:
On 10/6/05, Ly Lam Ngoc Bich [EMAIL PROTECTED] wrote:
I am using Linux Fedora 3 . I've installed Postgres with
postgresql-8.0.3.tar.gz package , so there is no rpm package when I
check with
rpm -qa|grep postgresql
Please show me
Go the installation directory and try
#make uninstall - if it doesn't work then do the following
# make clean
# make dist clean
and remove the directory manually
I think he wants to know how to uninstall the files that were
installed with 'make install', not the source
On 09.10.2005 08:48, andrew wrote:
A very usual and smart approach is to use clases in PEAR::DB.
Well, IMHO PEAR::DB is one of the worst classes of PEAR. Besides its
ugly code it's worth nothing. This is some incomplete abstraction
layer for kiddies, to make it easy for people coming from
The lib I use is call lo_in and lo_out for manage BLOB.
I understand that lo_unlink be related with lo_import and lo_export so I don't think that it work.
Douglas McNaught [EMAIL PROTECTED] 07-Oct-05 20:13:36 pm Moises Alberto Lindo Gutarra [EMAIL PROTECTED] writes: try: delete from
I found loid column in pg_catalog.pg_largeobject. I try to match loid with any numbers in oidcolumn and lo column but I cannot found some that matched.
What think I do that wrong? Please advise Moises Alberto Lindo Gutarra [EMAIL PROTECTED] 07-Oct-05 18:40:12 pm try: delete from
Hello.
I have found README file, and tried to install pg_autovacuum as Windows
service, by a batch file:
@echo off
set ODREDISTE=C:
echo target disc is %ODREDISTE%
cd %ODREDISTE%\Program Files\PostgreSQL\8.0\bin
pg_autovacuum.exe pgsql-8.0.4 -I -N postgres_service -W postgres_service
Tom, Oleg, Yonathan,
thanks for the suggestions.
Indeed, upping the statistics from 10 to 100 helped.
But order by did not:
palga=# explain analyze select rapnaam from udps where geboortedatum =
'1966-01-01' and naamvrouw like 'vos%' order by geboortedatum;
Premsun Choltanwanich [EMAIL PROTECTED] writes:
The lib I use is call lo_in and lo_out for manage BLOB.
I understand that lo_unlink be related with lo_import and lo_export so I
don't think that it work.
It's exactly what you want--it removes a LO with the specified OID
from the large object
On Sun, 9 Oct 2005, CSN wrote:
Maybe this is a crazy idea, I don't know how
technically or legally feasible it is, but I really
like the idea of the two open-source communities
uniting to battle Oracle.
Two? I haven't used Firebird, but have heard lots of positive comments
from users.
I am receiving the following error and cannot understand what it means.
Please let me know if this makes sense to you.
ERROR: could not open relation 1663/3364852/7973197: No such file or
directory
CONTEXT: SQL statement create temporary table tmpcust as select a.* from
qry_Customers_Country a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stupid question, but what does MySQL bring to the equation? Why
not just use PostgreSQL in the first place?
A good question. I think one answer is the MySQL name. Many open-source
advocates seem enamored of MySQL, but you can never pin them
Hi everybody,
i'd like to know if it is better to use a primary key made of a couple
columns, than to use a constraint UNIQUE() on this couple columns,
regarding the sake of postgresql.
For example, i've got these two tables, 'buyer' and 'purchaser' and i
want to make an association table
On Thu, 2005-10-06 at 17:42, Mark Cave-Ayland wrote:
Hi everyone,
I've just got back from LinuxWorld in London and seeing this thread thought
I would share my experience of the MySQL stand - if you are of a delicate
dispostion, please look away now. I basically asked them straight up why I
Greg Sabino Mullane wrote:
The other answer may be the license: plugging PG into the MySQL system
(which is about as technically feasible trying to breed a porpoise
and an elephant) keeps MySQL GPL, which is another reason many people
like it.
The fact that PostgreSQL is NOT released under
On Fri, 2005-10-07 at 21:34, Qingqing Zhou wrote:
[EMAIL PROTECTED] wrote
Hi, I have a table A in both database d1 and d2. I would like to copy
data in A in d1 to A in d2. How can I do it? I do not want to copy all
data, just some part of A,
Here is a way if you feel want to try. The
Brent Wood wrote:
Two? I haven't used Firebird, but have heard lots of positive comments
from users. Firebird/Postgres/MySQL together maybe? Or with all the
embedded SQLlite users out there, perhaps all four :-)
i can't think of a single good reason why anyone in the PostgreSQL
community
On Mon, Oct 10, 2005 at 04:44:54PM +0200, David Pradier wrote:
Hi everybody,
i'd like to know if it is better to use a primary key made of a couple
columns, than to use a constraint UNIQUE() on this couple columns,
regarding the sake of postgresql.
In PostgreSQL, both primary keys and
On Mon, 10 Oct 2005 09:53:17 -0500
Dan Armbrust [EMAIL PROTECTED] wrote:
The fact that PostgreSQL is NOT released under GPL is the reason that
people like me are here - MySQL's license drove us away from them.
Their change of the driver licensing prevents us from shipping new
drivers with
Sim Zacks [EMAIL PROTECTED] writes:
I am receiving the following error and cannot understand what it means.
Please let me know if this makes sense to you.
ERROR: could not open relation 1663/3364852/7973197: No such file or
directory
CONTEXT: SQL statement create temporary table tmpcust as
In PostgreSQL, both primary keys and UNIQUE constraints are implemented
via UNIQUE indexes, ergo there is no difference...
Thanks Martijn, it's exactly what i wanted to know.
Best regards,
David
--
David Pradier -- Directeur Technique de Clarisys Informatique -- Chef de projet
logiciels
qry_Customers_Country is a view.
There is no row in pg_class with relfilenode=7973197 either when it
works or after I get the error.
The version (from select version()) is
PostgreSQL 8.0.1 on i686-pc-linux-gnu, compiled by GCC i686-pc-linux-gnu-gcc
(GCC) 3.3.5 (Gentoo Linux 3.3.5-r1,
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.
Likewise. They probably don't hear it enough, so I hope they're
aware that some of us have a great deal of respect for both
Martijn van Oosterhout kleptog@svana.org writes:
On Mon, Oct 10, 2005 at 04:44:54PM +0200, David Pradier wrote:
i'd like to know if it is better to use a primary key made of a couple
columns, than to use a constraint UNIQUE() on this couple columns,
regarding the sake of postgresql.
In
Just for the sake of completeness, there are exactly two differences:
* PRIMARY KEY implies NOT NULL on the key columns; UNIQUE doesn't.
* PRIMARY KEY creates a default target for foreign key references,
ie, if you've declared a primary key then you can later just say
REFERENCES mytab
Sim Zacks [EMAIL PROTECTED] writes:
The version (from select version()) is
PostgreSQL 8.0.1 on i686-pc-linux-gnu, compiled by GCC i686-pc-linux-gnu-gcc
(GCC) 3.3.5 (Gentoo Linux 3.3.5-r1, ssp-3.3.2-3, pie-8.7.7.1)
Gentoo eh? When you run a bleeding-edge distribution, sometimes you get
Hello,
Having freshly installed a PG database (8.0.3), I have difficulties in
tracing exceptions in my PL/pgSQL functions. All my functions
implement a BEGIN-EXCEPTION-END block in which exceptions must be
traced :
BEGIN
-- Some stuff
EXCEPTION
WHEN OTHERS THEN
-- trace
END;
I would
Hi All,
I am sorry if this was already discussed. I am new to the world of
postgressql and was experincing a problem for which I need help of an
expert in this lists.
We have devloped a site(asp.net 1.1) for which we have used postgresql 7.4
as the backend database. When the number of
I have a store procedure which returns a record; the query is defined as:
select * from spec_proc.view_empl_1('bg',2) AS (f1 varchar, f2 varchar,
f3 date, f4 varchar, f5 varchar,f6 varchar,f7 varchar, f8 varchar, f9
int, f10 varchar, f11 varchar, f12 varchar, f13 int, f14 varchar, f15
date, f16
first of all, your clients are closing connections??
yo should use a pool connection.
2005/10/10, [EMAIL PROTECTED] [EMAIL PROTECTED]:
Hi All,
I am sorry if this was already discussed. I am new to the world of
postgressql and was experincing a problem for which I need help of an
expert in
Venki,
Postgres is using a thread per _realized_ connection, and reserves some
memory per _configured_ connection. So setting the configured connection
count too high is not free even if normally you won't have that many
connections actually open. And of course at peak load the number of
[EMAIL PROTECTED] wrote on 10/09/2005 08:16:22 AM:
This is the first time I can think of where software being GPL'd might
actually hurt the open-source community.
The MySQL license has been modified so that it is, IMHO, not compatible
with the GPL. The basic tenet of the GPL is that I
Marc G. Fournier wrote:
Stupid question, but what does MySQL bring to the equation? Why not just
use PostgreSQL in the first place?
really.
to my mind, the best thing the PostgreSQL community can do for the
MySQL community is provide simple, easy to use migration tools
and documentation.
On Mon, 2005-10-10 at 10:59, [EMAIL PROTECTED] wrote:
Hi All,
I am sorry if this was already discussed. I am new to the world of
postgressql and was experincing a problem for which I need help of an
expert in this lists.
We have devloped a site(asp.net 1.1) for which we have used
Tom Lane wrote:
[EMAIL PROTECTED] writes:
After upgrading to 8.0.3 I see very poor performance on several indexes.
...
Database was recently analyzed. Clearly, something has to be tuned that
didn't
need tuning on 7.4.3 ? (Main table has about 1.7 million records).
No, there's no reason
On 10/7/05, Jim C. Nasby [EMAIL PROTECTED] wrote:
http://lnk.nu/prnewswire.com/4dv.pl--Jim C. Nasby, Sr. Engineering Consultant[EMAIL PROTECTED]Pervasive Software
http://pervasive.comwork: 512-231-6117vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461---(end of
On 10/10/05, Greg Sabino Mullane [EMAIL PROTECTED] wrote:
A good question. I think one answer is the MySQL name. Many open-source
advocates seem enamored of MySQL, but you can never pin them down about
exactly what it is they love so much about it. Maybe we can rebrand
PG as MiSQL or
From:
http://www.filmsite.org/whof4.html
Valiant: Come on. Nobody's gonna drive this lousy freeway when they can take
the Red Car for a nickel.
Doom: Oh, they'll drive. They'll have to. You see, I bought the Red Car so I
could dismantle it.
I don't think Oracle has any interest in InnoDB other
Stupid question here, but how susceptible is Oracle to monopolistic
practices, similar to what M$ is going through with the DoJ in the US?
This seems to be *very* close to the line, if it isn't over it ... no?
On Mon, 10 Oct 2005, Dann Corbit wrote:
From:
http://www.filmsite.org/whof4.html
Gregory Youngblood [EMAIL PROTECTED] writes:
I've been using SuSE and PostgreSQL for a fairly long time.
Recently (last 12 months), I've noticed that the 9.x (9.2 and
9.3 specifically) versions of SuSE do not include PostgreSQL on
the CD install -- only on the DVD. At first (9.2), I
I think it kind of depends on how they treat with MySQL. If they expect
MySQL to pay them $10,000 per installation, and MySQL was paying Heiki
$100 per installation, then that would be predatory. OTOH, if they
charge the same rate, or some small incremental increase over what
innobase charges
Marc G. Fournier wrote:
Stupid question here, but how susceptible is Oracle to monopolistic
practices, similar to what M$ is going through with the DoJ in the
US? This seems to be *very* close to the line, if it isn't over it ...
no?
They are not... too many competitors... MS suffers
On Mon, Oct 10, 2005 at 02:47:31PM -0300, Marc G. Fournier wrote:
Stupid question here, but how susceptible is Oracle to monopolistic
practices, similar to what M$ is going through with the DoJ in the
US? This seems to be *very* close to the line, if it isn't over it
... no?
It may well
Consider what happened to Stak verse MS.
Stak won the court case but still went out of business.
-Original Message-
From: David Fetter [mailto:[EMAIL PROTECTED]
Sent: Monday, October 10, 2005 11:17 AM
To: Marc G. Fournier
Cc: Dann Corbit; snacktime; pgsql-general@postgresql.org
On Mon, Oct 10, 2005 at 11:29:24AM -0700, Dann Corbit wrote:
Consider what happened to Stak verse MS. Stak won the court case
but still went out of business.
My point exactly ;)
Cheers,
D
-Original Message-
From: David Fetter [mailto:[EMAIL PROTECTED]
Sent: Monday, October 10,
Scott Marlowe [EMAIL PROTECTED] wrote
Under no circumstances should you do this with a database that has any
data in it that you value. pg_dump / pg_restore / psql are the
preferred way of doing this.
Oh yeah, sorry for the miss leading information. My method is dangerous and
can not
On Mon, 2005-10-10 at 13:53, Qingqing Zhou wrote:
Scott Marlowe [EMAIL PROTECTED] wrote
Under no circumstances should you do this with a database that has any
data in it that you value. pg_dump / pg_restore / psql are the
preferred way of doing this.
Oh yeah, sorry for the miss
--- Michael Fuhr [EMAIL PROTECTED] wrote:
On Sun, Oct 09, 2005 at 12:46:51PM -0700, CSN wrote:
select * from table1 where id=586;
586|a|b|c|d
Do you get different results from the following
queries?
SET enable_seqscan TO on;
SET enable_indexscan TO off;
SELECT * FROM table1 WHERE
On Mon, Oct 10, 2005 at 06:43:25PM +0300, Ivan Pavlov wrote:
I have a store procedure which returns a record; the query is defined as:
select * from spec_proc.view_empl_1('bg',2) AS (f1 varchar, f2 varchar,
f3 date, f4 varchar, f5 varchar,f6 varchar,f7 varchar, f8 varchar, f9
int, f10
[EMAIL PROTECTED] (Marc G. Fournier) writes:
Stupid question here, but how susceptible is Oracle to monopolistic
practices, similar to what M$ is going through with the DoJ in the
US? This seems to be *very* close to the line, if it isn't over it
... no?
No. The market for databases is
CSN [EMAIL PROTECTED] writes:
oid | ctid| xmin | cmin | xmax | cmax | id
+---+-+--+-+--+-
125466 | (2672,11) | 1445346 |0 | 1481020 |0 | 985
125466 | (2745,50) | 1481020 |0 | 1682425 |2 | 985
Hmm. The fact that the
I don't have a compiler on this machine. If somebody
can point me to a copy of pg_filedump for Windows (I
didn't see any using Google) I'd be happy to use it.
Or perhaps I could compile it under cygwin.
The hard drive is a Western Digital 200GB JD (SATA),
if that can be used to determine how
On Mon, 2005-10-10 at 15:51, CSN wrote:
I don't have a compiler on this machine. If somebody
can point me to a copy of pg_filedump for Windows (I
didn't see any using Google) I'd be happy to use it.
Or perhaps I could compile it under cygwin.
The hard drive is a Western Digital 200GB JD
On Mon, Oct 10, 2005 at 04:28:57PM -0400, Tom Lane wrote:
It's really highly annoying that we can't see the contents of the
infomasks for the rows.
Any particular reason there isn't an infomask system column?
--
Michael Fuhr
---(end of
Hi list,
I have a weird problem with grants. Probably I am forgetting something, but I
simply don't understand it.
We have a user 'x' that is member of group 'a'
there is a sequence where
Grant all on table schema.sequence to group 'a'
But still I get a permission denied when I try to access
Michael Fuhr [EMAIL PROTECTED] writes:
On Mon, Oct 10, 2005 at 04:28:57PM -0400, Tom Lane wrote:
It's really highly annoying that we can't see the contents of the
infomasks for the rows.
Any particular reason there isn't an infomask system column?
(a) inertia
(b) lack of desire to add an
On Mon, 2005-10-10 at 16:37, Dick Kniep wrote:
Hi list,
I have a weird problem with grants. Probably I am forgetting something, but I
simply don't understand it.
We have a user 'x' that is member of group 'a'
there is a sequence where
Grant all on table schema.sequence to group 'a'
Dick Kniep [EMAIL PROTECTED] writes:
We have a user 'x' that is member of group 'a'
there is a sequence where
Grant all on table schema.sequence to group 'a'
But still I get a permission denied when I try to access the sequence as user
'x'.
Works fine for me, so you've omitted some
On Mon, Oct 10, 2005 at 05:28:17PM -0400, Tom Lane wrote:
I recall having proposed that we stop storing explicit pg_attribute
entries for system columns, which would make this sort of change easier
to make, and would save a pretty considerable amount of space in
pg_attribute too. (In the
Martijn van Oosterhout kleptog@svana.org writes:
On Mon, Oct 10, 2005 at 05:28:17PM -0400, Tom Lane wrote:
But people were a bit worried about what
might break.
In catalog/heap.c there already is a SystemAttributeByName() to do the
legwork. Seems to me all you'd need to do is check just as
Check the TODO, I'm 99% certain it's on there.
On Mon, Oct 10, 2005 at 02:02:32PM +0200, Csaba Nagy wrote:
On Mon, 2005-10-10 at 13:34, Lincoln Yeoh wrote:
[snip]
It's actually quite surprising how many people get this wrong and don't
realize it (I wonder how many problems are because of
On Mon, Oct 10, 2005 at 09:51:48AM -0500, Scott Marlowe wrote:
Actually, the same could be said of Samba and Apache. I'll take one Tom
Lane or Jan Wieck or (all the other postgresql hackers go here) over
1,000 MySQL hackers.
I wonder what kind of result we would get if we compared something
Guys,
I was interested in researching a few items regarding bug reports in
PostgreSQL, but I can't seem to find what the project uses as a bug
tracker. I see the web form and mailing list, but I can't imagine
they're not captured in some central repository.
Could someone point me in the right
What's the datatype on naamvrouw? Notice that it's being casted to text,
which means an index on that column won't be used.
On Mon, Oct 10, 2005 at 11:29:38AM +0200, [EMAIL PROTECTED] wrote:
Tom, Oleg, Yonathan,
thanks for the suggestions.
Indeed, upping the statistics from 10 to 100
J B wrote:
Guys,
I was interested in researching a few items regarding bug reports in
PostgreSQL, but I can't seem to find what the project uses as a bug
tracker. I see the web form and mailing list, but I can't imagine
they're not captured in some central repository.
Could someone point me
On Mon, Oct 10, 2005 at 07:59:16PM -0400, J B wrote:
Guys,
I was interested in researching a few items regarding bug reports in
PostgreSQL, but I can't seem to find what the project uses as a bug
tracker. I see the web form and mailing list, but I can't imagine
they're not captured in some
On Mon, Oct 10, 2005 at 05:20:13PM -0700, Joshua D. Drake wrote:
J B wrote:
Guys,
I was interested in researching a few items regarding bug reports in
PostgreSQL, but I can't seem to find what the project uses as a bug
tracker. I see the web form and mailing list, but I can't imagine
On Mon, 10 Oct 2005, Joshua D. Drake wrote:
J B wrote:
Guys,
I was interested in researching a few items regarding bug reports in
PostgreSQL, but I can't seem to find what the project uses as a bug
tracker. I see the web form and mailing list, but I can't imagine
they're not captured in some
IIRC the last time this was brought up it was violently shot-down on
-hackers (and the fact that bugzilla didn't directly support PostgreSQL
back then had nothing to do with it).
Yep, but you never know. Someday it just may happen. The community got
Linus to
stop using his email box for
On 10/10/2005 1:32 PM, Dann Corbit wrote:
From:
http://www.filmsite.org/whof4.html
Valiant: Come on. Nobody's gonna drive this lousy freeway when they can take
the Red Car for a nickel.
Doom: Oh, they'll drive. They'll have to. You see, I bought the Red Car so I
could dismantle it.
I don't
On Mon, 10 Oct 2005, Joshua D. Drake wrote:
IIRC the last time this was brought up it was violently shot-down on
-hackers (and the fact that bugzilla didn't directly support PostgreSQL
back then had nothing to do with it).
Yep, but you never know. Someday it just may happen. The community
On a side note, have you considered submitting a case study about the
work you're doing? One place where MySQL AB and it's zealots likes to
beat PostgreSQL over the head is with it's list of clients. It'd be nice
to be able to say that the Mayo Clinic is using PostgreSQL.
On Mon, Oct 10, 2005 at
Marc G. Fournier wrote:
On Mon, 10 Oct 2005, Joshua D. Drake wrote:
IIRC the last time this was brought up it was violently shot-down on
-hackers (and the fact that bugzilla didn't directly support PostgreSQL
back then had nothing to do with it).
Yep, but you never know. Someday it just
Excuse me, How? I try to find the way but not found. Douglas McNaught [EMAIL PROTECTED] 10-Oct-05 20:07:57 pm "Premsun Choltanwanich" [EMAIL PROTECTED] writes: The lib I use is call lo_in and lo_out for manage BLOB. I understand that lo_unlink be related with lo_import and lo_export so I don't
Joshua D. Drake [EMAIL PROTECTED] writes:
I have thought about that, however I would at least at some level want a
blessing. For example, if we did that would we do it with
pgFoundry bug tracking? Or would we use Trac? Or Bugzilla?
I think the main thing that's killed previous proposals in
If integer's range is -2147483648 to +2147483647, why
is serial's range only 1 to 2147483647 instead of 1 to
about 4294967294?
CSN
__
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/
CSN [EMAIL PROTECTED] writes:
If integer's range is -2147483648 to +2147483647, why
is serial's range only 1 to 2147483647 instead of 1 to
about 4294967294?
How are you going to stuff 4294967294 into an integer field, which as
you just stated has an upper limit of 2147483647?
If we had an
Marc G. Fournier wrote:
Stupid question, but what does MySQL bring to the equation? Why not
just use PostgreSQL in the first place?
Simplicity. A huge user base. No one is questioning that pg is a
superior product :)
http://www.mysql.com/why-mysql/marketshare/ *
*with a pinch of salt
[EMAIL PROTECTED] wrote:
What is Oracle after? Small DB technology? They already have rdb.
Firebird, back in the Groton Database Corporation days, was built to be
compatible with rdb. Marrying those technologies through modification of
existing gateways makes more technological sense than
Marc G. Fournier wrote:
Stupid question here, but how susceptible is Oracle to monopolistic
practices, similar to what M$ is going through with the DoJ in the US?
This seems to be *very* close to the line, if it isn't over it ... no?
One big issue is that MS has the DOJ watching over it,
Chris Browne wrote:
[EMAIL PROTECTED] (Uwe C. Schroeder) writes:
On Saturday 08 October 2005 21:07, Chris Browne wrote:
2. The code base was pretty old, pretty creaky, and has a *really*
heavy learning curve.
It was pretty famous as being *really* difficult to build; throw
--- Tom Lane [EMAIL PROTECTED] wrote:
CSN [EMAIL PROTECTED] writes:
If integer's range is -2147483648 to +2147483647,
why
is serial's range only 1 to 2147483647 instead of
1 to
about 4294967294?
How are you going to stuff 4294967294 into an
integer field, which as
you just stated
Terence wrote:
Marc G. Fournier wrote:
Stupid question, but what does MySQL bring to the equation? Why not
just use PostgreSQL in the first place?
Simplicity.
Simplicity is in the eye of the beholder. Which of a dozen or so
different storage engines should I use for table X? If I mix
On Oct 11, 2005, at 14:04 , CSN wrote:
I was thinking about the types in the C code behind
PostgreSQL, rather than types in PG itself. Been a
long time since I coded in C but I thought it had
unsigned ints and maybe data types could be mapped as
so (pardon my ignorance about C/PG's inner
84 matches
Mail list logo