Re: [GENERAL] Adventures in Quest for GUI RAD

2005-05-05 Thread Tony Caduto
. Also I have had good luck with Microolap, I use their postgresdac components, and guess what? That MySQL RAD thing they sell is created with.yep you guessed it Delphi. -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql 8.x http://www.amsoftwaredesign.com

Re: [GENERAL] Adventures in Quest for GUI RAD

2005-05-06 Thread Tony Caduto
That's what was said 7 years ago. guess what it's still around and going strong. This is one of the most ridiculous arguments against using Delphi, every year people like you say this, then 7 years go by and your still wrong The problem with Delphi is that it is uncertain where it will s

Re: [GENERAL] Adventures in Quest for GUI RAD

2005-05-06 Thread Tony Caduto
teaching myself in my spare time, for fun. Tony Caduto is worried that some employer is losing money because I wont purchase Delphi. But thanks Tony, for your good advice. And it IS good advice for someone with money and staff behind them to take that advice and make something pro

Re: [GENERAL] Connecting to Postgres using Rekall

2005-05-06 Thread Tony Caduto
". Anyone know why this is happening? Thanks, Jerome -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql 8.x http://www.amsoftwaredesign.com ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Functions!

2005-05-07 Thread Tony Caduto
/interactive/plpgsql-cursors.html Hope this helps, Tony Caduto http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql 8.x Hrishikesh Deshmukh wrote: Hi All, Can a query be cast as function: i have a query say like: select * from tableName where signal>=2000 and signal <=2000

[GENERAL] You can do Postgresql DB GUI programming with Lazarus (free delphi clone)

2005-05-07 Thread Tony Caduto
I just read on the Lazarus home page that Zeos (http://www.zeoslib.net) has been ported to Lazurus. Lazarus is a Delphi IDE like clone that uses the Free Pascal compiler. check it out at: http://www.lazarus.freepascal.org/ Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql

Re: [GENERAL] Delphi - Developers start develop Access components

2005-05-10 Thread Tony Caduto
ccess for Delphi". -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql 8.x http://www.amsoftwaredesign.com ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Delphi - Developers start develop Access components

2005-05-10 Thread Tony Caduto
unless we are thinking of something different I do this: sql.clear; sql.add('select myfunction();'); sql.add('fetch all from return_cursor;'); open; > > ?? > How? On EoF of a TDataSet? Its clear that you can fetch manually. How do you do that? > -- Tony Cadu

Re: [GENERAL] Delphi 2005, Postgresql, ZEOS & optimistic locking

2005-05-12 Thread Tony Caduto
e transactions. When you use tiNone you simply do all your statements in one operation, just do a bunch of adds and seperate each statement with a semi colon, then do the execsql. All the statements will be executed in a single transaction by the server and if a error occurs they all get rolled bac

Re: [GENERAL] Delphi 2005, Postgresql, ZEOS & optimistic locking

2005-05-12 Thread Tony Caduto
Why not just add a onenter event handler to the forms field in question and just check the data before they edit it. If it's different update the field with the most current data. Access probably just does something similar under the hood for you. I don't think that's a feature of the ODBC driver

Re: [GENERAL] solaris 10 vs Linux Debian on SUN Fire v40z

2005-05-27 Thread Tony Caduto
Both are good, I guess it depends what kind of expertise you have around or are willing to pay for. For me I would pick Linux because it is easier to install and maintain, and there is much more articles etc on the web. For a bullet proof Linux Install you could use CentOS which is a clone of

Re: [GENERAL] Postgres under Windows

2005-05-30 Thread Tony Caduto
Did you restart the service? Did you change the postgresql.conf file to listen on tcp/ip all addresses? listen_addresses = '*' After that I made some changes to the pg_hba.conf file and changed the method hostall all 127.0.0.1/32 md5 INTO hostall all

Re: [GENERAL] Postgres under Windows

2005-05-30 Thread Tony Caduto
Ah, I didn't catch the fact that you where not doing it as the super user (postgres) For another account to work you need to grant that account the createdb right. Look up in the docs about the grant command. Glad to hear you have it working. Tony Caduto http://www.amsoftwaredesign.com

Re: [GENERAL] writting a large store procedure

2005-06-02 Thread Tony Caduto
deal. After the pre-release the price is going up to 29.99, so if you grab a copy now you can get it for the cost of lunch :-) Tony Caduto http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql 8.x Sean Davis wrote: I have to recommend pgEdit (nearly free and does have a

[GENERAL] PG Lightning Admin running on Linux via WINE 2005524

2005-06-03 Thread Tony Caduto
think this is because the odd numbered row coloring is on by default. NOTE: running the program on WINE is not officially supported. Tony Caduto http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql 8.x ---(end of broadcast

Re: [GENERAL] PG Lightning Admin running on Linux via WINE 2005524

2005-06-03 Thread Tony Caduto
Can't do that, it's a Delphi 7 application. Huh, have you considered compiling it on Linux using libwine? That may give you better results. -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql 8.x http://www.amsoftwaredesign.com

Re: [GENERAL] PG Lightning Admin running on Linux via WINE 2005524

2005-06-03 Thread Tony Caduto
text boxes showing through to the window below). I'll give it a go at home this weekend with a more recent version of Wine and see if that improves things (I do actually want to be able to use this!) -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql 8.x

Re: [GENERAL] Version Control?

2005-06-09 Thread Tony Caduto
PG Lightning Admin also has function version control. http://www.amsoftwaredesign.com Russ Brown wrote: Thomas Kellerer wrote: Russ Brown wrote on 09.06.2005 23:12: Currently we just store a dump of the data structure. However, what I think is really needed is a specialist diff tool which

[GENERAL] ANN: PG Lightning Admin for PostgreSQL 8.x Released

2005-06-21 Thread Tony Caduto
AM Software Design is proud to announce the 1.0 stable release of PG Lightning Admin for PostgreSQL 8.x. PG Lightning Admin is a Windows GUI (graphical user interface) administration program which will run on Windows 95,98, ME,NT 4SP6, 2000 and XP. A full 30 day demo may be downloaded from: http

[GENERAL] Libpq question

2005-06-24 Thread Tony Caduto
Does anyone know if there is a compiled version of libpq.dll (ssl enabled) that does not require libintl-2.dll, libiconv-2.dll Whoever compiled these dlls failed to include version information with them, so it makes it a royal pain to deploy them, and it appears they must be in the system dir

[GENERAL] 8.1 Out parameter question

2005-06-28 Thread Tony Caduto
Will it be possible to use the out params to return more than one row? will the params act as a composite type so they can be used in a set returning function? Thanks, Tony ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] COnsidering a move away from Postgres

