We introduced prefix support in 8.4, so one may use:
=# select to_tsvector('Rumman went to iftekhar to solve it') @@
to_tsquery('ifte:*') as c;
c
---
t
(1 row)
On Sun, 21 Mar 2010, AI Rumman wrote:
I am using Postgresql 8.1 tsearch2.
I need to match a like operation in tsearch. Such
Is pg_get_functiondef an 8.4 appears to be an 8.4 function?
I don't see it in the 8.3 documentation and the servers in question are all
8.3.
Any alternatives for 8.3? pg_proc has the code body, but not the function
declaration, etc.
Andreas Kretschmer akretsch...@spamfence.net wrote in
Does any one use Wordpress-Mu with Postgresql?
If yes, please tell me the way.
On 03/21/2010 12:23 PM, AI Rumman wrote:
Does any one use Wordpress-Mu with Postgresql?
If yes, please tell me the way.
Wordpress doesn't support Postgresql as far as I know. Drupal supports
Postgresql.
--
Nilesh Govindarajan
Site Server Administrator
www.itech7.com
--
Sent via
In response to Carlo Stonebanks :
Is pg_get_functiondef an 8.4 appears to be an 8.4 function?
Yes, new since 8.4.
I don't see it in the 8.3 documentation and the servers in question are all
8.3.
Any alternatives for 8.3? pg_proc has the code body, but not the function
declaration,
In response to Jay :
Thanks!
But, since the master can contain many users (user2, user3, and so on)
I suppose this won't be a proper solution?
Sorry if I was a bit unclear in my description.
I.e., the master is of the form:
user_id date
User1 20010101
User1 2101
User1 19990101
Helo,
I am using Postgresql 8.1 and I found that to_tsquery('iftek:*) gives systax
error.
On Sun, Mar 21, 2010 at 12:11 PM, Oleg Bartunov o...@sai.msu.su wrote:
We introduced prefix support in 8.4, so one may use:
=# select to_tsvector('Rumman went to iftekhar to solve it') @@
2010/3/21 AI Rumman rumman...@gmail.com:
Helo,
I am using Postgresql 8.1 and I found that to_tsquery('iftek:*) gives systax
error.
you have to upgrade to 8.4 when you would to use this feature
regards
Pavel Stehule
On Sun, Mar 21, 2010 at 12:11 PM, Oleg Bartunov o...@sai.msu.su wrote:
On 21/03/2010 7:12 AM, Scott Marlowe wrote:
On Sat, Mar 20, 2010 at 3:57 PM, Herouth Maozhero...@unicell.co.il wrote:
The problem is not so much danger in upgrading, but the fact that doing so
without using the system's usual security/bugfix update path means
non-standard work for the
http://wiaderko.110mb.com/mustapha.html
_
Hotmail: Trusted email with Microsoft’s powerful SPAM protection.
http://clk.atdmt.com/GBL/go/210850552/direct/01/
On Sun, Mar 21, 2010 at 5:33 AM, Craig Ringer
cr...@postnewspapers.com.au wrote:
On 21/03/2010 7:12 AM, Scott Marlowe wrote:
On Sat, Mar 20, 2010 at 3:57 PM, Herouth Maozhero...@unicell.co.il
wrote:
The problem is not so much danger in upgrading, but the fact that doing
so
without using
On 21 March 2010 00:24, Adam Seering aseer...@mit.edu wrote:
Hi,
I'm trying to set up an internal general-purpose PostgreSQL server
installation. I want most users with login access to the server to be able
to create databases, but only with names that follow a specified naming
Sergey Konoplev wrote:
What about PL/pgSQL wrapper function for CREATE DATABASE with database
name check and SECURITY DEFINER option.
Not possible because CREATE DATABASE can't be executed within a function (nor
within a transaction).
Best regards,
--
Daniel
PostgreSQL-powered mail
On 21 March 2010 20:43, Daniel Verite dan...@manitou-mail.org wrote:
Sergey Konoplev wrote:
What about PL/pgSQL wrapper function for CREATE DATABASE with database
name check and SECURITY DEFINER option.
Not possible because CREATE DATABASE can't be executed within a function (nor
Daniel Verite dan...@manitou-mail.org writes:
Sergey Konoplev wrote:
What about PL/pgSQL wrapper function for CREATE DATABASE with database
name check and SECURITY DEFINER option.
Not possible because CREATE DATABASE can't be executed within a function (nor
within a transaction).
Postgresql Community:
We have an Java/JDBC application that runs against a range of versions
of Postgresql from 7.4 though 8.3 and are now moving to 8.4.
Because our databases will never approach 4GB in size we still use OIDs
... that is, in newer versions of Postgresql we create OIDs on all
On Sat, Mar 20, 2010 at 4:47 AM, Deepa Thulasidasan
deepatulsida...@yahoo.co.in wrote:
transaction table to grow by 10 times in near future. In this regard, we
would like to know if this same structure of the transaction table and the
indexing would be sufficient for quick retrivel of data
John Shott sh...@stanford.edu writes:
update status set some_column = 'some_value' where oid = 'some_string'
org.postgresql.util.PSQLException: ERROR: operator does not exist: oid =
character varying
Because these SQL commands are generated on the fly by a Java
application that opens a
Vick Khera wrote:
You really *never* delete this data? I would suspect then that having
a partitioning scheme where the number of partitions can grow over
time is going to be important to you.
he said a new table is created each day, but nothing about these daily
tables being partitions
Tom Lane et al:
Thank you for your comments and observations. In particular, you make
me realize that I likely don't know how the JDBC connection is handling
things. I find that I often tend to assume that what I see and use on
the interactive command like is exactly what is coming across
On Sun, Mar 21, 2010 at 1:30 PM, Vick Khera vi...@khera.org wrote:
Like the two Scott M's recommended, figure out your usage patterns and
partition across those vectors to optimize those searches. I would
not worry about optimizing the insert pattern.
Note that once the partitions get small
unsubscribe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Steve Crawford wrote:
Bill Moran wrote:
In response to Jonathan Tripathy jon...@abpni.co.uk:
I know the PostgreSQL licence is based on the BSD licence, however
the line which says without fee rings alarm bells, even though I
think it means that you don't have ot pay anything to the
Hi,
I've got a simple query. When I use explain analyze it lasts 7 times slower.
Why?
test_counters=# SELECT COUNT(*), xtype FROM test GROUP BY xtype ORDER BY
xtype;
count | xtype
-+---
669000 | A
84000 | B
63000 | D
15000 | E
159000 | G
7866000 | H
100 | N
Hi,
I have the following problem with the FTS: the database contains information
in several languages. As I understand, the FTS requires to associate a
language when ts_vector is created. Is there any way to make a kind of
international search, without having to associate a specific language to
Hi
I am beginner with postgres and DBT-2 database .
I am getting many errors with installation of DBT-2(dbt2-0.40)
I followed the instructions in Readme but I am not getting solution.
I build the database according to README. *build_db.sh -g -w 1
then I *run the workload run_workload.sh -d
Szymon Guz mabew...@gmail.com writes:
I've got a simple query. When I use explain analyze it lasts 7 times slower.
Why?
You've got a machine where gettimeofday() is really slow. This is
common on cheap PC hardware :-(
regards, tom lane
--
Sent via pgsql-general
Hi,
I build PG on VS2005, which files should I change to use a external lib in
my own contrib, for example, Berkeley DB 4.8.26?
Until now, I have tried the following 2 ways, but both failed.
1. Add the target include and lib
1). src/tools/msvc/config.pl
add a
28 matches
Mail list logo