Re: [GENERAL] SQL Manager 2007 for PostgreSQL released

Admin does anyway(work via WINE) and they program their products with Delphi as well, so I think it would work fine. Just one word of advice about WINE, make sure you have the core MS true type fonts installed or the win32 apps will look funny, especially when using editors. Later, -- Tony

Re: [GENERAL] Proposed Feature

" arrow if the service is running and a red one if it is not, then have a few right click options to start/stop/restart the service. I was thinking the same thing awhile back, but forgot about it. Later, -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Ligh

Re: [GENERAL] The leanest, meanest Windows installer possible

tested with 8.1, but should work just fine with 8.2. This program is AS IS..with no support from AM Software. Inno Setup is available from here for free: http://www.jrsoftware.org/isinfo.php I can't remember exactly, but I think this one comes in at around 8mb. -- Tony Caduto AM Sof

Re: [GENERAL] pgTray - win32 tray tool for monitoring PostgreSQL service

trol panel applet. Later, Tony Caduto AM Software Design ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] Reordering columns, will this ever be simple?

er more exciting ideas too. From a admin tool developers perspective the ability to reorder columns without manually copying to a new table and all that is pretty exiting :-) Tony Caduto AM Software Design http://www.amsoftwaredesign.com ---(end of broadcast)

Re: [GENERAL] Postgresql INSERT speed (how to improve performance)?

support if you are using anything other than InnoDB. With that said you can increase your insert performance by simply using a transaction and committing every 1000 rows or so. If you do this you will see a huge performance increase. hope that helps. Tony Caduto AM Software Design http

Re: [GENERAL] Postgresql INSERT speed (how to improve performance)?

messed up on the client. Might also help to let us know exactly how you are timing this stuff. Are you connecting remotely via PSQL or are you connecting via SSH and running psql or mysql that way? Later, Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Adm

[GENERAL] Need help doing a PostgreSQL vs Firebird feature comparison

Hi, I was just wondering if anyone could help me out by taking a look to see if I missed any important features. http://www.amsoftwaredesign.com/pg_vs_fb This comparison is going to be for the benefit of Delphi users. The Delphi community is heavily biased to Firebird. Please post any com

Re: [GENERAL] Need help doing a PostgreSQL vs Firebird feature comparison

Dmitry Koterov wrote: One difference in SQL syntax is that FireBird could join stored procedures like this: SELECT b.* FROM get_ids() a LEFT JOIN get_data(a.ID ) ON 1=1 (where a.ID parameter is passed from the previous set as a next procedure parameter), but Pos

[GENERAL] PostgreSQL vs Firebird feature comparison finished

Check it out here: http://www.amsoftwaredesign.com/pg_vs_fb When comparing in the grid the only major advantage FB has is probably BLOB support. PG only suppports 1 gb while FB supports 32gb. Bytea is pretty slow as well when compared to the FB BLOB support. The other area is Character set

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

Dave Page wrote: Couple of corrections Tony: - You don't necessarily need to stop the postmaster to take a filesystem backup - http://www.postgresql.org/docs/8.2/interactive/continuous-archiving.html#BACKUP-BASE-BACKUP. Obviously that assumes logs will be replayed during recovery. - The native

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

Dave Page wrote: Tony Caduto wrote: Other than that I would say PG kicks butt. You're just realising that? :-) Ah, I new that around 2004 :-) I just have to convince Delphi users of that :-) Later, Tony ---(end of broa

[GENERAL] Can someone else verify if this is a bug?

Hi, I think there might be a bug in the built in function pg_get_viewdef. Basically if you have a function in your view SQL like this: replace(address1, '\r', '') pg_get_viewdef is returning the view definition with the \r replaced by it's ASCII code which causes this: replace(address1, ' ',

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

Hi, Someone mentioned we should put this in the PostgreSQL wiki. Do you guys think that would be beneficial? If so, I don't mind the work on the list I have done so far going on the wiki. It would make it a lot easier to add other DBs to the mix. Later, Tony ---(end

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

Greg Smith wrote: This is a really good comparision, focusing on features that I think people understand rather than so much on technical trivia. Someone else mentioned moving it onto the Wiki. Questions that pop into my head: -Tony, would be you be comfortable with your work being assimi

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

Stephen Ince wrote: Postgres can't be embedded or serverless. Firebird has the embedded feature. Most of the databases have this capability (hsqldb, derby,oracle,mysql, firebird, and db2). Derby and hsqldb are the only free embedded databases for commercial use. A lot of Firebird users have

[GENERAL] Verison 8.3 PL/pgSQL debugger Question

Hi, Is there any documentation for developers on how to use the new debugger in 8.3? Specifically on how it works and general guidelines on integration into 3rd party GUI applications. thanks, Tony ---(end of broadcast)--- TIP 3: Have you check

[GENERAL] PLpgsql debugger question

functions are included by default in 8.3, but how do you install for 8.2? Thanks, Tony Caduto ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] PLpgsql debugger question

Tom Lane wrote: Tony Caduto <[EMAIL PROTECTED]> writes: As I understand it the debugger functions are included by default in 8.3, That's incorrect. regards, tom lane Ok, thanks for the info. Back in Sept the debugger was advertised as a fea

Re: [GENERAL] PLpgsql debugger question

text search made more accessible by becoming a feature included in the system code instead of being an add-on option. Clustering code from Skype for load balancing and spreading queries to a large database across several PostgreSQL systems. Now you know what I am talking about :-) Later, Tony Caduto

Re: [GENERAL] PLpgsql debugger question

Joshua D. Drake wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 14 Nov 2007 12:49:37 -0600 Tony Caduto <[EMAIL PROTECTED]> wrote: Here ya go: http://www.informationweek.com/news/showArticle.jhtml?articleID=201803375 I see nothing incorrect in that article. Sin

Re: [GENERAL] PLpgsql debugger question

