On Mon, Aug 07, 2000 at 10:58:27AM -0400, Tom Lane wrote:
> (I assume the lack of "survey_id =" here is just a cut-and-paste error?)
Yup. :)
> I think what you're getting bit by is that the optimizer doesn't
> recognize "var = function(param)" as being a potential indexscan clause.
> Does EXPLA
Rob van der Leek wrote:
> A question about the ALTER USER command I couldn't find in the
> standard documentation:
>
> - How do I assign an 'undefined' password?
>
> ALTER USER nobody WITH PASSWORD "";
>
> works, but doesn't assign an undefined password to nobody (like the
> `pg_passwd nobody` co
Hi everyone,
I'm using postgresql with php4. I wanted to write a stored procedure to
return a recordset (using pl/pgsql). From what I've read from the
documentation it seems like you can only returned postgres types like
strings, booleans, etc.
Is it possible to return recordsets using pl/pgs
A question about the ALTER USER command I couldn't find in the
standard documentation:
- How do I assign an 'undefined' password?
ALTER USER nobody WITH PASSWORD "";
works, but doesn't assign an undefined password to nobody (like the
`pg_passwd nobody` command would do).
DROP USER nobody; CRE
> Is it possible to change a user's password without using the pg_passwd
> command?
> For example, how does a user changes his password from the interactive
> monitor?
See the following commands:
CREATE USER
ALTER USER
CREATE GROUP
ALTER GROUP
For example:
ALTER USER user1 WITH PASSWORD 'passw
