PgSql

[HACKERS] Release Notes 9.0: substring() changes?
In the 9.0devel release notes http://developer.postgresql.org/pgdocs/postgres/release-9-0.html under E.1.2.3. String Handling three changes are mentioned, and for the first two changes it is said that substring() is "affected": ------------8<------------ 1 Properly treat ^ and $ as literals in SI... 4 Apr 2010 18:11

[HACKERS] Nice hint on table aliasing!
All, Not sure when this happened, but someone added a very informative hint for the case where you ambiguously refer to a base table name when you needed to refer to the alias. Nice work, we should do more of this helpful hinting. -- -- Josh Berkus ... 4 Apr 2010 17:04

make check hangs in alpha5
Hitoshi Harada <umi.tanuki(a)gmail.com> writes: I cannot figure out at all what is wrong. Have any idea? Since nobody else is reporting this, it seems like it must be either something messed up about your system, or something wrong with your copy of the PG sources. In the latter connection I confess to having l... 5 Apr 2010 21:42

"pg_stat_tmp/pgstat.stat": Stale NFS file handle
Jaime Casanova <jcasanov(a)systemguards.com.ec> writes: + WARNING: could not open statistics file "pg_stat_tmp/pgstat.stat": Stale NFS file handle this is an ext2 filesystem in an external hard drive, could be fs corruption? Evidently the kernel is confused. It seems more like busted in-memory state than... 4 Apr 2010 14:51

[HACKERS] "pg_stat_tmp/pgstat.stat": Stale NFS file handle
Hi, i was running installcheck on a 9.0 installation and get 6 failed tests, but when reading the regression.diff i found a lot of this messages: """ + WARNING: could not open statistics file "pg_stat_tmp/pgstat.stat": Stale NFS file handle """ and when listing the file i get this: """ postgres(a)casanova1... 4 Apr 2010 01:46

default privileges
Jaime Casanova <jcasanov(a)systemguards.com.ec> writes: I create some default privileges, now i'm trying to drop those roles but i get this error: mic=# drop role jcm; ERROR: role "jcm" cannot be dropped because some objects depend on it DETAIL: owner of default privileges on new relations belonging to... 4 Apr 2010 22:35

[HACKERS] default privileges
Hi, I create some default privileges, now i'm trying to drop those roles but i get this error: """ mic=# drop role jcm; ERROR: role "jcm" cannot be dropped because some objects depend on it DETAIL: owner of default privileges on new relations belonging to role jcm in schema public """ So i look for defau... 3 Apr 2010 17:02

\d commands in psql 9.0
Jaime Casanova <jcasanov(a)systemguards.com.ec> writes: are we requiring a space between the command and it's first parameter? Yes. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hack... 3 Apr 2010 17:02

[HACKERS] \d commands in psql 9.0
Hi, Seems like \dd and \ddp+ gives the same answer... The reason this is misleading is that \ddp is a command and i was trying to get extra info with \ddp+ (which doesn't exist) are we requiring a space between the command and it's first parameter? -- Atentamente, Jaime Casanova Soporte y capacitación d... 3 Apr 2010 17:02

[HACKERS] fallback_application_name and pgbench
Hi, By default, the application_name of pgbench is "[unknown]". But I think that pgbench should use fallback_application_name as psql, pg_dump, etc does. Is it worth creating the patch? Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgs... 3 Apr 2010 17:02