RE: [ADMIN] passwords ?

2000-02-23 Thread Hossein S. Zadeh
On Thu, 24 Feb 2000, Benjamin Tehan wrote: > i tried that also and it didnt work > > [admin@host3 admin]$ su postgres > Password: > su: incorrect password > [admin@host3 admin]$ > > If i su postgres from root i dont need to enter a password > Probably because password of postgres account is d

RE: [ADMIN] passwords ?

2000-02-23 Thread Benjamin Tehan
i tried that also and it didnt work [admin@host3 admin]$ su postgres Password: su: incorrect password [admin@host3 admin]$ If i su postgres from root i dont need to enter a password Any other ideas ? -Original Message- From: aubrey [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 24

[ADMIN] passwords ?

2000-02-23 Thread Benjamin Tehan
Ok, I have a small query. When I goto create a database I cannot create one I've already created the a new postgres database via initdb and i have run postmaster I never set a password to postgres, and I've tried using the admin/root password and yet that doesnt work either. Any one got any id

[ADMIN] Concurrent access

2000-02-23 Thread paguilar
Hi, I'm running postgres in a Linux box, kernel 2.2.11. I have a C program that forks and with one child it works perfectly. With 2 or more childs the select queries return different number of fields for each child. For example, select a, b, c, d, e from table1 the child 1 returns n tuples with

[ADMIN] bug with serial field?

2000-02-23 Thread Hernan J. Gonzalez
My table 'clientes' has a serial field, with name 'rid'. Now, take a look at these queries: ss => select rid from clientes where rid > 18974 and rid < 18976; rid - 18975 (1 row) ss => select rid from clientes where rid = 18975; rid --- (0 rows) A vacuum (or vacuum analyze) did

[ADMIN] more performance on some aggregates

2000-02-23 Thread Peter Vazsonyi
I've created a table, and index. Table= test +++---+ | Field| Type | Length| +++---+ | a | int4