[ADMIN] Is that a bug?

Hi, I have some problems with postgresql 7.0.3 running on Slackware linux 7.1. I have a table with about 25 milion records: create table gsc_act(reg_id int2,id int2,ra int4, de int4,mag int2); i created 2 indexes: create index gsc_act_de on gsc_act(de); create index gsc_act_rd on gsc_act(de,r

Re: [ADMIN] Is that a bug?

Hello ! I use POSTGRES 6.4... Everuthing was working ok for months, but since 3 days, I have sometimes when my PHP scrits try to connect : Warning: Unable to connect to PostgresSQL server: connectDB(): getprotobyname failed in /opt/htdocs/html/php/atos_lib.phtml on line 3 Have you any idea

[ADMIN] getprobyname problem

Hello ! I use POSTGRES 6.4... Everuthing was working ok for months, but since 3 days, I have sometimes when my PHP scrits try to connect : Warning: Unable to connect to PostgresSQL server: connectDB(): getprotobyname failed in /opt/htdocs/html/php/atos_lib.phtml on line 3 Have you any idea

[ADMIN] Disk full and table empty

Hi, I run postgresql 7.0.3. I have a large table and i started to create an index on it. Unfortunately the diak space was not enough and got a message that the device was full. From this moment the table i tried to index has 0 rows. what is wrong? I tried ipcclean, postgres reboot, system reboot a

Re: [ADMIN] Is that a bug?

No, plain select also does not work. --- Stephan Szabo <[EMAIL PROTECTED]> wrote: > > Hmm, does a plain select * from gsc_act work? > Also, what does explain show for the queries? > > Stephan Szabo > [EMAIL PROTECTED] > > On Thu, 21 Dec 2000, R D wrote: > > > Hi, > > I have some problems wit