s no mention of anything debugger related in the 8.3 beta release notes either. Kind of seems like its not really a feature to me, but what do I know :-) The article is very misleading with regards to the debugger. Later, Tony Caduto ---(e

[GENERAL] PostgreSQL 8.2 and Firebird 1.5 comparative

I submitted this to digg. http://digg.com/software/PostgreSQL_8_2_vs_Firebird_1_5_for_Enterprise_Use Needless to say PGSQL has a lot more yes entries :-) Please give it a digg if you want. Thanks, Tony ---(end of broadcast)--- TIP 5: don't forg

Re: [GENERAL] moving from mysql to postgree

ould check out Lightning Admin. We have a version for both that have the same look and feel and could make the transition easier. You can also ask questions at our forums: http://www.amsoftwaredesign.com/smf regarding moving from MySQL to PostgreSQL. Tony Caduto http://www.amsoftwaredesign.c

[GENERAL] 8.3 vs 8.2 sql compatiblity issue

Hi, Just running some queries that have worked from 7.4 through 8.2 and they don't seem to work on 8.3. select case when a.attnum = any(conkey) then true else false end from pg_constraint where contype = 'p' and conrelid = c.oid This one is puking on a.attnum = any(conkey) returns the fo

[GENERAL] Compiled debugger plug in for windows, any one have it?

I dont' have a c/c++ compiler on my PCs as I am a Delphi guy. Anyone have it compiled for win32 and willing to share? Actually I do have CodeGear C++, but it's unlikely to work with that. Thanks, Tony ---(end of broadcast)--- TIP 6: explain anal

Re: [GENERAL] 8.3 vs 8.2 sql compatiblity issue

Tom Lane wrote: That's no doubt got something to do with it, but I think Tony is mighty confused about exactly what is failing. pg_constraint.conkey is not text, for instance; it's smallint[] and so the quoted bit should still work just fine. I'd suggest trying the query in some client that giv

[GENERAL] Question about PostgreSQL from Delphi newsgroups

Hi, Someone asked me a question about PostgreSQL on the Delphi newsgroups and I was not sure how to answer them: "Do you know if using PostgreSQL a query or connection can have a priority set, so it can run quicker than other queries? For example, in a POS system the reporting queries should h

[GENERAL] Tom thinks it's bad code was 8.3 vs 8.2 sql compatibility issue

Alvaro Herrera wrote: Tom Lane wrote: Tony Caduto <[EMAIL PROTECTED]> writes: case when cast(a.attnum as text) IN( select array_to_string(conkey,',') from pg_constraint where Surely that's the worst bit of SQL code I've seen in awhile.

Re: [GENERAL] PLpgsql debugger question

Joshua D. Drake wrote: Don't get me wrong the debugger is certainly useful but I see no technical argument (and I am sure you will correct me if I am wrong :)) that deems it needs to be in core. Joshua D. Drake I would have to disagree. So if you are using Oracle do you have to go throu

Re: [GENERAL] The first dedicated PostgreSQL forum

On 11/15/2010 5:53 PM, Lee Hachadoorian wrote: If anyone's interested, I've started accessing the postgres list through gmane.org (along with several other mailing lists I subscribe to). It's gives you the choice of reading the list as a threaded archive, a blog, or through an NNTP newsreader or

Re: [GENERAL] Is PostGreSql's Data storage mechanism "inferior"?

ce it ONLY runs on windows and most hosting providers run some form of Unix where M$ cannot play at all. So in conclusion I would not pay attention to this article, it was written by someone who really does not know what they are talking about. Later, Tony Caduto AM Software Design Home

[GENERAL] Lets get the 8.3 Announcement on the front page of Digg

http://digg.com/programming/PostgreSQL_8_3_has_been_released I dugg it :-) Later, 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 do

Re: [GENERAL] Lets get the 8.3 Announcement on the front page of Digg

At the bottom of that Register article I saw this article: http://www.regdeveloper.co.uk/2008/01/24/stonebraker_dewitt_mapreduce/ In which it says: "Ingres inventor and Postgres architect Mike Stonebraker" So this Stonebraker guy is the Postgres Architect? Interesting stuff on the Register :-)

[GENERAL] Possible tiny issue with pg_dump.exe on windows

This may apply to Unix versions as well but I have not tried. Anyway, I am using C# to create a GUI front end to pg_dump and I am using the PGPASSWORD environment variable to set the password like this: System.Environment.SetEnvironmentVariable("PGPASSWORD", myargs.password); This works fine a

Re: [GENERAL] PostgreSQLDirect versus Npgsql

The Corelab product does not support SSL connections. I looked at it, but I needed SSL, so I am sticking with Npgsql. Other than the fact it does not have SSL, it looks very nice and includes a dump component, not sure if that is fully managed or just a wrapper around pg_dump.exe. Later, Tony

Re: [GENERAL] Pains in upgrading to 8.3

paul rivers wrote: Going from 8.2.4 and 8.2.6 to 8.3.0 has been painless for me. However, unlike the blogger you cite, I read the directions before, not after, attempting it. The blogger has a point about pg_dump and restore, it could be much better, for example the backup process could b

Re: [GENERAL] Pains in upgrading to 8.3

Magnus Hagander wrote: For the case of upgrading, it wouldn't work. But there are certainly other cases where it would help. Say from your central pgadmin console administering 10 servers from 3 different major release trees :-( It can be done with commandline pg_dump, but it means you have

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

Dave Page wrote: You can avoid this by building your own libpq.dll using mingw/msys if you like - that will work just fine with a VC++ built server. Hi Dave, Just some thoughts on the whole libpq.dll thing. It would be really nice from a client distribution view of things to have a libpq

Re: [GENERAL] date and time

ess. Do you mean something like this: CREATE OR REPLACE FUNCTION "public"."test"() RETURNS timestamp AS $BODY$ DECLARE mydate_var timestamp; BEGIN --store the current timestamp in a variable mydate_var = now(); RETURN mydate_var; END; $BODY$ LANGUAGE 'plpgsql&

[GENERAL] Getting weird pg_tblspc error, has anyone seen this before?

with no luck. I am missing some info from the client like what user he is running as and what his pg_hba.conf looks like. If anyone has seen this before please let me know. Thanks, Tony Caduto -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to you

Re: [GENERAL] Getting weird pg_tblspc error, has anyone seen this before?

ly or messing something up with the environment vars where it can't find the directory. Later, Tony Caduto -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Getting weird pg_tblspc error, has anyone seen this before?

Magnus Hagander wrote: Tony Caduto wrote: I will follow up with the client and have him check if that directory is missing. I think he may have used the Postbooks win32 installer to install his server, so it might be that their installer is messed up and not creating the directory properly or

Re: [GENERAL] Getting weird pg_tblspc error, has anyone seen this before?

a mystery :-) I did report the issue on the PostBooks sourceforge project forum. Later, Tony Caduto -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] edb-debugger, debugging pl/pgsql

twaredesign.com/debugger_client_announce Tony Caduto AM Software Design -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] edb-debugger, debugging pl/pgsql

