---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Added.
---
Christopher Kings-Lynne wrote:
>
> >> Unimplemented feature AFAIR. BTW, if you feel like doing something
> >> about this, COMMENT ON LARGE OBJECT would be good too.
> >
> >
> > * COMMENT ON [ CAST | CONVERSIO
Unimplemented feature AFAIR. BTW, if you feel like doing something
about this, COMMENT ON LARGE OBJECT would be good too.
* COMMENT ON [ CAST | CONVERSION | OPERATOR CLASS | LARGE OBJECT ]
Bruce - want to make this a TODO? May as well assign it to me - I'll
have a play with it. I assume th
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Jeroen Ruigrok/asmodai wrote:
> >> "The crypt_r function is a GNU extension."
>
> > BSD/OS doesn't have crypt_r(), and crypt() manual page says:
>
> > The crypt() function may not be safely called concurrently from multiple
> >
On Wed, 2003-10-08 at 18:27, Gaetano Mendola wrote:
> I found on the readme the following lines:
> deleteThreshold is equal to:
> vacuum_base_value + (vacuum_scaling_factor * "number of tuples in
> the table")
>
> insertThreshold is equal to:
> analyze_base_value + (analyze_scaling_fact
Tom Lane wrote:
> Neil Conway <[EMAIL PROTECTED]> writes:
> > On Wed, 2003-10-08 at 14:31, Bruce Momjian wrote:
> >> Well, this is really embarassing. I can't imagine why we would not set
> >> at least -O on all platforms.
>
> I believe that autoconf will automatically select -O2 (when CFLAGS isn
Added, yes, a 7.5 item.
---
Christopher Kings-Lynne wrote:
> >>I notice you cannot COMMENT ON the following:
> >>* Cast
> >>* Conversion
> >>* Operator class
> >>Is that a deliberate omission, or is it an oversight?
> >
> >
I notice you cannot COMMENT ON the following:
* Cast
* Conversion
* Operator class
Is that a deliberate omission, or is it an oversight?
Unimplemented feature AFAIR. BTW, if you feel like doing something
about this, COMMENT ON LARGE OBJECT would be good too.
* COMMENT ON [ CAST | CONVERSION | O
Bruce Momjian wrote:
Christopher Kings-Lynne wrote:
>>Well, with the CREATE CONSTRAINT TRIGGER you _can_, but we already have
>>a consensus that we don't _want_ that. Probably we should declare it
>>deprecated and remove it in 7.5. And the option currently under
>>discussion is exactly what wil
Christopher Kings-Lynne wrote:
>
> >>Well, with the CREATE CONSTRAINT TRIGGER you _can_, but we already have
> >>a consensus that we don't _want_ that. Probably we should declare it
> >>deprecated and remove it in 7.5. And the option currently under
> >>discussion is exactly what will cause ALT
Well, this is really embarassing. I can't imagine why we would not set
at least -O on all platforms. Looking at the template files, I see
these have no optimization set:
freebsd (non-alpha)
I'm wondering what that had in mind:
http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/temp
Well, with the CREATE CONSTRAINT TRIGGER you _can_, but we already have
a consensus that we don't _want_ that. Probably we should declare it
deprecated and remove it in 7.5. And the option currently under
discussion is exactly what will cause ALTER TABLE to let you, but IMHO
that _should_ be r
Peter Eisentraut wrote:
> Bruce Momjian writes:
>
> > Well, this is really embarassing. I can't imagine why we would not set
> > at least -O on all platforms. Looking at the template files, I see
> > these have no optimization set:
>
> > freebsd (non-alpha)
>
> I'm wondering what that had
Tom Lane wrote:
> Neil Conway <[EMAIL PROTECTED]> writes:
> > On Wed, 2003-10-08 at 14:31, Bruce Momjian wrote:
> >> Well, this is really embarassing. I can't imagine why we would not set
> >> at least -O on all platforms.
>
> I believe that autoconf will automatically select -O2 (when CFLAGS isn
Hi all,
I found on the readme the following lines:
deleteThreshold is equal to:
vacuum_base_value + (vacuum_scaling_factor * "number of tuples in
the table")
insertThreshold is equal to:
analyze_base_value + (analyze_scaling_factor * "number of tuples in
the table")
may be here del
Bruce Momjian writes:
> Well, this is really embarassing. I can't imagine why we would not set
> at least -O on all platforms. Looking at the template files, I see
> these have no optimization set:
> freebsd (non-alpha)
I'm wondering what that had in mind:
http://developer.postgresql.or
Neil Conway <[EMAIL PROTECTED]> writes:
> On Wed, 2003-10-08 at 14:31, Bruce Momjian wrote:
>> Well, this is really embarassing. I can't imagine why we would not set
>> at least -O on all platforms.
I believe that autoconf will automatically select -O2 (when CFLAGS isn't
already set) *if* it's ch
4:12p
Dear all,
I am facing problems with the postgres(7.3.1) on windows machine(98). The problem is
with pg_recvbuf. And here are the logs..
Can any one teach me more on this
LOG: pq_recvbuf: unexpected EOF on client connection
LOG: pq_recvbuf: unexpected EOF on client connection
LOG: pq_recvb
Jan Wieck wrote:
> > I think this is a larger argument than the one that was being discussed
> > above. Given a dump of objects I own, can I restore them without requiring
> > the fk check to be done if I alter table add constraint a foreign key? If
> > the answer to that is no, then the option can
Andrew Sullivan wrote:
> On Sat, Sep 27, 2003 at 09:13:27AM -0300, Marc G. Fournier wrote:
> >
> > I think it was Andrew that suggested it ... when the slave timesout, it
> > should "trigger" a READ ONLY mode on the slave, so that when/if the master
> > tries to start to talk to it, it can't ...
>
Neil Conway writes:
> nconway=# select 1::bit;
> bit
> -
> 0
> (1 row)
Oops. I've always thought that casting between int and bit should be
disallowed, but apparently it keeps sneaking back in.
> nconway=# select X'4'::bit varying;
> varbit
>
> 0100
> (1 row)
> -- why is that 4
Added to TODO:
* Use background process to write dirty shared buffers to disk
---
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Would it be a good idea to have a separate shared buffer process to
>
Would someone report on the answer to this m68k question?
---
Tom Lane wrote:
> =?ISO-8859-1?Q?R=E9mi_Zara?= <[EMAIL PROTECTED]> writes:
> > Here is the patch to make postgresql compile on m68k 1.6.x NetBSD:
>
> I can't app
Bruce Momjian wrote:
Jeff wrote:
On Wed, 8 Oct 2003, Neil Conway wrote:
What CFLAGS does configure pick for gcc? From
src/backend/template/solaris, I'd guess it's not enabling any
optimization. Is that the case? If so, some gcc numbers with -O and -O2
would be useful.
I can't belie
On Wed, 8 Oct 2003, Neil Conway wrote:
> ISTM the most legitimate reason for not enabling compilater
> optimizations on a given compiler/OS/architecture combination is might
> cause compiler errors / bad code generation.
>
> Can we get these optimizations enabled in time for the next 7.4 beta? It
On Wed, 2003-10-08 at 14:31, Bruce Momjian wrote:
> Well, this is really embarassing. I can't imagine why we would not set
> at least -O on all platforms.
ISTM the most legitimate reason for not enabling compilater
optimizations on a given compiler/OS/architecture combination is might
cause compi
Jeff wrote:
> On Wed, 8 Oct 2003, Neil Conway wrote:
>
> >
> > What CFLAGS does configure pick for gcc? From
> > src/backend/template/solaris, I'd guess it's not enabling any
> > optimization. Is that the case? If so, some gcc numbers with -O and -O2
> > would be useful.
> >
>
> I can't believe I
Is the following behavior intentional? If so, what's the reasoning
behind it?
nconway=# select 1::bit;
bit
-
0
(1 row)
nconway=# select '1'::bit;
bit
-
1
(1 row)
nconway=# select X'1'::bit;
bit
-
0
(1 row)
nconway=# select 1::bit varying;
ERROR: cannot cast type integer to bi
Andrew Dunstan writes:
> At program startup, the equivalent of the following statement is executed:
> setlocale( LC_ALL, "C" );
> Does this have any effect on us?
No, that is just a peculiar way to express that by default nothing
happens.
> Does it mean, as it appears to, that the locale wil
The MS runtime docs on setlocale() contaiun the following statement:
At program startup, the equivalent of the following statement is executed:
setlocale( LC_ALL, "C" );
Does this have any effect on us? Does it mean, as it appears to, that the locale will not be inherited from the parent?
If
scott.marlowe wrote:
OK, I've done some more testing on our IDE drive machine.
First, some background. The hard drives we're using are Seagate
drives, model number ST380023A. Firmware version is 3.33. The machine
they are in is running RH9. The setup string I'm feeding them on startup
righ
gist supports only balanced trees but I have to implement index as suffix tree which
is highly unbalanced.How can I do this?
"monu_indian" <[EMAIL PROTECTED]> writes:
> I have designed a new indexing tecknique for biological database now I want to
> implement it in pgsql so what the work I will
I'm seeing this compile warning on today's CVS tip:
$ make src/backend/commands/tablecmds.o
gcc -O2 -g -Wall -Wmissing-prototypes -Wmissing-declarations -I./src/include
-D_GNU_SOURCE -c -o src/backend/commands/tablecmds.o src/backend/commands/tablecmds.c
src/backend/commands/tablecmds.c: In fun
I'm having trouble overloading functions in plpgsql using PostgreSQL
7.3.2 on OS X.
I have created two functions with the following declarations:
CREATE OR REPLACE FUNCTION set_entity_type(BIGINT,TEXT) RETURNS BOOLEAN AS '
---(end of broadcast)---
I have tried, twice, to download the evaluation version of the alphora
product for testing and it doesn't work. Guess there would be a lot
to learn from playing with it; the product is more than a RDBMS
Regards,
Seun Osewa
[EMAIL PROTECTED] (Lauri Pietarinen) wrote:
> That is, in fact, the appro
I'm having trouble overloading functions in plpgsql using PostgreSQL
7.3.2 on OS X.
I have created two functions with the following declarations:
CREATE OR REPLACE FUNCTION set_entity_type(BIGINT,TEXT) RETURNS BOOLEAN
AS ' ...
CREATE OR REPLACE FUNCTION set_entity_type(BIGINT,BIGINT) RETURNS
B
OK, I've done some more testing on our IDE drive machine.
First, some background. The hard drives we're using are Seagate
drives, model number ST380023A. Firmware version is 3.33. The machine
they are in is running RH9. The setup string I'm feeding them on startup
right now is: hdparm -c3
Matthew T. O'Connor wrote:
> Tom Lane wrote:
>
> >Bruce Momjian <[EMAIL PROTECTED]> writes:
> >
> >
> >>Should we add a variable that is set from the dump filew that identifies
> >>the version of PostgreSQL that generated the dump?
> >>SET dumped_version = 7.3
> >>
> >>
> >
> >Is that id
Manfred Koizar <[EMAIL PROTECTED]> writes:
> Here is a patch that does this and adds a few regression tests.
Uh, I did that already ... for 7.4 at least.
regards, tom lane
---(end of broadcast)---
TIP 1: subscribe and unsubs
Tom Lane wrote:
Bruce Momjian <[EMAIL PROTECTED]> writes:
Should we add a variable that is set from the dump filew that identifies
the version of PostgreSQL that generated the dump?
SET dumped_version = 7.3
Is that identifying the backend version, or the pg_dump version?
Without a solid
On Thu, Oct 02, 2003 at 05:31:52AM -0700, Seun Osewa wrote:
>
> The beauty of the scheme is that the WAL syncs which "sync everyone's
> changes so far" would cost about the same as the WAL syncs for just
> one transaction being committed. But when there are so many trans-
> actions we would not
Zeugswetter Andreas SB SD wrote:
. using "wb" for writing out on Windows is so that we don't
get Windows' gratuitous addition of carriage returns. I will document that.
Please use the #define PG_BINARY_W from c.h which is defined
with the correct letters for all platforms ("wb" on Windows).
Dear Devrim,
I have been using Postgres on Irix for over 8 years, and I have only
used the SGI provided compilers. GCC doesn't work well on Irix. In addition,
you can build a 64 bit version of PostgreSQL. Here's the script we used for
PostgreSQL 7.3.2:
#!/bin/ksh -x
./copy_local_files_for
> . using "wb" for writing out on Windows is so that we don't
> get Windows' gratuitous addition of carriage returns. I will document that.
Please use the #define PG_BINARY_W from c.h which is defined
with the correct letters for all platforms ("wb" on Windows).
That is how Peter's comment was
On Sun, 05 Oct 2003 19:12:50 -0400, Tom Lane <[EMAIL PROTECTED]>
wrote:
>it seems we have to compare the null representation string to the
>pre-debackslashing input.
Here is a patch that does this and adds a few regression tests.
>(This is probably fairly easy to make happen
>in CVS tip, but it m
Seun Osewa wrote:
I observed that in in many applications there are some transactions
that are more critical than others. I may have the same database
instance managing website visitor accounting and financial
transactions. I could tolerate the loss of a few transactions whose
only job is to tell
46 matches
Mail list logo
