* 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 -D. Thats
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 understand
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.com
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
--
/LurkingMode
NewbieMode
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
... 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 the one
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
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
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 can be
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
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
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) -- Uuhhh !
test1=#
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 with
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/
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, and
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 reading;
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'::text)
Hi,
in psql, the command "\d table" 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
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
... 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.)
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
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
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
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
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
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 mistrust the test.
Can enyone make a plug-in (?) or something so Sybase's PowerDesigner can
generate Postrgres SQL?
tnx...
Marian Simpetru
"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 long way.
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.
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
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
31 matches
Mail list logo
