Neil Conway <[EMAIL PROTECTED]> writes:
> Should this produce a warning?
> [ foreign-key reference to column of a different datatype ]
> Aside from the logical inconsistency, it will also lead to poor
> performance since the type mismatch will prevent index scans. I've
> noticed a couple people hav
> A general query cache is something that is fairly clean and which might
> help both with count(*) and other queries.
>
> Many databases has a lot of tables that are more or less stable where this
> would work fine. From what I have heard mysql has something like this and
> it works well. For tabl
On Fri, 5 Sep 2003, Bruce Momjian wrote:
> > When I was curious as to how COUNT might be maintained, I was pretty
> > sure that this wouldn't be the preferred method...
>
> See my later idea of the trigger doing +/-1 rather than locking the
> value during the transaction.
>
> If we don't do it t
Christopher Browne wrote:
> Wouldn't this more or less be the same thing as having a trigger that
> does, upon each insert/delete "update pg_counts set count = count + 1
> where reltable = 45232;"? (... where 1 would be -1 for deletes, and where
> 45232 is the OID of the table...)
>
> Technically
Oops! [EMAIL PROTECTED] (Bruce Momjian) was seen spray-painting on a wall:
> 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
Tom Lane wrote:
> 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 on
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
> INS
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 noti
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 make
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
Jan Wieck wrote:
> Tom Lane wrote:
>
> > Jan Wieck <[EMAIL PROTECTED]> writes:
> >> Okay, my proposal would be to have a VACUUM mode where it tells the
> >> buffer manager to only return a page if it is already in memory, and
> >> some "not cached" if it would have to read it from disk, and simp
Manfred Koizar wrote:
> [ still brainstorming ... ]
>
> On Thu, 21 Aug 2003 17:16:50 -0400, Tom Lane <[EMAIL PROTECTED]>
> wrote:
> >> Whenever a backend encounters a dead tuple it inserts a reference to
> >> its page into the RSM.
> >
> >This assumes that backends will visit dead tuples with sign
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 18:
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 forget
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
>
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 c
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
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
>>>
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
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
+ Chr
Alvaro Herrera Munoz <[EMAIL PROTECTED]> writes:
> Anyway, I think the LOCK structure represents something that can be locked.
Right.
> The PROCLOCK struct represents that some process is holding a lock on said
> object.
IIRC, a PROCLOCK is created as soon as some backend tries to lock some
lock
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 fai
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" functiona
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 defer
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 na
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
> > > pr
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 ret
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
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 7
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 pg
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 inte
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 r
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 th
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
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
[ 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 (src
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
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
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 w
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 hav
> -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]
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. Ma
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 th
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 collect
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
> -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
-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 compi
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
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 i
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]
---
--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 t
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 th
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
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
On Thu, Sep 04, 2003 at 11:21:05AM -0700, Jenny - wrote:
> >I think the locks would actually by represented by PROCLOCK structures.
> >The LOCK structures are for lockable objects, not for actual locks.
>
> Well,from what i understand, PROCLOCK stores the TransactionID and the LOCK
> its holding
Bruce Momjian wrote:
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
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 n
[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 questions
> 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 broadcast)-
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)
retur
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
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 Lice
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 are
On Wed, 2003-09-03 at 17:28, Martijn van Oosterhout wrote:
> If you know the OID of a row, PostgreSQL doesn't have a special lookup table
> to find it. That's also why they're not unique; the backend would have to
> scan through every table to find out if the next one is available.
Ahh, thats not
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 broadcast)-
On Wed, 2003-09-03 at 13:19, Martijn van Oosterhout wrote:
> But your insert function needs to know something about the table it's
> inserting into. The sequences have quite predicatable names. Besides, you
> can set the name yourself (DCL does this IIRC).
No it don't know anything about the table
> No it don't know anything about the table it insert into. I simply do
> the following :
>
> 1. INSERT data (comming from another layer)
> 2. Get the last oid
> 3. SELECT * FROM the same table where oid = what I just found.
>
> I know absolutly nothing about the table, and I like it this way :-)
On Wed, 2003-09-03 at 11:38, Shridhar Daithankar wrote:
> Well, what I do is, declare a serate sequence, retrive next available value and
> explicitly insert it into a integer field. That avoids having to retrieve the
> latest value again.
Yeps, this is what I call an application specific implim
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?
> >
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 :-(
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.
> A
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
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
On Thu, Sep 04, 2003 at 08:56:31AM -0700, Jenny - wrote:
> 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 (src/include/storage) i have noticed that
> postgreSQL creates
--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
"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
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
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 :)
>
>
>
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 2
--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 ...
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 w
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
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,
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 a
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 enab
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
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 - - [EMAI
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 Hessd
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
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 pla
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
> t
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 inte
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 broadcast)
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 t
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
>
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]
--
> > 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. B
On Thu, Sep 04, 2003 at 08:56:31AM -0700, Jenny - wrote:
> 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 (src/include/storage) i have noticed that
> postgreSQL creates
"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
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)
1 - 100 of 116 matches
Mail list logo
