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
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
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
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
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
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
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
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
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
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 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
"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
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
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
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
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
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
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
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" :
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
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
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 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 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 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
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/
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
27 matches
Mail list logo
