2010/1/16 Mathieu De Zutter math...@dezutter.org:
On Sat, Jan 16, 2010 at 7:26 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
On Sat, Jan 16, 2010 at 11:02 AM, Mathieu De Zutter
math...@dezutter.org wrote:
shs-dev=# explain select * from parent where (c,n) = '(b,0)';
ERROR: input of
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(
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.
On Sun, 17 Jan 2010 20:19:59 +0300 (MSK)
Oleg Bartunov o...@sai.msu.su 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
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 select *
On Sun, Jan 17, 2010 at 8:06 PM, Jeff Davis pg...@j-davis.com 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
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 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
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 you do
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
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.
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