ssue and if it does crash or hang (not likely) it won't take down whatever admin tool you are using. Oh, and it's FREE. http://www.amsoftwaredesign.com/debugger_client_announce Check it out works great on win32 and built with a native compiler with a high performanc

Re: [GENERAL] edb-debugger, debugging pl/pgsql

Magnus Hagander wrote: You know, kinda like PostgreSQL vs Oracle Express ;) Well, not quite the same since LA Debugger Client is not crippled in some way Like Oracle or MS SQL Express :-) It's just plain old freeware. Later, Tony -- Sent via pgsql-general mailing list (pgsql-general@post

Re: [GENERAL] Number or parameters for functions - limited to 32 ?

E FUNCTION test_func(varchar) RETURNS void AS $BODY$ DECLARE IN_ARRAY text[] ; ACCOUNTNUMBER_INvarchar; BEGIN IN_ARRAY = string_to_array($1,'~^~'); --use a unique delimiter ACCOUNTNUMBER_IN = IN_ARRAY[1]; return; END $BODY$ LANGUAGE 'plpgsql' VOLATILE; Later, Tony

[GENERAL] 9.0 pg_database datconfig ?

Hi, Just looking around 9.0 and noticed pg_database is missing the datconfig field which stored default session info for the database. Where is this stored now? I looked in the release notes, but no mention of datconfig. Thanks, Tony -- Sent via pgsql-general mailing list (pgsql-general@p

Re: [GENERAL] RAISE NOTICE format in pgAdmin

t_announce (built with Delphi) If you are using the win32 version there is a option at the end of the installer script to install the debugger part. On 8.2 or 8.3 you will need to install it yourself. Please see: http://pgfoundry.org/projects/edb-debugger/ Hope that helps. Tony Caduto AM Softw

Re: [GENERAL] SELECT INTO returns incorrect values

wercase everything you send to the server that is not in quotes. It's a lot easier to read without the uppercase. Later, Tony Caduto AM Software Design Home of Lightning Admin for PostgreSQL http://www.amsoftwaredesign.com -- Sent via pgsql-general mailing list (pgsql-general@post

Re: [GENERAL] Oracle and Postgresql

David Fetter wrote: What they want to have is a huge entity they can blame when everything goes wrong. They're not interested in the actual response times or even in the much more important time-to-fix because once they've blamed Oracle, they know the responsibility is no longer on their shoulde

Re: [GENERAL] How to know the password for the user 'postgres'

o you making the change. Later, Tony Caduto AM Software Design http://www.amsoftwaredesign.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] 8.3 libpq.dll not working on some versions of windows

Hi, We have been running into issues where the 8.3.x versions of libpq.dll will not load in certain versions of windows and WINE(does not load at all on wine). It seems to be hit and miss on Windows XP, mostly seems to affect SP3 and some SP2 installs of XP. I have only been able to get arou

Re: [GENERAL] 8.3 libpq.dll not working on some versions of windows

Glyn Astill wrote: Pretty sure I've used most 8.3.x versions here on both sp2 and 3. How have you chacked you have all the dependencies? (I like depends.exe) http://www.dependencywalker.com/ hmm, the problem seems to be that MSVCR71.DLL has a problem with some versions of Kernel32.DLL,

[GENERAL] compiling libpq.dll with Borland C++, is it possible?

Hi, I am trying to compile my own copy of libpq.dll using bcc32.exe, the docs say it is possible, but I get a error when it tries to compile dirent.c Has anyone been able to do this? C:\postgresql-8.3.5\src\interfaces\libpq>make -N -DCFG=Release /f bcc32.mak MAKE Version 5.3 Copyright (c) 19

[GENERAL] Trying Compile libpq.dll with VC++ 9.0, but need help

Hi, Trying to get a libpq.dll that only has SSL deps using these instructions: http://www.postgresql.org/docs/8.3/interactive/install-win32-libpq.html It compiles a bit then dies at: C:\postgresql-8.3.5\src\interfaces\libpq>nmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 9

Re: [GENERAL] Trying Compile libpq.dll with VC++ 9.0, but need help

Dann Corbit wrote: How much disk space do you have? I guess that you are running out of space. During the link, watch the available disk space. Hi Dan, Thanks for the reply :-) I actually got it working.Now the only problem is it still has a dependency for MSVCR90.DLL Does anyon

