Max len record and how to access an array in binary

I would like to know the max length of a record containing arrays. How can I access the array field in binary form instead of ascii form. I'm using the pgsql library in C. Cheers. Franck Martin Network and Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mai

www.postgresql.org web master

I didn't complain about this much before because I was using NetPositive, but since I can reproduce this using Opera's rendering engine as well, I just wanted to mention that the logo is all messed up on http://www.postgresql.org I'm not totally sure what the problem is (I'm not a

Re: I can crash my database in less than 2 minutes...

On Tue, Mar 14, 2000 at 05:05:26PM +0100, Wim Aarts wrote: > I'm getting futher in focussing on the problem. I can reproduce these > messages I get when vacuuming a database. > And by reproduce I mean on a different system a clean installed database It > takes me less then a minute > > NOTICE

Re: [GENERAL] Max Length for VARCHAR?

Hi Jan, I fiddled around with the example you gave me and created the view with the necessary triggers. Everything worked great up to this point. I think in order to get this to work with jdbc though there may be need some changes to the jdbc driver. When I tried to insert 16,000 characters

drop table

Hello!   I have a problem when I try to drop a table :   redife=> drop table supervisor;ERROR:  cannot find attribute 8 of relation supervisor   this is the error that postgres showme, I had that problem before with another table and I deleted a file with the same name of the table in /var/

Re: pg_recvbuf: unexpected EOF on client connection

> Sounds like you are running of filedescriptors That can be due to > following factors: > 1. Kernel limit is exhausted (not likely, i think default is > 1024fds/process), and needs to be adjusted > 2. You are exceeding your ulimit for fds. type ulimit -a and see what's it > set to. > 3. Postgres

I can crash my database in less than 2 minutes...

I'm getting futher in focussing on the problem. I can reproduce these messages I get when vacuuming a database. And by reproduce I mean on a different system a clean installed database It takes me less then a minute NOTICE: Rel pg_class: TID 294/3: InsertTransactionInProgress 20065 - can't s

Re: pg_recvbuf: unexpected EOF on client connection

Sounds like you are running of filedescriptors That can be due to following factors: 1. Kernel limit is exhausted (not likely, i think default is 1024fds/process), and needs to be adjusted 2. You are exceeding your ulimit for fds. type ulimit -a and see what's it set to. 3. Postgres is leaking FDs

PHP3 date formating problem

select lo_date from payperiod; lo_date -- 1999-12-16 00:00:00-05 1999-12-30 00:00:00-05 lo_date is defined as timestamp. In PHP3 I retreive the rows and lo_date ends up in $row[2]. echo $row[2], date('D M-j',$row[2]), strftime('%a %b-%d',$row[2]); yeilds 1999-12-16 00:00:00-05

pg_recvbuf: unexpected EOF on client connection

Hallo, I get this message on each connect (the logfilesize is 1M in 3 days). I have a 24 hour production datebase with alltogether over 600,000 rows since one year. I never had trouble until I changed the machine an the postgres version. Before I had a celeron 300 and postgreSQL 6.4.2. Now I use

Digest

set digest end Steven Pennie Application Programmer/Analyst III KDOT Materials & Research Center 2300 SW Van Buren Topeka, KS 66611-1195 (785) 291-3863 - Fax (785) 296-2526 [EMAIL PROTECTED]

RE: TRIGGER inheritance?

So far forget it. I am working now on quick and dirty scheme for inherited objects (triggers, indexes, rules) generation. Andrzej > -Original Message- > From: Ian Harder [SMTP:[EMAIL PROTECTED]] > Sent: 14 marca 2000 07:12 > To: [EMAIL PROTECTED] > Subject: TRIGGER inheritance? >