On Tue, Jan 14, 2003 at 04:27:22PM +0200, Tambet Matiisen wrote:
>
> First I would like to say, that I'm quite amazed. You even guessed table names
>right! :) I did not expect such an in-depth analysis in such a short time. Thanks,
>Tomasz!
It wasn't difficult - these names where in foreign keys
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> Database version: PostgreSQL 7.2.3 on i686-pc-linux-gnu,
> compiled by GCC 2.96
> Archiver (db) version:7.1.2
> Proceeding deespite mistmatch.
> What's going wrong?
It told you: you're using the wrong pg_dump. Apparently you have
overridden
hi all
the pg_dump utilitie return the follow message.
Database version: PostgreSQL 7.2.3 on i686-pc-linux-gnu,
compiled by GCC 2.96
Archiver (db) version:7.1.2
Proceeding deespite mistmatch.
getTables():SELECT (for PRIMARY KEY) failed on table
AnomaliasEstacion.
Exlanation from backend: E
First I would like to say, that I'm quite amazed. You even guessed table names right!
:) I did not expect such an in-depth analysis in such a short time. Thanks, Tomasz!
> -Original Message-
> From: Tomasz Myrta [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 14, 2003 11:51 AM
> To:
I would like to know in how can i reference a table
in a database A from a database B.
In resume, i want to separate the data in my
database in two others databases and make references for them.
Thanks,
Pedro Igor
---Outgoing mail is certified Virus
Free.Checked by AVG anti-virus system
Tambet Matiisen wrote:
You are right. After disabling seq_scan, it uses indexes just as you
described. Unfortunately my view happens to use subquery:
Don't disable seq_scan - sometimes it is better than indexscan.
I had the same problem as you - find subject "sub-select with aggregate"
on pgsq
>
> Can you add some sql examples - table & index definition,
> view definition?
> If your view doesn't contain other views or sub-selects,
> postgres should
> use indexes.
> Tomasz Myrta
>
You are right. After disabling seq_scan, it uses indexes just as you described.
Unfortunately my view
