Re: [GENERAL] reading build config.log --> possible bug?

2011-11-27 Thread Rob Sargentg
On 11/27/2011 09:31 PM, Tom Lane wrote: Rob Sargentg writes: Looking to see where my new data directory is in recently built 9.1 I happened upon what could potentially be a bug in configure: Just after the line which begins "configure_args=" (line 11068 for me, 99% of buffer) I find: datadir='$

Re: [GENERAL] reading build config.log --> possible bug?

2011-11-27 Thread Tom Lane
Rob Sargentg writes: > Looking to see where my new data directory is in recently built 9.1 I > happened upon what could potentially be a bug in configure: > Just after the line which begins "configure_args=" (line 11068 for me, > 99% of buffer) I find: > datadir='${datarootdir}' > datarootdir=

[GENERAL] reading build config.log --> possible bug?

2011-11-27 Thread Rob Sargentg
Looking to see where my new data directory is in recently built 9.1 I happened upon what could potentially be a bug in configure: Just after the line which begins "configure_args=" (line 11068 for me, 99% of buffer) I find: datadir='${datarootdir}' datarootdir='${prefix}/share' I'm troubled

Re: [GENERAL] Way to create unique constraint in Postgres even with null columns

2011-11-27 Thread David Johnston
On Nov 27, 2011, at 17:43, Mike Christensen wrote: > On Sun, Nov 27, 2011 at 2:18 PM, David Johnston wrote: >> -Original Message- >> From: pgsql-general-ow...@postgresql.org >> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Mike Christensen >> Sent: Sunday, November 27, 2011 5:

Re: [GENERAL] Way to create unique constraint in Postgres even with null columns

2011-11-27 Thread Thomas Kellerer
David Johnston wrote on 27.11.2011 23:18: Also, the index example above presumes you want RecipeId to be "Null-able" as opposed to MenuId as described in your original post. Well of course that was a typo in my answer, it should have been: CREATE UNIQUE INDEX Favorites_UniqueFavorite ON

Re: [GENERAL] Way to create unique constraint in Postgres even with null columns

2011-11-27 Thread Mike Christensen
On Sun, Nov 27, 2011 at 2:18 PM, David Johnston wrote: > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Mike Christensen > Sent: Sunday, November 27, 2011 5:02 PM > To: Thomas Kellerer > Cc: pgsql-general@postgresql.

Re: [GENERAL] Way to create unique constraint in Postgres even with null columns

2011-11-27 Thread David Johnston
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Mike Christensen Sent: Sunday, November 27, 2011 5:02 PM To: Thomas Kellerer Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Way to create unique constraint in Postgr

Re: [GENERAL] Way to create unique constraint in Postgres even with null columns

2011-11-27 Thread Mike Christensen
On Sun, Nov 27, 2011 at 1:47 PM, Thomas Kellerer wrote: > Mike Christensen wrote on 27.11.2011 22:18: >> >> I have a table with this layout: >> >>     CREATE TABLE Favorites >>     ( >>       FavoriteId uuid NOT NULL, --Primary key >>       UserId uuid NOT NULL, >>       RecipeId uuid NOT NULL, >>

Re: [GENERAL] Way to create unique constraint in Postgres even with null columns

2011-11-27 Thread Thomas Kellerer
Mike Christensen wrote on 27.11.2011 22:18: I have a table with this layout: CREATE TABLE Favorites ( FavoriteId uuid NOT NULL, --Primary key UserId uuid NOT NULL, RecipeId uuid NOT NULL, MenuId uuid ) I want to create a unique constraint similar to th

Re: [GENERAL] Way to create unique constraint in Postgres even with null columns

2011-11-27 Thread Pavel Stehule
Hello 2011/11/27 Mike Christensen : > I have a table with this layout: > >    CREATE TABLE Favorites >    ( >      FavoriteId uuid NOT NULL, --Primary key >      UserId uuid NOT NULL, >      RecipeId uuid NOT NULL, >      MenuId uuid >    ) > > I want to create a unique constraint similar to this:

[GENERAL] Way to create unique constraint in Postgres even with null columns

2011-11-27 Thread Mike Christensen
I have a table with this layout: CREATE TABLE Favorites ( FavoriteId uuid NOT NULL, --Primary key UserId uuid NOT NULL, RecipeId uuid NOT NULL, MenuId uuid ) I want to create a unique constraint similar to this: ALTER TABLE Favorites ADD CONSTRAINT Favorit

Re: [GENERAL] text search synonym dictionary anomaly with numbers

2011-11-27 Thread Richard Greenwood
To answer my own question - my synonym dictionary was not be applied to '1st' because '1st' is a numword, not an asciiword, and my synonym dictionary was not mapped to numword. To map a dictionary token class: ALTER TEXT SEARCH CONFIGURATION english ALTER MAPPING FOR numword WITH my_synonym_dic

[GENERAL] PostgreSQL poster

2011-11-27 Thread Ivan Voras
I was looking for some PostgreSQL promotional material and found this: http://imgur.com/4VUUw I would very much like to get a high-res version of this image - does anyone here have it? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] text search synonym dictionary anomaly with numbers

2011-11-27 Thread Richard Greenwood
Oleg, Thank you. I am sure that you have identified my problem. \dF+ english (output below) lists my dictionary which is named 'rwg_synonym' before numword so I would have thought that my dictionary would have normalized '1st' to '1' before the numword dictionary was reached. Maybe this question

Re: [GENERAL] text search synonym dictionary anomaly with numbers

2011-11-27 Thread Oleg Bartunov
Richard, you should check your mapping - '1st' belongs to 'numword' and may be processed in a different way than 'first' or '1'. Oleg On Sat, 26 Nov 2011, Richard Greenwood wrote: I am working with street address data in which 'first st' has been entered as '1 st' and so on. So I have created

Re: [GENERAL] General performance/load issue

2011-11-27 Thread Tomas Vondra
On 27 Listopad 2011, 10:45, Gaëtan Allart wrote: > Actually, this is because I changed sort_mem to 4 Mb as asked by Robert. > > I removed this setting.. This is exactly the reason why it's recommended not to do any changes until it's reasonably certain what is the caause. Did increasing the work_

Re: [GENERAL] CPU move

2011-11-27 Thread frank
This message has been digitally signed by the sender. Re___GENERAL__CPU_move.eml Description: Binary data - Hi-Tech Gears Ltd, Gurgaon, India -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.

Re: [GENERAL] CPU move

2011-11-27 Thread Frank Lanitz
Am 26.11.2011 19:18, schrieb Carlos Henrique Reimer: > Hi, > > We're planning to move our postgreSQL database from one CPU box to > another box. > > I'm considering an alternative procedure for the move as the standard > one (pg_dump from the old, copy dump to the new box, psql to restore in > th

Re: [GENERAL] General performance/load issue

2011-11-27 Thread Gaëtan Allart
Actually, this is because I changed sort_mem to 4 Mb as asked by Robert. I removed this setting.. Gaëtan Le 26/11/11 18:58, « Tomas Vondra » a écrit : >Dne 26.11.2011 18:08, Gaëtan Allart napsal(a): >> UhmŠ >> >> I'm seeing dozens and dozens of temporary file creations in logs : >> >> LOG: