Re: [GENERAL] any body using Solaris8 with postgresql 7.3.3

On Fri, Jul 04, 2003 at 02:52:41PM +0800, Weiping He wrote: pmdie 2 Just a hunch, but could this have anything to do with power management? That's controlled by a program called pm. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS

Re: [GENERAL] any body using Solaris8 with postgresql 7.3.3

On Fri, Jul 04, 2003 at 03:45:04PM -0400, Andrew Sullivan wrote: On Fri, Jul 04, 2003 at 02:52:41PM +0800, Weiping He wrote: pmdie 2 Just a hunch, but could this have anything to do with power management? That's controlled by a program called pm. Hmm. Not a program, after all. My

Re: [GENERAL] Datatypes and performance

, there is a performance penalty for limiting their length, because you have to check on each insert. My coworker has more experience with Oracle and MS-SQL than postgresql You may want to tell your coworker to read the docs ;-) A -- Andrew Sullivan 204-4141 Yonge Street

Re: [GENERAL] Datatypes and performance

.) ---cut here--- A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110 ---(end

Re: [GENERAL] [pgsql-advocacy] interesting PHP/MySQL thread

have been installed and used under a wide variety of circumstances. The lack of a real, built-in replication system in Postgres is a fundamental problem, and therefore the sort of thing that people justifiably point to as a missing feature. A -- Andrew Sullivan 204

Re: [GENERAL] Concatenating two Text fields from the same tuple

problems, but the || operator allows you to concatenate. And where field1||field2 = 'something' works. Whether it'd be efficienct is another question. Maybe you could do something fancy with a partial index or something, but I can't think how. A Andrew Sullivan 204-4141

[GENERAL] moving char() to varchar()

that, by the way. My memory is about as reliable these days as the DIMM I took out of my PC last week. That's why I need a good DBMS like postgres!) A -- Andrew Sullivan 87 Mowat Avenue Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED

[GENERAL] --enable-syslog and Solaris 7

suggestion is much appreciated, because I'm stumped. I've never seen anything like this before. Thanks, A -- Andrew Sullivan 87 Mowat Avenue Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M6K 3E3

[GENERAL] dumb question: multiple postmasters on Solaris

Hi, I believe this is a dumb question, and I have a sneaky feeling that I've seen something about this on the list before, but I can't find it in the archives. I am used to using PostgreSQL on Linux, but we have moved some of our work onto Solaris multiprocessor boxes. Now, I see multiple

Re: [GENERAL] Re: postgresql.conf ignored

at will get the hits. Thanks, A -- Andrew Sullivan | McMaster University Research Computing Support, CIS | 1280 Main Street West [EMAIL PROTECTED]| Hamilton, Ontario +1 905 525 9140 x 27601 | L8S 4L8

[GENERAL] Easy way to find out allowed data?

on that. It looks like relevant information is in pg_relcheck, but I'm not sure I understand what I'd have to do to get it out (more like, "I'm sure I don't understand. . ."), because there's a lot of other stuff in there. Thanks, A -- Andrew Sullivan Computer Servi

Re: [GENERAL] phpPgAdmin

ions, also. There is extensive documentation (not all of it a model of clarity, but if I can understand it, I'm sure anyone can) at http://www.php.net. A -- Andrew Sullivan Computer Services [EMAIL PROTECTED]Burlington Public Library +1 905 639

Re: [GENERAL] update inside transaction violates unique constraint?

On Tue, Sep 26, 2000 at 04:43:02PM -0400, Andrew Sullivan wrote: Have I done something wrong here, or have I stumbled on a bug? Shouldn't this cause an error and a rollback? Sorry, forgot to include the usual stuff : PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2

Re: [GENERAL] pg_dump problem

to STDERR? That would solve that problem... It could save some people's time in finding how it works.. Why? If you do it the new way, you get the prompts that you expect, and you don't have to redirect to a file, so you get a nice clean dump file. -- Andrew Sullivan

Re: [GENERAL] Postgres + PHP question: username in pg_connect?

use passwords if you don't want. By the way, you'd be better off, in almost every circumsntance, to use pg_pConnect. Then, you don't have to open a new database connection every time you want to do an operation. The overhead of that really hurts. -- Andrew Sullivan

Re: [GENERAL] Slashdot discussion

occurs to me, though, that many people may not install from source. Maybe the RPMs are better for MySQL? I don't use 'em, so I don't know. A -- Andrew Sullivan Computer Services [EMAIL PROTECTED]Burlington Public Library

[GENERAL] Hints about how to debug pg_dump problem?

. A -- Andrew Sullivan Computer Services [EMAIL PROTECTED]Burlington Public Library +1 905 639 3611 x158 2331 New Street Burlington, Ontario, Canada L7R 1J4

[GENERAL] dump files

Ok, so I really am even stupider than I look. I had a third look at the output from my attempted read, and finally noticed the permissions error early on which made everything fail. Sorry to be a bother. A -- Andrew Sullivan Computer Services [EMAIL

Re: [GENERAL] Revised Copyright: is this more palatable?

, of course, include the original copyrightedwork under different terms. But even the original copyright owner can't go back and change the license forsomething in the past, no? -- Andrew Sullivan Computer Services [EMAIL PROTECTED]Burlington

Re: [GENERAL] Lock record

u're trying to break someone's 20 year bad habit). Use transactions. Much better than locking. -- Andrew Sullivan Computer Services [EMAIL PROTECTED]Burlington Public Library +1 905 639 3611 x158

<    3   4   5   6   7   8