[GENERAL] Query questions

I'm building a database containing key parameters for ~500,000 data files. The design I found logical is Two tables for each file: 1) Larger table with detailed key parameters (10-15 columns, ~1000 rows), call it large_table 2) Small table with file summary (~30 columns, 1 row), call it

Re: [GENERAL] Query questions

On Sat, 2005-09-03 at 00:59 -0800, Poul Jensen wrote: I'm building a database containing key parameters for ~500,000 data files. The design I found logical is Two tables for each file: 1) Larger table with detailed key parameters (10-15 columns, ~1000 rows), call it large_table 2)

Re: [GENERAL] Schema problems RedHat / SuSE 9.3 for version 7.4.8

Hi list, Again after reconsidering the way this problem came to be, it struck me that I used a pg_dump -f /tmp/dumpdb and restored with psql. How can it be that not all grants of the schema's, views and tables are restored? There were no messages during the restore that could be interpreted

Re: [GENERAL] LOG: unexpected EOF within message length word

Thx for u'r response here is the sample code which works fine and prints column lengths in HP-UX PA machines and breaks in HP-UX IA machines. I tried tusc (I sent that o/p in previuos mail. Client opens a socket and starts to write.but after some send receive it goes to SLEEPING state) void

Re: [GENERAL] LOG: unexpected EOF within message length word

1) I am using postgres 7.4 version. 2)I have sent tusc o/p along with first mail.however I will attch it once again. 3)the following code works fine in HP-UX PA machines.but not in HP-UX IA machines. I meant the maxiumum data that we can insert into IA machines is 40760.if we make it to

Re: [GENERAL] LOG: unexpected EOF within message length word

here is the complete code: If I change the event_rawdata size to 40764 then it wotks in HP-UX PA but goes infinite waiting /sleeping If I close it externally (say ctrl c)then postgres gives the LOG:Incomlete message from client or unexpected EOF within message length word Prasanna. #include

[GENERAL] Not able to insert the large data to HP-UX IA machines

Hi, We are supposed to insert the large data which is around 200 k/row. (Through libpq) We are able to do it in HP-UX PA machines.not in HP-UX IA machines. We can insert the data upto 46k in IA machines.(we have bytea field .and most(all) of data go to this field) When we try to insert the

Re: [GENERAL] LOG: unexpected EOF within message length word

On Sat, Sep 03, 2005 at 11:31:19AM +0530, Mavinakuli, Prasanna (STSD) wrote: 1) I am using postgres 7.4 version. Exactly which version? What does SELECT version() show? Did you build PostgreSQL from source yourself, or did you install a pre-built package? Have you tried a newer version like

Re: [GENERAL] LOG: unexpected EOF within message length word

Michael Fuhr [EMAIL PROTECTED] writes: On Sat, Sep 03, 2005 at 11:31:19AM +0530, Mavinakuli, Prasanna (STSD) wrote: 1) I am using postgres 7.4 version. Exactly which version? I'm wondering about the relevance of this pre-7.4-final bug fix: 2003-10-19 17:36 tgl *

Re: [GENERAL] Schema problems RedHat / SuSE 9.3 for version 7.4.8

On Sat, Sep 03, 2005 at 04:07:34PM +0200, Dick Kniep wrote: Again after reconsidering the way this problem came to be, it struck me that I used a pg_dump -f /tmp/dumpdb and restored with psql. How can it be that not all grants of the schema's, views and tables are restored? There were no

[GENERAL] FAQ/Documentation about Postgresql on Windows XP

Hello everyone, I have been looking for a tutorial on setting up Postgresql on a Windows XP machine. I'm currently doing development on my home machine. Eventually we'll have Postgresql on a Windows server, but we want to try out and test code on a local machine before going live. I've

Re: [GENERAL] FAQ/Documentation about Postgresql on Windows XP

Hello, you could try to install the Windows version. It has a setup.exe I did not come across a tutorial for clicking on a setup.exe but as I see the demand now, I will think over it. ;-) Sebastian PS: Cygwin is not needed any more since version 8 of PostgreSQL [EMAIL PROTECTED] schrieb:

Re: [GENERAL] FAQ/Documentation about Postgresql on Windows XP

[EMAIL PROTECTED] wrote: Hello everyone, I have been looking for a tutorial on setting up Postgresql on a Windows XP machine. I'm currently doing development on my home machine. Eventually we'll have Postgresql on a Windows server, but we want to try out and test code on a local machine

Re: [GENERAL] Check if SELECT is granted

It helps if you spell privilege correctly ;-) Thanks, stupud mistake ... :) Poul ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

[GENERAL] Total memory used by postgresql

Hi, I would like to know how much memory postgresql is using in my machine. I´m thinking to use the following formula to make this calculation: For each process related to postgresql: SIZE column - SHARE column of TOP command. After summing all this values,the SHARED BUFFERS should be added.

[GENERAL] RAID0 and pg_xlog

Hi, Doesit make any sense to change the pg_xlog position if all my disks are configured inRAID level 0? Thanks in advance! Benkendorf Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA CONVERSA. Participe!

[GENERAL] pgsql with UTF-8 on Windows OS

Is there a way to set the cmd on Windows XP to use UTF-8 while using pgsql.exe ? Regards, Roger Tannous. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(end