Re: [GENERAL] outer join fails with error - solaris only

2001-05-17 Thread Tom Lane
[EMAIL PROTECTED] writes: > The following query gives an error when run on solaris 2.7, but it works > fine with an equivalent configuration on rh 6.2. It probably has nothing to do with the platform, but rather with when you last ran VACUUM ANALYZE and what the exact contents of the database wer

[GENERAL] outer join fails with error - solaris only

2001-05-17 Thread danw
The following query gives an error when run on solaris 2.7, but it works fine with an equivalent configuration on rh 6.2. select tr.transition_key, tr.transition_name from wf_transition_info tr left outer join wf_context_assignments ca

Re: [GENERAL] Backward migration

2001-05-17 Thread Valerio Santinelli
I think you should post the exact errors you're getting to the mailing list, so maybe someone can help you. Valerio Santinelli Digisoft Multimedia http://www.digisoftmultimedia.it/ - Original Message - From: "Francisco M. Marzoa Alonso" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: T

Re: [GENERAL] Restore from a dead machine.

2001-05-17 Thread jtp
Thanks all for the help. I've got it working. I remade the perl module and found that there were some directories/files it wanted to write to that it couldn't. So i allowed those permissions and remade install and everything worked swell. thanks for the help. .jtp -

Re: [GENERAL] Restore from a dead machine.

2001-05-17 Thread John Burski
I've seen this message before - it appears when, like you indicated, the specified module can't be found in any of the directories specified in the Perl @INC array. If you can locate the Pg.pm module on your system, copy it to one of the directories specified (a symbolic link might work, too, but

Re: [GENERAL] Need help using PHP ODBC to connect Postgress 7.1.1

2001-05-17 Thread Brent R. Matzelle
--- Hiroshi Inoue <[EMAIL PROTECTED]> wrote: > Allan Rafuse wrote: > > > > I'm having trouble setting up a remote Apache PHP webserver > to connect to > > our postgres machine using ODBC. > > > > Are you using ~/.odbc.ini(user DSN) for odbc.ini ? > Current psqlodbc driver doesn't understand sys

Re: [GENERAL] Restore from a dead machine.

2001-05-17 Thread User JOHN
On Wed, 16 May 2001, Tom Lane wrote: > User JOHN <[EMAIL PROTECTED]> writes: > > But when i try to run any of the perl scripts designed for the database > > I'm getting the following error: > > > Can't locate Pg.pm in @INC (@INC contains: /usr/libdata/perl/5.00503/mach > > /usr/libdata/perl/5.

[GENERAL] Backward migration

2001-05-17 Thread Francisco M. Marzoa Alonso
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi there, I must migrate a PostgreSQL database that I've created initially with PostgreSQL 7.0 over LiNUX to a system that has PostgreSQL 6.5.3 running on a FreeBSD. I've no chance to update de PostgreSQL engine to a newer version so the only way

[GENERAL] Timestamp Format

2001-05-17 Thread Alex
how can I make a timestamp data type be outputted without the time zone? I expect: "-MM-DD HH:MM:SS" instead of postgresql output: "-MM-DD HH:MM:SS-timezone" I know I can do that by using some functions on the select query, but my idea is to get this result without altering the queries,