Re: [GENERAL] tsearch2: plainto_tsquery() with OR?

On Thu, 9 Aug 2007, Tom Lane wrote: Oleg Bartunov <[EMAIL PROTECTED]> writes: On Thu, 9 Aug 2007, Tom Lane wrote: ... behavior that people want is "here's some words, get me a weighted result", and if the weighting improves from time to time that's OK. We need to provide that API too. I thi

Re: [GENERAL] tsearch2: plainto_tsquery() with OR?

On 8/8/07, Tom Lane <[EMAIL PROTECTED]> wrote: > Oleg Bartunov <[EMAIL PROTECTED]> writes: > > On Wed, 8 Aug 2007, cluster wrote: > >> Does anyone know where I can request an OR-version of plainto_tsquery()? > > > plainto_tsquery expects plain text, use to_tsquery for boolean operators. > > Are eit

Re: [GENERAL] tsearch2: plainto_tsquery() with OR?

Oleg Bartunov <[EMAIL PROTECTED]> writes: > On Thu, 9 Aug 2007, Tom Lane wrote: >> ... behavior that people want is "here's some words, get me a weighted >> result", and if the weighting improves from time to time that's OK. >> We need to provide that API too. > I think I understand. It's called n

Re: [GENERAL] tsearch2: plainto_tsquery() with OR?

Oleg Bartunov <[EMAIL PROTECTED]> writes: > On Thu, 9 Aug 2007, Tom Lane wrote: >> Are either of these definitions really right? If I type "foo bar baz" >> into Google, for instance, it seems to produce some sort of weighted >> result, neither a strict AND nor a strict OR. Google didn't get where

Re: [GENERAL] tsearch2: plainto_tsquery() with OR?

On Thu, 9 Aug 2007, Tom Lane wrote: Oleg Bartunov <[EMAIL PROTECTED]> writes: " neither a strict AND nor a strict OR" is not a good foundation for database text search API. Maybe not, but the Google boys have sure done well without telling anyone what their algorithms are. My feeling is that

Re: [GENERAL] tsearch2: plainto_tsquery() with OR?

Oleg Bartunov <[EMAIL PROTECTED]> writes: > " neither a strict AND nor a strict OR" is not a good foundation for > database text search API. Maybe not, but the Google boys have sure done well without telling anyone what their algorithms are. My feeling is that if you use an API that involves exp

Re: [GENERAL] tsearch2: plainto_tsquery() with OR?

On Thu, 9 Aug 2007, Tom Lane wrote: Oleg Bartunov <[EMAIL PROTECTED]> writes: On Thu, 9 Aug 2007, Tom Lane wrote: Are either of these definitions really right? If I type "foo bar baz" into Google, for instance, it seems to produce some sort of weighted result, neither a strict AND nor a stric

Re: [GENERAL] tsearch2: plainto_tsquery() with OR?

On Thu, 9 Aug 2007, Tom Lane wrote: Oleg Bartunov <[EMAIL PROTECTED]> writes: On Wed, 8 Aug 2007, cluster wrote: Does anyone know where I can request an OR-version of plainto_tsquery()? plainto_tsquery expects plain text, use to_tsquery for boolean operators. Are either of these definitio

Re: [GENERAL] tsearch2: plainto_tsquery() with OR?

Oleg Bartunov <[EMAIL PROTECTED]> writes: > On Wed, 8 Aug 2007, cluster wrote: >> Does anyone know where I can request an OR-version of plainto_tsquery()? > plainto_tsquery expects plain text, use to_tsquery for boolean operators. Are either of these definitions really right? If I type "foo bar

Re: [GENERAL] tsearch2: plainto_tsquery() with OR?

On Wed, 8 Aug 2007, cluster wrote: Does anyone know where I can request an OR-version of plainto_tsquery()? plainto_tsquery expects plain text, use to_tsquery for boolean operators. I don't understand why it doesn't exist already: In most cases, when using user entered keywords to search f

Re: [GENERAL] Crosstab Question

