Re: [HACKERS] Listen / Notify rewrite

2009-11-11 Thread A . M .
: add the number of times a notification was generated (coalesced count+1) to the callback data. That would satisfy any backwards compatibility concerns and my use case too! Cheers, M -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

[HACKERS] POSIX shared memory redux

2010-11-13 Thread A . M .
the shared memory file descriptor to the process. I am happy to implement this, if required. I am happy to continue work on this patch if the pg-hackers deem it worthwhile. Thanks! Cheers, M -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] POSIX shared memory redux

2011-04-13 Thread A . M .
of this patch and not its goal and, in the worst possible scenario, it doesn't change current behavior, I don't see how this can be a ding against this patch. Cheers, M -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

[HACKERS] Postgresql, HA ?, Monitoring.

2001-04-19 Thread V. M.
Dear Hackers, i'm using 7.1 in a production environment, porformace is very good, you've made a vesy good job. But there are problems, sometimes backend "failed to start": (mandrake 7.2, mod_perl 1.24, apache 1.3.14, Apache::DBI) (deadlock_timeout=2000 max_connections=300)

[HACKERS] Schema Issue

2001-04-25 Thread V. M.
I want to extract tables schema information, i've looked at src/bin/psql/describe.c but i cannot determine the datatype 'serial' and 'references' from pg_*, i understand that triggers are generated for serial and references, so how i can understand from my perl application the full schema ?

[HACKERS] unanswered: Schema Issue

2001-04-26 Thread V. M.
I want to extract tables schema information, i've looked at src/bin/psql/describe.c but i cannot determine the datatype 'serial' and 'references' from pg_*, i understand that triggers are generated for serial and references, so how i can understand from my perl application the full schema ?

[HACKERS] Re: unanswered: Schema Issue

2001-04-26 Thread V. M.
ok for serials, now i can extract from psql (\d tablename). But i'm not able to extract foreign keys from the schema. From: Joel Burton [EMAIL PROTECTED] To: V. M. [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: unanswered: Schema Issue Date: Thu, 26 Apr 2001 13:51:26 -0400 (EDT

Re: [HACKERS] Re: unanswered: Schema Issue