2005-06-30 Thread Tony Caduto
There are very nice inexpensive alternatives to PG Admin III. Because of it's cross platform nature it is severly lacking in many areas. Check out PG Lightning Admin at: http://www.amsoftwaredesign.com 3. The tools. PgAdmin does some things well but it is lacking the features of some of the

Re: [GENERAL] PostgreSQL sequence within function

2005-06-30 Thread Tony Caduto
All you where really mising was a semi colon afer nextval('myseq') and the begin end. CREATE or REPLACE FUNCTION getSeq() RETURNS int AS $$ begin RETURN nextval('myseq'); end; $$ LANGUAGE 'plpgsql'; Clark Allan wrote: -- CREATE FUNCTION getSeq() RET

Re: [GENERAL] PostgreSQL sequence within function

2005-07-05 Thread Tony Caduto
Try this version of your function. I don't think you can assign a value to a variable in the declaration section with the return value of a function. CREATE OR REPLACE FUNCTION sp_slide_create(int4, bool, bool, bool, varchar, text, varchar, varchar, int4) RETURNS int4 AS' DECLARE aScriptID AL

Re: [GENERAL] PostgreSQL sequence within function

2005-07-05 Thread Tony Caduto
Or upgrade your server to 8.x and use dollar quoting. with dollar quoting all that is a thing of the past. CREATE FUNCTION sp_slide_create(int4) RETURNS int4 AS $$ DECLARE aScriptID ALIAS FOR $1; seqID int4 := nextval('genseq'); -- no magic needed with dollar qouting :-) BEGIN INSERT INTO tblsli

Re: [GENERAL] Windows version of PostgreSQL 8.x?

2005-07-12 Thread Tony Caduto
ooked back :-) Tony Caduto http://www.amsoftwaredesign.com home of PG Lightning Admin for Postgresql 8.x Bjørn T Johansen wrote: How stable is the Windows version of PGSQL 8? Is it as stable as the Linux version or should I be looking for something else? Regards,

