[ADMIN] PK and FK relation ship

Can any one tell me when would a primary key be refered to as foreign key in its own table. - Warm Regards Shÿam Peri II Floor, Punja Building, M.G.Road, Ballalbagh, Mangalore-575003 Ph : 91-824-2451001/5 Fax : 91-824-2451050 DISCLAIMER: This message contains privileged and confidential

Re: [ADMIN] PK and FK relation ship

On Thu, 11 Sep 2003 [EMAIL PROTECTED] wrote: Can any one tell me when would a primary key be refered to as foreign key in its own table. Simple Trees. If you need a parent child relationship the simplest way of expressing it is to have a parent columnn and store the parent

[ADMIN] Views

PostgreSQL version 7.3.4 Quick question:With respect to a VIEW, why does PostgreSQL internally return all of the columns when, for example, the SELECT statement only requestssay 2 out of 10 columns ? Thanks in advance, Donald Fraser.

[ADMIN] `__builtin_va_alist' undeclared

HiPlease help me...I am installing postgresql-7.3.4 on solaris sparc 2.8.But with make it is giving me the following error. I am strucked now. Output: make -C nbtree SUBSYS.omake[4]: Entering directory `/opt/temp/postgresql-7.3.4/src/backend/access/nbtree'make[4]: `SUBSYS.o' is up to

[ADMIN] Pam Ldap (debian) problem

Hi, i dont get postgres working with pam to use an external ldap server to authenticate users. i think the problems is that postgres is using the wrong pam file, namely he uses pam_unix where he should use pam_ldap.so. postgres version 7.3.2 debian version 3 (kernel 2.4) any help is much

Re: [ADMIN] System catalog for triggers

A.Bhuvaneswaran [EMAIL PROTECTED] writes: Where does postgresql store tg_op and tg_when details for a trigger? If i am right, it is not in pg_trigger catalog. No, you're not right. It's encoded in tgtype somehow; you'll have to look at the trigger code for details (see

Re: [ADMIN] `__builtin_va_alist' undeclared

Kalyan (FS) [EMAIL PROTECTED] writes: I am installing postgresql-7.3.4 on solaris sparc 2.8. gcc -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../src/includ e -I/usr/local/include -I/usr/include -c -o stringinfo.o stringinfo.c stringinfo.c: In function `appendStringInfo':

[ADMIN] Pam Ldap (debian) solved

As noticed, he used pam_unix , as in a local connection, i just had to outcommend the 127.0.0.1 line in pam_ldap.conf to get it working.. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your

