Re: SV: [GENERAL] MySQL and PostgreSQL speed compare

2000-12-29 Thread Alfred Perlstein
* Lamar Owen <[EMAIL PROTECTED]> [001229 13:13] wrote: > Jarmo Paavilainen wrote: > > I run both MySQL and PostgreSQL as they are (minimum switches, no tuning, as > > default as it can be). That is MySQL as the .rpm installed it > > (--datadir --pid-file --skip-locking) and PostgreSQL with -i -S -

Re: SV: [GENERAL] MySQL and PostgreSQL speed compare

2000-12-29 Thread Lamar Owen
Alfred Perlstein wrote: > Lamar Owen wrote: > > But, then again, if the default settings are so bad performance-wise, > > why _are_ they the default anyway? There should be good reason, of > > course, but I think maybe the defaults could or should be revisited as > > to applicability. > I can un

Re: SV: [GENERAL] MySQL and PostgreSQL speed compare

2000-12-29 Thread John Burski
> > > > I really don't understand why people expect computers to do everything > for them, the burden of using tools properly belongs to the user. > Let the congregation say "Amen!" -- John Burski Chief IT Cook and Bottlewasher 911 Emergency Products, St. Cloud, MN (320) 656 0076 www.911ep

Re: [GENERAL] MySQL to PostgreSQL

2000-12-29 Thread The Hermit Hacker
http://www.pgsql.com/ -> Download On Tue, 26 Dec 2000, Nelio Alves Pereira Filho wrote: > Hi there. > > I am looking for a mysql to postgresql converter but the only I got > didn't work fine (I found this one at freshmeat). > > Does anyone knows a stable converter? > > Thanks > >

[GENERAL] NULLS and <> : Discrepancies ?

2000-12-29 Thread Emmanuel Charpentier,,,
Could some kind soul explain this to me ? test1=# select distinct "Cle" from "Utilisateurs"; Cle - 1 2 3 4 (4 rows) test1=# select distinct "CleUtil" from "Histoires"; CleUtil - 1 (2 rows) -- Uuhhh ! test1=# select count(*) as NbRec from "Histoires" where "CleUtil" is null; nbr

Re: [GENERAL] Lower record

