[GENERAL] DBD::Pg installation

POSTGRES_INCLUDE and POSTGRES_LIB need the variable POSTGRES_HOME. I defined $POSTGRES_HOME (/usr/local/pgsql) in the makefile, tried to make it again (perl Makefile.pl) and got the same error again! Suggestions?? Michelle --- Michelle Murrain, Ph.D. President

[GENERAL] web programming

to use with postgres, and why? Are there speed/performance issues I should think about? I'm also beginning to get into XML, so there is another set of things to think about. Thanks! Michelle --- Michelle Murrain, Ph.D. President, Norwottuck Technology

[GENERAL] GUIs, OSes and related

interested in a Mac port of postgres? (MacOS X might make it real easy.) Thanks! Michelle --- Michelle Murrain, Ph.D. President, Norwottuck Technology Resources [EMAIL PROTECTED] www.norwottuck.com

Re: [GENERAL] MySQL - pgsql

in mSQL (dumps the schema and data in SQL format into a text file), then go into psql and execute the text file that comes from the dump. I'm sure MySQL has a tool to do that. Michelle -- Michelle Murrain Ph.D., President Norwottuck Technology Resources [EMAIL

RE: [GENERAL] MySQL - pgsql

-- Michelle Murrain Ph.D., President Norwottuck Technology Resources [EMAIL PROTECTED] http://www.norwottuck.com

[GENERAL] tuples too big

into those fields, I get the "Tuple too large" error. I can't chop up the fields into smaller pieces, and 8104 is not enough. Suggestions? Michelle -- ---- Michelle Murrain, Ph.D. President Norwottuck Technology Resources [EMAIL PROTECTED] http://www.norwottuck.com

[GENERAL] troublesome inputs

that lead to wierdness? Other things I should be thinking about? Thanks! Michelle -- Michelle Murrain, Ph.D. President Norwottuck Technology Resources [EMAIL PROTECTED] http://www.norwottuck.com

Re: [GENERAL] Getting lengths of variable fields

Michelle Murrain, Ph.D. President Norwottuck Technology Resources [EMAIL PROTECTED] http://www.norwottuck.com ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Getting lengths of variable fields

it. Just do a select. It's a system table I hadn't learned about yet. And, I have to subtract 4 from it to get the real length. Thanks!! Michelle Michelle Murrain, Ph.D. President Norwottuck Technology Resources [EMAIL PROTECTED] http://www.norwottuck.com ---(end

Re: [GENERAL] Getting lengths of variable fields

| relisshared | relkind | relnatts | relchecks | reltriggers | relukeys | relfkeys | relrefs | relhaspkey | relhasrules | relacl Thanks again! Michelle Michelle Murrain, Ph.D. President Norwottuck Technology Resources [EMAIL PROTECTED] http://www.norwottuck.com ---(end

Re: [GENERAL] DELETE and efficiency

. Is that so? If so, that means there might be a way to do an undelete? What is it? Michelle -- Michelle Murrain, Ph.D. President Norwottuck Technology Resources [EMAIL PROTECTED] http://www.norwottuck.com ---(end of broadcast)--- TIP 3

Re: [GENERAL] IDE or RAD tools

next on my list of things to tackle. Michelle Michelle Murrain, Ph.D. President Norwottuck Technology Resources [EMAIL PROTECTED] http://www.norwottuck.com ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL

[GENERAL] Cold Fusion/ODBC

akehell" dbtype="ODBC" SELECT * FROM weather /cfquery Is there a dbtype command that will directly connect with a pg database, or do I have to make the connection via ODBC? Thanks in advance! Michelle -- Michelle Murrain, Ph.D. President Norwottuck Technology Re

Re: [GENERAL] Starting Postmaster

ot; How about some actual error messages? Also - look at your process list - is the postmaster running? Can you use psql? Michelle -------- Michelle Murrain, Ph.D. President Norwottuck Technology Resources [EMAIL PROTECTED] http://www.norwottuck.com

Re: [GENERAL] installing DBD::Pg without installing postgres

from tarball or CPAN, which I think is the best way to install perl modules), it requires the path of your postgres libraries and includes - so I guess it depends on a postgres installation on the local machine. What are you trying to accomplish, exactly? Michelle Michelle Murrain

[GENERAL] pg_encoding

? Michelle -- Michelle Murrain, Ph.D. President Norwottuck Technology Resources [EMAIL PROTECTED] http://www.norwottuck.com ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

[GENERAL] wierd problems with DBI/DBD::pg?

to debug, since DBI is not returning the full error string, so it's hard to know what's going on. Thanks in advance. Michelle -- Michelle Murrain, Ph.D. President Norwottuck Technology Resources [EMAIL PROTECTED] http://www.norwottuck.com ---(end of broadcast

Re: [GENERAL] Locking a database

ultiple-user machine, the above default # configuration is probably too liberal for you --- change it to use # something other than "trust" authentication. Michelle -- Michelle Murrain, Ph.D. President Norwottuck Technology Resources [EMAIL PROTECTED] http://www.norwottuck.com -

Re: [GENERAL] DBD::Pg errstr method doesn't return full error messages

ed a patch to it which worked for me. Sorry I deleted the original e-mail with the patch, but I can e-mail you the patched source file if you'd like. Michelle -- ---- Michelle Murrain, Ph.D. President Norwottuck Technology Resources [EMAIL PROTECTED] http://www.norw

Re: [GENERAL] Ideal hardware configuration for pgsql

-- Michelle Murrain, Ph.D. President Norwottuck Technology Resources [EMAIL PROTECTED] http://www.norwottuck.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

[GENERAL] Re: Re: Which Front End for Postgresql

Tony Grant wrote: Hi, Does anybody know of any issues with Mac OS 9.x and either AppleWorks or Excel and ODBC access to a Postgres backend? I have a client who needs to print labels and who has AppleWorks. Actually, I was going to investigate this for FileMaker - are their postgresql

[GENERAL] Re: Which Front End for Postgresql

Al Frick wrote: Which software should I use for a front end for Postgresql? I know I need an admistrator package for the databases, don't I? What about which software to write the enduser routines? The input screens, etc? come to think of it, what software should I use for reporting