Re: [GENERAL] Quotation marks in queries

2005-07-14 Thread Tony Caduto
The easiest solution is just not to use caps or spaces in your table/object names, there is no advantage to doing so. People just need to get over the fact that having caps in a name make it easier to read. My Test Table should be my_test_table, the naming makes no difference to the applicat

Re: [GENERAL] Quotation marks in queries

2005-07-20 Thread Tony Caduto
. Good luck with your conversion. Tony Caduto http://www.amsoftwaredesign.com Home of PG Lighting Admin for Postgresql 8.x teknokrat wrote: The problem we have is that we want to migrate to postgresql from our current sql server db, but the problem with caps requiring quotes around them makes

Re: [GENERAL] Quotation marks in queries

2005-07-20 Thread Tony Caduto
m the source system as tab delimited and then use the postgresql copy command to import the tab delimited file to postgresql. Tony Caduto http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql 8.x So, if you don't use quotes in the CREATE TABLE statement, you'll neve

Re: [GENERAL] temporary tables ?

2005-07-22 Thread Tony Caduto
They can also be set to drop with ON COMMIT DROP, this way they disappear after the tranaction is commited. I use them in this way on my web server to sort file listings, and it works well since each apache DSO connection gets one connection to the database. Tony http://www.amsoftwaredesign

Re: [GENERAL] PostgreSQL, Lazarus and zeos ?

2005-07-25 Thread Tony Caduto
will vary with Lazarus. Hope this helps. Tony Caduto http://www.amsoftwaredesign.com home of PG Lightning Admin (PGLA) for Postgresql 8.x ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscr

Re: [GENERAL] Wishlist?

2005-07-25 Thread Tony Caduto
Even in Pascal a procedure and a function are the same except one returns a result, the other does not. And it C++ everything is a function, you just set the return type to void for a proc. But AFAICS this is a distinction made by people (like in Pascal) but is not a distinction at all. As

Re: [GENERAL] About Tools at the DB design phase.

2005-07-27 Thread Tony Caduto
Zeos Database Designer is OK. http://www.zeoslib.net Tony Caduto http://www.amsoftwaredesign.com/lightning_admin.php Home of PG Lightning Admin (PGLA) for Postgresql 8.x Ying Lu wrote: Greetings, I am at the design phase of the DB design. That is, I'd like to design table

Re: [GENERAL] GUID for postgreSQL

2005-07-27 Thread Tony Caduto
Use Dblink and do a select off of a sequence on just one of the boxes? You could set up a view that uses DBlink on all the boxes that points to the master seq box. should work. Scott Marlowe wrote: So, how can two databases, not currently talking to one another, guarantee that their GUIDs do

Re: [GENERAL] GUID for postgreSQL

2005-07-27 Thread Tony Caduto
-0500, Tony Caduto wrote: Use Dblink and do a select off of a sequence on just one of the boxes? You could set up a view that uses DBlink on all the boxes that points to the master seq box. should work. It'll make the whole thing painfully slow.

[GENERAL] Raise Notice question

2005-07-28 Thread Tony Caduto
Does anyone know how Raise Notice Messages get sent back to the client when a function is executed? Thanks, Tony ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] weirdness with the a sql update

2005-08-04 Thread Tony Caduto
Hi, I just noticed this, if I do a update like this: update new_requests set name = 'tony' where request_id = 2 If I do a select * from new_requests that record I just updated is now at the bottom , before the update it was at the top? Why is Postgresql changing the ordering of the results a

Re: [GENERAL] weirdness with a sql update

2005-08-04 Thread Tony Caduto
Just wanted to say thanks for all the great replies explaining why Postgres does this. Tony ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes

[GENERAL] Simple PG Sql question (i hope)

2005-08-08 Thread Tony Caduto
I have a simple query: select true,78,'Here is a value' as stringfield, testname from tbltest; it returns: true as bool 78 as int4 and the string 'Here is a value' as Unknown Why is it that all the values besides the string come back with the correct type? what is a simple string being returne

[GENERAL] AMD 64 RPM?

2005-08-08 Thread Tony Caduto
I have a Red Hat EL 4 server and they only ship 7.x with it, but I want to run 8.x on it. The server is running in 64bit mode and was wondering if there is a RPM available? (I could only find 32bit ones on the Postgresql web page) Thanks, Tony ---(end of broadcast)

