Hi shreedhar :
--- shreedhar <[EMAIL PROTECTED]> wrote:
> Can any body tell that how sub queries and joins
> differs funcationally.
> Because sub queries taking lot of time than joins.
>
The following could be the probable reasons:
a) Your are using correlated queries - Correlated
queries al
Can any body tell that how sub queries and joins differs funcationally.
Because sub queries taking lot of time than joins.
Regards,
Sreedhar
"Faith, faith, faith in ourselves, faith, faith in God, this is the secret
of greatness.
If you have faith in all the three hundred and thirty millions of y
Michiel Lange <[EMAIL PROTECTED]> writes:
> I get this error message:
> psql: FATAL: permission denied
As near as I can tell, you must have some code that is trying to do
SET SESSION AUTHORIZATION --- which only a superuser is allowed to do.
Evidently user 20020003 isn't one.
Hello people,
I have this Postgres 7.3 database, and could not find if this is a known
issue, but:
I can connect to the database with my postgres user to a remote database.
This as supposed with
psql -d mydb -h 123.456.789.001 -U postgres
it goes fine... postgres user exists on my system and the
Yes, it is. We now recommend MD5, and have since 7.2. The only way to
use crypt still is to store the password UNENCRYPTED in ALTER USER.
---
Raúl Gutiérrez Sánchez wrote:
> I have tried to perform a cryp authentication bu
On Sun, Jan 26, 2003 at 06:31:50PM +0530, shreedhar wrote:
> Hi All,
>
> Before indexing query plan was showing cost as 40.00, after indexing query
> plan again showing as 'seq scan' and cost as 3060.55.
> The field which i indexed is primary key to this table.
> May i know
> 1) what is the cause
Hi All,
Before indexing query plan was showing cost as 40.00, after indexing query
plan again showing as 'seq scan' and cost as 3060.55.
The field which i indexed is primary key to this table.
May i know
1) what is the cause that scan type is showing as 'seq scan' after indexing
also
2) why it is
