Hi,
I had some doubts about the gist index on cube column. So if I have a
column of type cube and create a gist index on it, would the index be
on individual elements in the cube or the cube as a whole. I mean will
a gist index on cube column improve the performance of earthdistance
function o
On 6/7/07, Sergei Shelukhin <[EMAIL PROTECTED]> wrote:
Version is 8.1
The query I originally ran returned ~4-5 rows and had a lot of other
joins and filtering conditions prior to the join with the big table.
Is there any way to instruct postgres to do joins in the specific
order or smth?
make
Vince wrote:
I want to access by postgre db over the internet. My pg_hba.conf if
setup to do this:
hostall all 0.0.0.0/0md5
Now, what I don't understand is how does the "md5" effect things?
If I connect via php:
$db = pg_connect('host=xx.xx.xx.xx port=5433 dbname=MYDB u
Hi,
is there a way to have MS-Access use ODBC and still use a passphrase
encrypted private-key?
Right now ODBC works with unencrypted key.
For security reasons I'd rather have my private key stored encrypted.
I suppose to do this Access had to tell the odbc driver the passphrase
so that it can
On Jun 9, 12:15 am, Erwin Brandstetter <[EMAIL PROTECTED]> wrote:
> 3.) Write results of the subquery in a temp table, then DELETE:
>
> CREATE TEMP TABLE mydel AS SELECT DISTINCT dokumnr FROM firma1.rid;
> DELETE FROM firma1.dok USING mydel WHERE firma1.rid.doumnr =
> mydel.doumnr;
Ah! 3.) should
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Alexander Staubo escribió:
>> Are you sure? I was under the impression that PostgreSQL could reorder
>> "where" clauses, but did not yet reorder explicit joins (as opposed
>> to implicit ones through, say, "in"). But perhaps it only applied to
>> some t
On Sat, Jun 09, 2007 at 02:43:06AM -0700, Vince wrote:
> I want to access by postgre db over the internet. My pg_hba.conf if
> setup to do this:
> hostall all 0.0.0.0/0 md5
>
> Now, what I don't understand is how does the "md5" effect things?
It causes the password exchan
I want to access by postgre db over the internet. My pg_hba.conf if
setup to do this:
hostall all 0.0.0.0/0 md5
Now, what I don't understand is how does the "md5" effect things?
If I connect via php:
$db = pg_connect('host=xx.xx.xx.xx port=5433 dbname=MYDB user=postgre
Try using COPY instead of insert select, if that is possible for you.
It is much faster than insert.
Otherwise, you might try dropping the index and constraint, loading the
data, and recreating the index and constraint.
From: [EMAIL PROTECTED]
[mailto:[EMAI
Hi all.
I use PG 8.1.8 and PostGIS 1.1.1
vka1=# select version();
version
-
PostgreSQL 8.1.8 on x86_64-pc-linux-gnu, compiled by GCC
On Jun 8, 7:59 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
wrote:
> i have 4 tables :
>
> date_table (date_id,.)
> A_table(A_table_id, something1,something2.)
> A1_table(A1_table_id references A_Table(A_Table_id),A11,A12)
> A2_table(A2_table_id references A_Table(A_table_id),A21
11 matches
Mail list logo
