Re: [SQL] Password user postgres

2002-12-22 Thread Oliver Elphick
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 conn

Re: [SQL] Password user postgres

2002-12-22 Thread Mathieu Arnold
--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

Re: [SQL] Password user postgres

2002-12-22 Thread Tomasz Myrta
> 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 t

[SQL] Password user postgres

2002-12-22 Thread Arnaudo Massimo
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://spazioinwi

Re: [SQL] create index on function - why?

2002-12-22 Thread Philip Warner
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 w