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

[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] 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

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] 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] 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] 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

[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

[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] 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

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

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

[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

[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

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] 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] 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

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] 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] 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] 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

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] 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

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] 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] 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?

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

[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] 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&

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] 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] 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] 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

[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] 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] 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] 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

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

[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.

[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

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] 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

[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

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] 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] 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

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

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

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

[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

[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

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

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

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

[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

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

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

[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] 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] 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] 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

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] 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] 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] 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] 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] 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] Postgres data/form entry tool

) to design the forms. Netbeans IDE There are probably many more -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best option for Postgresql Administration ---(end of broadcast

Re: [GENERAL] Is there a shortage of postgresql skilled ops people

d take a decent admin of any database to come up to speed in a very short time as long as they were interested in doing so. -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Administration ---

Re: [GENERAL] Postgresql to Delphi

om mytable where bla = bla;'); myquery.open; While not myquery.eof do begin if myquery.fieldbyname('somefield').asstring = 'something' then //signal your device. myquery.next; end; I guess that is the best I can come up without knowi

Re: [GENERAL] Postgresql to Delphi

ne Assembler if you really need to do that :-) It also has full support for pointers etc so you can pretty much get the performance of C or C++ all in the same package. Using Delphi for database applications is like being in Paradise all the time :-) Later, -- Tony Caduto AM Softw

Re: [GENERAL] pg_dumpall and version confusion

d do the trick. Later, -- 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 6: explain analyze is your friend

Re: [GENERAL] pg_dumpall and version confusion

ummer of code project :-) (make pg_dump more backwards compatible to at least 8.0) Later, -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Administration ---(end of broa

Re: [GENERAL] pg_dumpall and version confusion

hat Tom said. If I misquoted anyone I apologize in advance. Thanks, -- 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] pg_dumpall and version confusion

ust a oversight? Seems it should be a simple matter to add some logic that says IF version >= 8.2 THEN use grant on seq else don't use it. Bruce told me just the opposite of what you said in the above message. Thanks, -- Tony Caduto AM Software Design http://www.amsoftwaredesign.c

Re: [GENERAL] How to write a function that manipulates a set of results

. -- 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 6: explain analyze is your friend

Re: [GENERAL] grant on sequence and pg_restore/pg_dump problem

Bruce Momjian wrote: Tony Caduto wrote: Hi, I did a quick search and didn't see anything on this, if I missed it sorry in advance. Anyway, I was doing a restore of a 8.1 database(on a 8.1 server) using the 8.2 pg_restore and it was throwing errors when it was trying to restor

[GENERAL] grant on sequence and pg_restore/pg_dump problem

Hi, I did a quick search and didn't see anything on this, if I missed it sorry in advance. Anyway, I was doing a restore of a 8.1 database(on a 8.1 server) using the 8.2 pg_restore and it was throwing errors when it was trying to restore the permissions on the sequences. basically the pg_restor

Re: [GENERAL] postgresql vs mysql

reSQL is. -- Tony Caduto AM Software Design Home of Lightning Admin for PostgreSQL and MySQL http://www.amsoftwaredesign.com ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] Nice article on Unicode and it's encodings (utf8, utf16 and utf32)

http://developersoven.blogspot.com/ -- Tony Caduto AM Software Design Home of Lightning Admin for PostgreSQL and MySQL http://www.amsoftwaredesign.com ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Password issue revisited

Magnus Hagander wrote: Are we sure we want to do this? (Sorry, didn't notice this thread last time) The default on *all* windows versions since NT 4.0 (which is when the directory we use was added) will put this file in a protected directory. Is there truly such a thing on a windows PC? All

[GENERAL] CodeGear working on a new DB access layer for Delphi, but.....

65.aspx?Pending=true Take a peek and add a comment (if you want to) that nicely suggests PostgreSQL support. I know there are not a lot of Delphi developers on this list, but the more stuff that supports PostgreSQL the better right? Later -- Tony Caduto AM Software Design Home of Ligh

Re: [GENERAL] PostgreSQL/FireBird

s not have temp tables and it is limited to one stored proc language. If need a embedded database Firebird is a good choice, however if you want a serious database that can compete with Oracle or M$ SQL server then look no further than PostgreSQL :-) -- Tony Caduto AM Software D

Re: [GENERAL] I "might" have found a bug on 8.2.1 win32