2001-04-26 Thread V. M.
read it, but i can determine only the related tables and not the fields of these tables that are related. valter From: Joel Burton [EMAIL PROTECTED] To: V. M. [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: [HACKERS] Re: unanswered: Schema Issue Date: Thu, 26 Apr 2001 14:42:31 -0400 (EDT

Re: [HACKERS] Re: unanswered: Schema Issue

2001-04-26 Thread V. M.
example is: fk_provincie_id_paesi_id_provin\000paesi\000province\000UNSPECIFIED\000id_provincia\000id\000 first field (fk_provincie_id_paesi_id_provin) is constraint name, and i can understand that: paesi(id_provincia) references provincia(id). valter From: Joel Burton [EMAIL PROTECTED] To: V. M

[HACKERS] CVSup not working!

2001-05-03 Thread V. M.
cvsup -L 2 postgres.cvsup Parsing supfile postgres.cvsup Connecting to postgresql.org Cannot connect to postgresql.org: Connection refused Will retry at 22:31:23 -- # This file represents the standard CVSup distribution file # for the PostgreSQL ORDBMS project #

[HACKERS] Postgresql.exe 7.1 for M$ OS

2001-05-04 Thread V. M.
Where i can find a wonderful installer for postgres 7.1 on our windows2000 advanced servers ? We use postgres on linux systems, But... I'm not able to find on the net a binary for Postgres 7.1. I don't want to compile, i want a simple installer. windows machines are 200 Million, if you'll

[HACKERS] Child itemid in update-chain marked as unused - can't continue repair_frag

2001-07-12 Thread V. M.
lindo=# vacuum analyze; NOTICE: Index probably_good_banner_myidx1: NUMBER OF INDEX' TUPLES (1) IS NOT THE SAME AS HEAP' (4). Recreate the index. NOTICE: Index probably_good_banner_myidx1: NUMBER OF INDEX' TUPLES (1) IS NOT THE SAME AS HEAP' (4). Recreate the index. NOTICE:

[HACKERS] NOTICE: Child itemid in update-chain marked as unused...

2001-08-01 Thread V. M.
sometimes i'm getting: NOTICE: Child itemid in update-chain marked as unused - can't continue repair_frag during a simple vacuum, db is online. pg version 7.1, on debian linux kernel 2.4. what's the problem? thanks, valter m

[HACKERS] UNICODE encoding

2004-10-24 Thread Agent M
Would the version bump be a good time to fix the UNICODE encoding misnomer in database creation and in the backend param status? I assume it should be UTFx. ---(end of broadcast)--- TIP 6: Have you searched our list archives?

Re: [HACKERS] UTF8 or Unicode

2005-02-16 Thread Agent M
On Feb 14, 2005, at 9:27 PM, Abhijit Menon-Sen wrote: I know UTF8 is a type of unicode but do we need to rename anything from Unicode to UTF8? I don't know. I'll go through the documentation to see if I can find anything that needs changing. It's not the documentation that is wrong. Specifying

[HACKERS] listen not schema-aware

2006-03-31 Thread Agent M
Why is the schema ignored entirely when using listen/notify? I couldn't find any mention of this in the documentation. Ideally, it should support schemas (and store any string it takes) but it should at least throw an error when a schema is prepended. I guess the workaround is to simply

Re: [HACKERS] control pg_hba.conf via SQL

2006-04-01 Thread Agent M
Unfortunately, there is still one serious deficiency with the solution below- it may not be the actual information postgresql is currently using to determine who can log in and how- the file can be easily changed behind the scenes and there is currently no way to know. I (speaking as a DBA)

Re: [HACKERS] control pg_hba.conf via SQL

2006-04-01 Thread Agent M
But there is still no way to verify that the information in the file is what postgres saw last. DBAs make mistakes too. A simple way to view the current access state would be much appreciated. On Apr 1, 2006, at 1:01 PM, Andrew Dunstan wrote: Er, how can the file be changed behind the

Re: [HACKERS] Speaking of pgstats

2006-04-05 Thread Agent M
The general idea would be to still use UDP backend-stats but get rid of the pipe part (emulated by standard tcp sockets on win32), so we'd still have the lose packets instead of blocking when falling behind. Right. Please correct me if I am wrong, but using UDP logging on the same computer

[HACKERS] TODO items..

2006-04-22 Thread Dhanaraj M
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] Protocol Message Graph

2006-04-23 Thread Agent M
://www.themactionfaction.org/pg/PGXProtocol.pdf (Messages in ellipses are sent from the server, rectangle message are sent from the client.) -M ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ AgentM [EMAIL PROTECTED] ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ---(end of broadcast

Re: [HACKERS] Protocol Message Graph

2006-04-23 Thread Agent M
On Apr 23, 2006, at 6:43 PM, Alvaro Herrera wrote: Agent M wrote: I have created a directed graph using graphviz that shows the message flow/event stream. Perhaps this will be helpful to someone. Of course, corrections are also welcome. Interesting. I'm not sure how to read the graph

[HACKERS] bug# 2073 - Clarification

2006-04-24 Thread Dhanaraj M
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

[HACKERS] Need a help - Performance issues

2006-05-09 Thread Dhanaraj M
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

[HACKERS] Need some clarification

2006-05-10 Thread Dhanaraj M
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] Clarification required

2006-05-12 Thread Dhanaraj M
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

Re: [HACKERS] Clarification required

2006-05-18 Thread Dhanaraj M
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] Performance Issues

2006-05-23 Thread Dhanaraj M
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

Re: [HACKERS] Performance Issues

2006-05-23 Thread Dhanaraj M
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] fwd: parallel PSQL ?

2000-11-03 Thread valter m
ql. Where the clients will connect ? I mean. There is more than one machine answering to postgresql port! You need to distribute the load. and that's the whole point of Mosix: one virtual machine! Richard -Original Message- From: valter m [SMTP:[EMAIL PROTECTE

[HACKERS] [JOB] pqsql hacker needed

2001-01-24 Thread M Carling
such as medical and stock options plus some less common benefits such as free massages and shower facilities on site. Please reply with an ASCII resume. M Carling CIO Axis, Inc.

[HACKERS] Like vs '='

2001-01-29 Thread m w
I have a function to transform text into a pseudo-metaphone variable, take this example: cddbsql=# select song, metatext(song) from cdsongs where metatext(song) like metatext('born to run') limit 3 ; song | metatext -+-- Born To Run | brntorn Born To Run | brntorn

