On 20/03/2015 00:33, Andreas Karlsson wrote:
On 03/19/2015 04:55 PM, Julien Tachoires wrote:
On 18/03/2015 19:54, Andreas Karlsson wrote:
Looks good but I think one minor improvement could be to set the table
space of the toast entires to the same as the tablespace of the table to
reduce
On 15/03/2015 20:27, Julien Tachoires wrote:
On 15/03/2015 04:34, Andreas Karlsson wrote:
On 03/15/2015 04:25 AM, Andreas Karlsson wrote:
Nice. You will also want to apply the attached patch which fixes support
for the --no-tablespaces flag.
Just realized that --no-tablespaces need
On 15/03/2015 04:34, Andreas Karlsson wrote:
On 03/15/2015 04:25 AM, Andreas Karlsson wrote:
Nice. You will also want to apply the attached patch which fixes support
for the --no-tablespaces flag.
Just realized that --no-tablespaces need to be fixed for pg_restore too.
Indeed, after taking
On 14/03/2015 16:10, Andreas Karlsson wrote:
Noticed a bug when playing round some more with pg_dump. It does not
seem to dump custom table space for the table and default table space
for the toast correctly. It forgets about the toast table being in
pg_default.
Good catch. This is now
Hi,
On 10/03/2015 00:31, Andreas Karlsson wrote:
On 03/03/2015 04:14 PM, Julien Tachoires wrote:
Sorry for the delay, I missed this thread.
Here is a new version of this patch considering Andreas' comments.
Please also add it to the next open commitfest so we do not lose the patch.
Here
On 10/03/2015 13:27, Alvaro Herrera wrote:
Robert Haas wrote:
On Mon, Mar 9, 2015 at 7:26 PM, Andreas Karlsson andr...@proxel.se wrote:
I think we should allow moving the indexes for consistency. With this patch
we can move everything except for TOAST indexes.
It might make sense to always
Hi,
Sorry for the delay, I missed this thread.
Here is a new version of this patch considering Andreas' comments.
On 30/12/2014 03:48, Andreas Karlsson wrote:
- A test fails in create_view.out. I looked some into it and did not see
how this could happen.
***
there is no DEFAULT the parser/rewriter should set the column/subfield
to NULL.
Is build_column_default() the right place to handle that case ?
--
Julien Tachoires
http://dalibo.com - http://dalibo.org
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
2012/10/8 Tom Lane t...@sss.pgh.pa.us:
Julien Tachoires jul...@gmail.com writes:
About \ds behaviour, I think to add 2 columns :
- 'LastValue'
- 'Increment'
That would make the command a great deal slower, since it would have to
access each sequence to get that info. I don't object
2012/10/8 Robert Haas robertmh...@gmail.com:
On Mon, Oct 8, 2012 at 3:49 AM, Julien Tachoires jul...@gmail.com wrote:
2012/10/8 Tom Lane t...@sss.pgh.pa.us:
Julien Tachoires jul...@gmail.com writes:
About \ds behaviour, I think to add 2 columns :
- 'LastValue'
- 'Increment'
That would make
2012/10/8 Tom Lane t...@sss.pgh.pa.us:
Julien Tachoires jul...@gmail.com writes:
2012/10/8 Tom Lane t...@sss.pgh.pa.us:
The other problem you're going to have here is that there is in fact no
such command as \ds (nor \ds+); rather, it's a special case of
\dtsvi. As such, putting any relkind
Hi,
I would like to work on psql \ds improvements. Here's my idea :
- in src/bin/psql/describe.c, add a new function :
listSequences(*pattern, verbose) wich will list sequences and remove
code related to sequences from listTables()
- in src/bin/psql/command.c, call listSequences() on \ds
- about
2012/1/24 Robert Haas robertmh...@gmail.com:
On Sun, Jan 22, 2012 at 11:04 AM, Julien Tachoires jul...@gmail.com wrote:
2011/12/15 Alvaro Herrera alvhe...@commandprompt.com:
Uhm, surely you could compare the original toast tablespace to the heap
tablespace, and if they differ, handle
Hi,
2012/1/16 Alvaro Herrera alvhe...@commandprompt.com:
Excerpts from Jaime Casanova's message of lun ene 16 03:23:30 -0300 2012:
On Tue, Dec 13, 2011 at 12:29 PM, Julien Tachoires jul...@gmail.com wrote:
OK, considering that, I don't see any way to handle the case raised by
Jaime
2011/12/13 Jaime Casanova ja...@2ndquadrant.com:
On Mon, Dec 12, 2011 at 10:54 AM, Julien Tachoires jul...@gmail.com wrote:
2011/12/10 Jaime Casanova ja...@2ndquadrant.com:
On Mon, Nov 28, 2011 at 1:32 PM, Julien Tachoires jul...@gmail.com wrote:
2) after CLUSTER the index of the toast table
2011/12/13 Robert Haas robertmh...@gmail.com:
On Tue, Dec 13, 2011 at 12:02 PM, Julien Tachoires jul...@gmail.com wrote:
Right, it seems to happen when the destination tablespace is the same
as the database's tbs, because, in this case, relation's tbs is set to
InvalidOid :
src/backend
Hi,
2011/12/10 Jaime Casanova ja...@2ndquadrant.com:
On Mon, Nov 28, 2011 at 1:32 PM, Julien Tachoires jul...@gmail.com wrote:
2) after CLUSTER the index of the toast table gets moved to the same
tablespace as the main table
there is still a variant of this one, i created 3 tablespaces
Hi,
Here's a patch to allow TOAST tables to be moved to a different
tablespace. This item has been picked up from the TODO list.
Main idea is to consider that a TOAST table can have its own tablespace.
Regards,
--
JT
diff --git a/doc/src/sgml/ref/alter_table.sgml
18 matches
Mail list logo