On Aug 8, 2007, at 19:23 , David Blewett wrote: Since the number of questions to be pivoted will vary per questionnaire the method should accept a number of columns parameter. The crosstab in the tablefunc contrib module expects the columns to be explicitly identified before hand. I suppose it

Re: [GENERAL] Take your postgresSql on the road, and live to tell of it.

You can also have a trigger that records into a log table the id & table of each record inserted/updated/deleted, and then it's a simple matter of merging changes from a certain point forward by searching that table and using the values of the current records. -- Scott Ribe [EMAIL PROTECTED] http

[GENERAL] Crosstab Question

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Hi All: I'm building an application along the lines of the questionnaire design on varlena.com [1], with slight modifications. In my design, there's a table called chartversionquestion that collects different questions into a bundle to create the qu

Re: [GENERAL] Reordering columns, will this ever be simple?

On Wed, Aug 08, 2007 at 11:37:11AM -0500, Scott Marlowe wrote: > If the danger of implementing this is some subtle bug that eats my > data, I'd just as soon do without. It's not a feature I've ever felt > the need for really. And there are lots of cool features I could > think of I'd want before

Re: [GENERAL] backend process terminates

On Wed, Aug 08, 2007 at 08:50:41AM -0400, Geoffrey wrote: > Correct on both counts. Many of the routines are wrapper routines used > to assist in code portability. That ok in programs, but shared libraries need to be careful not to use names likely to be used by programs that use them. FWIW, thi

Re: [GENERAL] Trigger not working as expected, first row gets a null value

On Wed, Aug 08, 2007 at 03:20:00PM -0700, novnov wrote: > > I know that would be best but it'd be a major undertaking to try to repro > this situation. I was hoping for some hints, 'it sounds like xyz', because > I'm pretty sure I'm just tripping over a commonplace issue. It doesn't have to be re

Re: [GENERAL] Trigger not working as expected, first row gets a null value

I know that would be best but it'd be a major undertaking to try to repro this situation. I was hoping for some hints, 'it sounds like xyz', because I'm pretty sure I'm just tripping over a commonplace issue. Rodrigo De León-2 wrote: > > On Aug 8, 3:20 pm, [EMAIL PROTECTED] (novnov) wrote: >> .

Re: [GENERAL] Having trouble building 64-bit pgsql 7.4.17 on HPUX ia64

Why don't you use latest version of postgresql? On 8/8/07, Decibel! <[EMAIL PROTECTED]> wrote: > > On Tue, Aug 07, 2007 at 06:50:14PM +0530, Rajaram J wrote: > > Hi > > > > I'm having trouble building 64-bit pgsql 7.4.17 on the latest release of > HP-UX 11.23 on ia64. > > I don't believe that's su

Re: [GENERAL] Automation using postgres

