Sergey Burladyan writes:
> I install postgresql-server-dev-9.2 from
> 'deb http://apt.postgresql.org/pub/repos/apt/ squeeze-pgdg main'
> and try to build contrib module from 9.2 but it fault with error:
>
> $ make USE_PGXS=1 PG_CONFIG=/usr/lib/postgresql/9.2/bin/pg_config
> gcc -g -O2 -I/usr
to start the one it built.
I just did a complete removal, and my home brew PG still works fine. I'll
worry about adding contrib modules later.
Robert
Original message
>Date: Fri, 01 Jul 2011 07:20:24 +0800
>From: Craig Ringer
>Subject: Re: [GENERAL] Contrib source
On 07/01/2011 12:48 AM, gnuo...@rcn.com wrote:
I just got wholly confused. Synaptic makes it appear that *contrib is a
separate entity. And the source isn't in a src subdirectory, but in the
contrib directory directly.
Debian, like most distros, produces several binary packages from a
single
On Thursday, June 30, 2011 9:48:57 am gnuo...@rcn.com wrote:
> I just got wholly confused. Synaptic makes it appear that *contrib is a
> separate entity. And the source isn't in a src subdirectory, but in the
> contrib directory directly. If I built PG on a regular basis, I might
> remember all
with a specific set of
modules built in. So, off to build it again.
Robert
Original message
>Date: Thu, 30 Jun 2011 11:03:52 -0500
>From: Michael Nolan
>Subject: Re: [GENERAL] Contrib source
>To: gnuo...@rcn.com
>Cc: reid.thomp...@ateb.com,pgsql-general@postgresql.o
On Thu, Jun 30, 2011 at 10:17 AM, wrote:
> D'oh! I didn't recall that it was packaged together, but the contrib
> source isn't in src, where I looked. Oh well.
>
IIt's not a separate file, there should be a contrib subdirectory in the
source code file.
However, if you're using a packaged pre-
D'oh! I didn't recall that it was packaged together, but the contrib source
isn't in src, where I looked. Oh well.
thanks,
Robert
Original message
>Date: Thu, 30 Jun 2011 11:04:43 -0400
>From: Reid Thompson
>Subject: Re: [GENERAL] Contrib source
>To:
On Thu, 2011-06-30 at 10:46 -0400, gnuo...@rcn.com wrote:
> I'll need the contrib source, and I don't find it anywhere. I must not be
> looking in the right place.
>
> Where might that be?
http://www.postgresql.org/ftp/source/
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
On Fri, Oct 16, 2009 at 10:04 AM, decibel wrote:
> Out of curiosity, did you look at doing hints as comments in a query? I'm
> guessing you couldn't actually do that in just a contrib module, but it's
> how Oracle handles hints, and it seems to be *much* more convenient, because
> a hint only appl
On Oct 16, 2009, at 10:04 AM, decibel wrote:
Out of curiosity, did you look at doing hints as comments in a query?
I don't think that a contrib module could change the grammar.
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
On Oct 6, 2009, at 2:57 PM, Oleg Bartunov wrote:
this is an announcement of our new contribution module for
PostgreSQL - Plantuner - enable planner hints
(http://www.sai.msu.su/~megera/wiki/plantuner).
=# set enable_seqscan=off;
=# set plantuner.forbid_index='id_idx2';
Out of curiosity, did
Thanx for tip, Tom. I'll definitely give that a try in my spare time.
Cheers,
Kevin
Tom Lane wrote:
Kevin Neufeld <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
A superuser can create whatever he wants in pg_catalog. Whether this
is a good idea or will behave smoothly is a topic that has not be
Kevin Neufeld <[EMAIL PROTECTED]> writes:
>> Tom Lane wrote:
>>> A superuser can create whatever he wants in pg_catalog. Whether this
>>> is a good idea or will behave smoothly is a topic that has not been
>>> thought about, to my knowledge.
> Sorry, Tom. I think you are mistaken. In my 8.3 inst
Tom Lane wrote:
A superuser can create whatever he wants in pg_catalog. Whether this
is a good idea or will behave smoothly is a topic that has not been
thought about, to my knowledge.
regards, tom lane
Sorry, Tom. I think you are mistaken. In my 8.3 instance, system
catalo
Really? I didn't know that ... guess I never tried. I'll have to do
some experimenting! Thanx Tom.
-- Kevin
Tom Lane wrote:
Kevin Neufeld <[EMAIL PROTECTED]> writes:
This might seem like a silly question, but what are the implications of
PostgreSQL allowing developers to create custom catal
Kevin Neufeld <[EMAIL PROTECTED]> writes:
> This might seem like a silly question, but what are the implications of
> PostgreSQL allowing developers to create custom catalogs?
> For example, PostgreSQL currently uses the pg_catalog schema to store
> system catalogs / relations / functions / etc.
"brien colwell" <[EMAIL PROTECTED]> writes:
> Is there documentation for the contrib / fuzzystr module? I haven't been
> able to find it ...
Should be a couple of README files whereever your contrib documentation
is installed ...
$ ls contrib/fuzzystrmatch
CVS/ fuzzystrma
I have installed postgresql 8.2 on redhat enterprise release WS 4. I
need to use the cube operator which I guess resides in the contrib
modules. Please may I know the link to install the appropricate contrib
module for my linux machine.
1) If you have an automatic updater like yum configured, yo
usually contrib is installed along with postgresql.
Look for
/usr/lib/pgsql/contrib or /usr/lib/postgresql/contrib
and maybe it resides in
/usr/share/pgsql/contrib
or just type
locate contrib
Uwe
On Thursday 17 May 2007, ABHANG RANE wrote:
> Hi,
> I have installed postgresql 8.2 on redhat ent
On Dec 9, 2006, at 21:52 , Tomi N/A wrote:
I would have, but I don't know where the documentation is. The README
in /usr/share/doc/postgresql-x.x.x/contrib doesn't mention it.
It's not specific to fuzzymatch (or any other contrib module): it's a
feature of the PostgreSQL server itself.
Mi
On Dec 09 12:52, Tomi N/A wrote:
> 2006/12/9, Martijn van Oosterhout :
> >Check the documentation for the details, but it's basically:
>
> I would have, but I don't know where the documentation is. The README
> in /usr/share/doc/postgresql-x.x.x/contrib doesn't mention it.
Google does. Search for
2006/12/9, Martijn van Oosterhout :
On Sat, Dec 09, 2006 at 12:08:08PM +, Tomi N/A wrote:
> A variable called search_path is set to public at the begining of the
> fuzzystrmatch script.
> Can anyone tell me what it does?
Check the documentation for the details, but it's basically:
- The lis
On Sat, Dec 09, 2006 at 12:08:08PM +, Tomi N/A wrote:
> A variable called search_path is set to public at the begining of the
> fuzzystrmatch script.
> Can anyone tell me what it does?
Check the documentation for the details, but it's basically:
- The list of schemas to look in when given a t
Ah, yes, you are correct.
Hm, it's too bad levenshtein() is ascii-only.
On Thu, 28 Sep 2006, Tom Lane wrote:
Ben <[EMAIL PROTECTED]> writes:
The levenshtein function from contrib/fuzzystrmatch.sql has a max arg
length of 255. OK, that's cool. But check this out:
mbrainz_db=> select max(len
Ben <[EMAIL PROTECTED]> writes:
> The levenshtein function from contrib/fuzzystrmatch.sql has a max arg
> length of 255. OK, that's cool. But check this out:
> mbrainz_db=> select max(length(name)) from public.track;
> max
> -
> 255
> (1 row)
> mbrainz_db=> select levenshtein(name,'foo')
On Thu, Sep 28, 2006 at 12:02:34PM -0700, Ben wrote:
> The levenshtein function from contrib/fuzzystrmatch.sql has a max arg
> length of 255. OK, that's cool. But check this out:
>
> mbrainz_db=> select levenshtein(name,'foo') from public.track;
> ERROR: argument exceeds max length: 255
The m
"SunWuKung" <[EMAIL PROTECTED]> wrote
>
> Does the contrib library exist for Windows?
If you are compiling from source tar ball, it is in pgsql\contrib.
Regards,
Qingqing
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will i
Thanks guys,
Found it!
Just needed info on the pgcrypto package.
[EMAIL PROTECTED] (S McLurkin) writes:
> Is there some place where I can find information on all the contrib
> extenstions?
Download the sources, and examine each directory for its
documentation. There is commonly a README file...
--
output = ("cbbrowne" "@" "ntlug.org")
http://cbbrowne.com/inf
S McLurkin wrote:
Is there some place where I can find information on all the contrib
extenstions?
The source distribution has a series of README files in the contrib/
directory.
If you have a packaged version, documentation will depend on the
packaging. Is there a specific package you are
On Tue, Dec 20, 2005 at 10:31:06PM -0800, S McLurkin wrote:
> Is there some place where I can find information on all the contrib
> extenstions?
In the contrib directory of the source code. That directory has a
README with a short summary of each extension, and each extension's
subdirectory has o
On Tue, Apr 05, 2005 at 01:43:56PM -0400, Joseph Shraibman wrote:
>
> Can I take the new .c file, do a make install, and have it work in 7.4.7 ?
Not unmodified, since it uses features new to 8.0 (e.g., tablespaces).
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---(end of
Can I take the new .c file, do a make install, and have it work in 7.4.7 ?
Michael Fuhr wrote:
On Tue, Apr 05, 2005 at 01:25:01PM -0400, Joseph Shraibman wrote:
local]:o=>select version();
version
--
On Tue, Apr 05, 2005 at 01:25:01PM -0400, Joseph Shraibman wrote:
> local]:o=>select version();
> version
> -
> PostgreSQL 7.4.7 on i686-pc-linux
local]:o=>select version();
version
-
PostgreSQL 7.4.7 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2
20030222 (Red Hat Linux 3.2.2-5)
(1
On Tue, Apr 05, 2005 at 12:24:02PM -0400, Joseph Shraibman wrote:
>
> How come relation_size() doesn't work on an index?
Could you define "doesn't work"? An example with the expected and
actual output might show what's happening.
I just ran some simple tests and relation_size() correctly showed
On Tue, Mar 22, 2005 at 05:21:32PM -0800, Ron Mayer wrote:
>
> If one of the contrib modules (int_array_aggregate in contrib/intagg) is
> crashing my backend, where's a good place to report a bug or get hints
> where to look further?
Bug reports should go to the pgsql-bugs mailing list (I've cc
On Monday 29 March 2004 05:24 pm, Dann Corbit wrote:
> Of course I meant that is contained in "vacuumlo" --> stupid spell
I have never worked with large objects in postgresql and I have no idea what
is different with vacuumlo. Suggestions or thoughts anyone?
Matthew
---
Of course I meant that is contained in "vacuumlo" --> stupid spell
checker auto-corrected it.
-Original Message-
From: Dann Corbit
Sent: Monday, March 29, 2004 2:24 PM
To: [EMAIL PROTECTED]
Subject: Contrib question
Is there any functionality contained in vacuum that is not contained in
39 matches
Mail list logo
