Re: [GENERAL] New Software Database is Live ...

1999-02-09 Thread The Hermit Hacker
Done...:) On Tue, 9 Feb 1999, Oleg Broytmann wrote: > Hi! > > On Sun, 7 Feb 1999, The Hermit Hacker wrote: > > http://www.postgresql.org/index.html -> Software Database > >Are you listing only English-language sites? I worked and is working now > on pure Russian sites. What about add

[GENERAL] Postgres C interface

1999-02-09 Thread Dinesh Patil
Hi, Can you please give me any information about how C programming can be used for accessing, creating database of Postgres. I am not getting clear idea of how Postmaster process has to be started and how to initialize different parameters of Postgres. So please help me for this.. thanks for y

[GENERAL] pqReadData() -- backend closed the channel unexpectedly.

1999-02-09 Thread Ludovico Magnocavallo
I have recently installed postgresql 6.4.2 on a Linux 2.2.0 box, and I keep getting this error message when I queue a a few queries in a Perl script: pqReadData() -- backend closed the channel unexpectedly. My script has a loop that performs three queries for every hour of a single day: the firs

RE: [GENERAL] pqReadData() -- backend closed the channel unexpectedly.

1999-02-09 Thread Jackson, DeJuan
1st suggestion - If there is no reason behind have temp tables rewrite your sql to eliminate them (this reduces to just 24 queries): INSERT INTO week (address, origbytes, destbytes, when) SELECT o.origine, sum(o.bytes), sum(d.bytes), '09/02/1999 9:00:01' FROM day o, day d WHERE o.origine=d

Re: [GENERAL] pqReadData() -- backend closed the channel unexpect edly.

1999-02-09 Thread Ludovico Magnocavallo
Thanks a lot for your suggestion, that in fact gets me through the loop. Only problem is, I need to group by origine and get that sum(bytes) and by destinazione and get that sum(bytes). They are different. Your statement only groups for origine (in fact it groups by address, which is non-existent

Re: [GENERAL] New Software Database is Live ...

1999-02-09 Thread Oleg Broytmann
Hi! On Sun, 7 Feb 1999, The Hermit Hacker wrote: > http://www.postgresql.org/index.html -> Software Database Are you listing only English-language sites? I worked and is working now on pure Russian sites. What about adding new field - language, or may be "primary language"? Oleg.

Re: [GENERAL] A mistake generates strange result

1999-02-09 Thread Stéphane Dupille
Hi ! "Ricardo J.C.Coelho" <[EMAIL PROTECTED]> writes: > Just for PgSQL's development group think about > I made a mistake typing a query that generates a strange result > (Very strange). > The query: select text('12345678'::float8); > It returns a date in datetime format !!