On Wed, Aug 08, 2007 at 11:48:28AM -0400, Jasbinder Singh Bali wrote: > Hi, > > I my system, I am using postgres triggers to launch some unix tools and thus > postgres not only serves the purpose of data storage but also works as an > engine to automate the whole system. (this is about my system,

Re: [GENERAL] Interpreting statistics collector output

On Wed, Aug 08, 2007 at 11:01:13AM -0400, Steve Madsen wrote: > Can anyone provide a brief overview of how to go about interpreting > the information generated by the statistics collector? I've looked > around and can't find old mailing list messages or anything in the > manual beyond the ba

Re: [GENERAL] Data Mart with Postgres

On Wed, Aug 08, 2007 at 08:56:47AM -0300, Andr? Volpato wrote: > > Hello everybody, > I?m working with a small project to a client, using Postgres to > store data in a dimensional model, fact-oriented, e.g., a Datamart. > At this time, all I have is a populated database, with the "star > schemma"

Re: [GENERAL] Reordering columns, will this ever be simple?

On Tue, Aug 07, 2007 at 02:28:20PM -0500, Tony Caduto wrote: > Gregory Stark wrote: > >"novnov" <[EMAIL PROTECTED]> writes: > > > > > >>Is there any plan to add such a capability to postgres? > >> > > > >It's been talked about. I wouldn't be surprised to see it in 8.4 but > >nobody's > >sai

Re: [GENERAL] Having trouble building 64-bit pgsql 7.4.17 on HPUX ia64

On Tue, Aug 07, 2007 at 06:50:14PM +0530, Rajaram J wrote: > Hi > > I'm having trouble building 64-bit pgsql 7.4.17 on the latest release of > HP-UX 11.23 on ia64. I don't believe that's supported. There was just discussion about this, but I can't find it in the archive right now... -- Decibel!

Re: [GENERAL] Trigger not working as expected, first row gets a null value

On Aug 8, 3:20 pm, [EMAIL PROTECTED] (novnov) wrote: > ... I also don't understand ... DDL + sample data, please... ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] PostgreSQL and cluster

7;kill -9' the postmaster >> >> >> > -- > Email.it, the professional e-mail, gratis per te: http://www.email.it/f > > Sponsor: > Non perderti nella giungla di facili promesse, Logos ti da credito sempre! > > Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6559&d=20070808 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Dump all objects under a specific schema

On Aug 8, 2007, at 14:18 , Emi Lu wrote: Is there a way that I can only dump all objects under a specific schema? Have you checked the pg_dump documentation? http://www.postgresql.org/docs/8.2/interactive/app-pgdump.html In particular, the -n flag might interest you. Michael Glaesemann gr

Re: [GENERAL] Dump all objects under a specific schema

Hi; Hello List, Is there a way that I can only dump all objects under a specific schema? I'd like to dump all tables, views' definition and data under a specific schema. pg_dump --help says that you're looking for the -n flag, so, pg_dump -n -f output.sql Hope that helps, Aurynn Sha

[GENERAL] Trigger not working as expected, first row gets a null value

I have a trigger function that updates a field in the update/insert table which uses a not so simple sql statement to find the value to update with. I am not getting the results I expect. I expect I'm falling into some classic trigger gotcha. The table being updated is for 'bids'; 'bids has a fke

[GENERAL] Dump all objects under a specific schema

Hello List, Is there a way that I can only dump all objects under a specific schema? I'd like to dump all tables, views' definition and data under a specific schema. Thank you! ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] tsearch2: plainto_tsquery() with OR?

