On Fri, 2011-07-08 at 12:34 -0700, Darren Duncan wrote:
Yes, but that would just be in-memory or in temporary places external to
every
database. On disk internal to a database there would just be the oid. In
fact,
another aspect of the database model I defined is that each database is
Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
If for some reason we needed to have tables that happened to be called
x.y.z and a.b.c accessible from a single SQL session, we could allow
that much more simply by allowing schemas to be nested. Then we could
allow arbitrary numbers of
2011/7/8 Noah Misch n...@2ndquadrant.com:
On Fri, Jul 08, 2011 at 09:20:46AM +0100, Kohei KaiGai wrote:
2011/7/7 Noah Misch n...@2ndquadrant.com:
On Thu, Jul 07, 2011 at 03:56:26PM +0100, Kohei KaiGai wrote:
2011/7/7 Noah Misch n...@2ndquadrant.com:
On Wed, Jul 06, 2011 at 10:25:12PM
2011/7/9 Robert Haas robertmh...@gmail.com:
On Fri, Jul 8, 2011 at 9:06 AM, Kohei KaiGai kai...@kaigai.gr.jp wrote:
I definitely agree with this idea. It will enables to eliminate ugly switch
statements for error-messaging reasons.
All right, so please submit a patch that introduces that
On Fri, 2011-07-08 at 21:04 -0700, Darren Duncan wrote:
I think you should make more of an effort to understand how the system
works now, and why, before proposing radical redesigns.
Well yes, of course. But that will take time and I think I already
understand
enough about it to make
2011/7/9 Robert Haas robertmh...@gmail.com:
On Fri, Jul 8, 2011 at 4:57 PM, Noah Misch n...@2ndquadrant.com wrote:
Note that it does not matter whether we're actually doing an index scan -- a
seq
scan with a filter using only leakproof operators is equally acceptable.
What I
had in mind
On Sat, Jul 09, 2011 at 09:00:30AM +0200, Kohei KaiGai wrote:
The attached patch is a revised version according to the approach that updates
pg_class system catalog before AlterTableInternal().
It invokes the new ResetViewOptions when rel-rd_options is not null, and it
set
null on the
2011/7/9 Noah Misch n...@2ndquadrant.com:
On Sat, Jul 09, 2011 at 09:00:30AM +0200, Kohei KaiGai wrote:
The attached patch is a revised version according to the approach that
updates
pg_class system catalog before AlterTableInternal().
It invokes the new ResetViewOptions when rel-rd_options
On Sat, Jul 09, 2011 at 10:52:33AM +0200, Kohei KaiGai wrote:
2011/7/9 Noah Misch n...@2ndquadrant.com:
On Sat, Jul 09, 2011 at 09:00:30AM +0200, Kohei KaiGai wrote:
The attached patch is a revised version according to the approach that
updates
pg_class system catalog before
hi,
would it be possible to incorporate
http://www.postgres.cz/index.php/Enhanced-psql in core PostgreSQL/psql?
This patch adds lots of nice functionalities, which we could definitely
use.
Best regards,
depesz
--
The best thing about modern society is how easy it is to avoid contact with it.
2011/7/5 Hitoshi Harada umi.tan...@gmail.com:
2011/7/5 Yeb Havinga yebhavi...@gmail.com:
Hello Hitosh, list,
Attached is revised version.
I failed to attached the patch. I'm trying again.
I'm currently unable to test, since on holiday. I'm happy to continue
testing once returned but it
2011/6/19 Hitoshi Harada umi.tan...@gmail.com:
2011/6/17 Andrew Tipton andrew.t.tip...@gmail.com:
At this point I'm a bit lost -- while pg_amop.h has plenty of examples
of crosstype comparison operators for btree index methods, there are
none for GiST. Is GiST somehow a special case in this
On Fri, 2011-07-08 at 23:39 -0700, Darren Duncan wrote:
What if you used the context of the calling code and resolve in favor of
whatever match is closest to it? The problem is related to general-purpose
programming languages.
Basically start looking in the lexical context for an x and if
On Fri, 2011-07-08 at 22:51 -0400, Robert Haas wrote:
I'm wondering if we might want to call this out with a note or
similar... especially if we're only going to put it into the 9.0
docs.
Sure, sounds good.
Regards,
Jeff Davis
--
Sent via pgsql-hackers mailing list
On 2011-07-09 16:23, Hitoshi Harada wrote:
2011/7/5 Hitoshi Haradaumi.tan...@gmail.com:
2011/7/5 Yeb Havingayebhavi...@gmail.com:
Hello Hitosh, list,
Attached is revised version.
I failed to attached the patch. I'm trying again.
I'm currently unable to test, since on holiday. I'm happy to
On tor, 2011-07-07 at 17:34 -0400, Alvaro Herrera wrote:
The attached patch introduces pg_constraint rows for NOT NULL
column constraints.
The information schema views check_constraints and table_constraints
currently make up some artificial constraint names for not-null
constraints. I suppose
Jeff Davis wrote:
On Fri, 2011-07-08 at 23:39 -0700, Darren Duncan wrote:
What if you used the context of the calling code and resolve in favor of
whatever match is closest to it? The problem is related to general-purpose
programming languages.
Basically start looking in the lexical context
It bit rotted a bit find a new version attached that includes the
following fixes:
- show_session_authorization() no longer exists, instead access the
session_authorization_guc directly (like we do for show_role in
commands/variable.c). I find it quite ugly tho...
- it changed %u to %U and %U to
2011/7/9 hubert depesz lubaczewski dep...@depesz.com:
hi,
would it be possible to incorporate
http://www.postgres.cz/index.php/Enhanced-psql in core PostgreSQL/psql?
This patch adds lots of nice functionalities, which we could definitely
use.
Some features are very interesting but I I would
On Sat, Jul 9, 2011 at 5:29 AM, hubert depesz lubaczewski
dep...@depesz.com wrote:
hi,
would it be possible to incorporate
http://www.postgres.cz/index.php/Enhanced-psql in core PostgreSQL/psql?
This patch adds lots of nice functionalities, which we could definitely
use.
big part of this
On Sat, Jul 9, 2011 at 8:14 PM, Jaime Casanova ja...@2ndquadrant.com wrote:
On Sat, Jul 9, 2011 at 5:29 AM, hubert depesz lubaczewski
dep...@depesz.com wrote:
hi,
would it be possible to incorporate
http://www.postgres.cz/index.php/Enhanced-psql in core PostgreSQL/psql?
This patch adds lots
Excerpts from Robert Haas's message of vie jul 08 23:30:10 -0400 2011:
On Thu, Jul 7, 2011 at 5:34 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
The attached patch introduces pg_constraint rows for NOT NULL
column constraints.
This patch is a heavily reworked version of Bernd
Shigeru Hanada escribió:
(2011/06/26 18:34), Kohei KaiGai wrote:
I checked your patch.
Thanks for the review! Please find attached a revised patch.
Err, \dec seems to have a line in describe.h but nowhere else; are you
going to introduce that command?
The new ALTER TABLE grammar seems a
Can someone help me understand pg_locks? There are three fields related
to virtual and real xids:
virtualtransaction | text |
transactionid | xid |
virtualxid | text |
Our docs say 'virtualtransaction' is:
Virtual ID of the transaction that is holding or
Excerpts from Jeff Davis's message of vie jul 08 00:58:20 -0400 2011:
On Thu, 2011-07-07 at 12:36 -0400, Robert Haas wrote:
I think it's probably too late to go fiddling with the behavior of 9.0
at this point. If we change the text of error messages, there is a
chance that it might break
25 matches
Mail list logo