Re: [GENERAL] Trouble with Innstalling PostGreSQL 6.5.2 on Win NT

1999-10-01 Thread Kevin Lo
Jeff Hoffmann wrote: > on a related note, i've been thinking about trying out postgres on NT, > but i've been hesitant to do so because it seems to be a "just because i > can" port -- maybe not as stable or fast as on a unix system, but neat > to have. are people actually using it for serious (i

Re: [GENERAL] Trouble with Innstalling PostGreSQL 6.5.2 on Win NT

1999-10-01 Thread Oleg Broytmann
On Fri, 1 Oct 1999, Kevin Lo wrote: > Some friends of mine works on NT platform, they just want to learn SQL, > but you know, almost databases on NT are commercial, they are expensive > and they cannot pay it just because they want to learn SQL, right? If you know (or agree to learn) Python pr

Re: [GENERAL] ODBC-client->Linux-server: datatype boolean not recognized?

1999-10-01 Thread jose soares
oh! this was for old releases, now I'm using the following: create function MsBool(bool,int4) returns bool as ' declare     bool_int int4; begin     if $1 is NULL then     return NULL;     end if;     if $1 is TRUE then if $2 <> 0 then ret

[GENERAL] query string too long

1999-10-01 Thread leshan
Does any one know a way around the query string too long error? I am trying to create a view. Below is the create command and the error message. Thank you, Jd create view external_job as select positions.id as position_id, positions.title as position_title, external, expire, never,

Re: [GENERAL] Trouble with Innstalling PostGreSQL 6.5.2 on Win NT

1999-10-01 Thread Bruce Momjian
> >> I have a web page about installing on WinNT, see: > >> > >> http://members.tripod.com/~kevlo/postgres/portNT.html > > > > Added to FAQ. > > Bruce, > > I changed URL to http://www.freebsd.org/~kevlo/postgres/portNT.html > Please update FAQ, thanks. I also update my page, porting 6.5.2 > to N

[GENERAL] PostgreSQL vs Mysql for website?

1999-10-01 Thread Scott Perkins
In a discussion with a local Linux enthusiast we were discussing which would be better for a small website project to be driven by PHP and hosted by nix/nuz and apache. I have seen that Mysql does not support unions, transactions, subselects. PostgreSQL supports subselects and transactions. I do

[GENERAL] datetime datatype question

1999-10-01 Thread Kevin Heflin
If from the psql command line I use select current_timestamp it shows like this: 1999-10-01 14:30:53-05 However if I insert into a datetime field, when I do a select it formats it like so: Sun Oct 03 10:00:00 1999 CDT Is there a way I can retrieve the information from a datetime field, and fo

Re: [GENERAL] datetime datatype question

1999-10-01 Thread Patrick Welche
Kevin Heflin wrote: > > > If from the psql command line I use select current_timestamp it shows like > this: > > 1999-10-01 14:30:53-05 > > However if I insert into a datetime field, when I do a select it formats > it like so: > > Sun Oct 03 10:00:00 1999 CDT > > Is there a way I can retriev

[GENERAL] alpha and true64 port

1999-10-01 Thread amy cheng
hi, this is kind of emergent! we are in the process of decision making. Is there an true64 on alpha port? thanks in advance!! amy __ Get Your Private, Free Email at http://www.hotmail.com

Re: [GENERAL] alpha and true64 port

1999-10-01 Thread Bruce Momjian
> hi, this is kind of emergent! > > we are in the process of decision making. Is there an true64 on > alpha port? > > thanks in advance!! We have alpha/osf, but no tru64 that I know of. -- Bruce Momjian| http://www.op.net/~candle [EMAIL PROTECTED]

[GENERAL] Keeping postmaster running or restarting

1999-10-01 Thread Doran L. Barton
I've been using PostgreSQL since it was Postgres95 and this has always been a problem- only recently it has become a BIG problem. I'm running an e-commerce backend using PostgreSQL and it works great but crashes every once in a while for mysterious reasons and then the whole company is breathing

Re: [GENERAL] How to import data from MDB or pipe delimited file into PostgreSQL

1999-10-01 Thread Doran L. Barton
Not long ago, PostgreSQL proclaimed... > What is the best way to import into a PostgreSQL database data from a > Microsoft Access database? > > Should I export the data to a pipe or comma delimited file and then import? > *But how can I do that* ? Once you have an Access table exported using som

[GENERAL] How to import data from MDB or pipe delimited file into PostgreSQL

1999-10-01 Thread PostgreSQL
What is the best way to import into a PostgreSQL database data from a Microsoft Access database? Should I export the data to a pipe or comma delimited file and then import? *But how can I do that* ? With mSQL it is easy, it has already a builtin function where you specify the name of the text fi

Re: [GENERAL] PostgreSQL vs Mysql for website?

1999-10-01 Thread Bruce Momjian
> In a discussion with a local Linux enthusiast we were discussing which > would be better for a small website project to be driven by PHP and hosted by > nix/nuz and apache. I have seen that Mysql does not support unions, > transactions, subselects. PostgreSQL supports subselects and transactio

Re: [GENERAL] alpha and true64 port

1999-10-01 Thread Adriaan Joubert
Bruce Momjian wrote: > > hi, this is kind of emergent! > > > > we are in the process of decision making. Is there an true64 on > > alpha port? > > > > thanks in advance!! > > We have alpha/osf, but no tru64 that I know of. Tru64 is just a renaming of Digital Unix / OSF/1(Those Compaq people

Re: [GENERAL] How to import data from MDB or pipe delimited file into PostgreSQL

1999-10-01 Thread Mike Mascari
--- "Doran L. Barton" <[EMAIL PROTECTED]> wrote: > Not long ago, PostgreSQL proclaimed... > > What is the best way to import into a PostgreSQL > database data from a > > Microsoft Access database? > > > > Should I export the data to a pipe or comma > delimited file and then import? > > *But how c