PgSql

[HACKERS] PATCH: Minor notes in CLUSTER page
I was looking for how to undo a CLUSTER call earlier today. Nothing on the CLUSTER page told me how to do it, or pointed me to the ALTER TABLE page. I figure a pointer to would help the next person in my situation. xoxo, Andy -- Andy Lester => andy(a)petdance.com => www.petdance.com => AIM:petdance ... 6 May 2010 16:31

SELECT * in a CREATE VIEW statement doesn't updatecolumn set automatically
Tom Lane wrote: Joseph Adams <joeyadams3.14159(a)gmail.com> writes: This isn't exactly a bug, but it could be considered unintuitive behavior. It's required by the SQL standard. And many places regard "select *" in anything other than throw-away queries as bad prac... 6 May 2010 15:23

[HACKERS] SELECT * in a CREATE VIEW statement doesn't update column set automatically
This isn't exactly a bug, but it could be considered unintuitive behavior. Consider this: CREATE VIEW foo AS SELECT * FROM a; CREATE VIEW foo_v AS SELECT * FROM foo; ALTER TABLE foo ADD COLUMN b INT; The ALTER TABLE statement affects VIEW foo, but the column addition does not propagate to VIEW foo_v. Thus, ... 6 May 2010 15:23

SQLSTATE for Hot Standby cancellation
Simon Riggs <simon(a)2ndQuadrant.com> wrote: We don't have a retryable SQLSTATE, so perhaps we should document that serialization_failure and deadlock_detected are both retryable error conditions. As the above implies HS can throw some errors that are non-retyable, so we use ERRCODE_ADMIN_SHUTDOWN. The... 7 May 2010 05:39

Adding xpath_exists function
On Thu, May 6, 2010 at 10:10 AM, Mike Fowler <mike(a)mlfowler.com> wrote: Hi hackers, Although this is a very small change I figured I'd practice the policy of outlining your change before you write the code and attempt a patch submission. Essentially I see the function as a convenience function that ex... 29 Jun 2010 07:27

[HACKERS] Adding xpath_exists function
Hi hackers, Although this is a very small change I figured I'd practice the policy of outlining your change before you write the code and attempt a patch submission. Essentially I see the function as a convenience function that exposes the results of the xpath built in exists() function as a boolean for easi... 6 May 2010 10:46

[HACKERS] SQLSTATE for Hot Standby cancellation
On Thu, 2010-05-06 at 12:08 +0200, Yeb Havinga wrote: That's funny because when I was reading this thread, I was thinking the exact opposite: having max_standby_delay always set to 0 so I know the standby server is as up-to-date as possible. The application that accesses the hot standby has to be 'spec... 6 May 2010 10:46

[HACKERS] pg_stat_transaction patch
Hi, I propose a set of new statistics functions and system views. I need these functions in order to do automated testing of our system, consisting of hundreds of stored procedures in plpgsql. My plan is to develop some additional functions to pgTAP, benefiting from the new system tables I've added. The pat... 6 May 2010 10:46

LD_LIBRARY_PATH versus rpath
On Thu, May 6, 2010 at 12:20 AM, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: Now, pg_regress tries to ensure that the temporary installation will work as desired by setting LD_LIBRARY_PATH to point at the temp installation's lib/ directory.  However, the psql executable will by default get built with a DT_RPATH ent... 6 May 2010 10:47

Partitioning/inherited tables vs FKs
On May 6, 2010, at 10:52 , Boszormenyi Zoltan wrote: =# create table parent (id serial primary key, t text); ... =# create table child () inherits (parent); ... =# create table refer (id serial primary key, parent_id integer ... =# insert into child (t) values ('a') returning id; ... =# selec... 18 May 2010 07:04