On Sun, 21 Mar 2010, C?dric MOULLET wrote:
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
FTS doesn't needs to be as
Afaik no, you can make a schema-dump and extract the function
declarations from the dump.
Yeah, that's what I was doing. Bloody tedious. Thanks anyway!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/
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 new
Szymon Guz 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 mailing list (pgsql-ge
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
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 th
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
1440
Steve Crawford wrote:
Bill Moran wrote:
In response to "Jonathan Tripathy" :
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 PostgreSQL
develope
unsubscribe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sun, Mar 21, 2010 at 1:30 PM, Vick Khera 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 enough, on big
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 the
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 in
John Shott 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 JDBC connection t
On Sat, Mar 20, 2010 at 4:47 AM, Deepa Thulasidasan
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 or do we have to
> partit
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
"Daniel Verite" 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).
Note that the reas
On 21 March 2010 20:43, Daniel Verite 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
> within a transacti
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 00:24, Adam Seering 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
> convention (in
On Sun, Mar 21, 2010 at 5:33 AM, Craig Ringer
wrote:
> On 21/03/2010 7:12 AM, Scott Marlowe wrote:
>>
>> On Sat, Mar 20, 2010 at 3:57 PM, Herouth Maoz
>> wrote:
>>>
>>>
>>> The problem is not so much danger in upgrading, but the fact that doing
>>> so
>>> without using the system's usual security
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 21/03/2010 7:12 AM, Scott Marlowe wrote:
On Sat, Mar 20, 2010 at 3:57 PM, Herouth Maoz 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 sysadmin, meaning he has to
2010/3/21 AI Rumman :
> 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 wrote:
>>
>> We introduced prefix suppo
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 wrote:
> 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
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 19
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
> declarati
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 pgsql-gene
27 matches
Mail list logo