Re: [GENERAL] Simple PG Sql question (i hope)

2005-08-08 Thread Tony Caduto
Hi, I don't think I was clear enough. I know about using the AS keyword, that is not the problem. The query in issue is: select true,78,'Here is a value' as stringfield, testname from tbltest Is returning the string as TYPE Unknown, not the column name. The column name comes back as stringfie

Re: [GENERAL] AMD 64 RPM?

2005-08-08 Thread Tony Caduto
Hi Joshua, Forgive me but I am not normally a redhat user (normally Gentoo) So it will build a 64bit binary by default, there is no editing of the spec file or anything else required? Thanks, Tony Just download the source RPM and: rpmbuild -bb --target=i686 src.rpm Sincerely, -

Re: [GENERAL] AMD 64 RPM?

2005-08-08 Thread Tony Caduto
Thanks for your help Joshua. I will give it a try. Tony o it will build a 64bit binary by default, there is no editing of the spec file or anything else required? Oh if you are using 64bit then just: rpmbuild -bb --target=x86_64 src.rpm You may need to add some rpms in advance such as: o

Re: [GENERAL] Simple PG Sql question (i hope)

2005-08-08 Thread Tony Caduto
I always thought that single qoutes in a sql statement meant a string/varchar/text. Thanks for the info on this. Single quotes denote an untyped constant, not a string. Hope this helps, ---(end of broadcast)--- TIP 2: Don't 'kill -9' the

[GENERAL] What's up with EnterpriseDB?

2005-08-10 Thread Tony Caduto
I saw their announment today and they said they have Oracle compatiblility. What exactly does this mean? They don't go into any details. Did they implement a Oracle compatible proc language or something? Tony ---(end of broadcast)--- TIP

[GENERAL] EnterpriseDB mentioned in eweek, and...

2005-08-10 Thread Tony Caduto
according to the article they "make postgresql" :-) http://www.eweek.com/article2/0,1895,1846635,00.asp ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] EnterpriseDB mentioned in eweek, and...

2005-08-10 Thread Tony Caduto
I agree, SCO is vile, but Borland what the heck are they thinking. Tony Joshua D. Drake wrote: Tony Caduto wrote: according to the article they "make postgresql" :-) http://www.eweek.com/article2/0,1895,1846635,00.asp Worse, they are partnering with SCO. Sorry Denis/A

[GENERAL] Question about the NAME type used in pg_proc and pg_class

2005-08-15 Thread Tony Caduto
Hi, Just had a quick question about the name type used by pg_proc and pg_class etc to return the name of a function,table,seq,view etc. Is this type limited to 64 bytes? ( could not find it in the docs) Must function/table names be limited to 64 characters in length? Thanks, Tony ---

Re: [GENERAL] Question about the NAME type used in pg_proc and pg_class

