Re: [ADMIN] switching from windows to linux

2003-12-29 Thread Uwe C. Schroeder
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 29 December 2003 10:18 pm, vidhya baskaran wrote: > Hi, > > We are using postgres under Cygwin on a win2k server and we would like to > move it to a Linux box. Good decision > > You told to use PsqlODBC driver to establish a connection betw

[ADMIN] switching from windows to linux

2003-12-29 Thread vidhya baskaran
Hi, We are using postgres under Cygwin on a win2k server and we would like to move it to a Linux box.   You told to use PsqlODBC driver to establish a connection between a Linux based postgres server and a Windows application.   We have to install psqlODBC driver in win2k server is it right? Do w

[ADMIN] 答复: [ADMIN] How to use psql -c?

2003-12-29 Thread 周仁军
u's PATH have no problem? -ååéä- åää: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] David F. Skoll åéæé: 2003å12æ30æ 6:24 æää: Charles Haron æé: [EMAIL PROTECTED] äé: Re: [ADMIN] How to use psql -c? On Mon, 29 Dec 2003, Charles Haron wrote: > I want to be able to run the above

Re: [ADMIN] IEEE 754

2003-12-29 Thread William Yu
The answer is simple. Don't use floating point for money. Sai Hertz And Control Systems wrote: Dear all , I would like to share my concerns about the IEEE 754 specification and floating point handling by PostgreSQL . Also I would like to learn how professional users of PostgreSQL work with r

Re: [ADMIN] How to use psql -c?

2003-12-29 Thread Charles Haron
> From: "David F. Skoll" <[EMAIL PROTECTED]> > Date: Mon, 29 Dec 2003 17:23:53 -0500 (EST) > To: Charles Haron <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: [ADMIN] How to use psql -c? > > On Mon, 29 Dec 2003, Charles Haron wrote: > >> I want to be able to run the above command as

Re: [ADMIN] How to use psql -c?

2003-12-29 Thread David F. Skoll
On Mon, 29 Dec 2003, Charles Haron wrote: > I want to be able to run the above command as a cron job. I created a > script with the following command, but I get "ERROR: Attribute 'f' not > found": > su - postgres -c 'psql -c "DELETE FROM prg_dates_members WHERE confirm = > 'f';" comfire' Why n

Re: [ADMIN] How to use psql -c?

2003-12-29 Thread Charles Haron
> From: Michael Fuhr <[EMAIL PROTECTED]> > Date: Mon, 29 Dec 2003 14:06:13 -0700 > To: Charles Haron <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: [ADMIN] How to use psql -c? > > On Mon, Dec 29, 2003 at 01:49:00PM -0700, Charles Haron wrote: >> >> Can someone give me an example of

Re: [ADMIN] How to use psql -c?

2003-12-29 Thread Anjan Dave
Chuck, Report bugs to <[EMAIL PROTECTED]>. -bash-2.05b$ psql -c 'select version();' template1 version - PostgreSQL 7.2.3 on i686-pc-linux-gnu,

Re: [ADMIN] How to use psql -c?

2003-12-29 Thread Michael Fuhr
On Mon, Dec 29, 2003 at 01:49:00PM -0700, Charles Haron wrote: > > Can someone give me an example of how to use the -c option of psql? I can't > seem to get it to work. What are you doing and what are the results? We can't tell you what's wrong unless you show us what you're doing and what's hap

Re: [ADMIN] How to use psql -c?

2003-12-29 Thread Sean Shanny
from the command prompt: psql -U password -d database -c "select tablename from pg_stats ;" --sean Charles Haron wrote: Hello, Can someone give me an example of how to use the -c option of psql? I can't seem to get it to work. Thanks, Chuck ---(end of broadcast)

[ADMIN] How to use psql -c?

2003-12-29 Thread Charles Haron
Hello, Can someone give me an example of how to use the -c option of psql? I can't seem to get it to work. Thanks, Chuck ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] UNIX File buffering disable?

2003-12-29 Thread Greg Spiegelberg
Yes, databases like Oracle and DB2 can benefit from the file system option you're referring too but it depends first on the nature of the database (OLTP v. warehouse), the operating system, the file system in use and even the hardware. I have managed many varieties. One case was DB2 warehouse runn

[ADMIN] IEEE 754

2003-12-29 Thread Sai Hertz And Control Systems
Dear all , I would like to share my concerns about the IEEE 754 specification and floating point handling by PostgreSQL . Also I would like to learn how professional users of PostgreSQL work with rounding of monetary terms . If you would like to know whats IEEE 754 read this http://docs.sun