Re: [GENERAL] Trying Compile libpq.dll with VC++ 9.0, but need help

Dann Corbit wrote: Change from /MD to /MT and it will not use the runtime DLL. Look under: Properties -> Configuration Properties -> C/C++ -> Code Generation -> Runtime Library Hi Dann, I changed that in the win32.mak file and now it gives this error: link.exe @C:\DOCUME~1\20659\L

Re: [GENERAL] Trying Compile libpq.dll with VC++ 9.0, but need help

Hiroshi Saito wrote: Hi. It is very strange I checked that it was ready in VC9 again. http://winpg.jp/~saito/pg_work/WIN32_BUILD_INF/LOG_LIBPQ_WIN32MAK.txt Furthermore, even psql was checked. http://winpg.jp/~saito/pg_work/WIN32_BUILD_INF/psql_win32_pg83.mak Please move psql_win32_pg83 w

[GENERAL] Libpq.dll lite is here :-)

current libpq.dll won't work on wine because of the VC++ runtime. I would like to maintain these for future PostgreSQL releases and if anyone is interested in helping or has a suggestion on where to host them permanently please let me know. Later, Tony Caduto AM Software Design

Re: [GENERAL] Visual DATA editor for PostgreSQL?

Dmitry Koterov wrote: Hello. Is there a GUI utility to visually edit Postgres DATA (not a database schema!), which allows at least: - insert/update rows using screen windowed forms (possibly ugly auto-generated forms, but - still forms) - insert foreign key references by selecting them from a

[GENERAL] pg_restore question (-T and -t)

Hi, does anyone know if you can do multiple -T or -t (restore named trigger, restore name table) switches? In the docs for pg_restore it does not specify if it will accept more than one, but in the pg_dump docs the -n and -t switches allow multiples. Thanks, tony -- Sent via pgsql-general

Re: [GENERAL] System table documentation

Bill Todd wrote: Where can I find documentation for the system tables? I have not found anything in the 8.3.1 documentation. Thanks. Bill Hi Bill, Good to see a Delphi guy here :-) http://www.postgresql.org/docs/8.3/interactive/catalogs.html Later, Tony Caduto AM Software Design http

Re: [GENERAL] PGSQL or other DB?

appens fairly often and it's part of the reason why I eventually dumped it and moved to PostgreSQL. Hope that helps you out some. Tony Caduto AM Software Design Home of Lightning Admin for PostgreSQL http://www.amsoftwaredesign.com -- Sent via pgsql-general mailing list (pgsql-general@postgre

Re: [GENERAL] PGSQL or other DB?

/UsersGuide.html You can scale PostgreSQL and Python web apps really well with that as long as you are not using CGI. I use Pylons combined with mod_wsgi, but you can use it with mod_python as well. Tony Caduto AM Software Design Home of Lightning Admin for PostgreSQL http://www.amsoftwaredesign.com

Re: [GENERAL] COPY questions

as well. Later, Tony Caduto AM Software Design htpp://www.amsoftwaredesign.com Home of Lightning Admin for PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] is there anyway to get the backends IP address from

, Oracle) is that Postgres does little to no pre-runtime type checking. Thanks, Tony Caduto Bruce Momjian wrote: Tony Caduto wrote: Hi, Does anyone know if there is a way to get the backends IP address from the PID? I am using the view pg_stat_activity and it would be nice if it would also display

[GENERAL] question about 8.1 and stored procedures

Hi, I read in a article/interview on http://madpenguin.org/cms/html/62/3677.html that work was being done on improving/adding support for sql standard compliant stored procs/functions Does anyone know exactly what that means? Does it mean that Postgres will have stored procs that can have input

Re: [GENERAL] Question about function body checking and 8.1

Ok, here is a example CREATE OR REPLACE FUNCTION mytest(); RETURNS VOID as $$ DECLARE mytestvar varchar; mytestvar2 integer; BEGIN mytestvarr = 'bla'; select testfield from nonexistanttable where testfield = 2 INTO mytestvar2; --The table does not exits, yet postgresql d

Re: [GENERAL] Another help needed on Window client

You need to set your pg_hba.conf file to allow trusted authentication for 127.0.0.1 i.e. hostall all 127.0.0.1/32 trust Vernon wrote: Here is my situation: C:\Program Files\PostgreSQL\8.0>runas /user:user01 cmd.exe Enter the password