Re: [HACKERS] Like vs '='

2001-01-30 Thread m w
In 7.1 the row limit is not as big a deal because of tuple toaster. I had a 7.0 database that needed the row limit change, in 7.1 it does not seem too. But if you want to chang it anyway, in config.h, look for this line: #define BLCKSZ 8192 It can be made as large as 32768. --- Manuel

[HACKERS] Like vs '=' bug with indexing

2001-01-30 Thread m w
I am reposting this because I'm not sure it actually made it to the list. I have a function to transform text into a pseudo-metaphone variable, take this example: cddbsql=# select song, metatext(song) from cdsongs where metatext(song) like metatext('born to run') limit 3 ; song |

Re: AW: AW: [HACKERS] Like vs '=' bug with indexing

2001-01-31 Thread m w
--- Zeugswetter Andreas SB [EMAIL PROTECTED] wrote: I am reposting this because I'm not sure it actually made it to the list. It did make it to the list, but can you give more details whether or which of the following you use: --enable-locale ?

Re: [HACKERS] Like vs '=' bug with indexing

2001-02-03 Thread m w
--- Tom Lane [EMAIL PROTECTED] wrote: m w [EMAIL PROTECTED] writes: Here is the problem: Depending on whether there is an index or not, 'like' behaves differently. Please provide a complete, self-contained example with which we can reproduce the problem. I am trying to create a test

Re: [HACKERS] Like vs '=' bug with indexing

2001-02-04 Thread m w
--- Hannu Krosing [EMAIL PROTECTED] wrote: Should we not examine "the _possible_ outputs of every C-coded function to make sure it produces a valid value of the datatype" ;) For me producing an invalid data for a datatype seems very much like a bug and it _should_ be reported. No, I

[HACKERS] contrib

2001-02-04 Thread m w
Is there a formal way of submiting something to the contrib section of the distribution? __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/

[HACKERS] Can we modify 'text *' passed to a C function?

2001-02-05 Thread m w
If I write a function that does a 'tolower()' on each character of a parameter passed into my function, do I have to allocate a new text object and initialize it and copy the data, or can I modify that object in place and return it? Modifying it in place will save the overhead of an alloc call,

Re: [HACKERS] Can we modify 'text *' passed to a C function?

2001-02-05 Thread m w
--- Tom Lane [EMAIL PROTECTED] wrote: m w [EMAIL PROTECTED] writes: If I write a function that does a 'tolower()' on each character of a parameter passed into my function, do I have to allocate a new text object and initialize it and copy the data, or can I modify that object

[HACKERS] Help needed in testing my code.

2003-05-28 Thread Srikanth M
give the query. Sincerely Srikanth M ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Help needed in testing my code.

2003-05-28 Thread Srikanth M
Dear Sir I am new to postgres and dont know the excat procedure of testing my code, okay i will use elog, but please tell me the procedure of testing that. for example,pls tell what should i do after i add code, what make files should i run and where should i place the new

[HACKERS] DATA-CUBE in Postgresql.

