[HACKERS] PAM authentication fails for local UNIX users

Hi all, http://archives.postgresql.org/pgsql-admin/2003-02/msg00301.php I also try to address the same issue.. I run postmaster as postgres user and pg_hba.conf includes the following entry: local all dhanaraj pam However, the authentication fails for

[HACKERS] Replacement of readline by libedit in PostgreSQL 8.1.x

this. Thanks Dhanaraj ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] [PATCHES] Allow the identifier length to be increased via a

Tom Lane wrote: Alvaro Herrera <[EMAIL PROTECTED]> writes: Dhanaraj M wrote: I am sending the patch for the following TODO item: Allow the identifier length to be increased via a configure option You should use pg_config.h, not mangle postgres_ext.h like that. Or

Re: [HACKERS] Clarification needed

In psql, psql>\d tableName Query is SELECT pg_catalog.format_type(a.atttypid, a.atttypmod) from pg_attribute a, pg_class c where a.attrelid =c.oid and c.relname='TableName' and a.attname='ColName'; Zdenek Kotala wrote: Look at http://www.postgresql.org/docs/8.1/interactive/catalogs.htm

[HACKERS] Is there any utility to update the table whenever text file gets changed?

Is there any utility in postgresql which can do the following? The utility must update the table whenever there is any change in the text file. COPY command helps to do that, though this is not straight forward. Can it be automated? Thanks Dhanaraj ---(end of

Re: [HACKERS] [PATCHES] Patch - Have psql show current values

| Seq Value +--+--+--+--- public | a| sequence | Dhanaraj | 5 public | b| sequence | Dhanaraj | 2 public | c| sequence | Dhanaraj | 1 (3 rows) output without aplying the patch mydb

[HACKERS] Security bugs

I heard that 2 security bugs were fixed in 8.1.4. Since I like to upgrade from 8.1.3, I like to know the bugs. Can somebody give the description of those bugs? Thanks Dhanaraj ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

[HACKERS] Turning off disk caching

Hi Is there anybody who knows about "Turning off disk caching" in solaris machines. If so, pl. reply back. Thanks Dhanaraj ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] Performance Issues

Thank you for your help. I found that an implicit index is created for the primary key in the current version. However, it is not done in 7.x version. Mark Woodward wrote: Dhanaraj M wrote: I have the following doubts. 1. Does postgres create an index on every primary key? Usually

[HACKERS] Performance Issues

es 10 seconds to execute the next time also. I'm wondering if there's any kind of caching that can be enabled -- so, the next time it takes <10 seconds to return the results. Thanks Dhanaraj ---(end of broadcast)--- TIP 9: In versi

Re: [HACKERS] Clarification required

The server log file means the files that are in pg_xlog. or some more/some other files? The log files in pg_xlog dir are not human readable. How is it useful on the client side? Dave Page wrote: could not understand the following TODO item. Can anyone explain this. Monitoring: =

[HACKERS] Clarification required

the server log file is stored. Thanks Dhanaraj ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[HACKERS] Need some clarification

I could see the following in TODO list but I am not clear what is expected out of this. Can anyone explain this? 1. *Allow VIEW/RULE recompilation when the underlying tables change * *Another issue is whether underlying table changes should be reflected in the view, e.g. should SELECT *

[HACKERS] Need a help - Performance issues

uum (and other such database health maintenance commands) were run 5. comments about the growth of certain tables/databases If any body has the scripts or can give some links which could be useful for our group. Thanks Dhanaraj ---(end of broadc

[HACKERS] bug# 2073 - Clarification

e whether statement-2 is valid or not (as you say that the default sequence should not be changed). Or the default seq. can be dropped and cant be changed. I like to know the expected output. Thanks Dhanaraj ---(end of broadcast)--- TIP 3: H

[HACKERS] TODO items..

splay of schema information (Neil) Please explain me the current feature that is supported and expected out of it. Thanks Dhanaraj ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[HACKERS] How to create the patch?

Hi all I fixed a bug. I downloaded the recent version of postgres using CVS. I made the changes and tested. I dont know how to create a patch. Should i login and execute diff command? Can u explain the steps in detail?? Please help me in this regard.. Thanks Dhanaraj

[HACKERS] How to put back??

fix into postgres src code.. (or) What is the procedure that I should follow at this stage?? Waiting for your suggestions, Thanks Dhanaraj ---(end of broadcast)--- TIP 4: Have you searched our list archives? http

[HACKERS] A doubt..

Hi all I looked at B-tree and r-tree implementations. However i could not find out where it is used. It seems that the data retrieved from the data base is kept in the tuple data structure. I am not clear in that. please some one help me.. Thanks Dhanaraj ---(end of

[HACKERS] Doubt in parser

Dhanaraj ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org