Re: [GENERAL] time penalties on triggers?

2007-10-05 Thread Kenneth Downs
into play as overhead in firing the trigger. -- Kenneth Downs Secure Data Software, Inc. www.secdat.comwww.andromeda-project.org 631-689-7200 Fax: 631-689-0527 cell: 631-379-0010 ---(end of broadcast)--- TIP 3: Have you checked our extensive

Re: [GENERAL] a provocative question?

2007-09-06 Thread Kenneth Downs
' the postmaster -- Kenneth Downs Secure Data Software, Inc. www.secdat.comwww.andromeda-project.org 631-689-7200 Fax: 631-689-0527 cell: 631-379-0010

Re: [GENERAL] Writing most code in Stored Procedures

2007-08-17 Thread Kenneth Downs
. -- Kenneth Downs Secure Data Software, Inc. www.secdat.comwww.andromeda-project.org 631-689-7200 Fax: 631-689-0527 cell: 631-379-0010 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] MVCC cons

2007-08-14 Thread Kenneth Downs
derived information in columns, so my tables are more fat to begin with, and so this hits me harder. -- Kenneth Downs Secure Data Software, Inc. www.secdat.comwww.andromeda-project.org 631-689-7200 Fax: 631-689-0527 cell: 631-379-0010 ---(end of broadcast

Re: [GENERAL] MVCC cons

2007-08-14 Thread Kenneth Downs
Tom Lane wrote: Kenneth Downs [EMAIL PROTECTED] writes: Speaking as an end-user, I can give only one I've ever seen, which is performance. Because of MVCC, Postgres's write performance (insert and update) appears on my systems to be almost exactly linear to row size. Inserting 1000 rows

[GENERAL] Interesting abilities of substring

2007-08-09 Thread Kenneth Downs
significantly simpler... That's all, now back to our regularly scheduled mailing list. -- Kenneth Downs Secure Data Software, Inc. www.secdat.comwww.andromeda-project.org 631-689-7200 Fax: 631-689-0527 cell: 631-379-0010 ---(end of broadcast

Re: [GENERAL] Interesting abilities of substring

2007-08-09 Thread Kenneth Downs
within the threshhold of the human attention span of .5 second or so. Naz Gassiep wrote: This may be useful to me and others, care to paste an example of what you mean? Thanks, - Naz. Kenneth Downs wrote: Here is something cool that I did not realize postgres's substring() could do. Basically

Re: [GENERAL] Interesting abilities of substring

2007-08-09 Thread Kenneth Downs
Tom Lane wrote: Kenneth Downs [EMAIL PROTECTED] writes: Basically, it knows what you mean when you do substrings on dates and numbers, doing an implicit cast for you. Implicit casts to text are evil, and are mostly going to be gone in 8.3. So try not to rely on this behavior

Re: [GENERAL] Linux distro

2007-08-01 Thread Kenneth Downs
---(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 not match -- Kenneth Downs Secure Data Software, Inc. www.secdat.comwww.andromeda

Re: [GENERAL] Retrieve the record ID

2007-07-20 Thread Kenneth Downs
)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq -- Kenneth Downs Secure Data Software, Inc. www.secdat.comwww.andromeda-project.org 631-689-7200 Fax: 631-689-0527 cell: 631-379-0010 ---(end of broadcast

Re: [GENERAL] How to prevent modifications in a tree of rows, based on a condition?

2007-06-19 Thread Kenneth Downs
an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Kenneth Downs Secure Data Software, Inc. www.secdat.comwww.andromeda-project.org 631-689-7200 Fax: 631-689-0527 cell: 631-379-0010

Re: [GENERAL] PGSQL development tools. Any advice?

2007-06-12 Thread Kenneth Downs
. Is there advice for a better tool to be run under Linux/KDE? MTIA! -- Kenneth Downs Secure Data Software, Inc. www.secdat.comwww.andromeda-project.org 631-689-7200 Fax: 631-689-0527 cell: 631-379-0010 ---(end of broadcast)--- TIP 3: Have you

Re: [GENERAL] SQL Manager 2007 for PostgreSQL released

2007-05-29 Thread Kenneth Downs
administration and development tool! I'd be happy to use EMS products, but I really need Linux versions. Any plans regarding *nix platforms support? Ditto, when will we see the *nix versions? -- Kenneth Downs Secure Data Software, Inc. www.secdat.comwww.andromeda-project.org 631-689-7200 Fax

Re: [GENERAL] Paypal and going root

2007-05-18 Thread Kenneth Downs
Dave Page wrote: Kenneth Downs wrote: The last one left that I have is the sticky issue of a paypal IPN transaction coming in. I believe it applies generally to financial transactions. The user is sent by our application to the Paypal site. When they pay, paypal sends a POST with various

Re: [GENERAL] Paypal and going root

2007-05-18 Thread Kenneth Downs
Richard Huxton wrote: Kenneth Downs wrote: Richard Huxton wrote: Kenneth Downs wrote: The last one left that I have is the sticky issue of a paypal IPN transaction coming in. I believe it applies generally to financial transactions. The user is sent by our application to the Paypal site

Re: [GENERAL] Paypal and going root

2007-05-18 Thread Kenneth Downs
Richard Huxton wrote: Kenneth Downs wrote: The last one left that I have is the sticky issue of a paypal IPN transaction coming in. I believe it applies generally to financial transactions. The user is sent by our application to the Paypal site. When they pay, paypal sends a POST

[GENERAL] Paypal and going root

2007-05-17 Thread Kenneth Downs
that idea of running anonymously and committing financial data. In this case it seems creating a stored procedure will not automatically help, as then we just execute the SP anonymously, and it strikes me as no different. Has anybody pondered this and come up with anything? -- Kenneth Downs

Re: [GENERAL] plperl functions not re-entrant?

2007-04-26 Thread Kenneth Downs
Martijn van Oosterhout wrote: On Wed, Mar 14, 2007 at 08:09:24PM -0400, Kenneth Downs wrote: What I have noticed is that once the innermost instance exits, none of the outer instances execute any further, suggesting that the plperl routine is not re-entrant (if I am using that term

Re: [GENERAL] Postgres data/form entry tool

2007-04-19 Thread Kenneth Downs
opensource data entry tool that can be used to make some simple forms for entering data in to postgres? ---(end of broadcast)--- TIP 6: explain analyze is your friend -- Kenneth Downs Secure Data Software, Inc. www.secdat.comwww.andromeda

Re: [GENERAL] Auditing a database

2007-04-19 Thread Kenneth Downs
it is simpler to follow the trace of updates. What you suggest? Regards, -- Kenneth Downs Secure Data Software, Inc. www.secdat.comwww.andromeda-project.org 631-379-7200 Fax: 631-689-0527 ---(end of broadcast)--- TIP 2: Don't 'kill -9

[GENERAL] Cron'd dumpall failing?

2007-04-05 Thread Kenneth Downs
I truly hoping I'm missing something silly here. I've got a cron job to run a dumpall each early am. It fails, and I get a handful of emails. The first reads like this: pg_dump: [archiver (db)] connection to database adocs failed: FATAL: sorry, too many clients already pg_dumpall: pg_dump

Re: [GENERAL] cutting out the middleperl

2007-03-27 Thread Kenneth Downs
Kev, we have a GPL'd product targeting Postgres that has significant overlap with what you want, though in other areas we went in another direction. The site is www.andromeda-project.org, and I've put some comments below: Kev wrote: Hi everyone, I'm still in the design phase of a project.

Re: [GENERAL] cutting out the middleperl

2007-03-27 Thread Kenneth Downs
Randal L. Schwartz wrote: Kenneth == Kenneth Downs [EMAIL PROTECTED] writes: Kenneth This in effect makes the web server a proxy to the database, which Kenneth sounds like what you are after. The P portion for us is PHP, not Kenneth Perl, and it is small though non-zero. It has

Re: [GENERAL] cutting out the middleperl

2007-03-27 Thread Kenneth Downs
Merlin Moncure wrote: On 3/27/07, Randal L. Schwartz merlyn@stonehenge.com wrote: Kenneth == Kenneth Downs [EMAIL PROTECTED] writes: Kenneth This in effect makes the web server a proxy to the database, which Kenneth sounds like what you are after. The P portion for us is PHP, not Kenneth

Re: [GENERAL] plperl function called once in cascading triggers

2007-03-15 Thread Kenneth Downs
Martijn van Oosterhout wrote: On Wed, Mar 14, 2007 at 08:09:24PM -0400, Kenneth Downs wrote: What I have noticed is that once the innermost instance exits, none of the outer instances execute any further, suggesting that the plperl routine is not re-entrant (if I am using that term

[GENERAL] Debugging Server Code

2007-03-14 Thread Kenneth Downs
I'm guessing that there is no step-wise debugger for pgsql. If there is, then glory be and call me a dummy for not R'ing TFM. In fact, I've never heard of a step-wise debugger for any DB server, am I wrong? As I grovel through some plPerl code in a statement level trigger that depends on

[GENERAL] plperl function called once in cascading triggers

2007-03-14 Thread Kenneth Downs
Consider the case where an AFTER STATEMENT trigger calls a plperl function which performs a loop. Inside of the loop it updates at least one other table. The table being updated has an AFTER STATEMENT trigger that calls the same plperl function (w/different parms of course), which goes into

Re: HIPPA (was Re: [GENERAL] Anyone know ...)

2007-03-10 Thread Kenneth Downs
Tom Lane wrote: Kenneth Downs [EMAIL PROTECTED] writes: The biggest security limitation we have is actually a weakness in Postgres - the inability to restrict the abilities of a user with CREATUSER rights, they can make somebody who can do anything. For higher security this requires

Re: HIPPA (was Re: [GENERAL] Anyone know ...)

2007-03-10 Thread Kenneth Downs
Awesome! That never occurred to me. This is really cool. Tom Lane wrote: Kenneth Downs [EMAIL PROTECTED] writes: Perhaps a lesser form of CREATEROLE, CREATEROLE_LIMITED, who can create roles and only grant to the roles he himself is a member of. You can make that out of spare parts

Re: HIPPA (was Re: [GENERAL] Anyone know ...)

2007-03-10 Thread Kenneth Downs
Alvaro Herrera wrote: David Legault escribió: That's basically what I've done with my past questions on the ROLE system in place. Since roles are global, I wanted it fine grained to the DB level so I had to append DB_ in front of each role name and by using current_database() inside my

Re: HIPPA (was Re: [GENERAL] Anyone know ...)

2007-03-09 Thread Kenneth Downs
Ron Johnson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/08/07 20:38, Kenneth Downs wrote: [snip] Management and we are about to add the CRM to it so that the scheduling/billing database also serves the doctor's public website, Is that wise? One bug and a cracker

Re: HIPPA (was Re: [GENERAL] Anyone know ...)

2007-03-09 Thread Kenneth Downs
Karsten Hilbert wrote: On Fri, Mar 09, 2007 at 08:08:11AM -0500, Kenneth Downs wrote: First, security is defined directly in terms of tables, it is not arbitrated by code. The public group has SELECT access to the articles table and the schedules tables, that's it. If a person figures

Re: HIPPA (was Re: [GENERAL] Anyone know ...)

2007-03-09 Thread Kenneth Downs
Karsten Hilbert wrote: If the user figures out our URL scheme, they might try something like ?gp_page=patients and say Wow I'm clever I'm going to look at the patients table, except that the public user has no privilege on the table. The db server will throw a permission denied error.

Re: HIPPA (was Re: [GENERAL] Anyone know ...)

2007-03-09 Thread Kenneth Downs
Ron Johnson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/09/07 10:02, Kenneth Downs wrote: Karsten Hilbert wrote: On Fri, Mar 09, 2007 at 08:08:11AM -0500, Kenneth Downs wrote: First, security is defined directly in terms of tables, it is not arbitrated

Re: HIPPA (was Re: [GENERAL] Anyone know ...)

2007-03-09 Thread Kenneth Downs
Kevin Hunter wrote: If a user has not logged in, that is, if they are an anonymous visitor, the web framework will connect to the database as the default public user. Our system is deny-by-default, so this user cannot actually read from any table unless specifically granted permission. In

Re: HIPPA (was Re: [GENERAL] Anyone know ...)

2007-03-09 Thread Kenneth Downs
Bill Moran wrote: If a user has not logged in, that is, if they are an anonymous visitor, the web framework will connect to the database as the default public user. Our system is deny-by-default, so this user cannot actually read from any table unless specifically granted permission. In the

Re: HIPPA (was Re: [GENERAL] Anyone know ...)

2007-03-09 Thread Kenneth Downs
Kevin Hunter wrote: What about an SQL injection bug that allows for increased privileges? Um, web programming 101 is that you escape quotes on user-supplied inputs. That ends SQL injection. Pardon my naivete (I'm fairly new to web/DB programming) . . . is this the current standard method

Re: [GENERAL] Anyone know a good opensource CRM that actually installs with Posgtres?

2007-03-08 Thread Kenneth Downs
Bradley Kieser wrote: I hope that someone has cracked this one because I have run into a brick wall the entire week and after 3 all-nighters with bad installations, I would appreciate hearing from others! I am looking for a decent OpenSource CRM system that will run with Postgres. SugarCRM

Re: [GENERAL] RFC tool to support development / operations work with slony replicated databases

2007-03-06 Thread Kenneth Downs
a database to its current state? If your scripts contain data modification code, they can be preserved, but using a dictionary smooths over a lot of the quirkiness of the scripts-based approach. -- Kenneth Downs Secure Data Software, Inc. www.secdat.com / www.andromeda-project.org Office: 631

Re: [GENERAL] M:M table conditional delete for parents

2007-03-06 Thread Kenneth Downs
) between all pairs of tables, and then having a view that UNIONs them together? This way you don't have to re-invent the foreign key to get it all working. -- Kenneth Downs Secure Data Software, Inc. www.secdat.com / www.andromeda-project.org Office: 631-689-7200 Cell: 631-379-0010 ::Think

Re: [GENERAL] usage for 'with recursive'?

2007-03-05 Thread Kenneth Downs
hubert depesz lubaczewski wrote: On 3/2/07, Kenneth Downs [EMAIL PROTECTED] wrote: This reminds me of another advantage of the WITH RECURSIVE, which is that it pushes to overhead to SELECT, with no associated write-time overheads. hmm .. why do you consider this as advantage? i would say it's

Re: [GENERAL] usage for 'with recursive'?

2007-03-02 Thread Kenneth Downs
hubert depesz lubaczewski wrote: On 3/1/07, Kenneth Downs [EMAIL PROTECTED] wrote: Better? I think perhaps different. There is materialized path, which requires a very problematic unlimited-length column to hold the path, and there is upper/lower bounds, which again requires client-side row

Re: [GENERAL] Custom session variables?

2007-03-02 Thread Kenneth Downs
Adam Rich wrote: Is there any way to define custom variables per session scope? In oracle, we do this using package variables. This would be so cool to have. -- Kenneth Downs Secure Data Software, Inc. www.secdat.com / www.andromeda-project.org Office: 631-689-7200 Cell: 631-379-0010

Re: [GENERAL] usage for 'with recursive'?

2007-03-01 Thread Kenneth Downs
affects another row, unlike the other two. If we could query out a list using WITH RECURSE it would become very powerful. best regards, depesz -- Kenneth Downs Secure Data Software, Inc. www.secdat.com / www.andromeda-project.org Office: 631-689-7200 Cell: 631-379-0010 ::Think you

Re: [GENERAL] General Ledger db design

2007-02-26 Thread Kenneth Downs
Karl O. Pinc wrote: On 02/25/2007 06:21:45 PM, Kenneth Downs wrote: Martin Winsler wrote: This is a real world situation where referential integrity needs to be broken in theory, I believe. Does anybody have any experience or knowledge of building financial accounting databases? Am I

Re: [GENERAL] General Ledger db design

2007-02-26 Thread Kenneth Downs
it is already closed, which as a bonus prevents new rows being added, and Distributing (as we call it) the close flag to the transaction rows when the batch closes. Karl [EMAIL PROTECTED] Free Software: You don't pay back, you pay forward. -- Robert A. Heinlein -- Kenneth

Re: [GENERAL] Best way to store and retrieve photo from PostGreSQL

2007-02-25 Thread Kenneth Downs
be reduced to: 1) Load into tables for transactional support, con is the write-time hit 2) Load into filesystem for faster load, but you have to provide integrity by another route -- Kenneth Downs Secure Data Software, Inc. www.secdat.com / www.andromeda-project.org Office: 631-689-7200 Cell

Re: [GENERAL] General Ledger db design

2007-02-25 Thread Kenneth Downs
for checks received, checks paid, etc, all of them have different batch types. In short, the problem of too many parents is inverted to produce many children instead, and the problem goes away. -- Kenneth Downs Secure Data Software, Inc. www.secdat.com / www.andromeda-project.org Office

Re: [GENERAL] ROLE INHERIT

2007-02-16 Thread Kenneth Downs
Tom Lane wrote: Kenneth Downs [EMAIL PROTECTED] writes: Except for the hole. On a public site that lets users register, we have to have way to let the web server assume the role of somebody who has createuser privelege, and that's pretty much the end of the no-root policy. If an exploit

Re: [GENERAL] ROLE INHERIT

2007-02-15 Thread Kenneth Downs
Tom Lane wrote: David Legault [EMAIL PROTECTED] writes: I thought it would transfer that CREATEROLE privilege too. I've been dying to get 2 cents in on this. Tell me if this suggestion makes any sense. We use real database users in our systems, we don't connect in with an

Re: [GENERAL] [ANNOUNCE] Advisory on possibly insecure security definer functions

2007-02-14 Thread Kenneth Downs
Peter Eisentraut wrote: The proper fix for this problem is to insert explicit SET search_path commands into each affected function to produce a known safe schema search path. Note that using the default search path, which includes a reference to the $user schema, is not safe when unqualified

Re: [GENERAL] Using PITR for creating Hot Standby

2007-02-13 Thread Kenneth Downs
Dhaval Shah wrote: I am in a situation where we have to deploy a hot standby to a postgres db server. There is no custom tablespace and all data files are in $PGDATA I was thinking of using PITR []http://www.postgresql.org/docs/8.1/static/backup-online.html] to achieve that and here are my

[GENERAL] Trouble w/plperl sproc on red hat 9

2007-02-10 Thread Kenneth Downs
Not sure if this one is fixable, but a user of my GPL'd package was unable to run our install. Eventually we pinned it down to a failed load of a sproc written in plperl. He says he's running a Red Hat 9 system with Postgres 8.1 and perl is 5.8.5. When he takes the plperl sproc and attempts

Re: [GENERAL] trigger for pg_authid

2007-02-09 Thread Kenneth Downs
Diego de Blas wrote: Hello, I'm trying to set a new trigger for pg_authid connected as postgres but system returns always the same error Permission denied: pg_authid is a system catalog... I have checked privileges and I can teorically add new triggers. I don't know whta's wrong... Thanks

[GENERAL] Not so much load balancing as load limits

2006-08-09 Thread Kenneth Downs
I'm having some trouble getting a google hit on this topic, and the docs aren't doing much for me. What I'm wondering is, how do I limit any particular postgres operation, in particular a long-running batch operation with lots of inserts, from bogging down a server? This is not so much a

Re: [GENERAL] Disabling and enabling constraints and triggers to

2006-08-07 Thread Kenneth Downs
Ken Winter wrote: Tom et al ~ I understand that this is all a risky business. So maybe someone can tell me a safer way to accomplish what I was trying to accomplish with pg_dump and data-only pg_restore. It's a basic bit of database administration work. I'm trying to establish two (or if

Re: [GENERAL] Best Procedural Language?

2006-08-03 Thread Kenneth Downs
Joshua D. Drake wrote: However, Alvaro is correct there are currently no resources dedicated to PL/php. There will be in the future but for now we are busy with other things. Well consider me your biggest cheerleader, and when circumstances bring it to the front burner that will be great.

Re: [GENERAL] Best Procedural Language?

2006-08-02 Thread Kenneth Downs
Christopher Browne wrote: Martha Stewart called it a Good Thing when "Carlo Stonebanks" [EMAIL PROTECTED] wrote: I am interested in finding out a "non-religious" answer to which procedural language has the richest and most robust implementation for Postgres. C is at the bottom of

Re: [GENERAL] Best Procedural Language?

2006-08-02 Thread Kenneth Downs
Carlo Stonebanks wrote: plPHP is not as mature as plTcl (or is that plTclng). However it is very well developed and maintained. Heck, companies are even holding talks and training classes on it now. What is lacking in plPHP? To be honest, even though I am a Tcl developer I

Re: [GENERAL] Best Procedural Language?

2006-08-02 Thread Kenneth Downs
Joshua D. Drake wrote: ww.commandprompt.com/community/plphp/ Last release was 2005. This is the first release that is actually useful, IMHO, because it allows SQL commands buried in the code, prior releases did not. That is actually wrong. Go here: Well I took it from your home

Re: [GENERAL] Constraint on an aggregate? (need help writing trigger,

2006-07-26 Thread Kenneth Downs
Isak Hansen wrote: Hello Isak! I was speaking to you about this on comp.databases, glad to see you here on the Postgres group. What you want to do is easy enough in the single case, but can get complicated if you do a lot of it. shameless plug We have a framework that is freely available

Re: [GENERAL] loop with circular updates

2006-07-26 Thread Kenneth Downs
Jessica M Salmon wrote: Hi All. I'm writing a plpgsql function that creates a table and loops over the items in that table, using a FOR ... IN EXECUTE ... loop. The thing is, on each iteration I update the table over which I am looping. Sometimes, the result of this update makes it no longer

Re: [GENERAL] Constraint on an aggregate? (need help writing trigger,

2006-07-26 Thread Kenneth Downs
Isak Hansen wrote: Each entry in 'A' belongs to a single 'business event'. E.g. registering a phone bill modifies your accounts payable, phone expenses and vat paid accounts. Those transactions better balance out. There's no 'A' table in the system we base ours on, you'd just have X lines with

Re: [GENERAL] sequences vs oids as primary keys

2006-07-25 Thread Kenneth Downs
craigp wrote: 1) does it make sense (and would it be possible) to make a rule which would, say, somehow write into the oid field of a tuple to be returned by lastoid? i'm assuming here that the database would not have oid's enabled. We do this in a trigger. We assign the NEXTVAL to a

Re: [GENERAL] Version/Change Management of functions?

2006-07-07 Thread Kenneth Downs
Michael Loftis wrote: OK I know this is an odd question but I'm working on an app that will rely more and more on database driven functions, and while the app's source is in SVN, and I intend for the source of the SQL scripts to also be there, I was wondering...what are people doing for

Re: [GENERAL] Version/Change Management of functions?

2006-07-07 Thread Kenneth Downs
Jorge Godoy wrote: Kenneth Downs [EMAIL PROTECTED] writes: We went for generating all server-side code out of a data dictionary. This makes for a significant change in the way change management is handled. In this scenario change management becomes the analysis of "b

Re: [GENERAL] User privileges in web database applications

2006-07-05 Thread Kenneth Downs
Antonis Christofides wrote: But I think that checking user privileges at the database level is better. I think it's simpler and more secure, and if later you also want to create nonweb apps, you won't have any more authentication/privilege headaches. Couldn't agree more. But consider this

Re: [GENERAL] Form builder?

2006-07-05 Thread Kenneth Downs
[EMAIL PROTECTED] wrote: So far, here are the candidates: Andromeda, Lazarus, and Rekall. I was probably fairly inarticulate in my first post, but none of these seem to meet my criteria for automatic generation of forms based on the database definition. Most of the above frameworks have a

Re: [GENERAL] minimizing downtime when upgrading

2006-06-23 Thread Kenneth Downs
Jim Nasby wrote: On Jun 21, 2006, at 7:42 AM, H.J. Sanders wrote: The last 15 years we also used Informix and we never, never had to unload/load the database because of an upgrade. Perhaps somebody knows how they do the trick? Do they provide a migration/upgrade utility? In the case

Re: [GENERAL] Return the primary key of a newly inserted row?

2006-06-22 Thread Kenneth Downs
John Tregea wrote: Greeting again, I am writing records to postgreSQL from an IDE called revolution. At the time I perform the INSERT command I need to retrieve the value of the serial_id column from the newly created row. We have an after-insert trigger that raises it as a notice. NOTICE

Re: [GENERAL] Return the primary key of a newly inserted row?

2006-06-22 Thread Kenneth Downs
Tim Allen wrote: using syntax along the lines of INSERT ... RETURNING ... SQL Server had a nifty feature here. You could simply toss a SELECT statement at the end of a trigger of sproc and the results would be returned. This in effect made a table the potential return type of all

Re: [GENERAL] Form builder?

2006-06-22 Thread Kenneth Downs
[EMAIL PROTECTED] wrote: We wrote a system that does exactly that, its called Andromeda, and it is GPL. http://docs.andromeda.com It uses a data dictionary to do two things: 1) build the database and 2) generate HTML maintenance forms. But it can also have multiple virtual sites going

Re: [GENERAL] Form builder?

2006-06-22 Thread Kenneth Downs
John DeSoi wrote: On Jun 22, 2006, at 7:38 AM, Kenneth Downs wrote: We wrote a system that does exactly that, its called Andromeda, and it is GPL. http://docs.andromeda.com OOPS: http://docs.secdat.com Sounds interesting but this link does not work (apparently no server

Re: [GENERAL] minimizing downtime when upgrading

2006-06-21 Thread Kenneth Downs
Richard Huxton wrote: Kenneth Downs wrote: AFAIK it has always been the case that you should expect to have to dump out your databases and reload them for version upgrades. Is anybody over at the dev team considering what an onerous burden this is? Is anyone considering doing away

Re: [GENERAL] Interface Guidance and Opinions Needed

2006-06-20 Thread Kenneth Downs
Chris Golden wrote: Hello to all, I use PHP as the web programming layer, it has a great community and support for such things as XML RPC, which may fit the bill. This is my first time posting to this forum and I am very new to PostgreSQL. I am very excited

Re: [GENERAL] minimizing downtime when upgrading

2006-06-16 Thread Kenneth Downs
snacktime wrote: Anyone have any tips for minimizing downtime when upgrading? So far we have done upgrades during scheduled downtimes. Now we are getting to the point where the time required for a standard dump/restore is just too long. What have others done when downtime is critical? The

Re: [GENERAL] PostgreSQL and Apache: authentication and authorization

2006-06-13 Thread Kenneth Downs
jqpx37 wrote: I can envision, broadly, two authentication schemes: (1) Users authenticate to Apache. (2) Users authenticate to PG. This is a little too complicated. The most accurate and precise security is obtained by having the user log in with a real postgres account, and to grant

[GENERAL] More on state variables

2006-06-13 Thread Kenneth Downs
Yesterday on this list I found out about the nifty setting custom_variable_classes='global' which allows the setting and retrieving of arbitrary values that persist across statements. I wonder if there is a way to do the same thing within the scope of a transaction? Is there a magic value

Re: [GENERAL] are there static variables in pgsql?

2006-06-12 Thread Kenneth Downs
Patrick TJ McPhee wrote: I'm not sure a static variable is the right way to achieve this, but you could use a custom_variable_class for this. Add this to your postgresql.conf: custom_variable_classes='global' Then you can set and show variables prefixed by global.: set global.success = 'true';

Re: [GENERAL] are there static variables in pgsql?

2006-06-12 Thread Kenneth Downs
Kenneth Downs wrote: OK, cancel the question, the answer is SELECT current_setting('global.val2'); This is very intriguing, but I'd like to make sure it is doing what I think it is doing. Is it tracking variables in a connection across SQL commands? If so, shouldn't this work (Assume

Re: [GENERAL] Best open source tool for database design / ERDs?

2006-06-06 Thread Kenneth Downs
[EMAIL PROTECTED] wrote: Seems like the open source data modeling tools aren't feature-rich quite yet. Disclaimer: this is probably *not* what you want, but I will throw it out for completeness. We have a non-graphical tool that builds databases out of text files that resemble CSS, such

Re: [GENERAL] Restricting access to rows?

2006-05-26 Thread Kenneth Downs
Josue E. Maldonado wrote: Benjamin Smith wrote: How can I set up a user so that Bob can update his records, without letting Bob update Jane's records? Is it possible, say with a view or some other intermediate data type? I've done something similar using a separate control table where I

Re: [GENERAL] 8.1 on gentoo

2006-05-25 Thread Kenneth Downs
Tim Allen wrote: Holger Hoffstaette wrote: On Thu, 25 May 2006 08:55:51 +0200, Sim Zacks wrote: Does anybody know when postgresql 8.1 will be considered stable on gentoo for x86? No, maybe ask in gentoo-users or -dev? Anyway just because it's not marked stable does not mean it isn't.

Re: [GENERAL] challenging constraint situation - how do I make it

2006-05-24 Thread Kenneth Downs
Alban Hertroys wrote: When encountering this problem I usually wonder why there isn't a data type that can store a timestamp and can be used to create a UNIQUE INDEX over it's values. That'd be wonderful. Well, maybe one day I'll actually have time to create one... I tried this at trigger

Re: [GENERAL] background triggers?

2006-05-24 Thread Kenneth Downs
Rafal Pietrak wrote: A plain INSERT of batch takes 5-10minutes on desktop postgresql (800MHz machine, ATA disks). When I attach trigger (*Very* simple funciton) to update the accounts, the INSERT take hours (2-4). But when I make just one single update of all accounts at the end of the batch

Re: [GENERAL] challenging constraint situation - how do I make it

2006-05-24 Thread Kenneth Downs
Alban Hertroys wrote: Kenneth Downs wrote: Alban Hertroys wrote: When encountering this problem I usually wonder why there isn't a data type that can store a timestamp and can be used to create a UNIQUE INDEX over it's values. That'd be wonderful. Well, maybe one day I'll actually have

Re: [GENERAL] background triggers?

2006-05-24 Thread Kenneth Downs
Rafal Pietrak wrote: On Wed, 2006-05-24 at 07:41 -0400, Kenneth Downs wrote: Why not have the INSERT go to an "inbox" table, a table whose only job is to receive the data for future processing. Actually, it 'sort of' works that way. Your client c

Re: [GENERAL] background triggers?

2006-05-24 Thread Kenneth Downs
to be a way on windows I would think. Kenneth Downs wrote: Rafal Pietrak wrote: A plain INSERT of batch takes 5-10minutes on desktop postgresql (800MHz machine, ATA disks). When I attach trigger (*Very* simple funciton) to update the accounts, the INSERT take hours (2-4). But when I make just one

[GENERAL] More confirmation: pgadmin3 freezeup fixed by wxgtk 2.6.3

2006-05-23 Thread Kenneth Downs
I've gotten a chance to upgrade wxGTK to 2.6.3.2. I can no longer deliberately reproduce the freezeup caused by a double-click on selected text in the query analyzer. This btw is using pgadmin3 1.2. begin:vcard fn:Kenneth Downs n:Downs;Kenneth email;internet:[EMAIL PROTECTED]

Re: [GENERAL] More confirmation: pgadmin3 freezeup fixed by wxgtk

2006-05-23 Thread Kenneth Downs
Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Kenneth Downs Sent: 23 May 2006 12:24 To: pgsql general Subject: [GENERAL] More confirmation: pgadmin3 freezeup fixed by wxgtk 2.6.3 I've gotten a chance to upgrade

Re: [GENERAL] background triggers?

2006-05-23 Thread Kenneth Downs
Rafal Pietrak wrote: So if I may re-phrase the question: is there a way to have a trigger, that, when launched, can check if it's already running in backgroung for some other INSERT, return imediately if so, but turn into background for a long-lasting job if not. Rafal, I'm wondering why

Re: [GENERAL] Announce: GPL Framework centered on Postgres

2006-05-18 Thread Kenneth Downs
Florian Weimer wrote: * Joshua D. Drake: Sounds great! But why GPL? Are you looking to sell licenses? GPL is to spread it as far and wide as possible as fast as possible. LGPL? My concern would be, I can't use this toolkit

Re: [GENERAL] Announce: GPL Framework centered on Postgres

2006-05-18 Thread Kenneth Downs
Florian Weimer wrote: * Kenneth Downs: If you seek to provide a closed source app that is built upon Andromeda, you are required to provide the source code to Andromeda itself. However, your app is not a derivative work in the strict sense because your code is not mixed

Re: [GENERAL] GUI Interface

2006-05-18 Thread Kenneth Downs
Florian G. Pflug wrote: It took me a while to find out how exactly to reproducte the hang (It would happen to me about once a day when using pgadmin3 heavily on gnome/metacity, but when trying to reproduce it, I couldn't). You have to select some text, and then _doubleclick_ on the

Re: [GENERAL] Announce: GPL Framework centered on Postgres

2006-05-17 Thread Kenneth Downs
Tom Lane wrote: Kenneth Downs [EMAIL PROTECTED] writes: If it turns out that nobody can release a closed source app, I will definitely reconsider and look again at LGPL, but I am not convinced you cannot do so. If you seek to provide a closed source app

Re: [GENERAL] Announce: GPL Framework centered on Postgres

2006-05-17 Thread Kenneth Downs
Anastasios Hatzis wrote: Kenneth Downs wrote: My company has developed an application development framework that targets PostgreSQL as its back-end, with PHP in the web layer. Is this product somehow related to AndroMDA (which is usually pronounced 'Andromeda')? http://www.andromda.org

Re: [GENERAL] best practice in upgrading db structure

2006-05-16 Thread Kenneth Downs
Csaba Nagy wrote: [leaving the original text, as it is reply to an older posting] On Fri, 2006-03-31 at 21:26, Jim Nasby wrote: On Mar 29, 2006, at 3:25 AM, Csaba Nagy wrote: Could somebody explain me, or point me to a resource where I can find out what

[GENERAL] Announce: GPL Framework centered on Postgres

2006-05-16 Thread Kenneth Downs
Hello folks, My company has developed an application development framework that targets PostgreSQL as its back-end, with PHP in the web layer. We are inviting any early adopters who may wish to experiment to download and install the code. You may contact me off-list with any support or

Re: [GENERAL] Announce: GPL Framework centered on Postgres

2006-05-16 Thread Kenneth Downs
Joshua D. Drake wrote: Kenneth Downs wrote: Hello folks, My company has developed an application development framework that targets PostgreSQL as its back-end, with PHP in the web layer. We are inviting any early adopters who may wish to experiment to download and install the code. You

[GENERAL] Is it me, or the list?

2006-05-16 Thread Kenneth Downs
I participate regularly on three mailing lists, including pgsql-general. I use thunderbird for mail. pgsql-general has the peculiar property, when I hit reply, of replying not to the list, but the individual who emailed to the list. Is this me, or is this the list? begin:vcard fn:Kenneth

  1   2   >