2010/1/16 Mathieu De Zutter :
> On Sat, Jan 16, 2010 at 7:26 PM, Scott Marlowe
> wrote:
>> On Sat, Jan 16, 2010 at 11:02 AM, Mathieu De Zutter
>> wrote:
>>> shs-dev=# explain select * from parent where (c,n) = '("b",0)';
>>> ERROR: input of anonymous composite types is not implemented
>>
>> Sho
Hello folks,
PGCon 2010 will be held 20-21 May 2010, in Ottawa at the University of
Ottawa. It will be preceded by two days of tutorials on 18-19 May 2010.
We are now accepting proposals for talks.
If you are doing something interesting with PostgreSQL, please submit
a proposal. You might be
My initial request was about a way to build up a tsquery that was
made similar to what plainto_tsquery does but using | inspite of &
as a glue.
But at the end of the day I'd like to find similar tsvectors and
rank them.
I've a table containing several fields that contribute to build up a
weighted
I'm looking for a data generator. Free would be nice, if possible. Has
anyone had good luck w/ anything? maybe point me in a good direction :)
Thanks,
Jamie K.
Ivan,
You can write function to get lexemes from tsvector:
CREATE OR REPLACE FUNCTION ts_stat(tsvector, weights text, OUT word text, OUT
ndoc
integer, OUT nentry integer)
RETURNS SETOF record AS
$$
SELECT ts_stat('SELECT ' || quote_literal( $1::text ) || '::tsvector',
quote_literal( $2::te
On 01/17/2010 09:26 AM, Jamie Kahgee wrote:
I'm looking for a data generator. Free would be nice, if possible. Has
anyone had good luck w/ anything? maybe point me in a good direction :)
Thanks,
Jamie K.
I use perl. And its free. It has no limitations on what it can generate.
Compatibl
On Sun, 17 Jan 2010 20:19:59 +0300 (MSK)
Oleg Bartunov wrote:
> Ivan,
>
> You can write function to get lexemes from tsvector:
> CREATE OR REPLACE FUNCTION ts_stat(tsvector, weights text, OUT
> word text, OUT ndoc integer, OUT nentry integer)
> RETURNS SETOF record AS
> $$
> SELECT ts_stat
On Sat, 2010-01-16 at 19:02 +0100, Mathieu De Zutter wrote:
> Hi,
>
> I'm trying to make constraint exclusion work correctly in a query with
> only one parameter, but I have some issues.
> Please have a look at the scenario below and tell me how I can improve it.
>
...
> shs-dev=# explain selec
On Sun, Jan 17, 2010 at 8:06 PM, Jeff Davis wrote:
> On Sat, 2010-01-16 at 19:02 +0100, Mathieu De Zutter wrote:
>> Hi,
>>
>> I'm trying to make constraint exclusion work correctly in a query with
>> only one parameter, but I have some issues.
>> Please have a look at the scenario below and tell m
On Sun, 2010-01-17 at 21:48 +0100, Mathieu De Zutter wrote:
> Can you explain this then:
> OK: select * from parent where (c,n) = ('b',0);
> NOT OK: select * from parent where (c,n)::y = ('b',0)::y;
Once you pass (c,n) into the cast, you get out something new that's
neither c nor n. It's as if you
Jamie Kahgee, 17.01.2010 16:26:
I'm looking for a data generator. Free would be nice, if possible. Has
anyone had good luck w/ anything? maybe point me in a good direction :)
Thanks,
Jamie K.
Have a look at "Benerator" I have been told, that it's quite good (I haven't
used it myself though
Hi All,
I am new to Postgresql and I need to turn off the AUTO COMMIT in
PostgreSQL 8.3.Can anyone guide me how to do it as SET AUTOCOMMIT = off;
does not seem to be supported any more in PostgreSQL 8.3.
Many thanks for help!
all
is there a external table create method ( similar to oracle external table )
? where to find the information ?
thanks
Amy
a.bhattacha...@sungard.com wrote:
> Hi All,
>
>
>
> I am new to Postgresql and I need to turn off the AUTO COMMIT in PostgreSQL
> 8.3.Can anyone guide me how to do it as SET AUTOCOMMIT = off; does not seem to
> be supported any more in PostgreSQL 8.3.
Do you using psql as client?
\set AUTOC
a.bhattacha...@sungard.com wrote:
> Hi All,
>
>
>
> I am new to Postgresql and I need to turn off the AUTO COMMIT in
> PostgreSQL 8.3.Can anyone guide me how to do it as SET AUTOCOMMIT = off;
> does not seem to be supported any more in PostgreSQL 8.3.
Just explicitly begin a transaction, like
Amy Smith wrote:
> all
> is there a external table create method ( similar to oracle external
> table ) ? where to find the information ?
For those non-Oracle users among us, what's an external table? What are
you trying to achieve?
Random guess: you might be looking for tablespaces.
--
Craig Ri
On Sat, Jan 16, 2010 at 09:10:53PM +, Greg Stark wrote:
> Switching to ICU means trading our current inconsistency from platform
> to platform for a different inconsistency which would be better in
> some cases and worse in others.
Or, you can have the cake and eat it too. That is, aim for the
On Sun, Jan 17, 2010 at 07:27:34PM -0800, Amy Smith wrote:
> all
> is there a external table create method ( similar to oracle external table )
> ? where to find the information ?
There is a project on pgfoundry which has had some activity lately
that's similar. You might also try DBI-Link.
Chee
On Fri, Jan 15, 2010 at 08:41:38AM -0700, Scott Marlowe wrote:
> With slony 2.0.3 or so, I had occasional complete lockups of my
> database that I didn't have time to troubleshoot as it was a live
> cluster and I had to restart slony and the databases to get them back
> up and running.
With slony
19 matches
Mail list logo