PgSql

[HACKERS] Documentation Bug/Misnomer?
Greetings, Under: http://developer.postgresql.org/pgdocs/postgres/runtime-config-file-locations.html We have: ident_file (string) Specifies the configuration file for ident authentication (customarily called pg_ident.conf). This parameter can only be set at server start. That's not really accu... 18 May 2010 13:40

[HACKERS] Clarifications of licences on pgfoundry
I notice that there are more than a few projects on pgfoundry that are marked as "BSD licence" but then the project files don't contain any mention of the licence details. In some cases, projects are also clearly marked Copyright of people or organizations. For example, pg_batch is clearly marked "BSD licence",... 18 May 2010 02:45

[HACKERS] New buildfarm client release
I have just released version 4.0 of the PostgreSQL Buildfarm client. There are two new features: * The SCM code is substantially rearranged into a separate OO module, with subclasses supporting CVS and Git. New config options support these changes, while old style config parameters for CVS ... 17 May 2010 23:29

New buildfarm client release
On Mon, May 17, 2010 at 7:00 PM, Andrew Dunstan <andrew(a)dunslane.net> wrote: I have just released version 4.0 of the PostgreSQL Buildfarm client. There are two new features:   * The SCM code is substantially rearranged into a separate OO     module, with subclasses supporting CVS and Git. New co... 17 May 2010 21:19

SELECT * in a CREATE VIEW statement doesn't update column set automatically
On May 6, 2010, at 4:29 PM, Merlin Moncure wrote: On Thu, May 6, 2010 at 3:23 PM, Andrew Dunstan <andrew(a)dunslane.net> wrote: And many places regard "select *" in anything other than throw-away queries as bad practice anyway. I have seen people get bitten by it over and over again, and I have worked at c... 17 May 2010 15:47

[HACKERS] errcontext from PL/pgSQL (was message style for errcontext)
On May 17, 2010, at 11:20 AM, Peter Eisentraut wrote: We have in 9.0 plperl.c errcontext("while executing PostgreSQL::InServer::SPI::bootstrap"))); errcontext("while parsing Perl initialization"))); errcontext("while running Perl initialization"))); errcontext("While executing PLC_TRUSTED."))); ... 17 May 2010 15:47

message style for errcontext
Peter Eisentraut <peter_e(a)gmx.net> writes: We have in 9.0 plperl.c errcontext("while executing PostgreSQL::InServer::SPI::bootstrap"))); errcontext("while parsing Perl initialization"))); errcontext("while running Perl initialization"))); errcontext("While executing PLC_TRUSTED."))); errcontext("While... 17 May 2010 15:47

[HACKERS] message style for errcontext
We have in 9.0 plperl.c errcontext("while executing PostgreSQL::InServer::SPI::bootstrap"))); errcontext("while parsing Perl initialization"))); errcontext("while running Perl initialization"))); errcontext("While executing PLC_TRUSTED."))); errcontext("While executing utf8fix."))); errcontext("While executing ... 17 May 2010 14:39

release notes
Andrew Dunstan <andrew(a)dunslane.net> writes: Why do the release notes say this, under plperl: * PL/Perl subroutines are now given names (Tim Bunce) This is for the use of profiling and code coverage tools. DIDN'T THEY HAVE NAMES BEFORE? If whoever put this in the release notes had bothe... 9 Jun 2010 15:20

Row-level Locks & SERIALIZABLE transactions, postgres vs. Oracle
On May 14, 2010, at 16:32 , Kevin Grittner wrote: Florian Pflug <fgp(a)phlo.org> wrote: I must admit that I wasn't able to find an explicit reference to Oracle's behavior in their docs, so I had to resort to experiments. They do have examples showing how to do FK-like constraints with triggers,... 17 May 2010 00:31