[GENERAL] Odd Invalid type name error in postgresql 9.1

2012-09-26 Thread Jim Wilson
structural problem in the database that might result in a crash later, I'd like to get it fixed now. Thanks in advance, Jim Wilson -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Problems with query in highly concurrent environment

2005-02-24 Thread Jim Wilson
r clients becoming memory bound (e.g. not enough RAM or poor garbage collection/memory leakage on the client side)? Best regards, Jim Wilson ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] PostgreSQL still for Linux only?

2005-03-10 Thread Jim Wilson
d easy maintenance for very low per user cost as compared to just about anything else. You may want to contact the folks at this web address for local linux support. http://nglug.org/ In any case I wish you the best of luck in your business. Best regards, Jim Wilson ---(

Re: [GENERAL] Safely Killing Backends (Was: Applications that leak connections)

2005-02-04 Thread Jim Wilson
ne to do a sufficient amount of testing to avoid some of these issues. If I was submitting patches for Postgres I\'d push a little harder, and if I were, this problem would be at the top of my list as things to fix in Postgres. Best regards, Jim Wilson ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Safely Killing Backends (Was: Applications that leak connections)

2005-02-04 Thread Jim Wilson
> Jim Wilson <[EMAIL PROTECTED]> writes: > > If you are not very careful about how you handle orphaned connections > > in Postgres you will likely lose datanot "maybe" like a long > > shot...but "likely". > > [ raised eyebrow ... ]

Re: [GENERAL] Safely Killing Backends (Was: Applications that leak connections)

2005-02-04 Thread Jim Wilson
> Jim Wilson <[EMAIL PROTECTED]> writes: > > Rather than getting into the raised eyebrow thing , I\\\'d suggest > > checking your "qualifiers". Consider that with Postgres, if killing a > > single connection brings the whole server down, you will lo

Re: [GENERAL] Safely Killing Backends (Was: Applications that leak connections)

2005-02-04 Thread Jim Wilson
> On Fri, Feb 04, 2005 at 05:01:43PM -0500, Jim Wilson wrote: > > > Rather than getting into the raised eyebrow thing , I\\\'d suggest > > checking your "qualifiers". Consider that with Postgres, if killing a > > single connection brings the

Re: [GENERAL] Safely Killing Backends (Was: Applications that leak connections)

2005-02-08 Thread Jim Wilson
;t mean that there aren\'t other areas of priority for other users. And no, I do not want to debate the meaning of the word "instability". :-) Best regards, Jim Wilson ---(end of broadcast)--- TIP 2: you can get off all lists a

Re: [GENERAL] GUI Interface

2006-05-12 Thread Jim Wilson
ould he run a Linux Desktop? > > Enough said... > > -- > Tony Caduto 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 sla

Re: [GENERAL] GUI Interface

2006-05-12 Thread Jim Wilson
> -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 --

Re: [GENERAL] Column qualifier issue

2004-01-12 Thread Jim Wilson
Stephan Szabo <[EMAIL PROTECTED]> said: > On Mon, 12 Jan 2004, Tom Lane wrote: > > > "Jim Wilson" <[EMAIL PROTECTED]> writes: > > > As far as I can tell, there isn't a way to get postgresql to accept column > > > qualifiers (e.g. t

Re: [GENERAL] Column qualifier issue

2004-01-12 Thread Jim Wilson
Tom Lane <[EMAIL PROTECTED]> said: > "Jim Wilson" <[EMAIL PROTECTED]> writes: > > As far as I can tell, there isn't a way to get postgresql to accept column > > qualifiers (e.g. tablenames). A 'parse error at or near "."' gets re

[GENERAL] Powerbuilder and PostgreSQL information

2004-01-24 Thread Jim Wilson
ddress is: http://pbpgsql.spiderbark.com Best regards, Jim Wilson ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] pl/pgsql docs 37.4.3. Row Types -- how do I use this

2004-01-24 Thread Jim Wilson
not exist > HINT: No function matches the given name and argument types. You may need > to add explicit type casts. Why not just use a text type in your definition? CREATE or REPLACE FUNCTION use_two_tables(text) RETURNS text AS ... You can always do a cast inside

Re: [GENERAL] relocatable binary distribution

2004-03-05 Thread Jim Wilson
, socket directory, and data directory can be specified either in environment or on the command line. Where are you getting stuck? Best, Jim Wilson ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] 7.4.1 upgrade issues

2004-03-06 Thread Jim Wilson
for servers IMO) are often not configured properly and can cause similar issues in a system with tons of ram and cpu. Best, Jim -- Jim Wilson - IT Manager Kelco Industries PO Box 160 58 Main Street Milbridge, ME 04658 207-546-7989 - FAX 207-546-2791 http://www.kelcomaine.c

Re: win32 users list (Re: [GENERAL] Native Win32 port - PLEASE!)

2004-03-28 Thread Jim Wilson
David Garamond said: > Bruce Momjian wrote: > So can I quietly beg the Win32 group to expedite this port. I believe > you will be utterly astonished at the demand. Please. > >> > >>Speaking of win32 port, do/will we need a win32 users list > >>(pgsql-win32)? MySQL has one. For now, I

Re: [GENERAL] To_char statement problems

2004-04-08 Thread Jim Wilson
Clark Endrizzi said: > I just sent this twice before with the wrong email address so it didn't > go through, that is why I am sending this so that it will get through. > I hope this isn't causing issues. > > Hi guys. I certainly hope this is the correct place to email this. I'm > having an iss

Re: [GENERAL] problems returning a resultset from a function

2004-09-13 Thread Jim Wilson
) { ...code to browse/process the rows... } Note the above examples might have a typo or two...but that's the general idea. I have not used the stored procedure statement object as you did. Perhaps that would be more portable. Best, Jim -- Jim Wilson - IT Manager Kelco Indu