On Fri, Aug 26, 2005 at 03:44:18PM -0400, Bruce Momjian wrote:
> Jim C. Nasby wrote:
> > I *think* this is reffering to how pg_dump makes some assumptions about
> > what things are system objects.
> >
> > http://archives.postgresql.org/pgsql-committers/2005-08/msg00203.php
> > doesn't help a heck
Andrew Dunstan wrote:
>
>
> Tom Lane wrote:
>
> >Or perhaps use a different separator:
> >
> >junk=# select * from xyz;
> > id |name| address | del_addr
> >++---+--
> >
Jim C. Nasby wrote:
> I *think* this is reffering to how pg_dump makes some assumptions about
> what things are system objects.
>
> http://archives.postgresql.org/pgsql-committers/2005-08/msg00203.php
> doesn't help a heck of a lot...
>
> Can we add an interface to the TODO list that contains sea
Hannu Krosing wrote:
> On K, 2005-08-24 at 21:58 -0400, Tom Lane wrote:
> > > * %Allow TRUNCATE ... CASCADE/RESTRICT
> >
> > Huh? What would that do?
>
> Maybe this was meant truncating of tables with dependent foreign keys ?
>
> AFAIR this was solved by allowing truncating several tables in on
Alvaro Herrera wrote:
> On Thu, Aug 25, 2005 at 01:53:32PM -, Greg Sabino Mullane wrote:
>
> > Tom Lane asked:
> >
> > >> o Improve psql's handling of multi-line queries
> >
> > > Uh, what's wrong with it? This item seems far too vague.
> >
> > I think perhaps this means adding multi
Great updates! Let me comment on each one.
> I made a pass over the TODO list to see what was out of date.
>
> > * Allow administrators to safely terminate individual sessions either
> > via an SQL function or SIGTERM
> >
> > Currently SIGTERM of a backend can lead to lock table corruptio
On Aug 25, 2005, at 11:29 PM, Matt Miller wrote:
On Thu, 2005-08-25 at 15:50 +0900, Michael Glaesemann wrote:
* %Remove CREATE CONSTRAINT TRIGGER
Do we really want to remove it,
Also, I believe CONSTRAINT TRIGGERS are the only way to provide
transaction level (rather than statement
On Wed, Aug 24, 2005 at 09:58:04PM -0400, Tom Lane wrote:
> > * %Allow RULE recompilation
>
> Eh? Perhaps you meant "automatically regenerate cached plans when
> needed", in which case it's redundant with the Dependency Checking
> entries. Whatever it means, this doesn't seem a particularly simp
Tom Lane wrote:
Or perhaps use a different separator:
junk=# select * from xyz;
id |name| address | del_addr
++---+--
1 | Joe Bloggs | 1 Hindhead Villas,
Oliver Elphick writes:
> It would be better to show the columns aligned (perhaps without showing
> separators for other columns so as not to give the impression that the
> other columns contain null or empty strings):
> junk=# select * from xyz;
> id |name| address
On Thu, 2005-08-25 at 13:53 +, Greg Sabino Mullane wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
> Tom Lane asked:
>
> >> o Improve psql's handling of multi-line queries
>
> > Uh, what's wrong with it? This item seems far too vague.
If you enter a multi-line query one
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane asked:
>> o Improve psql's handling of multi-line queries
> Uh, what's wrong with it? This item seems far too vague.
I think perhaps this means adding multi-line support to
the tab-completion? Only thing I can think of, cause other
On Thu, Aug 25, 2005 at 01:53:32PM -, Greg Sabino Mullane wrote:
> Tom Lane asked:
>
> >> o Improve psql's handling of multi-line queries
>
> > Uh, what's wrong with it? This item seems far too vague.
>
> I think perhaps this means adding multi-line support to
> the tab-completion? O
On Thu, 2005-08-25 at 15:50 +0900, Michael Glaesemann wrote:
> >> * %Remove CREATE CONSTRAINT TRIGGER
> >>
> > Do we really want to remove it,
>
> Also, I believe CONSTRAINT TRIGGERS are the only way to provide
> transaction level (rather than statement level) referential
> integrity.
Don't d
On Wed, 2005-08-24 at 21:58, Tom Lane wrote:
> > o Add pg_dumpall custom format dumps.
> >
> > This is probably best done by combining pg_dump and pg_dumpall
> > into a single binary.
>
> This is probably obsoleted by events, too. Now that we can dump blobs
> in text mode, I see
On K, 2005-08-24 at 21:58 -0400, Tom Lane wrote:
> > * %Allow TRUNCATE ... CASCADE/RESTRICT
>
> Huh? What would that do?
Maybe this was meant truncating of tables with dependent foreign keys ?
AFAIR this was solved by allowing truncating several tables in one
command even if they have FK relati
On Aug 25, 2005, at 10:58 AM, Tom Lane wrote:
* %Remove CREATE CONSTRAINT TRIGGER
This was used in older releases to dump referential integrity
constraints.
Do we really want to remove it, and thereby guarantee we can't load
dumps from those old releases?
Also, I believe CONSTRAINT TR
Kris Jurka <[EMAIL PROTECTED]> writes:
> On Wed, 24 Aug 2005, Tom Lane wrote:
>> This is done (see bitmap index scans).
> Will the optimizer ever choose this plan when dealing with only one index?
Certainly. It's actually likely to prefer a bitmap scan whenever the
query is estimated to fetch mo
On Wed, 24 Aug 2005, Tom Lane wrote:
* Fetch heap pages matching index entries in sequential order
Rather than randomly accessing heap pages based on index entries, mark
heap pages needing access in a bitmap and do the lookups in sequential
order. Another method would be to sort heap ct
19 matches
Mail list logo
