Re: [SQL] create index on function - why?
At 11:46 AM 15/02/2002 -0500, Tom Lane wrote: A functional index is sort of like a hidden, precomputed column added to your table. One of the things I keep running into is the desire for a mixed functional/data index. I know the workaround is to build a function that combines all fields, but would it be hard to allow mixed indexes: create table users(id integer, last_name text); create index users_id_name on users(id,lower(name)); ? Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.B.N. 75 008 659 498) | /(@) __---_ Tel: (+61) 0500 83 82 81 | _ \ Fax: (+61) 03 5330 3172 | ___ | Http://www.rhyme.com.au |/ \| |---- PGP key available upon request, | / and from pgp5.ai.mit.edu:11371 |/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[SQL] Password user postgres
Hi everibody, i have to see the table pg_shadow, but i don't remind the default password for user postgres in a Debian system. Can you help me? Thanks Massimo -- E impari che puoi davvero sopportare, che sei davvero forte, e che vali davvero. --- --- HomePage: http://spazioinwind.iol.it/arnaudo LinuxGroup: http://www.lugge.net ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [SQL] Password user postgres
> Hi everibody, > i have to see the table pg_shadow, but i don't remind the default password > for user postgres in a Debian system. > > Can you help me? > > Thanks > Massimo Change access from localhost 127.0.0.1 inside pg_hba.conf into "trust" and restart postgres. After this you can login to postgres without any password and change forgotten password. Tomasz Myrta ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [SQL] Password user postgres
--En cette belle journée de lundi 23 décembre 2002 15:22 +0100, -- Arnaudo Massimo écrivait avec ses petits doigts : > Hi everibody, > i have to see the table pg_shadow, but i don't remind the default password > for user postgres in a Debian system. > > Can you help me? I believe that on my 7.2 : cat /usr/local/pgsql/data/global/pg_pwd will tell you everything, the first field being the login and the seventh being the password. -- Mathieu Arnold ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [SQL] Password user postgres
On Mon, 2002-12-23 at 14:22, Arnaudo Massimo wrote: > Hi everibody, > i have to see the table pg_shadow, but i don't remind the default password > for user postgres in a Debian system. The Debian packages do not set any password. Their default access is "ident sameuser", meaning that you can connect using your Unix login name, provided that user has also been created as a PostgreSQL user. The PostgreSQL superuser is 'postgres'. -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "And there were in the same country shepherds abiding in the field, keeping watch over their flock by night. And, lo, the angel of the Lord came upon them, and the glory of the Lord shone around them; and they were sore afraid. And the angel said unto them, " Fear not; for behold I bring you good tidings of great joy which shall be to all people. For unto you is born this day in the city of David a Saviour, which is Christ the Lord."Luke 2:8-11 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