2005-08-15 Thread Tony Caduto
Never mind, I found it. I just did not scroll down on the page to see the "Special Char" types. Thanks, Tony Hi, Just had a quick question about the name type used by pg_proc and pg_class etc to return the name of a function,table,seq,view etc. Is this type limited to 64 bytes? ( could no

[GENERAL] question about plpgsql replace function

2005-08-19 Thread Tony Caduto
Hi, I have a text field that has some email addresses that are each on a new line by a CRLF. I want to replace the CRLF with a comma so I can use the email addresses in another app, so I thought I would do this: thearray = replace(mandi_notifications,'/r/n',','); but it does not work. Doe

[GENERAL] Postgresql Function Language question

2005-08-19 Thread Tony Caduto
Is it possible to write c style functions with Free Pascal? Thanks, Tony ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Postgresql Function Language question

2005-08-20 Thread Tony Caduto
What the heck are you talking about? It was a brand new subject, it was not part of any thread. A. Kretschmer wrote: am 19.08.2005, um 11:34:52 -0500 mailte Tony Caduto folgendes: Is it possible to write c style functions with Free Pascal? Please, if you open a new subject, then

Re: [GENERAL] plpgsql: returning multiple named columns from function

2005-08-23 Thread Tony Caduto
on't have to use a type or a record. If you need a actual test function, let me know. hope this helps, Tony Caduto http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql 8.x CREATE PROCEDURE test( @lookup char(50)) WITH ENCRYPTION AS BEGIN -- ... a bunch of code

Re: [GENERAL] Its Beta Time Again ... 8.1 Beta 1 Now Available

2005-08-25 Thread Tony Caduto
Hi Marc, Could you post the location of the beta documentation? I seem to have lost the link :-( Is there info on the new role system and in/out params in the beta docs? Thanks, Tony PostgreSQL 8.1 will bring in alot of fairly large features, including: - Improve concurrent access to

[GENERAL] Is there going to be a 8.1 beta for win32?

2005-08-26 Thread Tony Caduto
Is there going to be a 8.1 beta for win32? Thanks, P.S. I did find the 8.1 beta docs, it took a little searching on google. http://developer.postgresql.org/docs/postgres/ -- Tony Caduto http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql 8.x

Re: [GENERAL] Is there going to be a 8.1 beta for win32?

2005-08-26 Thread Tony Caduto
Thanks Magnus, yes by default I meant binary since that is how the majority of win32 software is distributed. I am a Delphi programmer, so I will wait for the binary installer to be released :-) Thanks again for the info. Tony Is there going to be a 8.1 beta for win32? I assume you ar

[GENERAL] Postgresql Function Cookbook/General howto

2005-08-26 Thread Tony Caduto
Hi, I have started a function/howto repository on my forums and seeded it with a few functions/howtos http://www.milwaukeesoft.com/forums/viewforum.php?f=12 Feel free to post any handy functions you wouldn't mind sharing with everyone. Thanks, Tony ---(end of broad

Re: [GENERAL] Postgresql Function Cookbook/General howto

2005-08-26 Thread Tony Caduto
Hi Bruce, That would be great :-) Thank you very much. I will keep the author information etc intact. Thanks again, Tony Bruce Momjian wrote: I have source to the old PL/PgSQL cookbook. Do you want it? ---

[GENERAL] 8.1 observation

2005-08-30 Thread Tony Caduto
Hi, I just noticed that pronargs in pg_proc does not show the full arg count, seems only to show count of IN args. shouldn't this show the full arg count including in/out/inout? Also is it ok to talk about the 8.1 beta in this list? Thanks, Tony ---(end of broadcast)-

[GENERAL] Is this still valid for current Postgresql versions?

2005-08-30 Thread Tony Caduto
"The current implementation of RETURN NEXT for PL/pgSQL stores the entire result set before returning from the function" I thought I read somewhere that 8.x did not do this. Thanks, Tony ---(end of broadcast)--- TIP 4: Have you searched our list

Re: [GENERAL] Embed PostgreSQL in application

2005-09-04 Thread Tony Caduto
e other ways to minimize or remove completely the need for a user to install PostgreSQL on his own. Thanks for the responses -- Lukas Demetz Digiem Snc http://www.digiem.net -- Tony Caduto http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql 8.x -

Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-08 Thread Tony Caduto
Just a FYI, you should also look at PG Lightning Admin (PGLA) it compares well with EMS and has some nifty features they don't have. i.e. EMS cannot cancel a long running query, they don't receive raise notices (last time I checked) and they can't view unicode data. Check it out at: http://www.

Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-08 Thread Tony Caduto
So it seemed to hang or it did hang? Have you tried a newer version? I routinely backup 100mb databases and it never hangs. I think one of the earlier versions did not change the cursor during the backup, is that what you mean by it appeared to hang? i.e. not being able to tell if it was doing

Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-08 Thread Tony Caduto
I understand. there was a issue with the pg_dump compression level defaulting to 0 which may have had some effect, or it may have been some other non related network issue. PGLA uses pg_dump.exe and pg_restorel.exe in the exact same way PG Admin III does (via createprocesses API command) so s

Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-10 Thread Tony Caduto
Just as a FYI, having trust in the pg_hba.conf file on win32 is normally not needed for PGLA to backup a database, I have been unable to reproduce the error Michael experienced while running on XP sp 2, the only thing I can think of was the version of pg_dump.exe I was shipping was corrupted or

Re: [GENERAL] EMS PostgreSQL Manager vs. TheKompany DataArchitect

2005-09-10 Thread Tony Caduto
Joshua D. Drake wrote: on another note it seems that the only version of pg_restore.exe that will accept a password from the command line is 8.0.0. All later versions prompt for the password, but fail every single time. The only way to restore a file on anything above 8.0.0 (pg_restore) i

Re: [GENERAL] Win32 Backup and Restore of large databases.

