[GENERAL] using PG with Syslog

Hi, Does anyone know of a good resource on how to use Postgresql as a destination for Syslogd messages? I am interested in putting all postfix logs to a table rather than a file. Thanks in advance, -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http

Re: [GENERAL] Hardware recommendation for PostgreSQL on Windows?

ning Admin (http://www.amsoftwaredesign.com), so it's a good reliable choice. Hope this helps, Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com ---(end of broadcast)--- TIP 3: Have

Re: [GENERAL] visual query builder for Postgres?

Zlatko Matić wrote: Is there any visual tool for creating queries in PostgreSQL? Zlatko PG Lightning Admin has a visual query builder plus lots more(modern tabbed MDI interface,printing,import/export etc) and it's super inexpensive. -- Tony Caduto AM Software Design Home of PG Ligh

Re: [GENERAL] linking temporary tables from MS Access?

fly, fill it what you want and then drop when you don't need it anymore. -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com ---(end of broadcast)--- TIP 9: In versions below 8.0, the pl

Re: [GENERAL] PostgreSQL Top 10 Wishlist

le etc makes me shudder.. Later, -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] what am I doing wrong with this query?

select array_to_string(conkey,',') from pg_constraint where contype = 'p' and conrelid = 17059 returns a value of 1,2,18 for the array to string function, when I do this it does not return true: select case when 18 in (array_to_string(conkey,',')) then true else false end from pg_constraint

Re: [GENERAL] what am I doing wrong with this query?

Never mind, I figured it out, I had to use ANY instead of IN, works fine now. Thanks, Tony ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that y

[GENERAL] optimizing server for a 10 million row table

fields and I could post the DDL of the table if needed. Thanks, -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] [HACKERS] Need help in installing postgresql 8.1.2 on Windows

ut PG Lightning Admin for your admin needs, it's much more intuituve than what comes with Postgresql. Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com ---(end of broadcast)--- TIP 4: Have yo

Re: [GENERAL] PostgreSQL Top 10 Wishlist

at it would really "just" take, but hey we are just talking here right? -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] PostgreSQL Top 10 Wishlist

, I rarely do it that way, I usually specify the columns by name i.e. insert into blabla (fieldname1,fieldname2) values('bla','bla') oh well, there goes that idea :-) -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com -

[GENERAL] Does this look ethical to you?

about this. Thanks, -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Does this look ethical to you?

Joshua D. Drake wrote: Tony Caduto wrote: I would call it fairly shady. I am guessing that by doing so they are getting placement within search engines or something. Hi Joshua, Yep, that's the part that I don't like. Using Postgresql in there is one thing as it's good beca

Re: [GENERAL] Does this look ethical to you?

down now also , something is really fishy with Navicat. Seems odd that my ISP is down and their page has a input problem...hmmm I did send them a email about it about 1/2 hour ago, so maybe they are in the process of fixing this issue. Thanks for your input on this guys. -- Tony Caduto AM

Re: [GENERAL] Does this look ethical to you?

l.navicat.com/PG_Lightning_Admin/ is gone or having a problem. I asked them nicely to remove it within 24 hours, so we shall see. Thanks again for the input. -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com -

Re: [GENERAL] Does this look ethical to you?

ike to know how they get such good placment on all the search engines, you do a search on "Postgresql GUI admin" and all you get on the first page is their stuff. Later, -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com

Re: [GENERAL] Does this look ethical to you?

the heads up on the spelling, I was not aware it was spelled like that. Later, Tony -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com ---(end of broadcast)--- TIP 4: Have you se

Re: [GENERAL] Does this look ethical to you?

ing a link or something in the win32 Postgresql installer back to the commercial products page: http://www.postgresql.org/download/commercial Thanks, -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com ---(e

Re: [GENERAL] Does this look ethical to you?

se of the third party market. I am just raising a valid concern, no need for flames. -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Does this look ethical to you?

