Re: [ADMIN] inheritance question

According to your posting below the second table will have all the columns of the first table plus extra columns. If that is true then why are you trying to add a column to your first table and not your second table as well? On Tue, 2004-07-13 at 06:32, evgeny tsurkin wrote: > Hi All! > That prob

Re: [ADMIN] Disk usage

Hi, It is possible to vacuum each table individually. Perhaps vacuum the large tables one a time first and then try a database vacuum. Mike On Mon, 2004-07-12 at 14:43, Octavio Alvarez Piza wrote: > I have a database to which I re-create daily via ODBC. I only drop the > data, not the index de

[ADMIN] help with lost pghoster website

Hello, I am probably a bit late in doing this as I have been AWOL for a couple weeks and only today found out about pghoster's disappearance. I would like to ask for help from anyone-- ex-customer of pghoster or not-- regarding the disappearing the pghoster web hosting company (which was listed

[ADMIN] inheritance question

Hi All! That probably was already asked thousand times but i did not find an exact answer: I want to have two tables the second one will have all the columns from the first + some extra .The data should be complittly separate .I was trying to use inheritance and setted the SQL_INHERITANCE = fals

Re: [ADMIN] Secure DB Systems - How to

Thanks Rajesh. What you propose is good for making each record private but does not protect from other with dba access from viewing the sensitive fields, e.g: socialsecuritynumber. Suppose that you have the following field: name address1 address2 city state zip socialsecuritynumber phonenumber pa

[ADMIN] Disk usage

I have a database to which I re-create daily via ODBC. I only drop the data, not the index definitions or the data definitions. I use TRUNCATE to drop the data. I REINDEX each table afterwards. For some reason, my VACUUM job was not running, so the DB was not being VACUUMed at all. Today I ran o

[ADMIN] Function to get client IP address

Hi, I've been looking through the mail archives in the hope of finding a function to get the client IP address according to the backend. Found lots of requests but no actual answers or examples. I've trawled through the backend code and as a result created a function to do the job. I though

Re: [ADMIN] URGENT - Postgres won't work

=?iso-8859-2?Q?Egy=FCd_Csaba?= <[EMAIL PROTECTED]> writes: > When I try to 'ls -l' the $PGDATA/base/19536 directory then the console > freezes and does nothing. Sounds to me like you've got disk hardware problems :-( regards, tom lane ---(end of br

Re: [ADMIN] Missing casts in PgAdmin III

Hi all, To respond to my own question, and yes, my face is red: switching on the "system objects" in the PgAdmin III menu did a reinstall ;-). Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 e-mail: [EMAIL PROTECTED] web:

[ADMIN] URGENT - Postgres won't work

Hi All, I have the following problem: (RH7.1, PostgreSQL 7.4.1) After stopping postresql service the /data/pgsql/tgr/data/postmaster.pid is not deleted. Starting Postgresql (after deleting the pid file manually): --- [EMAIL PROTECTED] /root]# /et

[ADMIN] Missing casts in PgAdmin III

Hi all, I have installed PostgreSQL 7.4.1 on 2 RedHat 8.0 servers using the RPMS from mirrors.ics.org. On server 1 I can see with PgAdmin III that I have 175 cast functions. On server 2 I have no cast functions at all. Apparently I did not do exactly the same installation as the result is diffe