Re: [SQL] has anyone tried running in MAC OS X

2001-05-17 Thread Tom Lane
"postgresql" <[EMAIL PROTECTED]> writes: > I guess the subject line says ithas anyone tried running > PostgreSQL in MAC OS X. Some folks at Apple did. Postgres 7.1 is alleged to build out-of-the-box on OSX. (But I haven't tried it myself.) Don't bother trying with earlier releases.

Re: [SQL] has anyone tried running in MAC OS X

2001-05-17 Thread Mike Castle
On Thu, May 17, 2001 at 08:48:39PM -0400, postgresql wrote: > I guess the subject line says ithas anyone tried running > PostgreSQL in MAC OS X. Isn't OS X fairly close to NEXTSTEP (or whatever the casing is these days)? How well does PostgreSQL work on NS? Did you try building it yet? :

[SQL] has anyone tried running in MAC OS X

2001-05-17 Thread postgresql
I guess the subject line says ithas anyone tried running PostgreSQL in MAC OS X. I see that in the product brochure, Apple specifically mentions Mysql. I run a shop that has all mac computers. I am runnng just 1 linux box (SUSE Linux on a Max G3) to run the job tracking system. Please, I

[SQL] ON UPDATE CASCADE overhead?

2001-05-17 Thread Forest Wilkinson
If I add ON UPDATE CASCADE to my foreign key definitions, how much will it affect performance for queries that don't trigger the cascade? Cheers, Forest ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

[SQL] Setting session global variables

2001-05-17 Thread Kyle
  Is there a way to set a session global variable in PostgreSQL?  The only thing I see are examples of setting config variables. Not sure if session variables are your best solution, but here's how you implement them: -- Warning: this defines a global variable in the tcl interpretor.  This coul

Re: [SQL] how to add an new record from part of an old one

2001-05-17 Thread George Moga
[EMAIL PROTECTED] wrote: Hi there I need to half copy and insert new data in a new record. Please see the SQL statement, that is not working, but i think is shows what I'd like to do. The fields a_nr and a_kurzbez will get the values from a form and a_bez needs to be copied from an existing auftr

[SQL] how to add an new record from part of an old one

2001-05-17 Thread juerg . rietmann
Hi there I need to half copy and insert new data in a new record. Please see the SQL statement, that is not working, but i think is shows what I'd like to do. The fields a_nr and a_kurzbez will get the values from a form and a_bez needs to be copied from an existing auftrag. Thanks for any help