[BUGS] BUG #7858: Inaccurate Log Message

2013-02-07 Thread jackie . qq . zhang
The following bug has been logged on the website: Bug reference: 7858 Logged by: Jackie Zhang Email address: jackie.qq.zh...@gmail.com PostgreSQL version: 9.1.4 Operating system: Ubuntu Description: Hi, The log message of the sanity check for "superuser_reserved_conn

[BUGS] BUG #7857: postgresql91-libs fails to create ld.so.conf.d symlink

2013-02-07 Thread chris . meisinger
The following bug has been logged on the website: Bug reference: 7857 Logged by: Chris Meisinger Email address: chris.meisin...@centro.net PostgreSQL version: 9.1.8 Operating system: CentOS 6.3 Description: 1. Provision a fresh machine (CentOS 6) 2. Perform a yum upd

Re: [BUGS] Why does FK creation still take an access exclusive lock on the referenced table?

2013-02-07 Thread Tom Lane
Josh Berkus writes: > I understand why establishing an FK needs an ExclusiveLock on the > referenced table, but it doesn't need an AccessExclusiveLock. Yes, it does, because it's adding triggers. We can't improve this in the near term, and complaining about it doesn't change that. At the very l

[BUGS] Why does FK creation still take an access exclusive lock on the referenced table?

2013-02-07 Thread Josh Berkus
Folks, I'd thought this was fixed with some of the ALTER changes in 9.2, but apparently not (9.2.2): SESSION1: sampledata=# create table test1 ( id int not null primary key ); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "test1_pkey" for table "test1" CREATE TABLE Time: 55.224