[GENERAL] Check postgres compile-time options

2005-08-01 Thread Laura Vance
rpm -q -a | grep -i odbc unixODBC-2.0.8-7mdk libiodbc-3.52.2-1 libunixODBC2-2.0.8-7mdk unixODBC-gui-gtk-2.0.8-7mdk libiodbc-admin-3.52.2-1 postgresql-odbc-7.1.2-19mdk libiodbc-devel-3.52.2-1 Thanks in advance for any help. -- Thanks, Laura Vance Systems Engineer Winfree Academy Charter Schools

Re: [GENERAL] Check postgres compile-time options

2005-08-01 Thread Laura Vance
Michael Fuhr wrote: On Mon, Aug 01, 2005 at 05:18:58PM -0500, Laura Vance wrote: In trying to get the ODBC installed on my test system, I've run into the problem that I need to know if my binary distribution of PostgreSQL was configured with the --enable-odbc option, and I can'

Re: [GENERAL] Check postgres compile-time options

2005-08-01 Thread Laura Vance
Martín Marqués wrote: El Lun 01 Ago 2005 20:13, Laura Vance escribió: I've tried other configuration test programs, but none of them seem to connect properly. Is there some incompatibility with this version of iodbc and postgresql 7.1.2? Sorry, I happen to recall that you w

Re: [GENERAL] Going beyond sql

2005-08-05 Thread Laura Vance
in Perl is the most efficient way to do it for me. But then I also wrote an extremely simple wrapper to the DBI / DBD::Pg module so that I don't have to muck with the extra house keeping steps in my programs. -- Thanks, Laura Vance Systems Engineer ---(e

Re: [GENERAL] One more time on ONE-TO-MANY

2004-05-27 Thread Laura Vance
one' row.' I'm pretty sure that Postgres does not support the last one automatically. I shall have to do that one by either a chron script or a post trigger. Does anyone have experience with a database that will do the last one, and what database would that be? -- Thanks, Laura Vance S

Re: [GENERAL] doubt

2004-06-14 Thread Laura Vance
ave 2 reference tables, and your 3rd table that matches them for each person's skills. This way you can add skills to your selection list (the code table) and have it ready even if nobody currently has that skill. -- Thanks, Laura Vance Systems Engineer Winfree Academy Charter Schoo

Re: [GENERAL] Performance

2004-06-24 Thread Laura Vance
his is really helpful on web-based apps, because you can point the browser anywhere you want to point it to retrieve whatever files you want. Obviously if you require more details about the file to be able to search, you can add more columns. This overcomes the need for the database to handle