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
Hello All!
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/include/mit-krb5 -fPIC -p
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
So, I needed to build a special PG, for use with xTuple (an ERP). I got the
8.4.4 source, dumped it in a directory in my home, and put the executable out
on a non-standard directory on one of my SSD.
Reading Greg Smith's "High Performance..." book, suggested that I needed the
postgresql-contri
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 Fri, 2009-10-16 at 12:04 -0500, decibel wrote:
> 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 applies for a specific query.
If that's the only reason, that seems eas
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
Hi there,
this is an announcement of our new contribution module for PostgreSQL -
Plantuner - enable planner hints
(http://www.sai.msu.su/~megera/wiki/plantuner).
Example:
=# LOAD 'plantuner';
=# create table test(id int);
=# create index id_idx on test(id);
=# create index id_idx2 on test(id
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.
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. Has thought gone into
extending the scope to a
Hi,
Is there any chance I can use the contrib/xml2 package with a 7.4
database, or does it need features only available with version 8 and
later? I'd prefer not upgrading the database for the moment, and would
like to use XSLT functions in Postgresql.
Thanks
Philippe
--
Sent via pgsql-general
"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
hi all,
Is there documentation for the contrib / fuzzystr module? I haven't been
able to find it ...
Thanks!
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
Hi,
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.
Thanks
Abhang
---(end of b
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
A variable called search_path is set to public at the begining of the
fuzzystrmatch script.
Can anyone tell me what it does?
Cheers,
t.n.a.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose a
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
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') from public.track;
ERROR: argument exceeds max
"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
I keep hearing about it and reading about it, and it sounds like
something I should be familiar with, but I have never seen the contrib
library - probably because I am working on Windows.
Does the contrib library exist for Windows?
if yes could somebody point me where can I download it from?
th
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
Is there some place where I can find information on all the contrib extenstions?
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
How come relation_size() doesn't work on an index?
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailin
I wrote:
> Grumble ... I seem to have managed to promote intagg from
> broken-on-64bit-platforms to broken-on-every-platform ...
> will look into a fix tomorrow.
Ron's problem is essentially a double-free bug. In this patch:
2005-01-27 16:35 tgl
* contrib/intagg/: int_aggregate.c, int_
Michael Fuhr <[EMAIL PROTECTED]> writes:
> I can duplicate the crash in 8.0.1 (REL8_0_STABLE) with the following
Grumble ... I seem to have managed to promote intagg from
broken-on-64bit-platforms to broken-on-every-platform ...
will look into a fix tomorrow.
regards, tom
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
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?
It seems to work fine on small arrays, but crashes on large ones.
The second query would have put about 500 rows in the aggrega
Hi group,
I've installed the win32 binary version of the 8.0beta1 using the
PGInstaller (http://pgfoundry.org/projects/pginstaller).
I've also downloaded the source to compile on our linux boxes and that is
fine. The problem I've got now is building binaries of the contrib folder
for win32 - speci
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
---
Title: Message
Is there any
functionality contained in vacuum that is
not contained in pg_autovacuum?
Suggestion:
Modify the
base schema for tables and add a timestamp column for the last vacuum
operation, and a timestamp for the last vacuum analyze. Finally, a
timestamp for the last tim
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
Apologies if this appears twice - testing a new email client.
There was some discussion the other day about a desire for int8
sequences. This simulates that by providing a large base value combined
with an int4 sequence. You will need to reset the big sequence to a new
base value every once in
58 matches
Mail list logo
