PgSql

"\ef <function>" in psql
Abhijit Menon-Sen <ams(a)oryx.com> writes: Refactoring pg_dump was more work than I had time to do right now, and I wanted \ef to work, so I hacked up the attached (by copying dumpFunc and its dependencies to src/bin/psql/dumpfunc.[ch]). I doubt we'd consider accepting a patch done this way. regards, to... 4 Aug 2008 13:37

Hint Bits and Write I/O
Added to TODO: * Consider decreasing the I/O caused by updating tuple hint bits http://archives.postgresql.org/pgsql-hackers/2008-05/msg00847.php --------------------------------------------------------------------------- Simon Riggs wrote: After some discussions at PGCon, I'd like to make some pro... 15 Jul 2008 10:14

Is there anyway to create a TupleDesc with uint32 attribute easily?
Hi, hackers. I'm working on my gsoc project - improving hash index. I need to create a TupldeDesc with uint32 attribute. Here is the reason why I need it - If we store hash code only in the tuple, then the TupleDesc's attribute should be uint32. In this way, we can use index_form_tuple() to create a tuple and ne... 15 Jul 2008 11:16

DROP ROLE dependency tracking ...
Alvaro Herrera wrote: Hans-Juergen Schoenig wrote: when thinking of REASSIGNED OWNED people tend to think about tables rather than about CONNECT rights. i would suggest to make DROP ROLE just kill the role unless there is a real object depending on it. i would not see a permission to... 15 Jul 2008 01:02

TODO item: Have psql show current values for asequence
Wow. I adjusted the patch slightly and applied it; the updated version is attached. We have been waiting for this to be done for quite some time. Thanks. --------------------------------------------------------------------------- Dickson S. Guedes wrote: Hi all, These patch implements the TODO... 15 Jul 2008 00:00

idea: storing view source in system catalogs
Added to TODO: * Improve ability to modify views via ALTER TABLE http://archives.postgresql.org/pgsql-hackers/2008-05/msg00691.php --------------------------------------------------------------------------- Robert Haas wrote: I think the real problem here is that PostgreSQL is very finicky about... 14 Jul 2008 19:54

A note about proargmodes and Pavel's pending patches
Awhile back I was objecting to Pavel's table-function patch on the grounds that it introduced a new proargmodes value (thereby breaking every client that looks at proargmodes) for what seemed to me to be entirely insignificant benefits. I still consider that patch mostly useless syntactic sugar, but that particula... 14 Jul 2008 13:42

Postgres-R source code release
Dear Hackers, it has been two years, since I've presented my work on Postgres-R for the first time to a broader audience in Toronto. I continued maintaining that code in my spare time, but to be honest, I didn't have much time for it. As much as I'd like to change that, I now think the best thing for the ... 17 Jul 2008 02:25

Building under Visual Studio 2008 - pqcomm.c compile error
"Knight, Doug" <dknight(a)wsi.com> writes: I am attempting to build postgres 8.3.3 under Visual Studio 2008, and I get the following error in the build: .\src\backend\libpq\pqcomm.c(389): error C2065: 'IPPROTO_IPV6' : undeclared identifier [ squint... ] They define IPV6_V6ONLY and AF_INET6 but not IPPR... 14 Jul 2008 14:44

testing locales and encodings
Andrew Dunstan wrote: Some time ago I raised the question of doing locale- and encoding-aware regression tests, and IIRC the consensus seemed to be that it was not worth the effort, but maybe we need to revisit that. We certainly seem to be doing a lot more work now to get Postgres to where it needs... 14 Jul 2008 14:44