2003-05-29 Thread Srikanth M
Hi! I am interested in adding DATA-CUBE operator(Related to Data Warehousing) to postgresql. I just want to know wheather it is already added to postgres or not. please reply to this mail if you have already worked or still working on it. Bye Srikanth ---(end

[HACKERS] Result of a query(Need Help)

2003-06-07 Thread Srikanth M
Hi! Could anyone tell me where excatly the result of a query is stored after the query is passed to pg_exec_query_string function and before it is printed. Please give me information about the Data structures where the result is stored Bye Srikanth ---(end

[HACKERS] Printing groupClause List

2003-06-12 Thread Srikanth M
Hi! Can someone tell me where the Attribute name in the group clause of a given query are stored in the 'Query' structure. I have seen a member in 'Query' structure It is List *groupClause, if the Attribute names are stored in this list, then how can we access the names present in

[HACKERS] informatoin reagarding the last date of submission

2003-06-23 Thread Srikanth M
Hi! Can anyone give me the informatoin reagarding the last date of submission of the code to be added in next version of pgsql. bye Srikanth ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

[HACKERS] How to use pset command in my program!!

2003-06-24 Thread Srikanth M
Hi! I want to use 'pset'command in my program it's like this. I want to do the execute the following in my program. \pset null 'ALL' how can this be done bye srikanth ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[HACKERS] Urgent : Regarding Submission of Code

2003-06-29 Thread Srikanth M
Hi! We have written two new files by name datacube.c in tcop directory and datacube.h in include directory. We have even changed some exsisting files. We have made a patch of the files that have been changed. But how should we send the new files datacube.c, and datacube.h along with

Re: [HACKERS] That EXPLAIN ANALYZE patch still needs work

2006-06-08 Thread Agent M
It's worth noting that on Darwin (on Apple hardware) gettimeofday is never a syscall whereas on Linux (AFAIK), it always is. On Jun 8, 2006, at 7:58 PM, Mark Kirkwood wrote: Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: Wow, that is slow. Maybe a problem in the kernel? Perhaps

[HACKERS] Turning off disk caching

2006-06-27 Thread Dhanaraj M
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

[HACKERS] binds only for s,u,i,d?

2006-07-03 Thread Agent M
[and the binds are ignored]. -M ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ AgentM [EMAIL PROTECTED] ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[HACKERS] 10th Anniversary Conference

2006-07-10 Thread Agent M
during his keynote, thanks for making a great database product that allows so many of us to pay the bills! Best regards, M *Offer void where prohibited. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send

Re: [HACKERS] Online index builds

2006-07-15 Thread Agent M
A great first step would be to add elog(INFO,...) in some standardized format over the wire so that clients can tell what's going on. It could be triggered by a GUC which is off by default. -M On Jul 15, 2006, at 9:10 PM, Greg Stark wrote: Hannu Krosing [EMAIL PROTECTED] writes: Maybe we

Re: [HACKERS] SPI Elections and mailing list

2006-07-16 Thread Agent M
Sorry- perhaps I misunderstand the purpose of your group, but how can you claim to be making decisions on software in the public interest on a private, paid-member mailing list? -M On Jul 16, 2006, at 2:10 PM, Josh Berkus wrote: Folks, Hopefully by now a bunch of you have joined

Re: [HACKERS] Progress bar updates

2006-07-19 Thread Agent M
). During the downloading of the rows, the client would display the bar relative to the number of estimated rows returned. -M On Jul 18, 2006, at 2:35 PM, Gregory Stark wrote: Has anyone looked thought about what it would take to get progress bars from clients like pgadmin? (Or dare I even

[HACKERS] Security bugs

2006-07-26 Thread Dhanaraj M
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

Re: [HACKERS] 8.2 features status

2006-08-06 Thread Agent M
place where one could maintain a publicly-visible development branch just for feature X, that would make the work open source and trackable instead of open-source-once-I'm-done. -M ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ AgentM [EMAIL PROTECTED

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

2006-08-24 Thread Dhanaraj M
=# \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

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

2006-09-14 Thread Dhanaraj M
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] contrib\xml2 package's xpath_table function in PostgreSQL

2010-02-01 Thread M Z
Is there a way to fix it so that those functions are usable in 8.4 without crashing the server? Thanks, M Z On Mon, Feb 1, 2010 at 10:50 AM, Robert Haas robertmh...@gmail.com wrote: The functions haven't actually been removed in 8.4, in spite of the deprecation notice. But it's very easy

Re: [HACKERS] contrib\xml2 package's xpath_table function in PostgreSQL

2010-02-01 Thread M Z
I am very interested in doing it. However I am new to postgresql. Could you and anyone here please give me some hint, which way I should, which part of code I should focus to fix it? Thanks, M Z On Mon, Feb 1, 2010 at 1:23 PM, Robert Haas robertmh...@gmail.com wrote: On Mon, Feb 1, 2010 at 1

Re: [HACKERS] remove contrib/xml2

2010-02-04 Thread M Z
) * For 1st test case, not sure if some paths applied to 8.3 haven't been applied to 8.4, or other reasons cause the difference between 8.3.8 and 8.4.2. Any ideas or comments? Thank you, M Z On Mon, Feb 1, 2010 at 8:44 PM, Robert Haas robertmh...@gmail.com wrote: On Mon

Re: [HACKERS] remove contrib/xml2

