Re: [GENERAL] Question about openSSL

2006-06-18 Thread Tony Caduto
change. -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Question about openSSL

2006-06-19 Thread Tony Caduto
the search order goes, the link you gave does not validate the behavior I see on my fully patched version of XP and fully patch versions of win2k in a corp environment. The MSDN docs are not always correct or fully updated. -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com

Re: [GENERAL] Form builder?

2006-06-22 Thread Tony Caduto
You could also use Lazarus. http://www.lazarus.freepascal.org/ -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Administration ---(end of broadcast)--- TIP

Re: [GENERAL] Form builder?

2006-06-24 Thread Tony Caduto
this point. Would anyone else find this useful? ---(end of broadcast)--- TIP 6: explain analyze is your friend -- Tony Caduto http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql 8.x ---(end of broadcast)-

Re: [GENERAL] RAID + PostgreSQL?

2006-06-26 Thread Tony Caduto
caches etc. -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Administration ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ

Re: [GENERAL] RAID + PostgreSQL?

2006-06-26 Thread Tony Caduto
Scott Marlowe wrote: On Mon, 2006-06-26 at 08:59, Tony Caduto wrote: MG wrote: Hello, we are using PostgreSQL 8.0.3 together with RAID on OpenServer 6. When we do a big SELECT-query the whole maschine becomes very very very slowly or stands. The maschine has 3 GB RAM, so we

Re: [GENERAL] Trying to connect to an Oracle instance...

2006-07-13 Thread Tony Caduto
e using DBI Link instead of DBlink? I thought DBLink was just for Postgresql databases? Later, -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Administration ---

Re: [GENERAL] How to access a table from one database to another

2006-07-14 Thread Tony Caduto
.postgresql.org/docs/faqs.FAQ.html -- Tony Caduto http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql 8.x ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Simple webuser setup

2006-07-17 Thread Tony Caduto
-(end of broadcast)--- TIP 6: explain analyze is your friend You just have to set it at the table level. You should check out PG Lightning Admin, it has a really nice Grant Manager that is grid based that makes this sort of thing very easy to setup. -- Tony Ca

Re: [GENERAL] custom installer

2006-07-18 Thread Tony Caduto
application with. You can get it here: http://www.amsoftwaredesign.com/downloads/pg_installer_setup.zip It uses a delphi DLL to handle things like the do the cluster init. All source is included. This is of course for win32. -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com

[GENERAL] Well, Pervasive is now out....

2006-08-03 Thread Tony Caduto
http://news.zdnet.com/2100-3513_22-6100795.html -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Administration ---(end of broadcast)--- TIP 1: if posting

[GENERAL] Postgresql mentioned on Newsforge MySQL article

2006-08-28 Thread Tony Caduto
http://newsvac.newsforge.com/newsvac/06/08/28/1738259.shtml Don't know the validity of this dvd order test they did, but the article claims Postgresql only did 120 OPM. Seems a little fishy to me. -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admi

Re: [GENERAL] Dblink and connections to MySQL?

2006-08-30 Thread Tony Caduto
Hi Brian, Dblink is for postgresql to postgresql, you have to use DBI-Link for connections to other databases. http://pgfoundry.org/projects/dbi-link/ -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql

Re: [GENERAL] Stored Procedure performance / elegance question

2006-09-12 Thread Tony Caduto
eate a new user from inside a function with a passed in username. Another example where you would need EXECUTE is if you are working with temp tables in a function. Later, -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your be

Re: [GENERAL] berkley sockets

2006-09-13 Thread Tony Caduto
ot;Could not create socket: $!\n" unless $sock; print $sock "null\r\n"; print $sock "send_broadcast\r\n"; print $sock $_[0]."\r\n"; print $sock $_[1]."\r\n"; close($sock); $BODY$ LANGUAGE 'plperlu' VOLATILE; -- Tony Caduto AM Soft

Re: [GENERAL] berkley sockets

2006-09-15 Thread Tony Caduto
some other tcp/ip daemon. You set up a rule to use Notify: create rule InsertDetect as on INSERT to notify_test do notify recinsert Then on the client side (if the client has libpq listen capability) you listen for the incoming notification messages and react to them accordingly. -- Tony Cadu

Re: [GENERAL] berkley sockets

2006-09-15 Thread Tony Caduto
ending a string with a CRLF, and then if the command you send returns anything you just go into a blocking read until you get the response back. Later, -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql

<    1   2   3   4   5