roduct commercial or open source, but I think links back to the commercial and open source pages on the postgresql site would be a fair thing to do. You are not letting the user make a choice about which admin tool to use or even try... Just my opinion on the whole fair competition thing, -- T

Re: [GENERAL] Does this look ethical to you?

cts available, you can get more information here to postgresql home page>. I don't see that as being detrimental to anyone and would certainly be in fair play. -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesig

Re: [GENERAL] Does this look ethical to you?

like that. That certainly provides some value to the end user, and there are also several other OSS projects that would like that exposure. (Exact wording is of course up for discussion) Does this fulfill your wish for a link/blurb? Thanks for hearing me out, -- Tony Caduto AM Software Design Home

Re: [GENERAL] Does this look ethical to you?

Doing something like that in no way could hurt pgAdmin III, since there is nothing to hurt(it's free after all). I think we have beat this into the ground, lets drop it now. I think everyone is or will be happy :-) -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postg

Re: [GENERAL] Seeking a better PL/pgSQL editor-debugger

opic.php?t=83 As far as I know this affects 8.0 and 8.1, I am sure someone will correct me if I am wrong :-) Hope this helps, -- Tony Caduto http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql 8.x Ken Winter wrote: Is a better PL/pgSQL editor / debugger than pgAd

Re: [GENERAL] Seeking a better PL/pgSQL editor-debugger

That is true in 8.0 but not anymore in 8.1. The reason we invented the "pg_pltemplate" catalog is to ensure that old dumps of PL language definitions will track desired changes without such manual heroics ... Tom, Thanks for the info, I will update my article to reflect that

Re: [GENERAL] [HACKERS] New project launched : PostgreSQL GUI Installer for

. Later, -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

[GENERAL] question about MAKE_EXPIRED_TUPLES_VISIBLE

I saw some where that if I recompiled my server with MAKE_EXPIRED_TUPLES_VISIBLE I would be able to see deleted rows? I did a ./configure --enable-MAKE_EXPIRED_TUPLES_VISIBLE It compiled ok but I dont see the deleted tuples ---(end of broadcast)---

Re: [GENERAL] question about MAKE_EXPIRED_TUPLES_VISIBLE

Tom Lane wrote: Tony Caduto <[EMAIL PROTECTED]> writes: I saw some where that if I recompiled my server with MAKE_EXPIRED_TUPLES_VISIBLE I would be able to see deleted rows? If you aren't a certified wizard you do NOT want to turn that on, because it will very probably he

[GENERAL] Any way to extract records from the WAL?

Hi, I accidently deleted 2600 records. They are not super important but I would like to get them back. I copied the WAL file the deletes are in and I can see the text and dates from the records, they are all there. Is there a way to just extract the records without going through the whole

Re: [GENERAL] question about MAKE_EXPIRED_TUPLES_VISIBLE

Stephan Szabo wrote: I think something like CFLAGS="-D MAKE_EXPIRED_TUPLES_VISIBLE" ./configure would be the way to get it. Thanks, I worked like a charm once I knew it was a CFLAG. I did the dump as plain text insert statements, verified the deleted records where there, then restored in

Re: [GENERAL] Tool

I am developing a database which needs testing prior to developing the host program. I am looking for an easy-to-learn tool. I want to develop an interface that I can use to enter and display information in a similar fashion to how a user would operate the database. A GUI tool would be

Re: [GENERAL] Why does an ON SELECT rule have to be named "_RETURN"?

ble view in any application I have ever created (thin or fat client). Maybe you just need to look at alternative application designs that don't need a updatable view. Thanks, -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com --

Re: [GENERAL] Why does an ON SELECT rule have to be named "_RETURN"?

Ken Winter wrote: Stephan ~ You're right: This thing I call a "view-table" would behave *exactly* like a view that has insert, update, and delete rules. The *only* difference I'm trying to achieve is to get it stored in pg_catalog.pg_class with relkind = 'r' ("ordinary table") rather than '

