Re: [GENERAL] Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work..

2009-01-10 Thread Andrew
Mohamed wrote: Thank you for you detailed answer. I have learned alot more about this stuff now :) Your welcome :-) As I see it accordingly to the results it's between Hunspell and Aspell. My Aspell version is 0.6 released 2006. The Hunspell was released in 2008. When I run the Postgres c

[GENERAL] Question about updates and MVCC

2009-01-10 Thread mailinglists
Hello, I have a couple of questions regarding how MVCC (in postges 8.3.3 if it makes a difference) affects vacuum. #1. If I am doing an update to a row and none of the values have changed, will that cause a "hole" that requires vacuum to reclaim? #2. I have a column in my table (called "status",

[GENERAL] Rename a constraint

2009-01-10 Thread Thom Brown
I can't find anything in the documentation, but does anyone know if there is a way to rename a constraint? Thanks Thom

Re: [GENERAL] Rename a constraint

2009-01-10 Thread Raymond O'Donnell
On 10/01/2009 19:15, Thom Brown wrote: > I can't find anything in the documentation, but does anyone know if > there is a way to rename a constraint? I just tried it with a primary key... test=# alter table t1 alter constraint t1_pk rename to t1_pp; ERROR: syntax error at or near "constraint" LI

Re: [GENERAL] Rename a constraint

2009-01-10 Thread Thom Brown
That would make more sense wouldn't it. :) Yeah, I think that's the answer. Cheers! Thom 2009/1/10 Raymond O'Donnell > On 10/01/2009 19:15, Thom Brown wrote: > > I can't find anything in the documentation, but does anyone know if > > there is a way to rename a constraint? > > I just tried it

[GENERAL] Renaming tables and columns to lowercase

2009-01-10 Thread Bruno Lavoie
Hello, In a migration process, I've imported a bunch of tables from an old Access database to PostgreSQL. The name of tables and fields on the source are mixed case. When copying tables to pg via ODBC, identifiers are copied in mixed case into pg destination db. Data is copied without any pro

Re: [GENERAL] Renaming tables and columns to lowercase

2009-01-10 Thread Joshua D. Drake
On Sat, 2009-01-10 at 17:25 -0500, Bruno Lavoie wrote: > Hello, > > In a migration process, I've imported a bunch of tables from an old > Access database to PostgreSQL. The name of tables and fields on the > source are mixed case. When copying tables to pg via ODBC, identifiers > are copied in

Re: [GENERAL] compile of 8.1.15

2009-01-10 Thread Chuck Davis
I have been trying to install 8.1.14 and 15 and it seems like there is an infinite loop in the make file. I do not have the skills to find it. Has anyone else had success compiling for Linux with gmake? Thanks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chang

Re: [GENERAL] compile of 8.1.15

2009-01-10 Thread Bruce Momjian
Chuck Davis wrote: > I have been trying to install 8.1.14 and 15 and it seems like there is > an infinite loop in the make file. I do not have the skills to find > it. Has anyone else had success compiling for Linux with gmake? We certainly used to be able to compile it on every Linux available

Re: [GENERAL] compile of 8.1.15

2009-01-10 Thread Tom Lane
"Chuck Davis" writes: > I have been trying to install 8.1.14 and 15 and it seems like there is > an infinite loop in the make file. I do not have the skills to find > it. Has anyone else had success compiling for Linux with gmake? I'll bet lunch your system clock is far in the past (ie, before