ur own password storage code which is not that difficult to do anyway. If you guys are at all interested in doing the right thing you will take this very seriously and find a way to fix it. I know you think I am being a pain, but I am just sticking to my guns on what I KNOW is right. Later, --

Re: [GENERAL] I "might" have found a bug on 8.2.1 win32

ly other solution to this problem beside the pgAdmin III team fixing the inappropriate use of pgpass is to make a change to libpq by adding a new connections string option to ignore the pgpass file. At least that way the developer of the application would have the choice to use pgpass or not.

Re: [GENERAL] I "might" have found a bug on 8.2.1 win32

for trust access. Sorry in advance if you don't like what I have to say, but sometimes you can be very stubborn and one way or the highway!!! Later, -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Adm

Re: [GENERAL] I "might" have found a bug on 8.2.1 win32

se that for the pg_restore/pg_dump so you don't have to pipe the password? Why don't you just store the password in a file in the same directory as the pgAdmin executable? That way it would not affect other applications. Later, -- Tony Caduto AM Software Design http://www.amsoftwaredesign

Re: [GENERAL] I "might" have found a bug on 8.2.1 win32

I kind of don't like the way the pgpass file affected all the apps that used libpq, it could be considered a security risk. -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Administration ---

Re: [GENERAL] I "might" have found a bug on 8.2.1 win32

sure some 3rd party application I was testing created the file when it took my server login information. I would have found out about it right away if it's use would have been written to the log. Thanks everyone for you help. -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com

Re: [GENERAL] I "might" have found a bug on 8.2.1 win32

search for a password file but it came back empty. Anyone have any ideas on why this is happening? -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Administration ---(end of broad

Re: [GENERAL] I "might" have found a bug on 8.2.1 win32

reboot yet, I will do reboot and see if that clears it up. -- 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

Re: [GENERAL] I "might" have found a bug on 8.2.1 win32

for a password or anything, and the localhost entry in pg_hba.conf is also set for md5. -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Administration ---(end of broa

[GENERAL] I "might" have found a bug on 8.2.1 win32

en uninstalled 8.2.1 on the win32 box and completely deleted the data directory and reinstalled and the same behavior prevailed. I know a new connect GRANT was enabled in 8.2, but I though that was in addition to the first checks done in pg_hba.conf. Maybe I am doing something wrong, but it sure

Re: [GENERAL] Any Plans for cross database queries on the same server?

David Fetter wrote: That being said, I think it is a dumb feature. If you have data in one database, that requires access to another database within the same cluster. You designed your database incorrectly and should be using schemas. I would have to disagree, it's a feature that has been

Re: [GENERAL] Any Plans for cross database queries on the same server?

Mark Walker wrote: It's sort of a matter of taste, but there are lots of people who like to keep there logic on the server or at least within sql statements, so there's probably a good sized market that your not reaching if you ignore it. That is a good point, I and many developers I know li

Re: [GENERAL] Any Plans for cross database queries on the same server?

Ron Johnson wrote: be separate databases because they're clearly related data. Just because they are related, doesn't mean that it's always wise to lump it all in the same database. Mainly for scalability and performance reasons. I would tend to agree, there are numerous times being

Re: [GENERAL] Any Plans for cross database queries on the same server?

Peter Eisentraut wrote: This has been discussed about ten thousand times, and the answer is still no. Why? Seems to me if it was discussed that much it must be a very sought after feature. How come it's not on the TO Do list for the future at least? Is it because of some limitation of the

[GENERAL] Any Plans for cross database queries on the same server?

Dblink is nice, but should it really be needed for databases on the same physical server? What would be cool is to allow a double dot notation i.e. database1..schema1.table1 Just a idea. Comments? -- Tony ---(end of broadcast)--- TIP 9: In v

[GENERAL] Default fillfactor question (index types other than btree)

Does anyone know what the default fillfactor is for index types other than btree? I found in the docs that the default for btree is 90, but can't seem to find what it is for the other index types. Thanks in advance, Tony ---(end of broadcast)-

[GENERAL] Postgresql 64bit question

Hi, I was just wondering if a 32bit client connected to a 64bit server, would it be possible for the 64bit server to return a OID that was over 4 billion to the 32 bit client and possibly cause a range error if the OID value was used in a unsigned 32-bit integer var? Thanks, -- Tony

  1   2   3   4   5   >