[GENERAL] PostGreSQL and LiveWire??

1999-05-07 Thread Ferdi
On a Unix (Solaris 2.6 + Netscapte enterprise) i have to interconnect a database and an internet site. I would like to know if i can use LiveWire (netscape solution) to work with PostGreSQL. Particularely, i have to secure an access by using a user profile saved in a database. So if you have exam

Re: [GENERAL] Restore from dump file: parse error

1999-05-07 Thread darold
Hi, To get the database creation you must use the -s option with pg_dump. (Dump out only the schema, no data) The parse error is probably due to a single quote somewhere in you text data... I use : pg_dump -D mydatabase > recover.sql

Re: [GENERAL] int8-datatype: possible bug

1999-05-07 Thread Jelle Ruttenberg
Hello José Soares, thank you. I tried your testcase and all input was changed in the magical value. The 'NOTICE' disappeared when I quoted the value, but the result was all the same. edahrecepten=> create table test(i8 int8); CREATE edahrecepten=> insert into test values(19980528112607 ); NOTI

Re: [GENERAL] int8-datatype: possible bug

1999-05-07 Thread José Soares
Jelle Ruttenberg ha scritto: Hello all, when I try to put a numeric 'timestamp' like 19980528112607 into an int8-datatype I get the notice 'NOTICE:  Integer input '19980528112607' is out of range; promoted to float' and the value is put in the database as 9223091508918288644. It doesn't matter if

Re: [GENERAL] int8-datatype: possible bug

1999-05-07 Thread José Soares
Seems that your platform has problems with int8. Here the begining of ../contrib/int8/README from Thomas G. Lockhart. Try to ask him :) --- Thomas G. Lockhart <[EMAIL PROTECTED]> This is a first attempt at 64-bit integer arithm

[GENERAL] Selecting from arrays

1999-05-07 Thread Simon Drabble
Sorry if this has been answered before but a dejanews search turned up nothing relevant. I'm trying to select from a table which has a couple of array columns, and I want to constrain the select on those columns, i.e. something like (pseudo-code) select date,loc from results where value appears

Re: [GENERAL] Trying using Postgresql on FreeBSD

1999-05-07 Thread Palle Girgensohn
With FreeBSD, you should really use the port; it saves you much grief. I recommend it! cd /usr/ports/databases/postgresql && make install (with a fresh ports tree, which you get with "cvsup /usr/share/examples/cvsup/ports-supfile"). Regards, Palle "Allan C. Lemos" wrote: > > Hi, > I'm running