[GENERAL] Can not get ODBC to log. Trace is not working.

2005-09-23 Thread Roy Souther
I am trying to get the ODBC client to log but I just can't. I have included my odbc.ini and odbcinst.ini. Can anyone tell me why there is never a log file created? I connect to the database with isql and OpenOffice, run queries and get data but never do I ever get a log file. Shouldn't it just

[GENERAL] How can I make SELECT return tuple numbers?

2005-07-05 Thread Roy Souther
t the field to be a unique index. As the query is run again and again I want more tuples appended to the table and each time the counter should start at 1 and count up. Roy Souther www.SiliconTao.com Let Open Source help your business move beyond. For security this message is digi

[GENERAL] UPDATE from a SELECT on two fields.

2005-07-08 Thread Roy Souther
< 0 THEN (value * -1) || ' (K)' END AS givekeepamount FROM ( SELECT mmpuncorvol, ((mmpuncorvol - uutuncorvol)::float4 / 1000)::NUMERIC(5,3) AS value FROM runs WHERE status ILIKE '%init%' AND status ILIKE '%fast%' AND inactive='f' AND evaluation = repo

[GENERAL] EXTPROC External Procedure

2005-02-09 Thread Roy Souther
I cannot find any information about wether PostgreSQL has EXTPROC or not. Can someone tell me if it dose or if there is a better way to do this. I need to be able to run a program when some data is requested from the database. Some query will do a SELECT on a known table and I need to have some

[GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support.

2006-03-01 Thread Roy Souther
I love Linux, any tool you need it has it. Just try to find the most basic of tools for Windows, what a joke. I need an Open Source SQL command line tool for Windows that will let me script queries to a database over an ODBC connection. It must use ODBC because it may or may not be PostgreSQL.

Re: [GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support.

2006-03-02 Thread Roy Souther
CLI = Command Line Interface GUI = Graphical User Interface WSI = Web Server Interface I need a CLI app. Sorry I was not clear on this. On Thu, 2006-03-02 at 10:05 -0600, Scott Marlowe wrote: On Wed, 2006-03-01 at 17:00, Roy Souther wrote: > I love Linux, any tool you need it has it. J

Re: [GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support.

2006-03-02 Thread Roy Souther
ery here window. Sometimes you just gotta use what you can get. Some of them have history and all that fancy stuff, they just live inside a GUI app. Me personally, I switched of Windows long ago due to issues like this. On Thu, 2006-03-02 at 10:34, Roy Souther wrote: > CLI = Command Line Interface

[GENERAL] CRLF problem going from Linux PostgreSQL server to WinXP client via ODBC.

2006-03-06 Thread Roy Souther
I have some multi-line address fields in my Linux PostgreSQL that get populated as Linux lines with CR line terminators. This works fine until a Windows client connects to it over ODBC and then barks because the end of line is not in CRLF format. Is there a simple fix for this? Is there anythi

[GENERAL] Is there a database file system?

2006-06-01 Thread Roy Souther
Is there a database file system? I have a project that needs very advanced permission control like that offered by Novell NDS. I am wanting to know if anyone knows of a (PHP | Perl | Samba | SQL ) (object | plug-in | module ) that would allow me to serve files from a connection that is control

Re: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully

2006-06-08 Thread Roy Souther
In what way could a database like PostgreSQL not be "faithful to relational theory"? Does he give any explanation as to what that means? Some people mistake the word relational for the meaning of normalization, but they do not have the same meaning. If Fabial is mistaking relational for normal

[GENERAL] Is there a way to run tables in RAM?

2006-07-13 Thread Roy Souther
I would like to know if there is anyway to move a section of some tables into RAM to work on them. I have large table, about 700MB or so and growing. I also have a bizarre collection of queries that run hundreds of queries on a small section of this table. These queries only look at about 100

[GENERAL] Can I make direct calls to PostgreSQL server?

2001-03-14 Thread Roy Souther
hen pass them to a local port then on into the server. Is this the only way? -- Roy Souther <[EMAIL PROTECTED]> 01100010 10101110 11000110 11010110 0100 10110010 10010110 11000110 01001110 0110 11001110 00010110 10010110 00101110 1100 1100