> Hmm, it certainly should be there somewhere, but the path might be
> either of these:
>.../lib/pgxs/src/makefiles/pgxs.mk
>.../lib/postgresql/pgxs/src/makefiles/pgxs.mk
> depending on exactly how the build was done. If it's not there at
> all this is an installer bug.
>
>
Hello list,
I'm trying to build the PL/R module on Win32 with PostgreSQL 8.3. I've
done this before with no trouble using several 8.2.x versions of
PostgreSQL (from the win32 installer). However, now that I'm trying to
update things for 8.3, it seems that the pgxs.mk file needed by the PL/R
Hello list,
Last night I was finally able to compile in MinGW the PL/R module for
using R stats in PostgreSQL. I describe how I did this here:
http://gborg.postgresql.org/pipermail/plr-general/2006-December/000183.html.
However, as I mention in that post, it seems that the dll doesn't want
to w
o add a routine
in my php scripts that does essentially the same thing.
I really appreciate your help,
Mike
Martijn van Oosterhout wrote:
On Fri, Apr 28, 2006 at 08:35:08AM -0400, Mike Leahy wrote:
Hello list,
Following from a question I had yesterday, I'm wondering if there is
s
Hello list,
Following from a question I had yesterday, I'm wondering if there is
some way to summarize the unique values of an indexed column in
PostgreSQL without having the query scan the whole table. For my
current work, I have many large tables, all of which have an indexed
column for the yea
---
Group (cost=0.00..161575.24 rows=2 width=2) (actual
time=0.350..2128.425 rows=2 loops=1)
-> Index Scan using schoolse_school_year on tbl_ind_schools_edu
(cost=0.00..161436.67 rows=55431 width=2) (actual time=0.296..1689.331
rows=55431 loops=1)
Total runti
Hello list,
I've been having a bit of difficulty getting Postgres to use indexes on
some large tables that I have. Included below are the results from
'explain analyze' for two queries that should get the unique years of
data that are available from two different tables (tbl_ind_schools_edu
and t
riginal Message-
From: Stephan Szabo [mailto:[EMAIL PROTECTED]
Sent: October 15, 2003 12:11 AM
To: Mike Leahy
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Indexes?
On Tue, 14 Oct 2003, Mike Leahy wrote:
> CREATE INDEX tbl_censo_poblacion_1993_manzana_idx ON tbl_censo_poblacion_1993
> ( dubi
Okay.I'm following the documentation that came with the PostgreSQL source
code (located in /usr/doc/postgresql-7.3.4-2/html/arrays.hmtl in my cygwin
root).
I created have a table with a varchar array in it, kind of like the
following:
CREATE TABLE tbl_db_usuario_detalles (NOMBRE varchar(50), COD_
Hello all,
I've got an issue with the ODBC component with PostgreSQL (v 7.3.4-2 in
Cygwin). I've connected to my DB using MS Access, and things seemed to be
working reasonably well.
However, when I exported a table to the DB from Access, while it shows up in
the list of tables in the DB, if I
10 matches
Mail list logo
