Bruce Momjian [EMAIL PROTECTED] writes:
pg_class.relacl is of type aclitem[] and has a pg_attribute.attstorage
of 'x', even though it doesn't support TOAST expansion:
It can't be toasted because pg_class hasn't got a toast table. I can't
recall at the moment whether there's a fundamental
Hi,
Am Mittwoch, 3. September 2003 20:16 schrieb Bruce Momjian:
...
As for the IPv6 issue --- how prevalent is this problem. What OS
versions are affected? Has the user done something special to enable
this?
I have a SuSE 8.2 out of the box. I have done nothing with IPv6. I don't even
Hi!
Thanks to all who have replied (privately or via the list), it seems sometimes
it's just necessary to be a bit insistant!
That said, I'm positively surprised by what has been done already (especially
Bruce and Marc, this is really a GoodThing to have the web page and the
list).
I'm
Joerg Hessdoerfer kirjutas N, 04.09.2003 kell 10:22:
I'm currently in the process of setting up my development environment (how the
heck do I get bison/flex to compile under MingW/MSYS? Oh my...)
there is a precompiled bison in the MinGW filelist
http://www.mingw.org/download.shtml#hdr2
dunno
On Thu, 4 Sep 2003, Bruce Momjian wrote:
Tom Lane wrote:
Matthew T. O'Connor [EMAIL PROTECTED] writes:
... Initially I saw an error in the logs about an IPv6 address
error but after I recompiled everthing with a simple ./configure
--prefix=/home/user/somethingelse/ I didn't get the
On Wed, Sep 03, 2003 at 11:31:55PM -0400, Bruce Momjian wrote:
Yes, I like the transaction status being the default prompt, but I don't
like the prompt shifting. Remember guys who have the current directory
in their prompt --- the thing bounces around all over the place.
Is that avoidable
Hans,
You are right about the startup memory - here is the top line for a few
seconds after startup :
PID USER PR NI VIRT RES SHR S %CPU %MEMTIME+
COMMAND
10116 postgres 15 0 3816 3816 3180 R 33.8 1.0 0:01.03 postmaster
seems that VIRT, RES, SHR all get the
Tommi Maekitalo wrote:
Users expect, that it works just after installation. But after following the
discussion I think, that it is not so much a problem. I have 127.0.0.1 in my
pg_hba.conf and when I set PGHOST to 127.0.0.1 it workes. If I set PGHOST to
localhost, it resolves to ::1, wich
Hi,
just want to verify first with you guys before dumping it on the bugs
list. Most likely I am just being silly here or something.
Take this:
create table blah (name TEXT CHECK (name IN ('blah', 'bleh')));
test=# \d blah
Table public.blah
Column | Type | Modifiers
Jeroen Ruigrok/asmodai [EMAIL PROTECTED] writes:
just want to verify first with you guys before dumping it on the bugs
list. Most likely I am just being silly here or something.
The ALTER ADD CONSTRAINT form creates a table constraint, ie, one that's
not attached to any particular column. If
Jeroen Ruigrok/asmodai wrote:
Hi,
just want to verify first with you guys before dumping it on the bugs
list. Most likely I am just being silly here or something.
Take this:
create table blah (name TEXT CHECK (name IN ('blah', 'bleh')));
test=# \d blah
Table public.blah
Column | Type |
(Perhaps a newbie question, but I tried to google this out without success).
Why postgres does an expensive seqscan to find the max(value) for an indexed
column? I think MAX() does not know or cares if a column is indexed, but...
Should not it? BTW, is there some smarter trick to do that?
I know
On 4 Sep 2003 at 11:32, Paulo Scardine wrote:
(Perhaps a newbie question, but I tried to google this out without success).
Why postgres does an expensive seqscan to find the max(value) for an indexed
column? I think MAX() does not know or cares if a column is indexed, but...
Should not it?
On Thu, 4 Sep 2003, Shridhar Daithankar wrote:
column? I think MAX() does not know or cares if a column is indexed, but...
No. Postgresql uses MVCC which mean there could be multiple views of sample
tuple active at the same time. There is no way to tell which is max. value for
a column
Joerg Hessdoerfer wrote:
Hi!
Thanks to all who have replied (privately or via the list), it seems sometimes
it's just necessary to be a bit insistant!
That said, I'm positively surprised by what has been done already (especially
Bruce and Marc, this is really a GoodThing to have the web
This is an FAQ, BTW -- try searching the archives again. It's also
mentioned in the documentation:
http://candle.pha.pa.us/main/writings/pgsql/sgml/functions-aggregate.html
On Thu, 2003-09-04 at 11:10, Dennis Bjorklund wrote:
On Thu, 4 Sep 2003, Shridhar Daithankar wrote:
It can not be
Hello
In my opinion, in 7.4 this optimized max() aggregate function would be a
very small, but significant improvement. As one of the members on the list
said, it would be a lot easier to port from/to other RDBMSes, with keeping
the same optimalization of the queries.
Bye,
Gergely Czuczy
Should this produce a warning?
nconway=# create table a (b int4 unique);
NOTICE: CREATE TABLE / UNIQUE will create implicit index a_b_key for
table a
CREATE TABLE
nconway=# create table c (d int8 references a (b));
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
Shridhar Daithankar [EMAIL PROTECTED] writes:
On 4 Sep 2003 at 11:32, Paulo Scardine wrote:
(Perhaps a newbie question, but I tried to google this out without success).
Why postgres does an expensive seqscan to find the max(value) for an indexed
column? I think MAX() does not know or
If my memory serves me well, Oracle has a number of system triggers. On
database startup and shutdown and perhaps also on connection start and
stop.
Sometimes they're very handy.
Is this a TODO? Is there an API that would make sense for us?
I believe it would make sense. But I'm not
I thing I haven't seen asked: is there a packet filter blocking
local-local UDP traffic by any chance?
Iptables is set to accept everything. If it would help I can give you all
log in information to poke around yourselves. I appreciate your help.
--- Adam Kavan
--- [EMAIL PROTECTED]
On Wed, Sep 03, 2003 at 10:30:05PM -0400, Tom Lane wrote:
tablecmds.c: In function `validateForeignKeyConstraint':
tablecmds.c:3546: warning: dereferencing type-punned pointer will break
strict-aliasing rules
Hm. Got any idea what these are really complaining about? I see no
such
Tom Lane writes:
Bruce Momjian [EMAIL PROTECTED] writes:
Can we allow the IPv6 entries to be in pg_hba.conf but ignore them on
non-IPv6 machines, or allow the connection to fail?
I don't see a good way yet. The fly in the ointment is that HAVE_IPV6
is set by configure based on the
Joerg Hessdoerfer writes:
I'm currently in the process of setting up my development environment (how the
heck do I get bison/flex to compile under MingW/MSYS? Oh my...),
Use the Cygwin tools.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of
Greg Stark wrote:
It has nothing to do with MVCC. It has to do with implementing this is hard in
the general case.
Think of examples like:
select max(foo) group by bar;
or
select max(foo) where xyz = z;
To do it properly max/min have to be special-cased and tightly integrated with
Peter Eisentraut [EMAIL PROTECTED] writes:
Bruce Momjian [EMAIL PROTECTED] writes:
Can we allow the IPv6 entries to be in pg_hba.conf but ignore them on
non-IPv6 machines, or allow the connection to fail?
What is the problem? Is it that a non-IPv6 enabled postmaster is unable
to identify or
On Thu, Sep 04, 2003 at 01:39:04AM -0400, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Doesn't the stats collector use unix domain sockets, not IP?
No. IIRC, we deliberately chose IP/UDP because it had buffering
behavior we liked.
Once you said it was because not all platforms
On Thu, Sep 04, 2003 at 07:18:57PM +0200, Peter Eisentraut wrote:
Tom Lane writes:
Bruce Momjian [EMAIL PROTECTED] writes:
Can we allow the IPv6 entries to be in pg_hba.conf but ignore them on
non-IPv6 machines, or allow the connection to fail?
I don't see a good way yet. The fly
Cygwin requires a license for commercial use.
-Original Message-
From: Peter Eisentraut [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 10:20 AM
To: Joerg Hessdoerfer
Cc: Bruce Momjian; [EMAIL PROTECTED]
Subject: Re: [HACKERS] Win32 native port
Joerg Hessdoerfer
http://developer.osdl.org/markw/44/
I threw together (kind of sloppily) a web page of the data I was
starting to collect for our DBT-2 workload (TPC-C derivative) on
PostgreSQL 7.3.4. Keep in mind not much database tuning has been done
yet. Feel free to ask any questions.
--
Mark Wong - -
I still did NOT pick up any changes :-(
Would you like an account on my box or do I need to do a full checkout?
LER
--On Thursday, September 04, 2003 14:59:32 -0300 Marc G. Fournier
[EMAIL PROTECTED] wrote:
by the time you see this email, it should be fixed ...
On Thu, 4 Sep 2003, Larry
Tom Lane wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
Bruce Momjian [EMAIL PROTECTED] writes:
Can we allow the IPv6 entries to be in pg_hba.conf but ignore them on
non-IPv6 machines, or allow the connection to fail?
What is the problem? Is it that a non-IPv6 enabled postmaster is
by the time you see this email, it should be fixed ...
On Thu, 4 Sep 2003, Larry Rosenman wrote:
--On Thursday, September 04, 2003 14:44:07 -0300 Marc G. Fournier
[EMAIL PROTECTED] wrote:
k, I just wipe'd out and rebuild /projects/cvsroot, and it looks like the
files are in sync
Bruce Momjian wrote:
Joerg Hessdoerfer wrote:
Hi!
Thanks to all who have replied (privately or via the list), it seems sometimes
it's just necessary to be a bit insistant!
That said, I'm positively surprised by what has been done already (especially
Bruce and Marc, this is
Peter Eisentraut wrote:
Tom Lane writes:
Bruce Momjian [EMAIL PROTECTED] writes:
Can we allow the IPv6 entries to be in pg_hba.conf but ignore them on
non-IPv6 machines, or allow the connection to fail?
I don't see a good way yet. The fly in the ointment is that HAVE_IPV6
is set
Tom Lane writes:
What is the problem? Is it that a non-IPv6 enabled postmaster is unable
to identify or parse valid IPv6 address specifications? In that case,
we need to provide some substitute routines.
To what purpose?
So we can put ::1 in the default pg_hba.conf and have it work on
--On Thursday, September 04, 2003 14:44:07 -0300 Marc G. Fournier
[EMAIL PROTECTED] wrote:
k, I just wipe'd out and rebuild /projects/cvsroot, and it looks like the
files are in sync again ... I checked abased on the pltcl.c commit that
Tom made at noon today, and the changes are there ... not
k, I just wipe'd out and rebuild /projects/cvsroot, and it looks like the
files are in sync again ... I checked abased on the pltcl.c commit that
Tom made at noon today, and the changes are there ... not sure why it
wasn't updating properly, bu tlet me know if you see it again ...
On Wed, 3 Sep
Will this have the native Windows port?
Marc G. Fournier [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Tue, 2 Sep 2003, postgresql wrote:
Hi all
Can anyone tell me the approximate pg 7.5 release date?
Summer of '04 ... approximate :)
---(end of
Doug McNaught wrote:
Dann Corbit [EMAIL PROTECTED] writes:
Cygwin requires a license for commercial use.
Use in the sense of distributing applications linked against it,
yes.
In this case I don't think it's a problem. The output of 'flex' and
'bison' is not required to be GPL (there
Dann Corbit [EMAIL PROTECTED] writes:
Cygwin requires a license for commercial use.
Use in the sense of distributing applications linked against it,
yes.
In this case I don't think it's a problem. The output of 'flex' and
'bison' is not required to be GPL (there is a specific exception in
the
--On Thursday, September 04, 2003 15:35:48 -0300 Marc G. Fournier
[EMAIL PROTECTED] wrote:
k, which file specifically are you expecting a change in? as I said, the
changes to pltcl.c that tom did today at noon are in anoncvs now, when I
checked ... try doing a full checkout and see if that
On Thu, 4 Sep 2003, Dann Corbit wrote:
Use the Cygwin tools.
Cygwin requires a license for commercial use.
It does? I don't see it:
http://cygwin.com/licensing.html
Jon
---(end of broadcast)---
TIP 8: explain analyze is your friend
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
To what purpose? I think I prefer Andrew Dunstan's approach of allowing
IPv4 syntax in pg_hba.conf to match appropriate IPv6 connections.
I am confused. Andrew Dunstan's approach added a new 'loopback' line
to
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
To what purpose? I think I prefer Andrew Dunstan's approach of allowing
IPv4 syntax in pg_hba.conf to match appropriate IPv6 connections.
I am confused. Andrew Dunstan's approach added a new 'loopback' line
to pg_hba.conf.
Andreas
k, which file specifically are you expecting a change in? as I said, the
changes to pltcl.c that tom did today at noon are in anoncvs now, when I
checked ... try doing a full checkout and see if that helps ... ?
On Thu, 4 Sep 2003, Larry Rosenman wrote:
I still did NOT pick up any changes :-(
Bupp Phillips wrote:
Will this have the native Windows port?
We think so.
Marc G. Fournier [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Tue, 2 Sep 2003, postgresql wrote:
Hi all
Can anyone tell me the approximate pg 7.5 release date?
Summer of '04 ...
Hi,
I was wondering if anybody here has any feedback on the windows version of
PostgreSQL from DBExperts.
Stability
Speed
Support
Anything else I should know.
Thanks
--
Patrick McLaughlin
Les Logiciels S.I.G.M. Inc.
Programmeur analyste
---(end of
Peter Eisentraut wrote:
Andrew Dunstan writes:
Having parsed it what would it do with it?
Nothing.
Surely if IP6 isn't configured in then having an IP6 address in
pg_hba.conf is an error.
Arguably, but not surely.
If Andreas Pflug's patch (with Kurt's caveat) and my patch
Did you read this:
This means that unless you modify the tools so that compiled
executables do not make use of the Cygwin library, your compiled
programs will also have to be free software distributed under the GPL
with source code available to all.
And this:
Red Hat sells a special Cygwin
On Thu, 4 Sep 2003, Dann Corbit wrote:
Did you read this:
This means that unless you modify the tools so that compiled
executables do not make use of the Cygwin library, your compiled
programs will also have to be free software distributed under the GPL
with source code available to all.
I
I just thought of something:
For a *real* special case, with no new keywords or other stuff, we could
just add something like this to hba.c at the start of the 'host*'
section of parse_hba():
#ifndef HAVE_IPV6
if (strcmp(token,::1) == 0 || strcmp(token,::1/128) == 0)
return;
The full check out found them :-\
I dunno what was going on.
'k, as I said, for some reason the /projects/cvsroot itself wasn't being
updated properly either, so it might be related *shrug*
let me know if it happens again, that's all ...
---(end of
[EMAIL PROTECTED] wrote:
http://developer.osdl.org/markw/44/
I threw together (kind of sloppily) a web page of the data I was
starting to collect for our DBT-2 workload (TPC-C derivative) on
PostgreSQL 7.3.4. Keep in mind not much database tuning has been done
yet. Feel free to ask any
Kurt Roeckx wrote:
On Thu, Sep 04, 2003 at 01:39:04AM -0400, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Doesn't the stats collector use unix domain sockets, not IP?
No. IIRC, we deliberately chose IP/UDP because it had buffering
behavior we liked.
Once you said it was because not
its hoped to ...
On Mon, 1 Sep 2003, Bupp Phillips wrote:
Will this have the native Windows port?
Marc G. Fournier [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Tue, 2 Sep 2003, postgresql wrote:
Hi all
Can anyone tell me the approximate pg 7.5 release date?
Bupp Phillips wrote:
Will this have the native Windows port?
Approximately maybe :-)
Jan
Marc G. Fournier [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Tue, 2 Sep 2003, postgresql wrote:
Hi all
Can anyone tell me the approximate pg 7.5 release date?
Summer of '04 ...
Andrew Dunstan writes:
Having parsed it what would it do with it?
Nothing.
Surely if IP6 isn't configured in then having an IP6 address in
pg_hba.conf is an error.
Arguably, but not surely.
If Andreas Pflug's patch (with Kurt's caveat) and my patch are applied,
then I really think there
--On Thursday, September 04, 2003 13:39:44 -0500 Larry Rosenman
[EMAIL PROTECTED] wrote:
--On Thursday, September 04, 2003 15:35:48 -0300 Marc G. Fournier
[EMAIL PROTECTED] wrote:
k, which file specifically are you expecting a change in? as I said, the
changes to pltcl.c that tom did today
Bruce Momjian writes:
As you can see from the new Compiling web page, I just normally
compile under Unix, distclean, then Win32 compile via Samba.
That isn't very efficient unless you have two machines or use something
like vmware.
--
Peter Eisentraut [EMAIL PROTECTED]
Kurt Roeckx wrote:
It could be useful to have a warning at the following line:
if (memcmp(fromaddr, pgStatAddr, fromlen))
continue;
That way you can rule out that that is a problem.
Anyway, I still didn't see the error message he got in
On Thu, Sep 04, 2003 at 12:27:58PM -0700, Dann Corbit wrote:
Did you read this:
This means that unless you modify the tools so that compiled
executables do not make use of the Cygwin library, your compiled
programs will also have to be free software distributed under the GPL
with source code
-Original Message-
From: Jon Jensen [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 4:32 PM
To: [EMAIL PROTECTED]
Subject: Re: [HACKERS] Win32 native port
On Thu, 4 Sep 2003, Dann Corbit wrote:
Did you read this:
This means that unless you modify the tools so that
-Original Message-
From: Jon Jensen [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 1:32 PM
To: [EMAIL PROTECTED]
Subject: Re: [HACKERS] Win32 native port
On Thu, 4 Sep 2003, Dann Corbit wrote:
Did you read this:
This means that unless you modify the tools so
On Thu, Sep 04, 2003 at 05:01:54PM -0400, Jan Wieck wrote:
Kurt Roeckx wrote:
It could be useful to have a warning at the following line:
if (memcmp(fromaddr, pgStatAddr, fromlen))
continue;
That way you can rule out that
On Thu, Sep 04, 2003 at 04:04:38PM -0400, Jan Wieck wrote:
And I agree with Tom that it is very likely that the IPV4/IPV6 stuff is
the reason. IIRC the postmaster creates the socket and noone ever does
bind(2) on it - so it uses it's dynamically assigned port number. Both,
the collector
Dann Corbit wrote:
-Original Message-
From: Jon Jensen [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 1:32 PM
To: [EMAIL PROTECTED]
Subject: Re: [HACKERS] Win32 native port
On Thu, 4 Sep 2003, Dann Corbit wrote:
Did you read this:
This means that unless you modify
It could be useful to have a warning at the following line:
if (memcmp(fromaddr, pgStatAddr, fromlen))
continue;
That way you can rule out that that is a problem.
Anyway, I still didn't see the error message he got in the first
place.
-Original Message-
From: Andrew Dunstan [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 2:35 PM
To: Postgresql Hackers
Subject: Re: [HACKERS] Win32 native port
Dann Corbit wrote:
-Original Message-
From: Jon Jensen [mailto:[EMAIL PROTECTED]
Sent:
Greetings,
I've recently been spending some quality time with the plpython module, and I
think I'm well on the road to an improved version of it(although, nothing about a
trusted variant). By improved, I mostly mean cleaned up, and reorganized..
Here are some of the changes that I
Peter Eisentraut wrote:
Bruce Momjian writes:
As you can see from the new Compiling web page, I just normally
compile under Unix, distclean, then Win32 compile via Samba.
That isn't very efficient unless you have two machines or use something
like vmware.
One quick solution would be to
Now that I have pg_autovacuum working I've bumped into another small
bug. When pg_autovacuum goes to vacuum or analyze one of my tables it runs...
analyze public.ConfigBackup
Because ConfigBackup is mixed case it cannot find the relation. I fixed
this by going to the function init_table_info
Adam Kavan [EMAIL PROTECTED] writes:
if (memcmp(fromaddr, pgStatAddr, fromlen))
continue;
This is the very line that is giving me problems. I commented it out and
recompiled and now the stats system works. Of course I have to assume that
its bad to go around with out that check...
Hmm.
[ pgsql-general removed from cc list, as this is quite inappropriate
there ]
Jenny - [EMAIL PROTECTED] writes:
I am working on a project that involves displaying locking information about
each lock taken, whether it be a row level or table leve llock.
When dealing with struct LOCK
Dann Corbit wrote:
You are making an assumption that the follwing sentence is only valid
under conditions of the first. That is nowhere stated. That connection
is only implied by your interpretation.
Not at all. the phrase This means clearly refers to what went before.
Even a trivial and
Here is the problem I have some key tables that I need
to import some data into it.I can't go ahead and
write insert into table value()for over 40 different
tables and over 100s of rows and columns
The reason that I have to write a script to enter the
data into the tables is that what if I have
At 06:49 PM 9/4/03 -0400, Tom Lane wrote:
Hmm. Could you look and see what the actual values are in each address?
regards, tom lane
I don't really know the layout of these structures so I dumped them to a
file and attached them. The first 16 bytes is from fromaddr and
Kurt Roeckx wrote:
On Thu, Sep 04, 2003 at 05:01:54PM -0400, Jan Wieck wrote:
Kurt Roeckx wrote:
It could be useful to have a warning at the following line:
if (memcmp(fromaddr, pgStatAddr, fromlen))
continue;
That way you can rule out
Bruce Momjian wrote:
Greg Stark wrote:
It has nothing to do with MVCC. It has to do with implementing this is hard in
the general case.
Think of examples like:
select max(foo) group by bar;
or
select max(foo) where xyz = z;
To do it properly max/min have to be special-cased and tightly
They are both structures of type sockaddr_in (sin_family 2 is AF_INET
whereas sin_family 10 would've been AF_INET6), and all relevant fields
of the structure look the same to me. The problem lies in the padding
bytes that make sockaddr_in the same size as sockaddr.
Since the static structure
Adam Kavan [EMAIL PROTECTED] writes:
I don't really know the layout of these structures so I dumped them to a
file and attached them. The first 16 bytes is from fromaddr and the second
is from pgStatAddr.
More legibly:
000 0200 8016 7f00 0001
010 0200 8016 7f00
Stephan Szabo wrote:
It looks like that right now if you have multiple constraints
with the same name on different tables and some are deferrable
and some are not, SET CONSTRAINTS name DEFERRED will fail when
it reaches the not deferrable constraint. Is this the behavior
we want, or do we
Kurt Roeckx [EMAIL PROTECTED] writes:
Then it connects to itself. I don't get the logic behind that
howver.
At least on HPUX, the connect(2) man page saith
If the socket is of type SOCK_DGRAM, connect() specifies the peer
address to which messages are to be sent, and the call
Kevin Brown wrote:
Bruce Momjian wrote:
Kevin Brown wrote:
The two approaches aren't necessarily mutually exclusive (though SQL99
compliance on constraint names would obviously make it unnecessary to
specify a tablename along with a constraint name), so I see little
problem here.
Bruce Momjian wrote:
Added to TODO:
* Print table names with constraint names in error messages, or make
constraint names unique within a schema
Should the TODO also include adding ALTER TABLE x ALTER CONSTRAINT
y RENAME TO z functionality if we don't make constraint names
On Thu, 4 Sep 2003, Bruce Momjian wrote:
Stephan Szabo wrote:
It looks like that right now if you have multiple constraints
with the same name on different tables and some are deferrable
and some are not, SET CONSTRAINTS name DEFERRED will fail when
it reaches the not deferrable
Kevin Brown wrote:
Bruce Momjian wrote:
Added to TODO:
* Print table names with constraint names in error messages, or make
constraint names unique within a schema
Should the TODO also include adding ALTER TABLE x ALTER CONSTRAINT
y RENAME TO z functionality if we
Stephan Szabo wrote:
On Thu, 4 Sep 2003, Bruce Momjian wrote:
Stephan Szabo wrote:
It looks like that right now if you have multiple constraints
with the same name on different tables and some are deferrable
and some are not, SET CONSTRAINTS name DEFERRED will fail when
it
When I do '\h alter' in psql, the content scrolls off my screen.
Should we be using the pager for \h output?
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+
Andrew Dunstan [EMAIL PROTECTED] writes:
There's a lot of confusion around :-) Let me see if I can disentangle
some of it.
People seem to want two things:
1. if ip4 is being tunneled over ip6 as it is in most Linux
distributions, match a corresponding 'host*' line with an ip4 address.
2.
The world rejoiced as [EMAIL PROTECTED] (Andreas Pflug) wrote:
Bruce Momjian wrote:
Greg Stark wrote:
It has nothing to do with MVCC. It has to do with implementing this is hard in
the general case.
Think of examples like:
select max(foo) group by bar;
or
select max(foo) where xyz = z;
To
Christopher Browne wrote:
IMHO portability is an important point. People are used to MAX() and
COUNT(*), and will be surprised that they need some special
treatment. While the reasons for this are perfectly explainable,
speeding up these aggregates with some extra effort would make porting
On Thu, 2003-09-04 at 22:02, Bruce Momjian wrote:
My idea is that if a transaction doing a COUNT(*) would first look to
see if there already was a visible cached value, and if not, it would do
the COUNT(*) and insert into the cache table. Any INSERT/DELETE would
remove the value from the
Neil Conway wrote:
On Thu, 2003-09-04 at 22:02, Bruce Momjian wrote:
My idea is that if a transaction doing a COUNT(*) would first look to
see if there already was a visible cached value, and if not, it would do
the COUNT(*) and insert into the cache table. Any INSERT/DELETE would
remove
This TODO item has been completed as of CVS tip, right?
Allow psql to do table completion for SELECT * FROM schema_part
and table completion for SELECT * FROM schema_name.
-Neil
---(end of broadcast)---
TIP 7: don't
Ouch... sorry, my fault. I'll fix this tomorrow (Friday) and submit a
patch, or if you want to submit a patch that would be fine. All you
have to do is change the the sql statements to put quotes around the
relation name.
Thanks for catching this.
Matthew T. O'Connor
On Thu, 2003-09-04 at
On Thu, 2003-09-04 at 18:39, Adam Kavan wrote:
Now that I have pg_autovacuum working I've bumped into another small
bug. When pg_autovacuum goes to vacuum or analyze one of my tables it runs...
Also, has this been officially fixed? All I have heard so far is that
you commented out the check
Bruce Momjian [EMAIL PROTECTED] writes:
Neil Conway wrote:
In general, I don't think this is worth doing.
It is possible it isn't worth doing. Can the INSERT/DELETE
incrementing/decrementing the cached count work reliabily?
I don't even see how the notion of a single cached value makes
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Neil Conway wrote:
In general, I don't think this is worth doing.
It is possible it isn't worth doing. Can the INSERT/DELETE
incrementing/decrementing the cached count work reliabily?
I don't even see how the notion of a single
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
You could doubtless maintain a fairly good approximate total this
way, and that would be highly useful for some applications ...
but it isn't COUNT(*).
With MVCC allowing multiple rows with only one visible, I thought the
INSERT/DELETE
1 - 100 of 114 matches
Mail list logo
