On Sun, Apr 29, 2001 at 03:04:18PM +1000, Jeff Waugh wrote:
>
>
> > will trillich <[EMAIL PROTECTED]> wrote:
> >
> > >Care to explain -- in terms a Debian newbie might grok -- what
> > >"contrib/pgcrypto" means?
> >
> > Peter is referring to a directory in the PostgreSQL sources, not to a part
On Sun, Apr 29, 2001 at 04:33:42PM -0020, [EMAIL PROTECTED] wrote:
> If the work that Alfred has done is as effective as he claims, then
> there must be a *REALLY* good reason why it isn't being included.
Isn't 7.1 in a code freeze?
That seems like a *REALLY* good reason not to include such a ch
Hi Clayton,
>From what I remember, using -p will change BOTH the TCP/IP port and the
Unix domain socket.
i.e. pg_ctl start -o '-i -p '
Should make PostgreSQL listen on TCP port , and on most unix systems
will create a socket file in /tmp/.s.PGSQL. (and its corresponding
lock file)
* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [010428 21:44] wrote:
> I am rather staggered by a developer considering it necessary to
> attempt to cooerce the core development team into including a patch.
I'm assuming you refer to the updated page at:
http://people.freebsd.org/~alfred/vacfix/
> If th
Under 7.0.x and earlier, no.
Under 7.1, you can use execute to execute a string which
could have dynamic bits (replace create sequence seqname;
with execute ''create sequence '' || seqname;)
On Sat, 28 Apr 2001, Lieven Van Acker wrote:
> Hi,
>
> is there a way to make a name in a plpgsql proc
Totally agreed.
It could just be from a lack of people's time to do things, or I wonder
if Alfred's patch is doing things which might not be beneficial?
(Maybe there have been decisions on a better way to get it done, but it
just hasn't been implemented yet).
I'm curious also.
Regards and bes
> will trillich <[EMAIL PROTECTED]> wrote:
>
> >Care to explain -- in terms a Debian newbie might grok -- what
> >"contrib/pgcrypto" means?
>
> Peter is referring to a directory in the PostgreSQL sources, not to a part
> of a binary package. "apt-get source postgresql" and look around.
You'll
I am rather staggered by a developer considering it necessary to
attempt to cooerce the core development team into including a patch.
If the work that Alfred has done is as effective as he claims, then
there must be a *REALLY* good reason why it isn't being included.
I don't want to start any fo
Hi,
I am trying to join 3 tables
with this query
select a.id, a.name, sum(b.qty), sum(c.qty)
from a, b, c
where a.id=xxx and b.id=a.id and c.id=a.id
what the sums that get returned look as if they are a cross products of
the b and c tables.
What is the correct way
* Jack Bates <[EMAIL PROTECTED]> [010428 13:31] wrote:
>
> Hello all:
>
> I am part of a software development team evaluating RDBMSs for inclusion
> as a base component of a "messaging" system. I've been thrashing hard
> on PostgreSQL under Solaris 8 and the GNU compiler for a few days now,
> a
On Sat, Apr 28, 2001 at 09:46:44AM +0800, Harry Yau wrote:
> Dear:
> I wanna create a function that return a multiple rows in to a single
>
> row.
> example:
> CREATE FUNCTION GETNAME() RETURNS SETOF VARCHAR AS 'SELECT NAME FROM
> TEST;' LANGUAGE 'SQL';
>
> when i call this function it retur
Is any work being done to streamline/redesign the way
PostgreSQL handles updates and/or the way VACUUM works so that it doesn't lock
the entire table while it does it's job? It seems that tables that need to
be VACUUM'ed the most would typically have fewer acceptable "windows" in which
to w
I had this problem with 7.0.3, but it cleared up completely with 7.1
W
James Thornton wrote:
>
> Vacuum analyze keeps hanging here...
>
> NOTICE: --Relation referer_log--
> NOTICE: Pages 529: Changed 1, reaped 509, Empty 0, New 0; Tup 24306:
> Vac 43000, Keep/VTL 0/0, Crash 0, UnUsed 0, MinL
Over the past few months there've been a number of requests for an
interactive type documentation setup like the folks at php.net have.
Great to add to the documentation, but I hope the PostgreSQL project
doesn't take it so far as to make the primary documentation
interactive. A well-thoug
Quoting GH ([EMAIL PROTECTED]):
> On Sat, Apr 28, 2001 at 02:18:42PM -0400, some SMTP stream spewed forth:
> > I just added a boolean column to an existing database with 70,000 records.
> > I then tried to set all the existing columns to true using
> > update waypoint set ispublic = TRUE;
> >
* will trillich in "Re: Re: SQL Where Like - Range it?!" dated
* 2001/04/28 03:17 wrote:
> apparently it does IF you use the 'anchor-at-beginning'
> construct, namely the "^":
>
> fld ~ '^[A-F]' -- STARTS with A,B,C,D,E, or F
> fld ~ '[A-F]' -- merely contains A,B,C,D,E, or F
>
H-
Thanks again.
Being slow at times I know why ~* '^[A-F]' wasn't working.
Yeah, that's right. There weren't any records in that range. I moved it
up and pulled some records in a range of A-P and it worked as expected.
Thanks to all that wrote in and replied. I understand why the LIKE 'A%'
Hello all:
I am part of a software development team evaluating RDBMSs for inclusion
as a base component of a "messaging" system. I've been thrashing hard
on PostgreSQL under Solaris 8 and the GNU compiler for a few days now,
and personally, I'm impressed. Thank you, developers.
The only two m
On Fri, 27 Apr 2001, Clayton Vernon wrote:
> I was wondering what the plans were for PostgreSQL to convert to the
> one process multithreaded approach, as Apache, Interbase and others
> are doing?
there has been talk about doing some threads actions inside of a
process, but, if I recall my read
Dear:
I wanna create a function that return a multiple rows in to a single
row.
example:
CREATE FUNCTION GETNAME() RETURNS SETOF VARCHAR AS 'SELECT NAME FROM
TEST;' LANGUAGE 'SQL';
when i call this function it return:
--
peter
susan
john
but I wonder is it possible to make it to ret
Vacuum analyze keeps hanging here...
NOTICE: --Relation referer_log--
NOTICE: Pages 529: Changed 1, reaped 509, Empty 0, New 0; Tup 24306:
Vac 43000, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 72, MaxLen 324;
Re-using: Free/Avail. Space 5205100/5193540; EndEmpty/Avail. Pages
0/508. CPU 0.03s/0.11u
21 matches
Mail list logo
