Re: [GENERAL] GUI Interface

2006-05-13 Thread Thomas Hallgren
Dan Armbrust wrote: You live in an interesting world... meanwhile, I'm here in the real world, using Eclipse - the best IDE I've ever used to develop java applications. Oh, wait, Eclipse is written in Java? I didn't think it was possible to write good apps in java? Certainly better than visu

Re: [GENERAL] GUI Interface

2006-05-13 Thread Dave Page
-Original Message- From: Tony Caduto [mailto:[EMAIL PROTECTED] Sent: Sat 5/13/2006 2:57 PM To: Dave Page Subject: Re: [GENERAL] GUI Interface > It's not that derogatory Dave, > All that page mentions is the weird quirks on win32, I am sure you know > what those are, i.e. windows sudde

Re: [GENERAL] GUI Interface

2006-05-13 Thread Russ Brown
On Sat, 2006-05-13 at 17:27 +0100, Dave Page wrote: > > > Why don't you just drop win32 support and leave the commercial > market > > to us proprietary coders :-) Seriously, there are now more than > enough > > commercial admin tools available to support the PG windows market. I can't find th

[GENERAL] INSERT RULE doesn't allow OLD, so how does one work with serial datatypes?

2006-05-13 Thread Karen Hill
I'm having a bit of mystery in solving a postgresql puzzle. I have a table that when it gets inserted or updated or deleted it is logged into a log table. The log table contains who (current_user) did the insert/update/delete the CURRENT_TIMESTAMP. Everything works great except the INSERT becaus

Re: [GENERAL] INSERT RULE doesn't allow OLD, so how does one work with serial datatypes?

2006-05-13 Thread Martijn van Oosterhout
On Sat, May 13, 2006 at 02:11:14PM -0700, Karen Hill wrote: > I'm having a bit of mystery in solving a postgresql puzzle. I have a > table that when it gets inserted or updated or deleted it is logged > into a log table. The log table contains who (current_user) did the > insert/update/delete the

[GENERAL] Mac Problem with Tunneling...

2006-05-13 Thread Jerry LeVan
Hi, On my linux box I can issue the command ssh -L :macjerry:5432 -l jerry macjerry This will create a "tunnel" to connect to my mac named "macjerrry". I can connect to databases on macjerry via psql by specifying port on my linux box and other postgresql front ends. How ever if I

Re: [GENERAL] Mac Problem with Tunneling...

2006-05-13 Thread Tom Lane
Jerry LeVan <[EMAIL PROTECTED]> writes: > How ever if I turn it around, and on the mac issue > the command > ssh -L :linuxbox:5432 -l jerry linuxbox > Then I am not able to connect to the linux box > via psql or any Gui front ends. [ tries it ... ] Worksforme, using the stock ssh in OS X

Re: [GENERAL] Mac Problem with Tunneling...

2006-05-13 Thread Jerry LeVan
On May 13, 2006, at 6:18 PM, Tom Lane wrote: Jerry LeVan <[EMAIL PROTECTED]> writes: How ever if I turn it around, and on the mac issue the command ssh -L :linuxbox:5432 -l jerry linuxbox Then I am not able to connect to the linux box via psql or any Gui front ends. [ tries it ... ]

Re: [GENERAL] Mac Problem with Tunneling...

2006-05-13 Thread Kris Jurka
On Sat, 13 May 2006, Jerry LeVan wrote: channel 3: open failed: administratively prohibited: open failed This is the standard error you'll see when /etc/ssh/sshd_config (or local equivalent) has AllowTcpForwarding no. Kris Jurka ---(end of broadcast)-

[GENERAL] pg_dump index/constraint creation order

2006-05-13 Thread Ed L.
While watching a 9-hour 60GB network load from 7.4.6 pg_dump into 8.1.2, I noticed the order in which indices and constraints are created appears to be their creation order. Would it make more sense to have pg_dump dump indexes grouped by the table? That way, if a table got loaded into cache f

Re: [GENERAL] rules: evaluate inputs in advance

2006-05-13 Thread Markus Schiltknecht
Hi Martijn, On Fri, 2006-05-12 at 18:05 +0200, Martijn van Oosterhout wrote: > But it can't really. In the example that started this thread, there are > two seperate rules and after rewriting the executor will be presented > two seperate queries. Ah, thank you, that explains the difficulties with