Re: [SQL] Tsearch

2008-06-12 Thread Steve Midgley
At 12:20 PM 6/12/2008, [EMAIL PROTECTED] wrote: Date: Thu, 12 Jun 2008 08:47:44 -0400 From: PostgreSQL Admin <[EMAIL PROTECTED]> To: pgsql-sql@postgresql.org Subject: Tsearch Message-ID: <[EMAIL PROTECTED]> this is a small sample of the data: short_desc |

Re: [SQL] COPY command and required file permissions

2008-06-12 Thread Harold A. Giménez Ch.
Thanks for the info. SELinux was the guilty party... On Thu, Jun 12, 2008 at 10:48 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > "=?ISO-8859-1?Q?Harold_A._Gim=E9nez_Ch.?=" <[EMAIL PROTECTED]> > writes: > > In migrating an application from sql server to Postgres, I created a ruby > > script that extra

Re: [SQL] COPY command and required file permissions

2008-06-12 Thread Tom Lane
"=?ISO-8859-1?Q?Harold_A._Gim=E9nez_Ch.?=" <[EMAIL PROTECTED]> writes: > In migrating an application from sql server to Postgres, I created a ruby > script that extracts csv files from sql server (from a windows box), then > SCPs them into a directory (/home/ruby_process) on the server running > Po

Re: [SQL] COPY command and required file permissions

2008-06-12 Thread Pavel Stehule
2008/6/12 Harold A. Giménez Ch. <[EMAIL PROTECTED]>: > Hi all, > In migrating an application from sql server to Postgres, I created a ruby > script that extracts csv files from sql server (from a windows box), then > SCPs them into a directory (/home/ruby_process) on the server running > Postgres (

[SQL] COPY command and required file permissions

2008-06-12 Thread Harold A. Giménez Ch.
Hi all, In migrating an application from sql server to Postgres, I created a ruby script that extracts csv files from sql server (from a windows box), then SCPs them into a directory (/home/ruby_process) on the server running Postgres (a Fedora core 8) and finally runs the Postgres COPY command for

[SQL] Tsearch

2008-06-12 Thread PostgreSQL Admin
this is a small sample of the data: short_desc | long_desc --+---