Re: [GENERAL] Postgresql Hosting

We offer Postgresql hosting with phpPgAdmin on Mac Dual G5 Xserve servers: http://www.systame.com/html/macwebhosting/ -- Randall Perry sysTame Xserve Web Hosting/Co-location/Leasing QuickTime Streaming Mac Consulting/Sales http://www.systame.com/ ---(end of

Re: [GENERAL] Rules vs Triggers

Thanks for the info guys; got a better understanding now. -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Development/Promotion Mac Consulting/Sales http://www.systame.com/ ---(end of broadcast)--- TIP 3: Have you checked our

[GENERAL] Rules vs Triggers

to determine this. And I gathered rules are necessary to allow update/insert/delete actions on views. Can anyone give me some simple reasons why they choose rules over triggers in their real-world dbs? -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Development/Promotion

[GENERAL] plpgsql -- any '+' ,'-' operators for INET?

as written a function to handle this? -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Development/Promotion Mac Consulting/Sales http://www.systame.com/ ---(end of broadcast)--- TIP 6: Have you searched our lis

[GENERAL] Triggers: using table's primary key value to update another field

E table_name = TG_RELNAME AND constraint_name ILIKE ''%_pkey''; IF NEW.parent_id IS NULL THEN SELECT NEW.pkey INTO NEW.parent_id; END IF; RETURN NEW; END; ' LANGUAGE 'plpgsql'; -- Randall Perry sysTame Xserve Web Hosting/Co-locat

[GENERAL] Upgrade to Win XP Service Pak 2 SP2 causes connection failure

ly, adding the server IP to trusted internet sites, all to no avail. Any one else run into this? -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Design/Development WebObjects Hosting Mac Consulting/Sales http://www.systame.com/ ---(end of broadcast)

[GENERAL] Perl won't eval PgSQL boolean value

I've got an if statement that checks if a boolean value is true: if ($cust_data->{'hold'} eq 't') But perl will not evaluate the value. $cust_data->{'hold'} is taken from a PgSQL boolean field (either t or f). If I use the construct above it tell me that 'eq' is not defined thinking it's a s

[GENERAL] ODBC driver for Mac?

Any plans to work on a Mac version of PgSQL ODBC driver? -- Randy Perry sysTame Mac Consulting/Sales ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [

Re: [GENERAL] canned code to get db on web quickly via perl orPHP?

Wondering if I should take a different tack; anyone have an opinion on how difficult it is to get MS Access or FileMaker Pro to connect to PgSQL via ODBC? -- Randy Perry sysTame Mac Consulting/Sales ---(end of broadcast)--- TIP 6: Have you sea

Re: [GENERAL] canned code to get db on web quickly via perl orPHP?

Thanks guys. I'll check 'em out. -- Randy Perry sysTame Mac Consulting/Sales ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can g

[GENERAL] canned code to get db on web quickly via perl or PHP?

Anyone know if there are classes, templates that will quickly get a database online for users to insert, update, delete? Doesn't have to be pretty. -- Randy Perry sysTame Mac Consulting/Sales phn 561.589.6449 mobile email[EMAIL PROTECTED] ---(

Re: [GENERAL] Text data type doesn't accept newlines?

on 6/5/01 12:00 PM, Bryan White at [EMAIL PROTECTED] wrote: >> I have a logging database that logs errors. The error messages contain >> newlines. Pgsql doesn't accept them on insert in a text data field. > > I have never had a problem storing newlines in a text field. What interface > are you

[GENERAL] Text data type doesn't accept newlines?

I have a logging database that logs errors. The error messages contain newlines. Pgsql doesn't accept them on insert in a text data field. MySQL has the 'blob' data type which does accept newlines. Do I have to convert all newlines to '\n' to use them in Pgsql? -- Randy Perry sysTame Mac Consu

[GENERAL] Perl Scope problem

I'm baffled by perl's scoping of variables. In the code below, the $cust_data hash ref is inited outside the while loop. It's then set in the while with the results of a PgSQL query. In the if-else statement $cust_data can be seen in the 'if' but not in the 'else' (if I try to print a value in el

Re: [GENERAL] Var substitution in SELECT statements

on 4/23/01 9:20 PM, Randall Perry at [EMAIL PROTECTED] wrote: > This works: > $res = $conn->exec("select cust, contact, user_name, email from $t where > user_name = a1a"); > > This doesn't: > $c = "a1a"; > $res = $conn->exec("select

[GENERAL] Var substitution in SELECT statements

This works: $res = $conn->exec("select cust, contact, user_name, email from $t where user_name = a1a"); This doesn't: $c = "a1a"; $res = $conn->exec("select cust, contact, user_name, email from $t where user_name = $c"); and returns the error: Attribute 'a1a' not found How do you