Re: [GENERAL] return setof and Temp tables

d any let me know and I can send you a example. -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an approp

[GENERAL] Postgresql win32 vs MySql win32

I have been playing around with Mysql in order to add support for it to PG Lightning Admin and I crashed the Mysql win32 5.0 version 5 times in 10 minutes just executing some basic SQL show commands. Postgresql win32 is FAR more stable than MySQL win32 and much easier to install. Just thought

Re: [GENERAL] win cmd line query tool

install it seperate from the server and call it from batch files etc, or if you need something more specialized you could create a console application with C,Delphi,C#,VB.net etc. Thanks, -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftware

[GENERAL] Special offer with a possible dontation to the project

. Thanks, Tony Caduto AM Software Design ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Special offer with a possible dontation to the project

Sorry, First day of spring for this promotion = March 21st ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support.

You could easily create a console application with Lazarus or Delphi to do this, the console app could read the script from params, standard input, or a text file and execute it against the server of your choice using ODBC or a native interface to libpq. Tony ---(end

Re: [GENERAL] Perspective: PostgreSQL usage boon after release of

#x27;t have any within sight.. the perspective buyer just moves on without saying anything. I have converted databases from other DBs such as MS SQL server and never had a problem with string escaping, can you please post a example of what you mean? Do you mean inside of functions? --

Re: [GENERAL] Wisconsin Circuit Court Access (WCCA) on PostgreSQL

Kevin Grittner wrote: Overall, PostgreSQL has been faster than the commercial product from which we converted. Kevin, Are you allowed to say what commercial product you converted from? Thanks, Tony Caduto AM Software Design Milwaukee WI http://www.amsoftwaredesign.com

Re: [GENERAL] Wisconsin Circuit Court Access (WCCA) on

Wes wrote: Hmm.. What vendor throws such a clause into all their licensing agreements. Sounds suspiciously like Microsoft... I'm not a lawyer, but I believe things such as what vendors a government entity is using is required by law to be public information. Wes I think we can safely as

Re: [GENERAL] PostgreSQL Free Visual Manager

I'm looking for a free or open source PostgreSQL visual manager (Linux or Windows). My aim is to quickly create and manage databases. The ability to export DB schema to file will be really useful for me. It's not free, but you can get PG Lightning Admin right now for 5 dollars and 1 dollar

[GENERAL] Only 6 days left to get PGLA for 5 dollars (promtion has been adjusted to 100 units)

sale, it just will not be very significant :-( Thanks to everyone who did take advantage of this sale. -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com ---(end of broadcast)--- TIP

[GENERAL] will slony work for this ?

I have two Postgresql 8.1 servers each one is in a DMZ and each one has a apache server running on it. What I want to do is have real time 2 way replication between the two databases so I can use DNS fail over, i.e when the primary goes down the secondary would take over. Then when the primary

Re: [GENERAL] About index for temporay table in a plpgsql function

Emi Lu wrote: The temporary table will be dropped automatically at the end of the function, right? A temp table will be dropped at the end of the connection. You can reuse it by adding ON COMMIT DELETE ROWS and then check if it exists in your function with this other function: http://www

[GENERAL] question about pg_hba.conf

Does anyone know if the server would have problems reading pg_hba.conf if the number of spaces where changed between fields or tabs where added? thanks, Tony ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your des

Re: [GENERAL] Advantages of PostgreSQL over MySQL 5.0

t servers etc etc. Mysql also does not seem to have system tables that are accessible to the developer, you have to use their information schema or the odd SHOW syntax which is not flexible at all. Tony Caduto http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql

[GENERAL] question about the admin contrib module and binary RPMs

Hi, I just updated my CentOS box to Postgresql 8.1.3 and installed the contrib rpm and I can't find the admin81 stuff anywhere. My question is how come this is not included in the RPM based binary distrubution? I don't have a source based install of PG anywhere nor do the servers have the compi

Re: [GENERAL] question about the admin contrib module and binary

Devrim GUNDUZ wrote: Admin81 stuff is not a part of PostgreSQL RPMs -- it is a part of pgadmin3 project. gards, Hi, I understand it was created by the pgAdmin project, but don't you think it would be better to be with the rest of the contrib modules? I and many others don't want to insta

Re: [GENERAL] question about the admin contrib module and binary

As far as I can tell there is no admin813 contrib module... I am looking at my 8.1.3 source install and there is no contrib module named that??? If the pgAdmin folks would like to submit it to PostgreSQL contrib that is a different argument. Joshua D. Drake Hi Joshua, You are correct,

Re: [GENERAL] question about the admin contrib module and binary

Which is one very good reason why it should be a separate RPM, no? If it were in the contrib RPM then you could not install that RPM *at all* on a machine that didn't have all of pgadmin's dependencies. I don't know offhand what its dependencies are, but I'd imagine they include a fair number

Re: [GENERAL] question about the admin contrib module and binary

Dave Page wrote: Well in fairness to Tony we do refer to it as a 'contrib' module, but that's because it uses the contrib build system (or PGXS in SVN trunk). Devrim has said he will build it as a separate RPM - in the meantime a source tarball can be downloaded from http://www.pgadmin.org/d

Re: [GENERAL] pgadmin

port 5432? You need to edit the postgresql.conf and set it to allow all connections by changing localhost to * , then you need to edit the pg_hba.conf file and allow access from all hosts or specific hosts. both of these files can be found in the postgresql data directory. Hope this he

[GENERAL] ACL question

Hi, I might have missed it in the docs, but is there a way for the non super user owner of a db to reset a objects ACL to default? I have been able to do it for users using the super user account by setting the objects acl entry to null. Thanks, Tony ---(end of br

Re: [GENERAL] Connecting

t host or you can allow whole subnets access. These files are located(at least on my PC :-) :C:\Program Files\PostgreSQL\8.1\data Hope this helps, Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet

Re: [GENERAL] Postgresql string parsing

vided delimiter which could be a EOL marker. Then use a loop to iterate through the array and insert into your table. Just a quick idea :-) || -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Administr

Re: [GENERAL] pgsql continuing network issues

ver had problems. 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 broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1

on upgrading before I put the database > into production. Hi Margaret, Tom means that Redhat won't provide a update for Postgresql, that does not mean you can't install it yourself. I run RedHat EL 4.3(Postgresql is at 7.4.x on EL 4.3) at work and I run 8.1 on it, I just installed it myse

Re: [GENERAL] Running Command Line From Trigger?

Yudie Pg wrote: I'm running postgresql 7.4.1. is it can't really be used for trigger function? http://www.postgresql.org/docs/7.4/static/plperl-missing.html That is true, but you can call a plperl function from a plpgsql trigger function. Wouldn't that

Re: [GENERAL] More PostgreSQL conversion fun

docs: http://www.postgresql.org/docs/8.1/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING After you have cleaned up the bad dates, then change the column to a date type. Note: I have not tested this, but I think it should work :-) Later, -- Tony Caduto AM Software Design Home of PG

Re: [GENERAL] the integer type

ccept double precision in it's type selection combobox. 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)---

Re: [GENERAL] the integer type

w field in the table editor. The whole point here is people coming from systems such as MS SQL server for example have no clue what int4 or float8 is. -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Admi

Re: [GENERAL] the integer type

example) it (pgAdmin) really starts to lose it's luster. I admit my views on this subject are biased though :-) -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Administration --

Re: [GENERAL] the integer type

Yes, PG Lightning Admin uses the format_type function, though I modify some of the returned pretty names. I change "character varying" back to varchar etc. -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your bes

[GENERAL] Having problems with a 25 million row table on 8.1.3

Hi, I have a client who has a 25 million row table that is used to keep track of financial security info. So far it has worked great, but today someone wanted to get all the tax codes(there are lot's of dupes) from the table. So we tried this: select DISTINCT tax_code from warehouse.sec_trans

[GENERAL] Question about postgresql.conf memory settings

Hi, I am a little confused on some of the memory setting in the postgresql.conf for example: maintenance_work_mem = 32768# min 1024, size in KB is the 32768 bytes or KB The comment says size is in KB, so I would assume this is actually 32768 * 1024 or is it really 32k? If it is 32k sho

Re: [GENERAL] Syntax problem for a newbie

ax for the substring function, see: http://www.postgresql.org/docs/8.1/static/functions-string.html 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

Re: [GENERAL] Debugging SQL queries

lane Hi Tom, I guess I didn't know there was a error-position field returned, I have been parsing out the "at character xx" to get the char number. Do you know offhand if there is the error-position field is discussed in the docs anywhere? Thanks, -- Tony Caduto AM Sof

Re: [GENERAL] Debugging SQL queries

Tom Lane wrote: We have actually removed the "at character N" bit from the default message format in CVS Tom, What will the error format be for 8.2? Since the char number has been removed, what will it show? Line number? Thanks, -- Tony Caduto AM Software D

Re: [GENERAL] GUI Interface

forum and a Mantis bug tracking system that you can check out(all powered by Postgresql of course). We make it a point to take customer requests and bug fixes very seriously which you can see by browsing the forums and the bug tracking system. Hope this helps you out. Tony Caduto AM Software

Re: [GENERAL] GUI Interface

e way PGLA actually works OK with the latest version of WINE so it can run on Linux, just not natively. I like many people dual boot Linux and I can tell you I spend most of my time in win32 because applications I need don't exist for Linux. Later, -- Tony Caduto AM Software D

Re: [GENERAL] GUI Interface

ck or right click to edit, then and only then is the object data brought back and displayed. When Lazarus(http://www.lazarus.freepascal.org/) becomes more stable I will create a port of PGLA that will run on Linux and Mac OS X. -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com H

Re: [GENERAL] GUI Interface

role for now is on the server not the desktop. You do realize that the original poster said he was running on Windows, so why in the heck would he run a Linux Desktop? Enough said... -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgres

Re: [GENERAL] GUI Interface

ecause you don't know what you are missing. 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 9: In ver

Re: [GENERAL] GUI Interface

very fast. It only slows down a bit when you save the function back to the server and it's not that much. Downloads on cable and DSL are fast, it's only the uploads where you see any kind of slowdown. In this day and age the load as you need it works much better overall. Later, --

Re: [GENERAL] GUI Interface

esktop they are accessing it from. It would be interesting to see what the numbers really are, maybe someone should put up a survey and put a link to it from the main Postgresql site. Later, -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresq

Re: [GENERAL] GUI Interface

s separate from the Enterprise Manager and much nicer to work with. 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)--

Re: [GENERAL] GUI Interface

Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Caduto Sent: 12 May 2006 17:08 To: Joshua D. Drake; pgsql-general@postgresql.org Subject: Re: [GENERAL] GUI Interface It would be interesting to see what the numbers really are

Re: [GENERAL] GUI Interface

Tino Wildenhain wrote: Tony Caduto wrote: Dave Page wrote: Only runs on Windows though doesn't it? Regards, Dave Hardly a limitation since Linux and other Unix based operating systems account for a trivial percent of the desktop market. I would guess that more re

Re: [GENERAL] GUI Interface

e: I don't think I every specifically mentioned "Enterprise Manager" I always said MS SQL DBAs not really mentioning what program they primarily used. You are right pgAdmnin III is better than it was 2 years ago, I will give you that :-) Later, -- Tony

Re: [GENERAL] GUI Interface

many many people accessed Postgresql from windows, I know I did. Also a lot of people think what they think from this mailing list and I can tell you there are many many causual users who have never used this list -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Ligh

Re: [GENERAL] GUI Interface

break this to you but the developers should not even be considered in all this as they are the very smallest subset of users. -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Administration

Re: [GENERAL] GUI Interface

Uhmmm your market *IS* developers ;)... You don't actually think my mom needs your product do you? Joshua D. Drake Sorry, I meant Postgresql developers :-) I figured you would have figured that out since you where talking about Tom :-) -- Tony Caduto AM Software Design

Re: [GENERAL] GUI Interface

LimeWire, while it works well, it takes forever to load and the UI seems a little sluggish compared to a native compiled application. -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Administration

Re: [GENERAL] GUI Interface

Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Caduto Sent: 12 May 2006 20:41 To: Jim Wilson Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] GUI Interface Jim Wilson wrote: Those Windows developer tools must