Does anyone know where I can request an OR-version of plainto_tsquery()? I don't understand why it doesn't exist already: In most cases, when using user entered keywords to search for, there should be returned some rows even though not ALL keywords are matched. ---(en

Re: [GENERAL] Running a query from the OS CLI

Yes, that works. The actual sql executes a stored function that returns a set of records. Output to the CLI looks great !!! Thanks to all !!! -dave -Original Message- From: Michael Glaesemann [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 2:43 PM To: Gauthier, Dave Cc: pg

Re: [GENERAL] Running a query from the OS CLI

On Aug 8, 2007, at 11:13 AM, Gauthier, Dave wrote: If I have a DB called “foo” ...and... I want to run “select name from table_a where name like ‘john%’” ...and... I want no table header “NAME” in the output ...and... I want to do this as a one-liner from the linux command line ...and...

Re: [GENERAL] Running a query from the OS CLI

On Aug 8, 2007, at 13:13 , Gauthier, Dave wrote: If I have a DB called "foo" psql --dbname "foo" ...and... I want to run "select name from table_a where name like 'john%'" psql --dbname "foo" -c "select name from table_a where name like 'john %'" ...and... I want no table header "

Re: [GENERAL] Running a query from the OS CLI

See: http://www.postgresql.org/docs/8.2/interactive/app-psql.html From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gauthier, Dave Sent: Wednesday, August 08, 2007 11:14 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Running a query from t

Re: [GENERAL] Dealing with tsvector in fuctions for data split

On Wed, 8 Aug 2007, Francisco Reyes wrote: Francisco Reyes writes: ERROR: operator does not exist: text || tsvector what'd you expect from this operation ? In 8.2 you can cast tsvector to text like this: =# select textin( tsvector_out( strip( to_tsvector('1 b c'::text || 'some text'::

[GENERAL] Running a query from the OS CLI

If I have a DB called "foo" ...and... I want to run "select name from table_a where name like 'john%'" ...and... I want no table header "NAME" in the output ...and... I want to do this as a one-liner from the linux command line ...and... I don't want to have to deal with intermediate files

Re: [GENERAL] PostgreSQL and cluster

'kill -9' the postmaster > > > -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: Non perderti nella giungla di facili promesse, Logos ti da credito sempre! Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6559&d=20070808

Re: [GENERAL] import content of XLS file into PostgreSQL

Hello, On 8/8/07, Roberto Mello <[EMAIL PROTECTED]> wrote: > On 8/8/07, Ivan Zolotukhin <[EMAIL PROTECTED]> wrote: > > Hello, > > > > One more way to do it with mouse clicking only is OpenOffice. Get OO > > and install PostgreSQL driver into OpenOffice Database application, > > then you'll be able

Re: [GENERAL] Reordering columns, will this ever be simple?

On 8/8/07, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote: > On Tue, Aug 07, 2007 at 08:15:19PM +0100, Gregory Stark wrote: > > "novnov" <[EMAIL PROTECTED]> writes: > > > > > Is there any plan to add such a capability to postgres? > > > > It's been talked about. I wouldn't be surprised to see it

Re: [GENERAL] Take your postgresSql on the road, and live to tell of it.

On 8/7/07, Owen Hartnett <[EMAIL PROTECTED]> wrote: > At 2:15 PM -0700 8/7/07, Ben wrote: > >How many users do you have? Have you considered giving each user a > >schema in which to make their changes? It sounds like you don't > >really have a multi-master replication issue, which makes things > >e

Re: [GENERAL] array_to_set functions

On Tue, 2007-08-07 at 17:46 -0500, Decibel! wrote: > On Sun, Aug 05, 2007 at 08:18:08PM +0530, Merlin Moncure wrote: > > On 8/3/07, Guy Fraser <[EMAIL PROTECTED]> wrote: > > > On Wed, 2007-08-01 at 07:14 +0530, Merlin Moncure wrote: > > > > On 8/1/07, Decibel! <[EMAIL PROTECTED]> wrote: > > > > > D

[GENERAL] Automation using postgres

Hi, I my system, I am using postgres triggers to launch some unix tools and thus postgres not only serves the purpose of data storage but also works as an engine to automate the whole system. (this is about my system, talking on a broader level ) I just wanted to know if there's any related work

[GENERAL] Interpreting statistics collector output

Can anyone provide a brief overview of how to go about interpreting the information generated by the statistics collector? I've looked around and can't find old mailing list messages or anything in the manual beyond the basics of how to query the statistics. Cache hit rates are easy to com

Re: [GENERAL] Dealing with tsvector in fuctions for data split

Francisco Reyes writes: ERROR: operator does not exist: text || tsvector Also, it'd be worth to show simplified version of your function, which demonstrates your problem. I did include that. The function looks like: AS $$ DECLARE v_sql TEXT; BEGIN v_sql := 'INSERT INTO messagecatalog

Re: [GENERAL] Modified FIFO queue and insert rule

On Wednesday 8. August 2007 15:12, Alban Hertroys wrote: >Leif B. Kristensen wrote: >> CREATE RULE placelimit AS >> ON INSERT TO recent_places DO ALSO >> DELETE FROM recent_places >> WHERE >> -- this clause doesn't work >> -- (place_fk = NEW.place_fk AND id <> NEW.id) OR >>

Re: [GENERAL] Modified FIFO queue and insert rule

Leif B. Kristensen wrote: > CREATE RULE placelimit AS > ON INSERT TO recent_places DO ALSO > DELETE FROM recent_places > WHERE > -- this clause doesn't work > -- (place_fk = NEW.place_fk AND id <> NEW.id) OR > id NOT IN (SELECT id FROM recent_places ORDER BY id DESC LIMIT 10

Re: [GENERAL] List tables in reverse dependancy order

Hello, five years ago I used CREATE OR REPLACE FUNCTION list_user_tables_sort_depend (owner VARCHAR, revers BOOLEAN) RETURNS SETOF VARCHAR AS ' DECLARE tabulky VARCHAR[]; i INTEGER; opakovat BOOLEAN = ''t''; pom VARCHAR; exportovano VARCHAR[] = ''{}''; r RECORD; mohu_exportovat BOOLEAN; BEGI

Re: [GENERAL] backend process terminates

Martijn van Oosterhout wrote: On Tue, Aug 07, 2007 at 07:46:45AM -0400, Geoffrey wrote: I don't know all the idiosyncrasies of how this works, so bear with me on this. The developer at the vendor indicated that he's narrowed down the problem to a set of wrapper routines in their code. They ar

Re: [GENERAL] Reordering columns, will this ever be simple?

On Tue, Aug 07, 2007 at 08:15:19PM +0100, Gregory Stark wrote: > "novnov" <[EMAIL PROTECTED]> writes: > > > Is there any plan to add such a capability to postgres? > > It's been talked about. I wouldn't be surprised to see it in 8.4 but nobody's > said they'll be doing it yet and there are a lot

[GENERAL] Modified FIFO queue and insert rule

I found an excellent description of how to implement a fifo que in PostgreSQL at Greg Mullane's blog: http://people.planetpostgresql.org/greg/index.php?/archives/89-Implementing-a-queue-in-SQL-Postgres-version.html I have used the 'rule' approach to implement a queue that generates a quick-list

[GENERAL] Data Mart with Postgres

Hello everybody, I´m working with a small project to a client, using Postgres to store data in a dimensional model, fact-oriented, e.g., a Datamart. At this time, all I have is a populated database, with the "star schemma" common relations (PK´s / FK´s). Below is a list of the main goals

Re: [GENERAL] PostgreSQL and cluster

On Wed, Aug 08, 2007 at 01:03:54PM +0200, [EMAIL PROTECTED] wrote: > Hi. > Anybody know if is possible to install PostgreSQL in cluster mode on a > cluster formed by two windows server 2003 cluster? Yes. Set it up as a generic service, and make sure you store the data directory (and any other tabl

[GENERAL] PostgreSQL and cluster

prodotti ufficiali della Nazionale Italiana FIDAL. Vestiti di azzurro Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6907&d=20070808

Re: [GENERAL] import content of XLS file into PostgreSQL

Hello, One more way to do it with mouse clicking only is OpenOffice. Get OO and install PostgreSQL driver into OpenOffice Database application, then you'll be able to import/export spreadsheets to and from database tables and work with DB tables just like they are spreadsheets. Regards, Ivan On

[GENERAL] Installation problem

sino a marzo 2008 Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6742&d=20070808

Re: [GENERAL] Comment for column in view - "legal" or just working?

Thanks, Dave. < reminds me to run allways newest pgadmin, even on customer sites :) having it used within pgadmin makes it "legal" enough for me to rely on it within my application Best wishes, Harald > > > You can in 1.8 - that will show a collection of columns under a view, > and allow yo

Re: [GENERAL] Comment for column in view - "legal" or just working?

Harald Armin Massa wrote: > Using PostgreSQL 8.1.8 on Windows. > > I have one named listedi in schema cust; that view has one column "name" > > No I used > > comment on cust.listedi.name is > 'MyDescriptive Name'; > > and the command suceeded. Using \d+ in psql also s

Re: [GENERAL] backend process terminates

On Tue, Aug 07, 2007 at 07:46:45AM -0400, Geoffrey wrote: > I don't know all the idiosyncrasies of how this works, so bear with me > on this. The developer at the vendor indicated that he's narrowed down > the problem to a set of wrapper routines in their code. They are named > OpenFile(), Clo

[GENERAL] Comment for column in view - "legal" or just working?

Using PostgreSQL 8.1.8 on Windows. I have one named listedi in schema cust; that view has one column "name" No I used comment on cust.listedi.name is 'MyDescriptive Name'; and the command suceeded. Using \d+ in psql also shows me that comment (also I find no option within pgadmin to view it :)