Re: [GENERAL] PostgreSQL Live CD for 9.2.3 released

2013-02-27 Thread Thomas Kellerer
Devrim GÜNDÜZ, 21.02.2013 11:48: Please let me know if you have any questions regarding this live CD. Thanks for the work! I have booted a VirtualBox system from the live CD. Can I convert this to a "real" system? The homepage mentions "Option to install image to hard drive" but I can't fi

[GENERAL] What could cause a temp table to disappear?

2013-02-27 Thread François Beausoleil
Hi all, I open a transaction, create a few temporary tables, import data in them, then insert into the final tables from the temporary tables and commit. In dev, it works, but not in prod. I'm trying to track down the cause. An outline of the generated SQL is (actual log at bottom): BEGIN; CRE

Re: [GENERAL] What could cause a temp table to disappear?

2013-02-27 Thread Adrian Klaver
On 02/27/2013 01:19 PM, François Beausoleil wrote: Hi all, I open a transaction, create a few temporary tables, import data in them, then insert into the final tables from the temporary tables and commit. In dev, it works, but not in prod. I'm trying to track down the cause. An outline of the

Re: [GENERAL] What could cause a temp table to disappear?

2013-02-27 Thread François Beausoleil
Le 2013-02-27 à 16:45, Adrian Klaver a écrit : > On 02/27/2013 01:19 PM, François Beausoleil wrote: > >> >> Any hints? > > See in line notes below. > Also what client/library are you using to connect with? I use Ruby & Sequel. Sequel is a very thin library over straight SQL. >> NOTE: Log cut

Re: [GENERAL] What could cause a temp table to disappear?

2013-02-27 Thread Adrian Klaver
On 02/27/2013 01:48 PM, François Beausoleil wrote: Le 2013-02-27 à 16:45, Adrian Klaver a écrit : On 02/27/2013 01:19 PM, François Beausoleil wrote: Any hints? See in line notes below. Also what client/library are you using to connect with? I use Ruby & Sequel. Sequel is a very thin lib

Re: [GENERAL] What could cause a temp table to disappear?

2013-02-27 Thread Tom Lane
Adrian Klaver writes: > On 02/27/2013 01:48 PM, François Beausoleil wrote: >> Le 2013-02-27 à 16:45, Adrian Klaver a écrit : >>> Also what client/library are you using to connect with? >> I use Ruby & Sequel. Sequel is a very thin library over straight SQL. > Everything else is the same? It is a

Re: [GENERAL] What could cause a temp table to disappear?

2013-02-27 Thread François Beausoleil
Le 2013-02-27 à 16:59, Tom Lane a écrit : > Adrian Klaver writes: >> On 02/27/2013 01:48 PM, François Beausoleil wrote: >>> Le 2013-02-27 à 16:45, Adrian Klaver a écrit : Also what client/library are you using to connect with? > >>> I use Ruby & Sequel. Sequel is a very thin library over s

[GENERAL] Poor performance when using a window function in a view

2013-02-27 Thread Chris Hanks
Hi. Sorry if this is repetitive, I tried posting to pgsql-performance first but I think it got stuck in moderation. I'm trying to create a view that uses a window function, but it seems that Postgres is unable to optimize it. Here's a reproduction of my situation with 9.2.2: --- drop table if ex

Re: [GENERAL] Poor performance when using a window function in a view

2013-02-27 Thread Merlin Moncure
On Wed, Feb 27, 2013 at 8:22 PM, Chris Hanks wrote: > Hi. Sorry if this is repetitive, I tried posting to pgsql-performance first > but I think it got stuck in moderation. > > I'm trying to create a view that uses a window function, but it seems that > Postgres is unable to optimize it. Here's a r

[GENERAL] Similarity Search with Wildcards

2013-02-27 Thread Ghislain Hachey
Hi list, I have a varchar column with content such as "Client Name - Brief Description of Problem" (it's a help desk ticket system). I want to generate reports by clients and the only thing I can base my query on is this column. The client names often contain typos or are entered slightly differen

Re: [GENERAL] Similarity Search with Wildcards

2013-02-27 Thread John R Pierce
On 2/27/2013 10:35 PM, Ghislain Hachey wrote: I have a varchar column with content such as "Client Name - Brief Description of Problem" (it's a help desk ticket system). I want to generate reports by clients and the only thing I can base my query on is this column. The client names often contai