2005-09-21 Thread Tony Caduto
that the Postgresql code was ever updated to allow larger files. -- Tony Caduto http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql 8.x ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Extraordinarily slow!!

2005-09-24 Thread Tony Caduto
tion that uses 8.03 as the backend. You did increase the kernels shared memory right, and properly setup your postgresql.conf file for performance? Are you using the autovaccum daemon? There are a few guides available on how to setup your postgresql.conf file for performance, just do a search on

Re: [GENERAL] Extraordinarily slow!!

2005-09-24 Thread Tony Caduto
Joshua D. Drake wrote: Bizarre. Question: Does the problem happen when you just type psql? What if you pass the host option? e.g; psql -h 127.0.0.1 What type of auth are you running? Don't use Gentoo? Seriously, that distribution is completely unsupportable because no one else has the f

Re: [GENERAL] Extraordinarily slow!!

2005-09-24 Thread Tony Caduto
or Suse anymore, unless you want support: http://www.opensuse.org The 10.0 release will be next month. -- Tony Caduto http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql 8.x ---(end of broadcast)--- TIP 9: In versions below 8

Re: [GENERAL] What Front-End you suggest ?

2005-10-07 Thread Tony Caduto
://www.lazarus.freepascal.org/ -- Tony Caduto http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql 8.x ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] PostgreSQL 8.1 vs. MySQL 5.0?

2005-10-07 Thread Tony Caduto
work. -- Tony Caduto http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql 8.x ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Considering an upgrade...

2005-10-11 Thread Tony Caduto
Hi, I did a bunch of updates from databases that where on 7.4 and there were no issues at all. You could always setup a test server on win32,linux or whatever and simply restore one of your databases and see how it goes. Tony Caduto AM Software Design Home of PG Lightning Admin for

Re: [GENERAL] PG 8.0.4, Centos and 64 bit

2005-10-12 Thread Tony Caduto
es were empty. > > Thanks. I compiled it from source on a HP DL385 opteron(64bit mode) with Red Hat 4.1, so it should work just fine on CentOS. Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql 8.x http://www.amsoftwaredesign.com ---(end of

Re: [GENERAL] A good client

2005-10-18 Thread Tony Caduto
lower right hand corner with 50% of itself off the screen. All the SQL editors have code completion(including schema completion) and function param hints. Another good point is we will fix the bugs for you, unlike PG Admin III :-) Check it out, you won't be disappointed. Tony Cadu

Re: [GENERAL] PostgreSQL on Dual Processors, Dual-Core AMD Chips

2005-10-18 Thread Tony Caduto
. Hopefully a developer will chime in and add/correct me :-) Thanks, Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightnint Admin Onyx wrote: Hello Everyone, Does anyone know if PostgreSQL supports running on dual processors, and will efficiently utilize the dual

Re: [GENERAL] A good client

2005-10-18 Thread Tony Caduto
org/) Zeos lib is available for it http://www.zeoslib.net and it provides a very very very similar experience to Delphi. From my experience it is best to stay away from Access for application development if can.It does have it's place but I consider it a "evil" way of getting th

Re: [GENERAL] Need help with INOUT mis-understanding

2005-10-26 Thread Tony Caduto
INOUT to be ths same as OUT, not the same as a IN. There have been many times I really could have even used IN params that where not declared as CONST. How difficult would it be to have INOUT params not declared as CONST? Thanks, Tony Caduto ---(end of broadcast)--

Re: [GENERAL] Need help with INOUT mis-understanding

2005-10-26 Thread Tony Caduto
Tom Lane wrote: Tony Caduto <[EMAIL PROTECTED]> writes: I have noticed this as well, if I declare OUT params I can modify them to my hearts content before they go out, however if you declare it as a INOUT you can't modify it because it is declared as a constant. Uh, I don

Re: [GENERAL] Connections to DB

2005-10-28 Thread Tony Caduto
Jim C. Nasby wrote: SELECT * FROM pg_stat_activity; Note that if you turn on stats_command_string you'll also be able to see what each connection is doing if you're connected as a superuser. Just as a little FYI, on 8.1 pg_stat_activity will show the IP address and port as well, but onl

[GENERAL] Part of original Postgresql cook book back online

2005-11-01 Thread Tony Caduto
authored any of these functions and the author information is incorrect please let me know, or if you would rather not have your function listed I would gladly remove it. I also would encourage new entries as well. Thanks, -- Tony Caduto http://www.amsoftwaredesign.com Home of PG Lightning