2010-02-06 Thread M Z
The thing is, why it doesn't crash on 8.3.8 but crash on 8.4.2? Any idea? A patch was applied to 8.3 but not to 8.4.2? Thanks, M Z On Fri, Feb 5, 2010 at 1:45 PM, Robert Haas robertmh...@gmail.com wrote: On Wed, Feb 3, 2010 at 8:49 AM, Alvaro Herrera alvhe...@commandprompt.com wrote: Robert

[HACKERS] CVS checkout source code for different branches

2010-02-08 Thread M Z
-avzCH --delete anoncvs.postgresql.org::pgsql-cvs $CVSROOT However, how can I checkout code from different branches (such as 8.3, 8.4)? Thank you. M Z

Re: [HACKERS] CVS checkout source code for different branches

2010-02-08 Thread M Z
Hi Andrew, Could you please give a little more detail how I can find different CVS branches? Thanks, M Z On Mon, Feb 8, 2010 at 10:38 PM, Andrew Dunstan and...@dunslane.net wrote: M Z wrote: Hi, I am trying to checkout code from different branches (such as 8.3, 8.4). I found a few

Re: [HACKERS] CVS checkout source code for different branches

2010-02-08 Thread M Z
but I don't know the their cvsroot Thanks M Z On Mon, Feb 8, 2010 at 11:04 PM, M Z jm80...@gmail.com wrote: Hi Andrew, Could you please give a little more detail how I can find different CVS branches? Thanks, M Z On Mon, Feb 8, 2010 at 10:38 PM, Andrew Dunstan and...@dunslane.netwrote

Re: [HACKERS] CVS checkout source code for different branches

2010-02-09 Thread M Z
:pserver:anoncvs:passw...@anoncvs.postgresql.org:/REL8_3_STABLE co -P pgsql /REL8_3_STABLE: no such repository What are the correct repositories for these branch? Is there a way I can list these branch repositories and how? Many thanks, M Z On Mon, Feb 8, 2010 at 11:56 PM, Andrew Dunstan and...@dunslane.net wrote

Re: [HACKERS] CVS checkout source code for different branches

2010-02-09 Thread M Z
Final, I tried: $ cvs -z3 -d :pserver:anoncvs:passw...@anoncvs.postgresql.org:/projects/cvsroot co -r REL8_3_STABLE -P pgsql Checked file configure.in. Around line 20, there is line: AC_INIT([PostgreSQL], [8.3.9], [pgsql-b...@postgresql.org]) Not sure that indicates version 8.3.9? But still,

Re: [HACKERS] CVS checkout source code for different branches

2010-02-09 Thread M Z
Thanks Robert, Your reply helps a lot. Just right after sending post, I found the way to list all branches in the CVS server. Best, M Z On Tue, Feb 9, 2010 at 10:43 PM, Robert Haas robertmh...@gmail.com wrote: On Tue, Feb 9, 2010 at 10:35 PM, M Z jm80...@gmail.com wrote: Final, I tried

[HACKERS] Error when building postgresql with contrib functions