Re: [ADMIN] `__builtin_va_alist' undeclared

Hi Tom, It works! Now I have to install. Thank you very much. Have a great day! Kalyan. Here is the final output: lib libplpgsql.a -shared -h libplpgsql.so.1 pl_gram.o pl_handler.o pl_comp.o pl_exec.o pl_funcs.o -L../../../../src/port -L/usr/local b -o libplpgsql.so.1.0 -f

Re: [ADMIN] postgresql and replication

On Wed, Sep 03, 2003 at 12:25:09PM +0200, [EMAIL PROTECTED] wrote: I am unable to find the adress to unsuscribe, could you please help me and give me that adress... thanks for advance!! http://gborg.postgresql.org/mailman/listinfo/erserver-general (Sorry, I've been buried lately and I'm

[ADMIN] Does VACUUM ever free up any disk space?

I've read a lot where people recommend using VACUUM FULL to free up disk space, especially after many updates/inserts. But does a regular VACUUM (or VACUUM ANALYSE) ever free up any space? 24/7 production databases cannot be locked for long periods of time to run VACUUM FULL, but I do not want

Re: [ADMIN] Does VACUUM ever free up any disk space?

On Thu, Sep 11, 2003 at 18:42:25 +0100, Chris Miles [EMAIL PROTECTED] wrote: I've read a lot where people recommend using VACUUM FULL to free up disk space, especially after many updates/inserts. But does a regular VACUUM (or VACUUM ANALYSE) ever free up any space? 24/7 production

Re: [ADMIN] Does VACUUM ever free up any disk space?

On Thu, 11 Sep 2003, Chris Miles wrote: I've read a lot where people recommend using VACUUM FULL to free up disk space, especially after many updates/inserts. But does a regular VACUUM (or VACUUM ANALYSE) ever free up any space? 24/7 production databases cannot be locked for long periods

Re: [ADMIN] How to create schema-specific users?

Dnia 03-09-09 16:22, Uytkownik Tom Gordon napisa: I'm missing something. How do I create a user that is just for a specific schema, and not a global user? I see in the docs how to create schemas and users, but not a schema-specific user. Users, as well as roles aka groups are non-schema

[ADMIN] unsubscribe

---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [ADMIN] Does VACUUM ever free up any disk space?

scott.marlowe [EMAIL PROTECTED] writes: On Thu, 11 Sep 2003, Chris Miles wrote: I've read a lot where people recommend using VACUUM FULL to free up disk space, especially after many updates/inserts. A regular vacuum since 7.2 never actually frees up space, it simply marks the space in the

[ADMIN] Cross-DB linking?

I am thinking of separating my data into various DBs (maybe on the same server, probably not) -- mostly for performance/stability/backup reasons -- but I have a considerable amount of foreign keys, views, and queries that would need to work across DBs if I were to split things the way I want

Re: [ADMIN] Cross-DB linking?

You might want to consider using schemas to accomplish some of this. You can backup individual schemas as of 7.4 (maybe 7.3, but I've not used it in production, waiting for 7.4 to upgrade from 7.2) performance will almost certainly suffer if you are doing cross db work, so schemas help there.

Re: [ADMIN] Report Generator Proposal

Nobody entusiastic ? I'm wrong about my feeling ? I think that have the psql able to generate a report will increase the our better response to a user novice or not ? Regards Gaetano Mendola - Original Message - From: Gaetano Mendola [EMAIL PROTECTED] Newsgroups:

Re: [ADMIN] Duplicate key ( reindex and vacuum full logs )

No clues? Gaetano - Original Message - From: Gaetano Mendola [EMAIL PROTECTED] Newsgroups: comp.databases.postgresql.admin Sent: Tuesday, September 09, 2003 4:39 PM Subject: Re: Duplicate key ( reindex and vacuum full logs ) just for add informations on the problem: these are the

[ADMIN] OLEDB Driver

I see a thread in ODBC that uses a DSN-less connection and {Postgresql} as the driver. Where can I get this driver to use with ADO? Also, I am not getting responces from my post on psql-odbc? Can you Help? Thomas LeBlanc _ Need

Re: [ADMIN] Cross-DB linking?

Thanks -- I haven't looked at schemas, I guess I will now :-). As for stability -- I was referring to the hardware breaking down, not Postgresql! Andrew 9/11/03 5:24:50 PM, scott.marlowe [EMAIL PROTECTED] wrote: You might want to consider using schemas to accomplish some of this.

Re: [ADMIN] Cross-DB linking?

On Thu, 11 Sep 2003, Andrew Biagioni wrote: Thanks -- I haven't looked at schemas, I guess I will now :-). Schemas rock. Like little sandboxes for each user with their own play areas and what not. As for stability -- I was referring to the hardware breaking down, not Postgresql! Ahhh. I

[ADMIN] Some basic info regarding postgresql?

Hi all, new to postgresql and WOW! IS it a great DB! I am blown away with it, it does far more than I thought it could. I am interested in learning a bit more regarding a few areas of PostgreSQL. Either through replies, or links anyone can provide to more detailed information, I would

Re: [ADMIN] Some basic info regarding postgresql?

On Thu, Sep 11, 2003 at 16:18:04 -0700, Duffey, Kevin [EMAIL PROTECTED] wrote: Security is another biggie. I see that you can limit who can access it based on ip, user name, etc. What other levels of security are there? Can table permissions be set on an individual user, or a group of