2000-12-29 Thread Len Morgan
>... I also cant use the following: > >$sql = "select threadid, commentid, name, detail from comments where >commentid < '$commentid' and threadid='$threadid'"; > > > because it gets the lowest value comment whereas what I want is the highest >value comment but lower that $commentid (so basically

[GENERAL] Re: [HACKERS] Merry X-Mass

2000-12-29 Thread Rod Taylor
Little early aren't you? select now()::date gives me 2000-12-22 Hmm.. only one digit is odd. -- Rod Taylor There are always four sides to every story: your side, their side, the truth, and what really happened. - Original Message - From: "Partyka Robert" <[EMAIL PROTECTED]> To: <[EMAIL

[GENERAL] How passwords can be crypted in postgres?

2000-12-29 Thread ouldm
Hello, I order to escape from .htaccess, I want to save user passwords in my database. However, passwords appear clear in the database. How passwords can be crypted in the database? I use PHP 3.0.16, Cobalt Raq3i. Thanks

Re: [GENERAL] How passwords can be crypted in postgres?

2000-12-29 Thread The Hermit Hacker
I usually just run 'crypt()' on the clear text before storing it to the backend ... On Fri, 22 Dec 2000 [EMAIL PROTECTED] wrote: > Hello, > > I order to escape from .htaccess, I want to save user passwords in my > database. > However, passwords appear clear in the database. > How passwords ca

Re: [GENERAL] How passwords can be crypted in postgres?

2000-12-29 Thread Steve Wolfe
From: <[EMAIL PROTECTED]> > I order to escape from .htaccess, I want to save user passwords in my > database. > However, passwords appear clear in the database. > How passwords can be crypted in the database? > > I use PHP 3.0.16, Cobalt Raq3i. Hmmm linux users that haven't heard of

[GENERAL] listing users and their rights

2000-12-29 Thread Thomas T. Thai
as a pgsql superuser, how can i list all the users and their rights? on mysql i just do a select on the mysql table. i'm a newbie here. i read the documents and didn't find the answer. also, when i start 'psql' as system user joe, it says: psql: FATAL 1: Database "joe" does not exist in the sys

Re: [GENERAL] NULLS and <> : Discrepancies ?

2000-12-29 Thread Stephan Szabo
On Fri, 22 Dec 2000, Emmanuel Charpentier,,, wrote: > Could some kind soul explain this to me ? > > test1=# select distinct "Cle" from "Utilisateurs"; > Cle > - > 1 > 2 > 3 > 4 > (4 rows) > > test1=# select distinct "CleUtil" from "Histoires"; > CleUtil > - > 1 > > (2 rows) -- Uuh

Re: SV: [GENERAL] MySQL and PostgreSQL speed compare

2000-12-29 Thread Ron Chmara
Jarmo Paavilainen wrote: > > Just curious, what kind of tables did you set up in MySQL? My > Ehh... there are more than one kind... I did not know. Still with > transactions on PostgreSQL (unsafe method?) MySQL was 2 times as fast as > PostgreSQL. I will check this out, and return to this list wi

Re: [GENERAL] listing users and their rights

2000-12-29 Thread Peter Eisentraut
Thomas T. Thai writes: > as a pgsql superuser, how can i list all the users and their rights? SELECT * FROM pg_user; -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: SV: [GENERAL] MySQL and PostgreSQL speed compare

2000-12-29 Thread Ron Chmara
John Burski wrote: > > I really don't understand why people expect computers to do everything > > for them, the burden of using tools properly belongs to the user. > Let the congregation say "Amen!" The counterpoints: (Complex tool) A car comes assembled, from the factory, tuned to accelerate, a

[GENERAL] Re: MySQL and PostgreSQL speed compare

2000-12-29 Thread Tim Kientzle
> Search were almost the same ... sorting and > reading sorted entries from dba was the same. > But insert/modify/delete [ were up to 15 times > slower in PostgreSQL than MySQL ]. One of MySQL's big speed problems involves multi-user situations where some users are writing while others are readin

Re: [GENERAL] group by and order by question

2000-12-29 Thread Emmanuel Charpentier,,,
GH wrote: > Here is the table I am using: > db=> \d links > Table "links" > Attribute | Type |Modifier > +-+ > id | integer | not null default nextval('links_id_seq':

[GENERAL] how to show foreign keys of a table

2000-12-29 Thread T. Dekany
Hi, in psql, the command "\d " gives me the table-definitions, but the defined foreign keys don't show up. How can I get those? How can I check, what foreign keys a table has? Thanx

[GENERAL] trouble with phpPgAdmin

2000-12-29 Thread Hubert Hafner
Hi i have some troubles with phpPgAdmin. PostgreSQL runs on a SuSE Linux and I want to admin it form a Win2k via phpPgAdmin. Unfortunataly I found no support in my PHP. ("Fatal error: Call to unsupported or undefined function pg_connect() in lib.inc.php on line 130") Does anyone know where I can

[GENERAL] Re: Failed Statements within Transactions

2000-12-29 Thread Tim Kientzle
> ... if a query fails inside a transactions block, > PostgreSQL "RollBack"s the whole transaction ... In my experience, it's unusual for SELECT statements (queries) to cause errors. If they do, the statements themselves are likely broken. (A SELECT that returns zero rows is not an error.) Lik

[GENERAL] authenticating local users

2000-12-29 Thread Chris Green
For local users, is there anyway to have users only be able to connect to the postmaster as the name associated with their current uid? I would like to not require db passwords on the for psql where data entry is also performed but I with full blown trust, it is too easy to circumvent uid control

[GENERAL] Compiling on SCO

2000-12-29 Thread Scott Holmes
I'm attempting to compile 7.0.2 on a SCO box. The compile fails attempting to build ecpg, complaining that nocachegetattr is undefined, first referenced in pgc.o I'm unable to find any reference to this. I used the configure options described in the FAQ_SCO file along with --with-odbc but to

[GENERAL] regress failed tests.. SERIOUS?

2000-12-29 Thread Thomas T. Thai
PLEASE NOTE: I'm brand new to PostgreSQL as of today. I've just moved from MySQL because it's not stable on NetBSD/Alpha. I don't know enough about pgsql to see if these failed test would make it unstable for production. i start the server like this: $ postmaster -D /usr/pkg/pgsql/data > /var/pg

[GENERAL] Re: PowerDesigner support?

2000-12-29 Thread Jean-Louis BERLIET
from powersoft.public.powerdesigner.general : > If you download 7.5, then you can grab the Postgresql 7.0.2 definition file from DataModel.Org http://www.datamodel.org/PowerDesigner). > Good luck. > > -- > > Michael F. Nicewarner [TeamSybase] Marian Simpetru a écrit dans le message <[EMAIL P

[GENERAL] Help in JDBC

2000-12-29 Thread Jarek
Is there anybody who can help me with JDBC Driver? Maybe this is not the best place to post this message , but should I ask ? I would like to ask a few questions about JDBC extension , especialy about Serialize class. How to use this class ? Is there any examples ? HOWTOS ? TUTORIALS ? Thx

[GENERAL] Set, SubSelect

2000-12-29 Thread George Johnson
Hello All, I spent yesterday and last nite reading the mailing lists and manual about: select * from tab1 where tab1.id in ('id1','id2','id3'); select * from tab1 where tab1.id in (select tab1.id from tab1,tab2 where tab1.id = tab2.id); select * from tab1 where exists (select tab1.id from tab1,t

Re: [GENERAL] MySQL and PostgreSQL speed compare

2000-12-29 Thread Benjamin Pflugmann
Hi. Just one note... On Fri, Dec 29, 2000 at 07:01:21PM +0100, [EMAIL PROTECTED] wrote: [...] > >>> Sir, thanks for sharing this with us. However, unless you can explain > >>> why queries inside of transactions run faster than queries outside of > >>> transactions, I would be inclined to mistrus

[GENERAL] PowerDesigner support?

2000-12-29 Thread Marian Simpetru
Can enyone make a plug-in (?) or something so Sybase's PowerDesigner can generate Postrgres SQL? tnx... Marian Simpetru

Re: SV: [GENERAL] MySQL and PostgreSQL speed compare

2000-12-29 Thread Marten Feldtmann
"Dominic J. Eidson" schrieb: > > ... > > What if I do a SELECT to check for a row. Then I do a INSERT. But between > > SELECT and INSERT someone else inserted a row. NO I do not think that "good > > programming" will solve this. > > Good design, together with good implementation, gets you a lo

[GENERAL] MD5 use in PL/Perl

2000-12-29 Thread Marc Rassbach
I'd like to be able to only store the database of usernames and passwrods here locally as a md5 hash. (in case the black hats come to visitI'd like to make life hard for them) Using AuthPG, I should be able to create a SQL call to postgresbut there is no native md5 hashing function. In

[GENERAL] geoobj type

2000-12-29 Thread Franck Martin
For the people interested, I have just commited in CVS of FMaps a new PostgreSQL type called geoobj. It is a very early release as I want to have early feedback. It is not complete and has many bugs, but it should give an overview of the type and the coding of it. It tries to follow the OpenGIS

[GENERAL] Error opening pgaccess

2000-12-29 Thread Max Wiberg
I have the latest LinuxPPC (Halloween) installation on my iMac. I'm using Postgresql 7.0.2. The installation works -- in the terminal window I can connect to the database using "psql" executing SQL-statments. and so forth. Using HTML-forms - Apache and PHP - I can enter data into the datab