[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

Hi all, In 8.2.x version of postgres, there is a configuration switch --with-libedit-preferred prefer BSD Libedit over GNU Readline. However, I don't see this switch in 8.1.x. Since people still use 8.1.x version, is there any plan to back-port this feature? If so, I like to work on this.

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 broadcast

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

=# \ds List of relations Schema | Name | Type | Owner +--+--+--+- public | a| sequence | Dhanaraj public | b| sequence | Dhanaraj public | c| sequence | Dhanaraj (3 rows) Peter Eisentraut wrote: Dhanaraj M wrote: This patch was

[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 will

[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

I have the following doubts. 1. Does postgres create an index on every primary key? Usually, queries are performed against a table on the primary key, so, an index on it will be very useful. 2. If 'm executing a complex query and it takes 10 seconds to return the results -- it takes 10 seco

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

I could not understand the following TODO item. Can anyone explain this. Monitoring: = Allow server logs to be remotely read and removed using SQL commands Does it mean that the server log file should be read by the client? What kind of removal (using SQL)? Also I like to know where

[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

I am currently looking at some performance issues. Our product uses the postgres as the backend and it uses a huge storage space. Is there a script available, which does the following: 1. When you point it to a postgres installation, -> 1.the script first identifies what platform (solaris

[HACKERS] bug# 2073 - Clarification

Bug- raised: = BUG #2073: Can't drop sequence when created via SERIAL column Answered: Right. We have this TODO item: * %Disallow changing default expression of a SERIAL column? which would prevent you from changing the default expression for a SERIAL column. So the

[HACKERS] TODO items..

I saw the following in the TODO list. I am currently trying to work on them. I could not understand clearly what needs to be done. Can anybody give me the details for the following so that I can work on? clients-psql = 1. Have psql show current values for a sequence 2. Fix psql's display

[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??

Hi all, I have recented joined and working on postgres. I fixed a bug that I saw in the mailing list. I ran the regression test that is available in postgres. It was successful and now I need the following details.. 1) Test suits that i could get to test my code.. 2) How can I put back my fix