Joshua D. Drake wrote:
>
>> BTW who was the EXPERT that slammed java performance?
>
> No clue, but java sucks on the desktop :)
>
No it doesn't (unless you mean when tilting your coffee mug. Hmm, no, then you would need
something that actually sucks java).
Regards,
Thomas Hallgren
---
> -Original Message-
> From: Tony Caduto
>
> One example is LimeWire, while it works well, it takes forever to load and
Six seconds on mine.
Best regards,
Jim Wilson
--
Jim Wilson
Kelco Industries
PO Box 160
Milbridge, ME 04658
207-546-7989
---(end of broad
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> You need to read more anti-government rants. I know I ran accross "sheeple"
> at least several years ago. And since it pronounces nicely and the notion
> of people acting like sheep goes back a long way, I expect that term does
> as well.
Google is you
On Fri, May 12, 2006 at 16:29:05 -0400,
John DeSoi <[EMAIL PROTECTED]> wrote:
>
> But mainly I just want to thank the other posters for "junior sales
> sheeple from MS" and "I don't particularly like MacOSX. It seems
> entirely too Charlie and the Chocolate factory for me." Almost spewed
>
What is the return type of your function? To me it looks
CSNTExtractUserClearTextPw2 has something like "RETURNS custom_type"
whereas CSNTExtractUserClearTextPw has "RETURNS SETOF custom_type".
If you need rows (even if just 1 row), use "SETOF".
On May 10, 2006, at 11:49 AM, [EMAIL PROTECT
Glade
WxDesigner
QT (I forget the name of their forms product)
Oh and if we are sadistic: Kylix.
I hate to say it but none of the above mentioned are in the same class
as Delphi except for Kylix.
Kylix is a bear to deploy but it is still the best IDE of all the ones
you mentioned above, and
Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of John DeSoi
Sent: 12 May 2006 21:29
To: pgsql general
Cc: Scott Marlowe; Joshua D. Drake
Subject: Re: [GENERAL] GUI Interface
But mainly I just want to thank the other posters for "j
Okay, so I voted and I see Linux leads the pack 16 of 29. I return afew moments later and Linux leads the pack 13 to 24. What gives??
Didn't you read about some part of the websites working on MySQL? Why are you then surprised?tongue-in-cheek,Harald-- GHUM Harald Massapersuadere et programmare
Ha
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of John DeSoi
> Sent: 12 May 2006 21:29
> To: pgsql general
> Cc: Scott Marlowe; Joshua D. Drake
> Subject: Re: [GENERAL] GUI Interface
>
> But mainly I just want to thank the other posters for "junior
> -Original Message-
> From: Tony Caduto [mailto:[EMAIL PROTECTED]
> Sent: 12 May 2006 21:24
> To: Dave Page; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] GUI Interface
>
> Dave calm downtake a chill pill...
> who said anything about pgAdmin III? Jim was referring to
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Geoffrey
> Sent: 12 May 2006 22:18
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] GUI Interface
>
> Dave Page wrote:
>
> > http://www.postgresql.org/community/
>
> Okay, so I voted an
Dave Page wrote:
http://www.postgresql.org/community/
Okay, so I voted and I see Linux leads the pack 16 of 29. I return a
few moments later and Linux leads the pack 13 to 24. What gives??
--
Until later, Geoffrey
Any society that would give up a little liberty to gain a little
security
Tony Caduto wrote:
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.
Good for you :-) Keep on thinking that
Eclipse is nice, but after using both (eclipse and netbeans) I
Dan Armbrust wrote:
Tony Caduto wrote:
Jim Wilson wrote:
Oh, and to get back on topic a bit more - DBVisualizer is also a nice
database GUI (written in Java, by the way) that is very fast,
responsive, and cross platform.
http://www.minq.se/products/dbvis/
All due respect but I am runni
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> [EMAIL PROTECTED]
> Sent: Tuesday, May 09, 2006 1:51 AM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Google Summer of Code: Full Disjunctions
>
> > First, i have no knowledge of anyo
> -Original Message-
> From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
> Sent: 12 May 2006 21:45
> To: Dave Page
> Cc: Tony Caduto; Jim Wilson; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] GUI Interface
>
> Although it certainly isn't fair or ethical if he negatively
> impact
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 be workin
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.
Good for you :-) Keep on thinking that
Eclipse is nice, but after using both (eclipse and netbeans) I just
liked net bea
I have nothing to offer this highly entertaining thread except I'm
firmly with the camp that thinks getting Unix/Linux developers on
board is the best way to promote a PostgreSQL GUI for all platforms.
Still hoping to do that someday soon.
But mainly I just want to thank the other posters f
Tony Caduto wrote:
Jim Wilson wrote:
Those Windows developer tools must be working really well
How right you are Jim, far superior and more productive than anything
available on
Linux at this time, though the netbeans IDE comes close, to bad Java is
slow for
almost all desktop application
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Dave Page
> Sent: 12 May 2006 21:07
> To: Tony Caduto; Jim Wilson
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] GUI Interface
>
>
>
> > -Original Message-
> > From: [EMAIL P
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 b
> -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 be w
David Link <[EMAIL PROTECTED]> writes:
> Thanks for your suggestion. I'm new to the concept of packet sniffing
> and tracing. Can you suggest where I should go or what I should read to
> better understand this?
"man strace" ... strace is probably easier to use for this purpose than
a packet sn
Tom Lane wrote:
David Link <[EMAIL PROTECTED]> writes:
Does anyone know how I can test ident?
I'd try sniffing the IP traffic to and from it with a packet sniffer
and/or tracing the daemon's system calls with strace. Manually invoking
the daemon isn't going to prove a lot, you want to
Jim Wilson wrote:
Those Windows developer tools must be working really well
How right you are Jim, far superior and more productive than anything
available on
Linux at this time, though the netbeans IDE comes close, to bad Java is
slow for
almost all desktop applications.
One example is L
> -Original Message-
> From: Tony Caduto [mailto:[EMAIL PROTECTED]
> Sent: 12 May 2006 17:17
> To: Dave Page
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] GUI Interface
>
> >
> > I'm sure I can arrange an official survey on
> > http://www.postgresql.org/community/
> >
Z-z-z-z-z-z-z-z-z-z-z-z-z-z-z-z-z
Those Windows developer tools must be working really well since you have the time
to litter my inbox with all these trivial arguments. :-)
BTW who was the EXPERT that slammed java performance?
No clue, but java sucks on the desktop :)
Best regards,
Jim
Bruce Momjian wrote:
I actually use a laptop running XP. I got it for the Win32 port, and
because I use putty/ssh, Mozilla, and Gaim 99% of the time, it doesn't
matter what OS I use. I could install a unix on it, but there seems to
be no need because all my unix work is done on my server via ss
So pg_dump does not work well in 7.3.4, and I have to pg_dump or the
global equivalent to upgrade to 7.4. A bit of a catch 22 in there.
No, because you will use the 7.4 dump to dump and restore to 7.4 from
the 7.3.
For full disclosure I run a consulting company for PostgreSQL but there
a
On Fri, 2006-12-05 at 10:57 -0700, Joshua D. Drake wrote:
> Blair Lowe wrote:
> > On Fri, 2006-12-05 at 10:51 -0700, Joshua D. Drake wrote:
> user# pg_dump -n > tmp95.sql
> pg_dump: invalid option -- n
> Try 'pg_dump --help' for more information.
>
> phpbb only works with
> From: Tony Caduto
>
> Kenneth Downs wrote:
> >
> >
> > I guess it depends on your definition of trivial. Linux represents
> > 100% of the desktops at Secure Data Software. Therefore lightning
> > will be deployed in the trivial percentage of zero.
> > ---(end of broad
On Fri, May 12, 2006 at 12:00:26PM -0500, Tony Caduto wrote:
> Joshua D. Drake wrote:
> >I am not trying to be antagonistic here, but honestly curious as to
> >how you are coming to your conclusions. I have been using
> >PostgreSQL since before it was PostgreSQL and except for Internet
> >Explorer/
Scott Marlowe wrote:
> On Fri, 2006-05-12 at 11:39, Joshua D. Drake wrote:
> > > I am regularly dealing with customers, and specifically developers that
> > > are running Linux+PostgreSQL on the server... but their desktop of
> > > choice is MacOSX.
> >
> > And to follow up on this, I just saw t
Blair Lowe wrote:
On Fri, 2006-12-05 at 10:51 -0700, Joshua D. Drake wrote:
user# pg_dump -n > tmp95.sql
pg_dump: invalid option -- n
Try 'pg_dump --help' for more information.
phpbb only works with version 7.x.
Oh... if you are running 7.3 your pretty much hosed... You need to
upgrade to 7
On Fri, 2006-12-05 at 10:51 -0700, Joshua D. Drake wrote:
> >> user# pg_dump -n > tmp95.sql
> >> pg_dump: invalid option -- n
> >> Try 'pg_dump --help' for more information.
> >>
> >> phpbb only works with version 7.x.
>
>
> Oh... if you are running 7.3 your pretty much hosed... You need to
> u
user# pg_dump -n > tmp95.sql
pg_dump: invalid option -- n
Try 'pg_dump --help' for more information.
phpbb only works with version 7.x.
Oh... if you are running 7.3 your pretty much hosed... You need to
upgrade to 7.4 at a minimum.
Sincerely,
Joshua D. Drake
TTYL,
Blair.
--
This option shows up in 7.4.
On Friday 12 May 2006 10:16 am, Blair Lowe wrote:
> On Fri, 2006-12-05 at 10:08 -0700, Adrian Klaver wrote:
> > On Friday 12 May 2006 09:50 am, Blair Lowe wrote:
> > See following-
> > -n schema
> > --schema=schema
> >
> > Dump the contents of schema only. If this o
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
http://www.amsoftwa
A.M. wrote:
It would be great if by default postgres used NOTIFY after any schema
changes. Then, listening UIs could be aware of changes behind the scenes
without polling or manual refreshing.
That sounds like a huge misuse of resources.
Sincerely,
Joshua D. Drake
-M
---
Tony Caduto wrote:
Joshua D. Drake wrote:
I am regularly dealing with customers, and specifically developers
that are running Linux+PostgreSQL on the server... but their desktop
of choice is MacOSX.
And to follow up on this, I just saw that Tom Lane, Buddha guru of
PostgreSQL runs a Powerboo
On Fri, 2006-12-05 at 10:08 -0700, Adrian Klaver wrote:
> On Friday 12 May 2006 09:50 am, Blair Lowe wrote:
> See following-
> -n schema
> --schema=schema
>
> Dump the contents of schema only. If this option is not specified, all
> non-system schemas in the target database will be dumped.
>
On Friday 12 May 2006 09:50 am, Blair Lowe wrote:
See following-
-n schema
--schema=schema
Dump the contents of schema only. If this option is not specified, all
non-system schemas in the target database will be dumped.
Note: In this mode, pg_dump makes no attempt to dump any other
I am getting my conclusions from the fact that Desktop Linux is just
not popular yet, there are few if any commercial apps being written for it.
Uhh... because they are not needed :)
I run my entire business one Linux. My business is no different then any
other small business. I need:
A
Thanks Joshua,
According to the man page:
-s
--schema-only
Dump only the schema (data definitions), no data.
I need data too.
What are the command line options to get a user's schema, and a user's data?
You are confusing "The Schema" with "Schemas". It is a commo
Joshua D. Drake wrote:
I am regularly dealing with customers, and specifically developers
that are running Linux+PostgreSQL on the server... but their desktop
of choice is MacOSX.
And to follow up on this, I just saw that Tom Lane, Buddha guru of
PostgreSQL runs a Powerbook ;)
hate to brea
Joshua D. Drake wrote:
I am not trying to be antagonistic here, but honestly curious as to
how you are coming to your conclusions. I have been using PostgreSQL
since before it was PostgreSQL and except for Internet Explorer/Web
access I can tell you that most do not use Windows to manage Postgr
On Fri, 2006-05-12 at 11:39, Joshua D. Drake wrote:
> > I am regularly dealing with customers, and specifically developers that
> > are running Linux+PostgreSQL on the server... but their desktop of
> > choice is MacOSX.
>
> And to follow up on this, I just saw that Tom Lane, Buddha guru of
> P
It would be great if by default postgres used NOTIFY after any schema
changes. Then, listening UIs could be aware of changes behind the scenes
without polling or manual refreshing.
-M
---(end of broadcast)---
TIP 5: don't forget to increase your f
> I have been using it in windows to manage and manipulate a PostgreSQL
> server running in Linux with limited of success.
>
> The application is EMS PostgreSQL Manager currently $135 directly from
> their site
>
> http://www.pgsqlmanager.com/
Just to complete the list of commercial products.
On Thu, 2006-11-05 at 11:09 -0700, Joshua D. Drake wrote:
> > select relname from pg_class where oid = 17736;
> > relname
> > -
> > bbs_auth_access
> > (1 row)
> >
> > phpbb_mainlandpc=> \q
> >
> > To access this user's table, I can be logged on as anyone, and that is
>
Not a sales pitch
And it may have been offered earlier in this string
But I have enjoyed the extra bells and whistles offered
This application is not Open Source.
I have been using it in windows to manage and manipulate a PostgreSQL
server running in Linux with limited of success.
The applica
Dave Page wrote:
Interesting - you've been complaining about the way the 'Enterprise
Manager' part compares to pgAdmin up until now, not the Query Analyser.
Out of interest, what is wrong with our Query Tool? We may well have
resolved many of the issues - for example, 1.6 will have:
I don't
I am regularly dealing with customers, and specifically developers that
are running Linux+PostgreSQL on the server... but their desktop of
choice is MacOSX.
And to follow up on this, I just saw that Tom Lane, Buddha guru of
PostgreSQL runs a Powerbook ;)
I found it interesting because I
That's not exactly true :-)
The market I am going after are those that run windows on the desktop
and access Postgresql running on any server platform.
I would still argue that the vast majority of people access their
Postgresql servers from a Windows Desktop, not a Unix one.
O.k., lets sa
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 regular peop
A survey would be interesting. But I'm sure it would still point out
that Windows is king as far as percentage goes. Linux and Mac would
possibly be neck and neck, but I'm not sure about that. I'm just
guessing. I know lots of Ruby on Rails developers use Macs, but I
don't know how many of
Tony Caduto wrote:
Dave Page wrote:
I work in a professional environment in a country (the UK) where the
cost of a 2Mb leased line could buy you a new laptop every month (a
significant amount of money for a small company), and yes, I regularly
use servers on the other side of the world where the
> -Original Message-
> From: Tony Caduto [mailto:[EMAIL PROTECTED]
> Sent: 12 May 2006 17:14
> To: Dave Page; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] GUI Interface
>
> Dave Page wrote:
> > I've used Enterprise Manager since before I started with pgAdmin II
> > and I stil
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,
may
On Fri, May 12, 2006 at 11:07:32AM -0500, Tony Caduto wrote:
> 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.
I doubt you could lend any credence to the results, but there is a
poll system o
Dave Page wrote:
I've used Enterprise Manager since before I started with pgAdmin II and
I still curse it to this day.
it's all what you are used to I guess :-)
I don't like enterprise manager either, but most of the hardcore MS DBAs
use the Query Analyzer program
which is separate from t
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 regular people (NON FOSS developer
> -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,
> ma
Joshua D. Drake wrote:
Well even more then that. The market that Tony is going after he
*thinks* runs Windows, it doesn't.
The majority of people out there that run PostgreSQL are running *nix.
Yes, the majority of downloads we have received over the past two
years is Windows. However that num
In this case, I'd be willing to bet that there are easily as many linux
desktops accessing PostgreSQL servers as there are Windows desktops, and
that the Mac comes in a distant third to either of them.
[snip]
I agree with everything you had to say Scott, but just FYI I think the
Mac, distan
On Fri, May 12, 2006 at 04:22:00PM +0200, Markus Schiltknecht wrote:
> > There have been discussions about the problems
>
> Do you have some pointers here? I did not find relevant discussions in
> the archives (of gmane.org)
Hmm, maybe not so much discussions as comments from developers when the
> -Original Message-
> From: Tony Caduto [mailto:[EMAIL PROTECTED]
> Sent: 12 May 2006 16:51
> To: Dave Page; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] GUI Interface
>
> Dave Page wrote:
> > I work in a professional environment in a country (the UK)
> where the
> > cost o
Dave Page wrote:
query-per-click interface unusable.
And I forgot to mention the remote users working from home via VPN over
a domestic ADSL line with only 256Kb/s upstream at 50:1 contention.
Regards, Dave
---(end of broadcast)---
TIP 4: H
Scott Ribe <[EMAIL PROTECTED]> writes:
>> My damn powerbook drive recently failed with very little warning
> It seems to me that S.M.A.R.T. reporting is a crock of shit. I've had ATA
> drives report everything OK while clearly in the final throes of death, just
> minutes before total failure.
FWI
Dave Page wrote:
I work in a professional environment in a country (the UK) where the
cost of a 2Mb leased line could buy you a new laptop every month (a
significant amount of money for a small company), and yes, I regularly
use servers on the other side of the world where the round trip time
etc
Rhys Stewart wrote:
hi all,
are there any function in pl/pgsql to call a shell script? or like is
there a pl/bash?
Actually scary enough, there is pl/bash. Google is your friend. You can
also use:
plpython, plperl, plphp, pljava etc...
Joshua D. Drake
Rhys
Peace & Love | Live Long & Pr
And, seriously,
are we still living at a time when connection speed should be
considered a deciding design factor? Yes, some people still
work off of slow connections, but the vast majority of us who
work in a professional environment most definitely do not.
I work in a professional enviro
On Fri, 2006-05-12 at 09:39, Tony Caduto wrote:
> Kenneth Downs wrote:
> >
> >
> > I guess it depends on your definition of trivial. Linux represents
> > 100% of the desktops at Secure Data Software. Therefore lightning
> > will be deployed in the trivial percentage of zero.
> > ---
> My damn powerbook drive recently failed with very little warning
It seems to me that S.M.A.R.T. reporting is a crock of shit. I've had ATA
drives report everything OK while clearly in the final throes of death, just
minutes before total failure.
--
Scott Ribe
[EMAIL PROTECTED]
http://www.kille
On Fri, May 12, 2006 at 09:54:23AM -0500, Rhys Stewart wrote:
> are there any function in pl/pgsql to call a shell script? or like is
> there a pl/bash?
PL/sh might be what you're after; you could also use PL/Perl, etc.
http://pgfoundry.org/projects/plsh/
What does the shell script do? Having t
Kenneth Downs 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 guess it depends on your definition of trivia
On Friday 12 May 2006 10:54 am, "Rhys Stewart" <[EMAIL PROTECTED]> thus
communicated:
--> hi all,
--> are there any function in pl/pgsql to call a shell script? or like is
--> there a pl/bash?
-->
You can use Perl in "untrusted" mode as a backend function and accomplish
something like that.
---
Two options I have run across.
pl/sh
http://developer.postgresql.org/~petere/pgplsh/
ShellSQL
http://www.edlsystems.com/shellsql/
On Friday 12 May 2006 07:54 am, Rhys Stewart wrote:
> hi all,
> are there any function in pl/pgsql to call a shell script? or like is
> there a pl/bash?
>
> Rhys
>
> Pea
hi all,
are there any function in pl/pgsql to call a shell script? or like is
there a pl/bash?
Rhys
Peace & Love | Live Long & Prosper
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/doc
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Dave Page
> Sent: 12 May 2006 15:46
> To: Erik Jones
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] GUI Interface
>
> I work in a professional environment in a country (the UK)
> where
> -Original Message-
> From: Erik Jones [mailto:[EMAIL PROTECTED]
> Sent: 12 May 2006 15:09
> To: Dave Page
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] GUI Interface
>
> Why not have it be an option as to how it loads table info?
It's a fairly fundamental part of the
> Well, triggers cannot be used to create writeable views, can they?
The documentation says that triggers can be used on views but only for Inserts;
not updates or
deletes.
http://www.postgresql.org/docs/8.1/interactive/rules-triggers.html
Regards,
Richard
---(end of b
Dave Page wrote:
Part of the problem is that pgAdmin III seems to preload
object properties instead of pulling them in as you need them.
I have noticed many times in pgAdmin III that when a function
is edited and saved by someone else on a different
workstation I can't see those changes until I
Kenneth Downs wrote:
I guess it depends on your definition of trivial. Linux represents
100% of the desktops at Secure Data Software. Therefore lightning
will be deployed in the trivial percentage of zero.
---(end of broadcast)---
TIP 2: Don'
Martijn van Oosterhout writes:
> I beleive you can set it to EXTERNAL, which it will always toast.
I don't think that will help; if the overall row size is below the
threshold, the code is not going to pick it apart to see if anything
is saying "toast me anyway!". And it shouldn't do so IMHO; th
"mmaclennan" <[EMAIL PROTECTED]> writes:
> Hi, I have a linux box (Fedora 3) running the latest version of
> PostgreSQL and PostGIS. I am trying connect to the database through a
> windows computer but can't seem to make the connection work. I've
> configured the pb_hba.config file in the usr direc
On Fri, 2006-05-12 at 15:57 +0200, Martijn van Oosterhout wrote:
> It's a known problem. It's also one of the reasons why triggers are
> recommended over rules. And it's not desirable behaviour.
Well, triggers cannot be used to create writeable views, can they?
> There have been discussions about
On Fri, May 12, 2006 at 03:51:18PM +0200, Markus Schiltknecht wrote:
> Hi,
>
> I was trying to create an updateable view. Suddenly I got foreign key
> violations when using nextval('myseq').
>
> As I understand, the rewriter does something similar to a simple text
> replacement (I guess copying t
Hi,
I was trying to create an updateable view. Suddenly I got foreign key
violations when using nextval('myseq').
As I understand, the rewriter does something similar to a simple text
replacement (I guess copying the plan tree nodes?) so that nextval gets
evaluated again for every rule that appli
On Thu, May 11, 2006 at 11:15:16PM -0400, Perez wrote:
> TOASTing is automatic? I don't have to code anything for it? Plain
> vanilla SQL99 will work with it? I have terrible memories of Oracle's
> LONG RAW columns
TOAST is automatic, yes. It's also transparent (ie there's no
functionalit
On Thu, May 11, 2006 at 10:28:37AM +0100, Chris Coleman wrote:
> Hi,
>
> I have written a couple of trigger functions in C that utilise the SPI
> interface. They are both row level triggers, one a before trigger and
> one an after trigger.
>
> If the triggers are called with an update statement
On Thu, May 11, 2006 at 10:35:12AM +0800, APSC, Patrick Chee Seng Onn wrote:
> Hi,
>
> I've just installed postgresql onto my system but unable to successfully
> add new users and databases. I would receive a error message:
>
> createuser: could not connect to database template1: FATAL u
On 5/11/06, APSC, Patrick Chee Seng Onn <[EMAIL PROTECTED]> wrote:
Hi,
I've just installed postgresql onto my system but unable to successfully add
new users and databases. I would receive a error message:
createuser: could not connect to database template1: FATAL user "root"
does n
On 10 May 2006 07:46:01 -0700, mmaclennan <[EMAIL PROTECTED]> wrote:
Hi, I have a linux box (Fedora 3) running the latest version of
PostgreSQL and PostGIS. I am trying connect to the database through a
windows computer but can't seem to make the connection work. I've
configured the pb_hba.config
Hi,
I have written a couple of trigger functions in C that utilise the SPI
interface. They are both row level triggers, one a before trigger and
one an after trigger.
If the triggers are called with an update statement that only affects
one row then both are excecuted correctly and without erro
Hello,
Has anyone thought of integrating shp2pgsql and pgsql2shp into
pgAdmin? This would be an extremely helpful addition. I'm really
happy that I've found pgsql and postgis, but getting geometry data in
and out of pgsql is still a major hassle for me.
Thanks,
nelson
-
Hi all,
I'm in the planning stages of replacing a MySQL DB using ISAM tables
with PostgreSQL 8.1.x on Suse 10.0. I think that sentence right there
will tell you why!
Anyway, one of the columns in one of the tables is a big chunk of XML
(500 to 500KB). I'm not normally a fan of that kind of
Hi,
In order to unify many distant Postgres databases, we
decided to use WAL archiving. The idea is to concatenate a distant WAL archive at
the beginning of a local WAL archive before launching PITR restore.
Does anyone know how to concatenate WAL contents, i.e.
decode and encode WAL file
Hi,
I've just installed postgresql onto my system but unable to successfully add
new users and databases. I would receive a error message:
createuser: could not connect to database template1: FATAL user "root"
does not exist
createdb: could not connect to database template1:
1 - 100 of 120 matches
Mail list logo
