[GENERAL] BLOBS from psql...

1998-11-03 Thread A James Lewis
Is there any way to enter a large object (Binary) into a database using psql... or any other tool I can run from a shell script... Ideally I need to be able to take stdin and put it in a particular place in a table Then obviously get it back out later... James ([EMAIL PROTECTED]) Vortex

[GENERAL] Bug report for 6.4Beta5 (Is this the right place?)

1998-11-03 Thread A James Lewis
test_db=> select cash_mul_flt8('$1', 100.72); cash_mul_flt8 - $100.71 (1 row) Do I have to explain whats wrong here? James ([EMAIL PROTECTED]) Vortex Internet My Windows unders~1 long filena~1, and yours?

[GENERAL] cache lookup failed

1998-11-03 Thread Lyn K. Finman
I am getting the following 'cache lookup failed' error when I try to update two of the tables in my database through psql. Similiar updates to three other tables complete successfully. Can anyone give me a hint on what I'm doing wrong? I'm running PostgreSQL 6.3.2 on Linux 4.1. splat=> update

Re: [GENERAL] Upcoming 6.4 release issues - WinNT

1998-11-03 Thread Bruce Momjian
> On Tue, 3 Nov 1998, Chris Williams wrote: > > > A few weeks ago there was lots of messages about a port to WinNT of > > postgres 6.4. Is this still the case and will it be available for > > download? If not..is there any time frame when it will be. > > The only report that comes to mind

Re: [GENERAL] Upcoming 6.4 release issues - WinNT

1998-11-03 Thread The Hermit Hacker
On Tue, 3 Nov 1998, Chris Williams wrote: > A few weeks ago there was lots of messages about a port to WinNT of > postgres 6.4. Is this still the case and will it be available for > download? If not..is there any time frame when it will be. The only report that comes to mind is one pers

[GENERAL] Support for images?

1998-11-03 Thread Gilley, Charles H.
Does Postgres support images or binary files in a database? Is this what the large objects are for? chg

Re: [GENERAL] Upcoming 6.4 release issues - WinNT

1998-11-03 Thread Chris Williams
A few weeks ago there was lots of messages about a port to WinNT of postgres 6.4. Is this still the case and will it be available for download? If not..is there any time frame when it will be. Thanks Chris The Hermit Hacker wrote: > On Mon, 2 Nov 1998, dustin sallings wrote: > > > On Mon, 2 Nov

RE: [GENERAL] Upcoming 6.4 release issues

1998-11-03 Thread Jason
Try setting the environment variable `CXX' to `"gcc -O3"' (If you are using `gcc'). For example `CXX="gcc -O3" ./configure'. If you use this you don't nead to have libg++ installed! -Jason. -Original Message- From: dustin sallings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 03,

Re: [GENERAL] float8 to text converter

1998-11-03 Thread Memphisto
On Tue, 3 Nov 1998, Jose' Soares wrote: > Hi Memphisto, > > If you are using v6.4 you can use CAST as: 6.4 is in beta, isn't it(currently i use 6.3.2)? Anyway thanks. Sebestyén Zoltán AKA Memphisto It all

Re: [GENERAL] Transaction aborted?

1998-11-03 Thread Jose' Soares
Mike Meyer wrote: > > I'm seeing these messages in the process of adding entries to a > database. > > NOTICE: (transaction aborted): queries ignored until END > > I'm not positive what they mean. Is there someone who is who could > tell me, and tell me how to catch then and deal with t

Re: [GENERAL] float8 to text converter

1998-11-03 Thread Jose' Soares
Hi Memphisto, If you are using v6.4 you can use CAST as: prova=> select cast('1.7976931348623e+308'::float8 as text); ?column? 1.7976931348623e+308 (1 row) or: prova=> select cast(f as text) from a; text -- 4714-11--2147483624 BC <--- 4714-11--2147483

Re: [GENERAL] Upcoming 6.4 release issues

1998-11-03 Thread dustin sallings
On Mon, 2 Nov 1998, The Hermit Hacker wrote: (experience with 6.4 beta 5) I'm not on this list, so if you have any questions, be sure to send directly to me. // This does not require C++ to compile, nor do I suspect it ever // will...I couldn't imagine the effort to go through to a