2010-02-15 Thread M Z
: SELECT * FROM xpath_table('id', 't', 'xpath_test', '/doc/int... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Thank you very much for your help. Best, M Z

Re: [HACKERS] remove contrib/xml2

2010-02-17 Thread M Z
or while processing the request. The connection to the server was lost. Attempting reset: Failed. ! == Best, M Z CREATE TABLE xpath_test (id integer NOT NULL, t xml); INSERT INTO xpath_test VALUES (1, 'docint1/int/doc'); SELECT * FROM xpath_table('id', 't

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

2007-04-15 Thread Dhanaraj M
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.

[HACKERS] PAM authentication fails for local UNIX users

2007-08-20 Thread Dhanaraj M
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

Re: [HACKERS] Clarification needed

2006-10-11 Thread Dhanaraj M
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

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

2006-12-28 Thread Dhanaraj M
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 maybe

[HACKERS] Problem with estimating pages for a table

2009-05-13 Thread Cristina M
Hello, I posted to the general list, and didn't receive any replies. Therefore, I am trying this list now, hopefully this is the right mailing list for this type of questions. I am trying to compute the no of pages of a table. I am using the formula : pages = ( columns width + 28) * no.

[HACKERS] DB Schema

2012-09-21 Thread m...@rpzdesign.com
During the execution of ProcessUtility() function in /src/backend/xxx/utility.c, the CreateStmt node type is processed to create a table. Is there a global function in the context of the backend process that will deliver what the current database and schema names? The querystring cannot be

[HACKERS] External Replication

2012-09-21 Thread m...@rpzdesign.com
instead of patching the statically compiled binary to simulate the triggers? Cheers, marco On 9/21/2012 10:15 AM, Heikki Linnakangas wrote: On 21.09.2012 17:58, m...@rpzdesign.com wrote: During the execution of ProcessUtility() function in /src/backend/xxx/utility.c, the CreateStmt node type

Re: [HACKERS] External Replication

2012-09-21 Thread m...@rpzdesign.com
will not even try to contribute this work, unless someone wants it. marco On 9/21/2012 1:19 PM, Andres Freund wrote: On Friday, September 21, 2012 08:12:26 PM m...@rpzdesign.com wrote: Heikki: Thanks for the response. I am writing an external replication engine and putting hooks

Re: [HACKERS] External Replication

2012-09-22 Thread m...@rpzdesign.com
subject indeed. I want CLOUD behavior without CLOUD prices. Anybody who is working on the 9.3 COMMAND TRIGGER, drop me a note if you wish. marco On 9/21/2012 3:41 PM, Andres Freund wrote: Hi, On Friday, September 21, 2012 11:06:46 PM m...@rpzdesign.com wrote: Thanks for the link on the GIT

Re: [HACKERS] [RFC][PATCH] wal decoding, attempt #2 - Design Documents (really attached)

2012-09-22 Thread m...@rpzdesign.com
Andres, nice job on the writeup. I think one aspect you are missing is that there must be some way for the multi-masters to re-stabilize their data sets and quantify any data loss. You cannot do this without some replication intelligence in each row of each table so that no matter how

Re: [HACKERS] External Replication

2012-09-24 Thread m...@rpzdesign.com
have not seen anybody request my hook code but a few have responded that the are working on things in the code base, release date unknown. Cheers, marco On 9/24/2012 10:20 AM, Dimitri Fontaine wrote: m...@rpzdesign.com m...@rpzdesign.com writes: You may want to consider changing the command

Re: [HACKERS] Switching timeline over streaming replication

2012-09-25 Thread m...@rpzdesign.com
replication needs and async for all the master - master stuff. cheers, marco On 9/24/2012 9:44 PM, Amit Kapila wrote: On Monday, September 24, 2012 9:08 PM m...@rpzdesign.com wrote: What a disaster waiting to happen. Maybe the only replication should be master-master replication so there is no need

Re: [HACKERS] Switching timeline over streaming replication

2012-09-25 Thread m...@rpzdesign.com
, likely because they do not have a single db engine that meets all the requirements like PG. marco On 9/25/2012 5:10 PM, John R Pierce wrote: On 09/25/12 11:01 AM, m...@rpzdesign.com wrote: At some point, every master - slave replicator gets to the point where they need to start thinking

Re: [HACKERS] Switching timeline over streaming replication

2012-09-26 Thread m...@rpzdesign.com
Josh: The good part is you are the first person to ask for a copy and I will send you the hook code that I have and you can be a good sport and put it on GitHub, that is great, you can give us both credit for a joint effort, I do the code, you put it GitHub. The not so good part is that the

[HACKERS] File Corruption recovery

2012-11-06 Thread m...@rpzdesign.com
I have been working on external replication on Postgresql 9.2 for a little while (with too many interruptions blocking my progress!) Who knows a good utility to aggressively analyze and recover Postgresql Databases? It seems the standard reply that I see is Make regular backups, but that

[HACKERS] Need to print the raw_parse_tree in the Log file

2015-11-07 Thread Praveen M
Hi All, I would like to print the raw parse tree into the log . Is there any internal utility function to achieve this. If there is none , can you please help me to achieve this. Thanks as always Praveen

[HACKERS] Eclipse Help

2015-10-13 Thread Praveen M
Hi All, I was able to follow the debugging of the child process using this link, https://wiki.postgresql.org/wiki/Working_with_Eclipse As per the notes , I was able to set breakpoints and everything seem to be working (hopefully). However I am not able to see the debug messages in the eclipse

[HACKERS] Identify user requested queries

2015-11-22 Thread Praveen M
Hi All, When the user attempts to make a connection with the database , the code will look into various pg_catalog tables internally. However the user also can query the pg_catalog tables. Is there a way to identify the user requested (or typed query) vs the system requested (internal) queries?

Re: [HACKERS] Identify user requested queries

2015-11-23 Thread Praveen M
Praveen On Mon, Nov 23, 2015 at 2:16 AM, Craig Ringer <cr...@2ndquadrant.com> wrote: > On 23 November 2015 at 13:27, Praveen M <thr...@gmail.com> wrote: > >> Hi All, >> >> When the user attempts to make a connection with the database , the code >> will look

[HACKERS] CreateFunction Statement

2015-11-20 Thread Praveen M
Hi All, I am trying to get the schema name of the create function call from the parse tree. When I look at the structure of the CreateFunctionStmt , I do not see the schemaname information . Can you please help me to understand how to extract the schema name for the function. typedef struct

Re: [HACKERS] Allowing GIN array_ops to work on anyarray

2016-08-11 Thread M Enrique
This is awesome. I will build it to start using and testing it in my development environment. Thank you so much for making this change. On Thu, Aug 11, 2016 at 11:33 AM Tom Lane wrote: > In > https://www.postgresql.org/message-id/15293.1466536...@sss.pgh.pa.us > I speculated

Re: [HACKERS] Gin index on array of uuid

2016-06-28 Thread M Enrique
What's a good source code entry point to review how this is working for anyarray currently? I am new to the postgres code. I spend some time looking for it but all I found is the following (which I have not been able to decipher yet). [image: pasted1] Thank you, Enrique On Tue, Jun 21, 2016

Re: [HACKERS] Gin index on array of uuid

2016-06-29 Thread M Enrique
Thank you. On Tue, Jun 28, 2016 at 11:06 PM Oleg Bartunov <obartu...@gmail.com> wrote: > On Wed, Jun 29, 2016 at 6:17 AM, M Enrique < > enrique.mailing.li...@gmail.com> wrote: > >> What's a good source code entry point to review how this is working for >

[HACKERS] Development build with uuid-ossp support - macOS

2016-09-24 Thread Enrique M
I am trying to do a macOS build of postgresql (9.6 stable branch from github) with the uuid-ossp contrib by typing "make world" but it fails due to an openjade error (I did install openjade using homebrew using this setup https://github.com/petere/homebrew-sgml). Is there a way to build

Re: [HACKERS] Development build with uuid-ossp support - macOS

2016-09-25 Thread Enrique M
I am going to try and switch to macports instead... I see the documentation provides the macports command for installing the toolset... https://www.postgresql.org/docs/9.6/static/docguide-toolsets.html Thank you. On Sat, Sep 24, 2016 at 4:52 PM Enrique M <enrique.mailing.li...@gmail.com>

Re: [HACKERS] [RFC] What would be difficult to make data models pluggable for making PostgreSQL a multi-model database?

2017-08-25 Thread Henry M
This may be interesting... they implement cypher (unfortunately they had to fork in order to have cypher be a first class query language with SQL). https://github.com/bitnine-oss/agensgraph On Mon, Aug 21, 2017 at 12:44 AM Chris Travers wrote: > On Sun, Aug 20, 2017

[HACKERS] Materialized View Summary

2004-02-24 Thread Jonathan M. Gardner
PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFAO3eZqp6r/MVGlwwRAnpEAKC8+/lFyPBbXetPEfFLwgUvJZLCmgCfYlmR 0vZmCcbGSNT/m/W8QOIhufk= =snCu -END PGP SIGNATURE- ---(end of broadcast)--- TIP 7: don't forget

Re: [HACKERS] [SQL] Materialized View Summary

2004-02-25 Thread Jonathan M. Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm not sure if my original reply made it through. Ignore the last one if it did. On Tuesday 24 February 2004 1:48 pm, Robert Treat wrote: On Tue, 2004-02-24 at 12:11, Richard Huxton wrote: On Tuesday 24 February 2004 16:11, Jonathan M. Gardner

Re: [HACKERS] [ADMIN] Any Gentoo users interested in a slotted PostgreSQL

2004-02-28 Thread Gavin M. Roy
I dont see a real need for slots, but I do question why the 7.4 branch isnt marked as stable yet. :) Gavin Jyry Kuukkanen wrote: Hello Are there any Gentoo users here? Yes, there are some :) Do you wish the PostgreSQL ebuild made use of SLOTS? - to allow installing of major

  1   2   3   >