Re: [GENERAL] GUI Interface

hat is so buggy it's not funny. Oh there is also Lazarus and that is also pretty nice, but can be unstable. -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Administration

Re: [GENERAL] GUI Interface

true RAD solutions. -- 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

[GENERAL] PG_DIAG_STATEMENT_POSITION Where is it defined?

I have been searching through the cvs web browser for about 1/2 hour and can't find where PG_DIAG_STATEMENT_POSITION is defined. I need to know the integer value of the constant(pascal talk)/Symbol (c talk) so I can add it to my Delphi client library. Thanks in advance -- Tony -

Re: [GENERAL] PG_DIAG_STATEMENT_POSITION Where is it defined?

Martijn van Oosterhout wrote: src/include/postgres_ext.h I did use grep but I am confused by what it showed, according to the docs: http://www.postgresql.org/docs/8.1/static/libpq-exec.html it should be a integer not 'P' Those symbols are used by PQresultErrorField which expects a integ

Re: [GENERAL] PG_DIAG_STATEMENT_POSITION Where is it defined?

Tony Caduto wrote: Martijn van Oosterhout wrote: src/include/postgres_ext.h I did use grep but I am confused by what it showed, according to the docs: http://www.postgresql.org/docs/8.1/static/libpq-exec.html it should be a integer not 'P' Those symbols are used by PQresult

