[ADMIN] db out of memory

1999-03-18 Thread hoelc
Hello, I have a PostgreSQL database with Linux system. I use C language to write the database application interface programs, with libpq and ecpg. Some of the programs work fine, but some always give " db out of memory error ". Anyone have any idea what does this mean? Please advice. Thank you

[ADMIN] delete data

1999-03-18 Thread hoelc
Hello, can some one please tell me how to delete a table in a database and how to delete one row a data in a table, for a PostgreSQL database? Thank you very much. Regards.. lch

[ADMIN] the last row in a table

1999-03-09 Thread hoelc
Hello, I am developing a database with PostgreSQL in Linux, and using ecpg to write the C program to communicate with the database. One of my application need to get the data from the last row in a table. Is there any function or command that can tract which is the last row of data in a table? Tha

[ADMIN] date & time

1999-03-06 Thread hoelc
Hello, Can some one please tell me how to set the date&time in the PostgreSQL system? I try to use date('now') and time('now') to keep tract of the data and time when the data is inserted or updated. When I use sql " insert into table (data1, date_chg, time_chg) values ('abc',date('now'),time('no

[ADMIN] create postgres superuser?

1999-03-01 Thread hoelc
Hello, I'm a newbei in this Unix world. I've a simple question here that need some advise. How should I create postgres superuser? I'm currently trying to install PostgreSQL into my Linux system, and the Installation Procedure stated that we need to create the Postgres superuser account. I wonde

Re: [ADMIN] problem upgrading to postgresql-6.4.2

1999-02-11 Thread hoelc
me problem just a few days ago ... > > Frans > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]]On Behalf Of hoelc > > Sent: Wednesday, February 10, 1999 5:30 AM > > To: [EMAIL PROTECTED] > > Subject: [ADMIN] having probl

[ADMIN] having problem with postgresql-6.4.2

1999-02-10 Thread hoelc
Hello, I'm trying to install postgresql-6.4.2 on my RedHat Linux 5.0. and got this error massage when creating database installation from postgres superuser(postgres), with command ' $ initdb ' : { this is the end part of the massage, where I notice some error } : ini