fixed
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Michael Fuhr
> Sent: Sunday, December 05, 2004 9:41 AM
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] List archives search function broken
>
> Using the list archive search function currently fai
The following is a preview of the 4th PostgreSQL RFD. Please suggest any
changes or improvements. I will send it to the NAN team Sunday night. It
can take up to a week to be posted by the NAN team, so I'll try to get the
bugs out of the RFD before I give it to them. :-)
P.S. feel free to post
System is 4-way Opteron 844, 16 GB memory, SCSI. This is a trial run
for converting an Oracle DB, so system is not optimized. I have
shared_buffers = 5
work_mem = 65536
A table has about 65 million rows (data collection system.) It has a
primary key, no other indexes, no OIDs. The primar
On Sat, 4 Dec 2004, Henry Molina wrote:
> drop table t1;
> drop table t2;
> create table t1 (id integer);
> create table t2 (id integer);
> CREATE OR REPLACE FUNCTION myfunc() RETURNS trigger AS '
> BEGIN
> insert into t2 values(NEW.id);
> END;
> ' LANGUAGE plpgsql;
>
> CREATE TRIGGER
>
On Sat, Dec 04, 2004 at 11:53:46PM -0500, Henry Molina wrote:
> drop table t1;
> drop table t2;
> create table t1 (id integer);
> create table t2 (id integer);
> CREATE OR REPLACE FUNCTION myfunc() RETURNS trigger AS '
> BEGIN
> insert into t2 values(NEW.id);
> END;
> ' LANGUAGE plpgsql;
>
Hi all
I'm having a problem with PostgreSQL 7.4.6-2
I do:
drop table t1;
drop table t2;
create table t1 (id integer);
create table t2 (id integer);
CREATE OR REPLACE FUNCTION myfunc() RETURNS trigger AS '
BEGIN
insert into t2 values(NEW.id);
END;
' LANGUAGE plpgsql;
CREATE TRIGGER
Eric Brown wrote:
SELECT expandobj(obj), * from mytable;
I get:
ERROR: cannot display a value of type record
I think/hope I'm missing something pretty stupid, but I can't figure out
what it might be. Any help would be appreciated. There might even be a
quite better way.
What you're trying to do i
Using the list archive search function currently fails with
503 Service Unavailable.
Should messages about list archive problems go to pgsql-general,
or would it be better to use one of the other lists like bugs,
hackers, or www?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
-
On Saturday December 4 2004 1:01, Ed L. wrote:
>
> ...I have a
> shell game using rules that goes like this for bloated table foo:
> ...
> begin
> drop view foo
> alter table slim_foo rename to foo
> commit
>
> Some basic testing for my particulars suggests this works, but anyone see
>
Hi,
Before anything I'm very sorry for sending that "RTFM" style question about
pg_autovacuum. I found it, but I couldn't try it out...
I faced a problem starting the postgres service.
After installation everything had gone well until I started
pg_autovacuum.exe. I do not think that something is
I have a table (quite a few of them actually) where python objects are
serialized into a column. So a table might look like:
CREATE TABLE mytable (id int, obj bytea);
When I'm trying to diagnose/debug things, I'd like to be able to expand
the 'obj' column into multiple columns in a view. I create
On Sat, Dec 04, 2004 at 12:18:03AM -0400, Marc G. Fournier wrote:
>
> After 3 months of BETA testing, The PostgreSQL Global Development Group is
> pleased to announce that we've locked down the source code and have now
> released our first Release Candidate.
>
> Our goal is to formally release
tom,
We're doing the best we can already: when the failure occurs, we really
don't know which directory is the problem, and cannot find out because
we can't navigate above it to find out its name.
good point. catch-22.
at the very least, some knowledgeable commentary in
docs/FAQ/howto/Troubleshoo
OpenMacNews <[EMAIL PROTECTED]> writes:
> whoa! i wasn't suggesting that at all ... rather, perhaps, simply a perms
> check
> from within the initdb script and an 'informative' error to the
> end-user.
We're doing the best we can already: when the failure occurs, we really
don't know which direc
hi tom,
% ls -ald /Volumes/data
drwxr-x--x 12 openmac wheel 408 Nov 27 15:25 /Volumes/data/
Ah-hah, yes that's undoubtedly it.
and, since i've cleared that up pgsql is, again, behaving. yay.
for posterity's -- and other OSX users' -- sake, that's:
for the relevant drives/mounts in /Volu
On 3 Dec 2004 20:34:36 GMT, Woodchuck Bill <[EMAIL PROTECTED]> wrote:
>David Harmon <[EMAIL PROTECTED]> wrote in
>news:[EMAIL PROTECTED]:
>
>> On Fri, 3 Dec 2004 00:29:40 + (UTC) in news.groups, Marc G.
>> Fournier From: <[EMAIL PROTECTED]> wrote,
>>>The pgsql.* hierarchy is a not a private
OpenMacNews <[EMAIL PROTECTED]> writes:
> on my sys:
>% ls -ald /Volumes/data
> drwxr-x--x 12 openmac wheel 408 Nov 27 15:25 /Volumes/data/
Ah-hah, yes that's undoubtedly it.
> if this *does* turn out to be the case, does it make sense to have the script
> check perms up through the
On Sat, 4 Dec 2004, Rolf Xstvik wrote:
[EMAIL PROTECTED] ("Marc G. Fournier") wrote in
news:[EMAIL PROTECTED]:
On Fri, 3 Dec 2004, Net Virtual Mailing Lists wrote:
this RFD in no way affects the mailing lists, and is in no way an
'official PostgreSQL newsgruop' ... the 'official newsgroups' are the
On 12/3/2004 4:12 PM, Mike Cox wrote:
Jan Wieck wrote:
So how exactly do you think that big number of non-developer advanced
PostgreSQL users will populate the comp.* groups? I don't see them there
right now, and without them the comp.* groups are the wrong groups
because you will not get answers t
John DeSoi wrote:
> Hi Michael,
>
> On Dec 2, 2004, at 11:53 PM, Michael Fuhr wrote:
>
> > Try setting the PGCONNECT_TIMEOUT environment variable:
> >
> > env PGCONNECT_TIMEOUT=5 psql -h bogushost
> >
>
>
> This works great -- thanks very much.
>
> I did not see this anywhere in the documentat
Dear Postgresql experts,
Looking at vmstat output on my database server I have been suprised to
see lots of disk writes going on while it is doing what should be
exclusively read-only transactions. I see almost no disk reads as the
database concerned is small enough to fit into the OS disk cach
Hi Michael,
On Dec 2, 2004, at 11:53 PM, Michael Fuhr wrote:
Try setting the PGCONNECT_TIMEOUT environment variable:
env PGCONNECT_TIMEOUT=5 psql -h bogushost
This works great -- thanks very much.
I did not see this anywhere in the documentation. Did I miss it or is
the source code the only refer
[EMAIL PROTECTED] ("Marc G. Fournier") wrote in
news:[EMAIL PROTECTED]:
> On Fri, 3 Dec 2004, Net Virtual Mailing Lists wrote:
>
> this RFD in no way affects the mailing lists, and is in no way an
> 'official PostgreSQL newsgruop' ... the 'official newsgroups' are the
> gated ones under pgsql.
Hi,
is it possibile to use an autovacuum feature on the win32 platform?
Or should I write a service application (or use the at service) to run
vacuumdb regularly?
thank you,
-- Csaba Együd
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Vers
24 matches
Mail list logo
