[BUGS] BUG #7706: Can slave database supports creating temporary tables?
The following bug has been logged on the website: Bug reference: 7706 Logged by: wilson Email address: wil...@leyou.com PostgreSQL version: 9.2.1 Operating system: debian Description: Hi Dears, In M/S mode,Slave database can't create temporary tables right now,just support read only access.But sometimes,for support some complex queries,we need create some temp tables actually. So I suggest postgresql slave node can support create temp tables in the next version,that'll be great!!! Thanks! -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7703: Error with partitioning with distinct over aggregate
maxim.bo...@gmail.com writes: > test=# create table test (id serial); > NOTICE: CREATE TABLE will create implicit sequence "test_id_seq" for serial > column "test.id" > CREATE TABLE > test=# create index test_id_key on test(id); > CREATE INDEX > test=# create table test_part_1 (like test including all) INHERITS (test); > NOTICE: merging column "id" with inherited definition > CREATE TABLE > test=# explain analyze select distinct min(id) from test; > ERROR: failed to re-find MinMaxAggInfo record Fixed, thanks for the report. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7706: Can slave database supports creating temporary tables?
On Mon, Nov 26, 2012 at 01:59:44PM +, wil...@leyou.com wrote: > The following bug has been logged on the website: > > Bug reference: 7706 > Logged by: wilson > Email address: wil...@leyou.com > PostgreSQL version: 9.2.1 > Operating system: debian > Description: > > Hi Dears, > In M/S mode,Slave database can't create temporary tables right now,just > support read only access.But sometimes,for support some complex queries,we > need create some temp tables actually. > So I suggest postgresql slave node can support create temp tables in the > next version,that'll be great!!! Well, because the slave is read-only, we have not figured out how to enable creation of temporary tables on the slave. It isn't even on our TODO list because we have no idea how we would do it. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7703: Error with partitioning with distinct over aggregate
On Tue, Nov 27, 2012 at 5:01 AM, Tom Lane wrote: > maxim.bo...@gmail.com writes: >> test=# create table test (id serial); >> NOTICE: CREATE TABLE will create implicit sequence "test_id_seq" for serial >> column "test.id" >> CREATE TABLE >> test=# create index test_id_key on test(id); >> CREATE INDEX >> test=# create table test_part_1 (like test including all) INHERITS (test); >> NOTICE: merging column "id" with inherited definition >> CREATE TABLE >> test=# explain analyze select distinct min(id) from test; >> ERROR: failed to re-find MinMaxAggInfo record > > Fixed, thanks for the report. > > regards, tom lane Thank you very much. PS: I know that the query sounds stupid, but most CMS/ORM unfortunately could produce unlimited amount of strange/stupid queries. -- Maxim Boguk Senior Postgresql DBA http://www.postgresql-consulting.ru/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