Re: [GENERAL] Pgsql 8.0 on Win32 Production env.

I have been using the win32 version of PG 8.0 on a windows 2003 server since sept 2004 and it's for a financial daily pricing application using apache 2.5x. I have a Delphi win32 app that the users use to update the database with data from a spreadsheet, the app then updates the tables used fo

Re: [GENERAL] do I need replication or something else?

If you are using Delphi you can use the tclientdataset which has a Briefcase type system built in. Or you can use one of the many middleware systems that are available for Delphi, all of which will do what you want. www.remobjects.com www.astatech.com etc etc Most of them work by creating a XML

[GENERAL] autopackage and Postgresql?

Does anyone know if there is a autopackage for Postgresql? http://www.osnews.com/story.php?news_id=10155 for a article www.autopackage.org for home page I tried and it works really well, and it installed a binary version of inkscape on my Gentoo box without issue. T

Re: [GENERAL] PostgreSQL and .NET

I think he means PL C# I thought I saw a project started for PL C# or PL Mono on Gborg. not knowin gmuch about .Net ... what is a 'server-side .Net'? Like a PL/.Net? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscra

[GENERAL] Question about format_type function

The format_type function is great, except for the way it formats varchars, it always returns Character Varying or whatever, it would be nice if it had a option to return a short version of these names. i.e. format_type(a.atttypid, a.atttypmod,true) would return all short names format_type(a.att

Re: [GENERAL] Question about format_type function

call that function and have the results look like what users see in tools such as MS SQL servers enterprise manager. Thanks, Tony On Sunday 03 April 2005 20:49 pm, Tom Lane wrote: > Tony Caduto <[EMAIL PROTECTED]> writes: > > The format_type function is great, except for the

Re: [GENERAL] pg 8.0.1-r3 killls pgadmin3 and phppgadmin

Why don't you try PG Lightning Admin and see if you get the same error. http://www.amsoftwaredesign.com I have been using it with 8.01 without issues. T ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives

[GENERAL] Announcment: PG Lighting Admin Pre-Release 6 available

Check it out here: http://www.amsoftwaredesign.com/ This release adds built in SSH tunnel support right from the server registration dialog along with the ability to execute a database dump from the GUI.(restore coming soon). This release also properly exports text fields with CRLF in them (strip

Re: [GENERAL] Plpgsql function with unknown number of args

ess special compiled to support more), but with this technique you can pass in as many as you want. hope this helps. Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql 8.x http://www.amsoftwaredesign.com CREATE FUNCTION myfunc(criteria) RETURNS AS $$ BEGIN BEGIN

Re: [GENERAL] Plpgsql function with unknown number of args

You don't have to cast it as anything, just return a refcursor from your function. Say you return a refcursor called return_cursor select myfunction(your_in_array); fetch all from return_cursor; If you are calling from a development environment, you put the return value of the fuction (the refcu

Re: [GENERAL] Suggestions

http://wwwmaster.postgresql.org/download/mirrors-ftp?file=win32%2Fpostgresql-8.0.2.zip Good luck, -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql 8.x http://www.amsoftwaredesign.com syed magthum wrote: Hi We are likely to build a desktop application in VB.Net and we are in a hu

Re: [GENERAL] Postgresql Windows ODBC

re stuff with Delphi as well, just about anything you could do in C or C++ minus device drivers. Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql 8.x http://www.amsoftwaredesign.com ? In Windows, what would you say is the easiest language to use which can talk to Pos

Re: [GENERAL] Playing with PostgreSQL and Access VBA

In a real application that uses a client/server type database you should NEVER construct queries that return a million rows. You have to keep in mind that each record has to be sent accross the wire via TCP/IP and it is going to take a lot of time to bring back 1 million rows and I am sure your

Re: [GENERAL] psqlODBC and Access

Let's not forget about PG Lightning Admin :-) http://www.amsoftwaredesign.com In case you don't like PgAdminIII you may try commercial products like EMS PostgreSQL Manager http://sqlmanager.net/products/postgresql/manager What they call "Visual Database Designer" might just be what you are looking

[GENERAL] Delphi personal (was Playing with PostgreSQL and Access VBA)