Re: [GENERAL] Postgres + CentOS

2005-11-02 Thread Tony Caduto
the performance is very good. Tony Caduto http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql 7.4.x and up ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] Built in function question

2005-11-02 Thread Tony Caduto
Does anyone know if there is a function that can return the path to the data directory? I was looking through the docs, but could not find anything. Thanks, -- Tony Caduto http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql 8.x ---(end of

Re: [GENERAL] Built in function question

2005-11-02 Thread Tony Caduto
I found it in the pg_settings view, but if there is another way I would like to know about it. Thanks, Tony Tony Caduto wrote: Does anyone know if there is a function that can return the path to the data directory? I was looking through the docs, but could not find anything. Thanks

[GENERAL] question about Postgresql and rsync

2005-11-03 Thread Tony Caduto
if the postmaster is stopped it should be safe. Comments? Thanks, Tony Caduto ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes d

[GENERAL] Remotely reload server config?

2005-11-03 Thread Tony Caduto
Does anyone know if there is a way to reload the server config remotely via a sql command? I looked through the docs, but may have missed it. Thanks, Tony ---(end of broadcast)--- TIP 4: Have you searched our list archives? http

[GENERAL] Question about 8.1 release news

2005-11-06 Thread Tony Caduto
Hi, Would anyone object if I posted the 8.1 release announcement (when it happens of course) on the Borland Newsgroups (in Third Party anouncments)? Thanks, Tony ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your

[GENERAL] 8.1 beta3 initdb required?

2005-11-14 Thread Tony Caduto
Hi, Is a initdb required to go from 8.1beta 3 to 8.1.0? Thanks, Tony ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] postgresql rising

2006-09-20 Thread Tony Caduto
more they think it is what they need :-) -- 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 4: Have you searche

Re: [GENERAL] Sockets and posgtres

2006-09-27 Thread Tony Caduto
uld 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 Software Desig

Re: [GENERAL] Error handling inside PL/pgSQL functions

2006-10-12 Thread Tony Caduto
fy the regular expression a bit as I was using it to test for doubles not just integers. -- 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)--

Re: [GENERAL] performace review

2006-10-24 Thread Tony Caduto
well before version 8.x -- 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] Send email from PostgreSQL, may I ?

2006-10-27 Thread Tony Caduto
separate connection to the server which is initiated from a thread. -- 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)---

[GENERAL] Does anyone have a compiled dblink_tds for Redhat EL 4.x?

2006-11-02 Thread Tony Caduto
-- 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 2: Don't 'kill -9' the postmaster

Re: [GENERAL] running external programs

2006-11-07 Thread Tony Caduto
though. -- 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/reading through Usenet, please send an

Re: [GENERAL] MSSQL to PostgreSQL : Encoding problem

2006-11-21 Thread Tony Caduto
stem.UTF8Encode(widestring). This will encode unicode to UTF8 which is compatible with a Postgresql UTF8 database. I am sure Perl could do it also. Hope this helps. -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet

Re: [GENERAL] MSSQL to PostgreSQL : Encoding problem

2006-11-22 Thread Tony Caduto
Encode*(const WS: WideString): UTF8String; Call Utf8Encode to convert a Unicode string to UTF-8. WS is the Unicode string to convert. Utf8Encode returns the corresponding UTF-8 string. I would imagine that Perl also has such routines, but I don't know for sure. These routines might be in Fr

Re: [GENERAL] Data transfer between databases over the Internet

2006-11-22 Thread Tony Caduto
lop (http://www.icsharpcode.com/OpenSource/SD/Default.aspx) which is excellent. Hope this helps, -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Administration ---(end of

Re: [GENERAL] Data transfer between databases over the Internet

2006-11-22 Thread Tony Caduto
pplication run at a single web server and the clients would access through a browser. That way you would not have to deploy anything. -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Admi

Re: [GENERAL] Data transfer between databases over the Internet

2006-11-22 Thread Tony Caduto
deployed. Of course you would need .net on all the client PCs, but more than likely it's already installed. If the client side app is pretty simple then it would be a good idea to migrate away from VB 6 as it really is a dead language now. Food for thought :-) Later, -- Tony Caduto AM Sof

<    1   2   3   4   5   >