Re: [GENERAL] Interface

sue taken care of internally. I have never had this problem with either Zeos or PostgresDAC. 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

[GENERAL] pg_depend question

Hi, I am working on a dependency/referenced by viewer and given a query like so: select refobjid from pg_depend where objid = 91640 how do I determine what refobjid is? is there a function or something I have missed or do I just run brute force queries against the system tables? Thanks in adv

[GENERAL] Is it a big deal to change the user the DB runs under?

Just wondering if anyone has done this: Change the user the DB runs under from postgres to apache on a established server? I would think I would just change ownership on all the data dir files and modify the startup script in /etc/init.d/postgresql. Reason is I need a plperlu procedure to gene

Re: [GENERAL] Import Data from MS SQL Server

else you need to do right from PGLA, no need for anything else. Check it out here: http://www.amsoftwaredesign.com/lightning_admin.php -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Administr

[GENERAL] PG Lightning Admin and Linux

WINE will be in build 1053 which should be available tonight. My test PC is a older AMD Athlon XP 1800+ and PGLA was very responsive and very usable, while not as fast as running natively on Windows, it is very very usable. Comments are welcome :-) No flames though :-) -- Tony Caduto AM Sof

[GENERAL] Access for Postgresql?

Or pretty similar, check it out http://www.glom.org/wiki/index.php?title=Main_Page -- 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] how to test my stored procedures?

myproc(); You can then see the results. -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] How to install PL/perlU (perl untrusted)

me on win32, except creatlang may not be in the path, so you should actually be in the bin dir when you run it or use the full path name. Hope this helps, -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postg

Re: [GENERAL] (no subject)

ction like this: select * from sybase_get2() not need to us AS See the examples on this page on how to use a type with a plperl function: http://www.commandprompt.com/community/pgdocs81/plperl-database -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin

<    1   2   3   4   5   >