All you need is the Personal Edition of say Delphi 6 or Delphi 7, and even Delphi 2005. For Delphi 2005 personal edition see this link: http://andy.jgknet.de/oss/kylix/wiki/index.php/Delphi_2005_Personal_Edition_xmlrtl.dcp_fake Heck, Delphi 5 is still extremely viable and can do anything 6,7 or 20

[GENERAL] question about about future 8.1 and IN, INOUT, and OUT parameters

I saw that the recently released pl/java has the ablity to use IN, INOUT, and OUT parameters. Is the syntax going to be exactly like it is in Oracle? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Playing with PostgreSQL and Access VBA

I guess I was thinking more of the "big picture" Your right of course, for someone just fooling around at home or for a very small business Access is great, but I am saying from experience that Access is a poor choice for any kind of large project or corp use. Access may be a poor choice for a De

Re: [GENERAL] Serial / auto increment data type

, you dont need it, but it is always there if you do need it, and it is harder to add such a field down the line, after the fact. Thanks! -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql 8.x http://www.amsoftwaredesign.com ---(end of broa

Re: [GENERAL] Postgresql, Windows, Peer-2-Peer network

upport, or Putty.exe and have all the other machines connect via encrypted SSH, then you could simply leave your server to allow connections only from localhost. -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql 8.x http://www.amsoftwaredesign.com IS IT POSSIBLE

Re: [GENERAL] Visual Query Builder

PG Lightning Admin has one. It's not free,but very,very inexpensive, especially if you purchase with Euros http://www.amsoftwaredesign.com Hrishikesh Deshmukh wrote: Hi All, I have DB in Postgresql; is there a visual query builder? Thanks in advance. Hrishi ---(end of b

Re: [GENERAL] Thanks for insights into internal design

That's fine for a system like access or DBASE, but you should never be making queries that large for a production application. Access or DBASE or any other local FILE based system will not have any problems bringing back 1 million records because it does not have to bring the records across the w

[GENERAL] Is there a bug in the win32 pg_restore (version 8.02) ?

e: *** aborted because of error I have the pg_hba.conf for my host set to md5, and if I change it to trust then I can do the restore. update: I just tried the pg_restore that has a version number of 8.0 and it works, definately seems to be a bug in the 8.02 version (win32) -- Tony Caduto AM Sof

Re: [GENERAL] temp tables ORACLE/PGSQL

space n ON n.oid = c.relnamespace where n.nspname like 'pg_temp_%' AND pg_catalog.pg_table_is_visible(c.oid) AND Upper(relname) = Upper($1); IF FOUND THEN RETURN TRUE; ELSE RETURN FALSE; END IF; END; $BODY$ LANGUAGE 'plpgsql' VOLATILE; -- Tony

Re: [GENERAL] temp tables ORACLE/PGSQL

does that in a production database application? Most people want to re-use connections for performance reasons. Dennis ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq -- Tony C

Re: [GENERAL] Postgresql and VBA vs Python

Like I said before get the personal/standard version of Delphi 6,7 or 2005, it's 99.99 and you can connect to postgres with it using third party component sets like Zeos. (2005 may not be available yet) The licence varies on the version, I think Delphi 6 personal allows for commercial developem

Re: [GENERAL] temp tables ORACLE/PGSQL

n't need global temp tables :-) And using a scheme like this will work on any database that supports sequences or some other form of generating a unique ID. -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql 8.x http://www.amsoftwaredesign.com fisher wrote: Hi Thank You

Re: [GENERAL] ip connection on local p2p network

host, '*' = any change it to this: listen_addresses = '*' # what IP interface(s) to listen on; # defaults to localhost, '*' = any notice the listen_addresses is uncommented. That's all you need to do. -- Tony Caduto AM Software Design Home of PG Lightning Admin for Post

Re: [GENERAL] Tuning queries inside a function

We have functions with upwards of 800 lines and we simply pull the queries out and stick them in the PG Lighting Admin or PG Admin III query editor. We then substitue any vars etc with real values. Works ok. > What's the best way to tune the queries inside a user function? > > I have a fairl

Re: [GENERAL] Postgres vs Firebird?

growth has been exponential, showing no sign of letting up soon, and I'm reviewing clustering and replication technologies so that we can continue to scale as nicely as we have to date with our single server. (now with a load avg around .30 typically) -Ben -- Tony Caduto AM Software Design

  1   2   3   4   5   >