--- Tom Lane <[EMAIL PROTECTED]> wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > I believe that's not necessarily true. If you
> select a tuple and it's
> > ctid and it's updated more than once with a vacuum
> in-between I believe
> > it could end up back in the same position, which
> woul
--- "Jim C. Nasby" <[EMAIL PROTECTED]> wrote:
> On Wed, Aug 24, 2005 at 09:26:10AM +0930, Jeff
> Eckermann wrote:
> > The ctid value can be useful in a multi user
> application, to check whether a
> > record has been changed by another user, before
> commi
""Ilja Golshtein"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello!
>
>>On Tue, Aug 23, 2005 at 09:15:42AM -0400, Robert Treat wrote:
>>> On Tuesday 23 August 2005 08:39, Ilja Golshtein wrote:
>>> >
>>> > select ctid from aaa where ctid in (select ctid from aaa limit 10);
>
>>A
"Ulises Poirier" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello:
>
> I can't to download this version..can you help me?
What did you do, and what happened? A copy-and-paste of a terminal session
would be ideal.
>
> regards,
> Ulises
>
> ---(end
"Jeff D. Hamann" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Sorry for the seemingly novice posting, but I could find a solution for
> this on the web so far...
>
> I've been developing a database using postgresql (and loving it) and have
> started running into problems with attem
"Scott Marlowe" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Fri, 2005-05-27 at 09:57, [EMAIL PROTECTED] wrote:
>
>>
>> Thanks for answer Tom
>>
>> "Consider what happens when the user leaves for lunch"
>>
>> Well, I've already thought about it.But I'm working with
>> VS2003 an
""Zlatko Matiæ"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hello.
I have a problem when working with MS Access/PostgreSQL.
Namely, as PostgreSQL syntax uses doble quotes for table names and field
names, when I write it as a string of a pass-through query or Command text
of A
""Zlatko Matic"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I was using ADO command object and both refresh method and method with
>creating parameter object while working with Access Project...but I didn't
>try to use it with PostgreSQL...
> I would rather like to have all que
""Philippe Lang"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
>
> Yes, I'm sure this kind of feature is application-based. There is nothing
> in the driver itself. If I'm not wrong, MS Access uses a timestamp column
> to check if the record was updated meanwhile, or the col
<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
>
> It is just too bad that there is not a better, more user friendly, well
> documented front-end tool for Postgresql in open source. It really is
> kind of a
> marketing issue, in a way. I mean, if someone could really put together
>
"Fmiser" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I'm a newbie to database admin, but I'm not afraid to try - but this one
> has me stumped.
>
> I'm using SQL-Ledger as a front end to postgresql 7.4.2. on (mostly)
> Debian Testing, i386.
>
> My fiscal year is over and I would
--- Zlatko Matic <[EMAIL PROTECTED]> wrote:
> I asked this question several weeks ago, but nobody
> proposed a solution, so
> I am repeating the same question again...
> I have an MS Access front-end for a database on
> PostgreSQL.
> I could use pass-through queries as record sources
> for reports
--- [EMAIL PROTECTED] wrote:
> I DID Succeed in doing the sort of things I want in
> VBA script in MSAccess,
> but that does me no good at work because we cant get
> the money to purchase
> copies of Access.
>
> I own a copy of Visual Basic, and if I could find a
> good example of
> acce
"Bruno Wolff III" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Please keep replies copied to the list so that other people can learn from
> and comment on the discussion unless to have a good reason to make the
> thread private.
>
> On Mon, Apr 25, 2005 at 21:46:20 +0200,
> Zlatk
"Tony Caduto" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> In a real application that uses a client/server type database you should
> NEVER construct queries that return a million rows.
> You have to keep in mind that each record has to be sent accross the wire
> via TCP/IP and
"Scott Ribe" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>> ..so the only question is:
>>
>> drop the the serials as PKs and just use short text handles? our
>> database size is arround 290 mb. there shouldn't be speed issues as long
>> as proper indexes exit, right? some of the co
<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
> Tonight I shall install the Postgresql ODBC driver which I downloaded, and
> experiment.
>
> Is anyone using ODBC? I was looking at Realbasic standard edition (not
> professional), and thinking of downloading the demo and trying it wi
<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
> Thanks for the help with /dt... Mike, your post helped me to discover psql
> command window, I had been trying out the pgAdmin ...
>
> I found an interesting article regarding MSAccess as a front end to
> Postgresql, so I downloaded the
"Zlatko Matiæ" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello.
>
> While I was working with Access Projects (Access front-end with MSDE) I
> was able to call stored procedures by using ADO command and parameters
> object.
> Now I am trying to migrate my database from MSDE t
Looks like your ODBC settings might have changed in the switch. In
particular, look at the " text as longvarchar" setting.
If you cannot find a solution, try posting to the pgsql-odbc list.
"Kristina Magwood" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
> We are updating f
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
>
> How do I call a StoredProcdure, written in PlPqSql
> which returns a set of records (or tableWhatever)
> and wants parameters,
> from ADO while using "adCmdStoredProc" ?
I don't believe that works (anyone who thinks I'm wrong,
--- Konstantin Danilov <[EMAIL PROTECTED]> wrote:
> Hello everyone!
> I have a question.. Does PostgreSQL have official
> certification? If yes, where can I find
> certification courses to get a certificate?
There are no official certifications. Anyone who
wants to can offer their own certificat
--- Marco Bizzarri <[EMAIL PROTECTED]> wrote:
> Hi all.
>
> I would like to know if postgresql has any
> certification for the
> military environment.
There are no official certifications, nor are there
likely to be. But certifications may be offered by
individual companies, like Red Had does
--- Joolz <[EMAIL PROTECTED]> wrote:
>
> Thanks.
>
> Btw what's going on on the list??? I seems someone
> is posting a lot
> of obscene nonsense, using my email address. I saw
> this happen
> before with someone else. Is there anything I can do
> about it?
This is the down side of free will.
--- Jerry III <[EMAIL PROTECTED]> wrote:
> Which means that sometimes they do not return the
> correct value - if you
> have a trigger that inserts another record you will
> not get the right value.
If you are new to PostgreSQL, as you say, then why are
you so sure of this? Perhaps you may pro
--- Brian {Hamilton Kelly} <[EMAIL PROTECTED]> wrote:
> Which only confirms my opinion that he's a fuckwit.
Evidently some of the nastiness out there on Usenet is
propagating into our lists in advance of any change.
__
Do you Yahoo!?
Check ou
--- William Yu <[EMAIL PROTECTED]> wrote:
> > ??? As a longstanding reader of the pgsql-
> > mailinglists, (including via news.postgresql.org
> on
> > occasion), all I see is some outsiders trying to
> help
> > us "fix" a problem that does not exist. And yes,
> I
> > have read most of the messag
--- Liviu BURCUSEL <[EMAIL PROTECTED]> wrote:
> Hi !
>
> I'm in the ultimate state of dispair. Over the night
> some of my
> databases just disapeared. But they did not dissaper
> totally. I can
> still connect to them but I cannot dump them. When
> doing a "select *
> from pg_database" I see onl
--- "Gary L. Burnore" <[EMAIL PROTECTED]> wrote:
> On 9 Nov 2004 15:51:24 -0800,
> [EMAIL PROTECTED] wrote:
>
> >This is a very unfair limitation.
>
> Stop top posting.
>
> >If there is a ballot, it should be posted to each
> of the individual mailing lists.
>
> That's not how it works.
>
>
--- Sim Zacks <[EMAIL PROTECTED]> wrote:
> After the stored procedure is run, call requery on
> the form that was
> updated.
>
> We are in the middle of moving Access
> implementations to PostGreSQL.
> I'd be happy to trade war stories, if you'd like.
I hope that you do it on the list, so that
--- Daniel Secomb <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm using PostgreSQL 7.3.4 on phpPgAdmin 2.4.2 and
> I'm getting the following
> error when I try and run a SQL query on a script:
>
> Error -
>
/usr/local/psa/admin/htdocs/domains/databases/phpPgAdmin/db_readdump.php
> --
> Line: 33
> Postg
--- Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Sun, 2004-08-29 at 15:30, Bruno Wolff III wrote:
> > On Fri, Aug 27, 2004 at 13:32:07 +0530,
> > Yateen Joshi <[EMAIL PROTECTED]> wrote:
> > > Hi,
> > >
> > > I have got a table which is supposed to contain
> only one row. It does
> > > not ha
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Jeff Eckermann <[EMAIL PROTECTED]> writes:
> > That probably won't impress your bosses. If you
> need
> > a track record, then erServer might be what you
> need.
> > erServer is a commercially produced produc
--- Darkcamel <[EMAIL PROTECTED]> wrote:
> Hello all,
>
> I am new to postgres and don't really understand
> how the database is
> set-up. I am very fluent with mysql and sql2000,
> but postgres is new to
> me. If anyone can point me to some good links I
> would appreciate it
Slony seems to be moving to the head of the pack of
replication solutions. Still too new to say
definitively.
Slony author Jan Wieck has said repeatedly that
replication is used in practice to meet various needs,
and there is no one replication solution that can be
ideal for all of them. For tha
I recall an extended discussion of certifications and
training some time back. You may recall it, too.
The outcome (if it may be so called) was the view
that, given the nature of the PostgreSQL project,
there exists no entity that can bless a certification
and thereby make it "official", any more
--- Paul Thomas <[EMAIL PROTECTED]> wrote:
>
> On 28/05/2004 20:46 Jeff Eckermann wrote:
> > I had a thought that the ODBC driver could be
> > stripping the trailing spaces, but the test I just
> did
> > (using MS Access via ODBC) worked fine.
>
> But
--- Tom Allison <[EMAIL PROTECTED]> wrote:
> Jeff Eckermann wrote:
> > --- Tom Allison <[EMAIL PROTECTED]> wrote:
> >
> >>I seemed to remember being able to do this but I
> >>can't find the docs.
> >>
> >>Can I run a sql query to
--- Tom Allison <[EMAIL PROTECTED]> wrote:
> I seemed to remember being able to do this but I
> can't find the docs.
>
> Can I run a sql query to insert new or update
> existing rows in one query?
>
> Otherwise I have to run a select query to see if
> it's there and then
> another one to update/
--- Mage <[EMAIL PROTECTED]> wrote:
> Bruce Momjian wrote:
>
> >
> >Uh, we have EXECUTE, but I don't know if will allow
> you to set a local
> >variable. Maybe you can do:
> >
> >
> execute doesn't support select into
It does, if you use the "for variablename in execute
..." syntax. Which may
--- Rick Gigger <[EMAIL PROTECTED]> wrote:
> > So can I quietly beg the Win32 group to expedite
> this port. I believe
> > you will be utterly astonished at the demand.
> Please.
>
> I'm sure quietly begging certain developers with
> your pocekt book
> probably wouldn't hurt your cause either
--- Harald Fuchs <[EMAIL PROTECTED]> wrote:
> In article
> <[EMAIL PROTECTED]>,
> "LitelWang" <[EMAIL PROTECTED]> writes:
>
> > I need this function :
> > CheckDate('2002-02-29') return false
> > CheckDate('2002-02-28') return true
>
> Why would you want to do that? Just try to insert
> '2002-02
--- [EMAIL PROTECTED] wrote:
> I write this to tell you why we won't use postgresql
> even though we wish we
> could at a large company. Don't get me wrong I love
> postgresql in many
> ways and for many reasons , but fact is fact. If
> you need more detail I
> can be glad to prove all my points.
--- Bret Busby <[EMAIL PROTECTED]> wrote:
> On Mon, 29 Dec 2003, Jeff Eckermann wrote:
>
> >
> > Isn't this what books are supposed to be for? i.e.
> to
> > fill in the gaps or provide the coverage, tips,
> howtos
> > etc. etc. that no-one really ex
This has been an interesting thread, with lots of well
considered contributions. The consensus seems to be
"PostgreSQL is plenty good enough and more, we just
need more people to know it, and an easier learning
path".
What bothers me a little here is an apparent lack of
awareness of the work of t
Chris,
Your persistence and your ideas suggest that you have
something to contribute in this area. Why not sign up
on the pgsql-advocacy list, and carry your ideas
forward there? That would be an appropriate forum for
this kind of discussion.
The arguments on both sides (if there are only two
s
--- Craig O'Shannessy <[EMAIL PROTECTED]> wrote:
>
> As it's very unlikely that there are tab's in your
> strings, tab makes a
> much safer field separator.
Probably, but I wouldn't bet the farm on it. I have
found plenty of instances of unexpected tabs,
especially with data generated from cha
--- Oksana Yasynska <[EMAIL PROTECTED]> wrote:
> Jeff,
>
> thank you for the time and suggestion.
> I'm also trying to use SETOF custom_type as a
> solution
I don't believe that works in 7.2. But if you do make
it work, be sure to tell me how ;-)
That will work with 7.3, but I am assuming that,
--- Oksana Yasynska <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I'm running Postgres 7.2.1 and I need to return
> multiple row sets from plpgsql
> function. I'm new in plpgsql but according
> documentation and everything I
> could find in the mailing list I need to switch to
> 7.3 to get at least S
--- G Lam <[EMAIL PROTECTED]> wrote:
> Hi, I am new to postgresql. I have done some small
> applications with MS
> Access. Are there some PG tools out there that can
> build applications like
> MS Access does out there?
MS Access works well with PostgreSQL via ODBC. Check
here: http://gborg.postg
--- Fabrizio Mazzoni <[EMAIL PROTECTED]> wrote:
> Hello .. i did the migration and my advice is that
> you forget about the automatic translation tools...
I have used the "migration wizard" that comes as a
plugin for PgAdminII, and was very happy with the
result. Yes, you can do everything by h
This discussion provides an opportunity to capture the
essentials of how to store and retrieve images using
PostgreSQL, and the issues (performance,
administration etc.) associated with each possible
method.
A discussion article on Techdocs (or even General
Bits?) would be a fine thing. My observ
--- Jonathan Bartlett <[EMAIL PROTECTED]> wrote:
> I'm a big fan of bytea. In every case where I've
> done the filesystem
> method I wished I hadn't.
For the education of me and maybe others too, why was
that? i.e. what problems did you run into, that bytea avoids?
_
--- Amin Schoeib <[EMAIL PROTECTED]> wrote:
> Hi,
> Like I see there is no equivalent to the Oracle
> decode Function
> In Postgres.Is there maybe somebody who wrote decode
> as a
> Function?
The problem for any such body is that there is no one
function possible in PostgreSQL that will cover all
Look at the "trim" function.
While you are about it, looking over the other
available functions would be worth your while too
(look under "Functions and Operators" in the docs).
--- Amin Schoeib <[EMAIL PROTECTED]> wrote:
>
> Hi,
> Is there an equivalent for the trunc function of
> Oracle in Post
Your function worked fine for me (I copied and pasted).
What PostgeSQL version are you running? EXECUTE is a new feature for
version 7.1.
- Original Message -
From: "Gaurav Priyolkar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 12, 2001 1:15 PM
Subject: [GENERA
Outer joins are supported in PostgreSQL, but not before version 7.1.
If you are using version 7.1, please post your failing query, and someone
will be able to help you.
"Emmanuel SARACCO" <[EMAIL PROTECTED]> wrote in message
9nnjc3$68p$[EMAIL PROTECTED]">news:9nnjc3$68p$[EMAIL PROTECTED]...
> hi,
use "ILIKE" instead of "LIKE"
or use a regular expression match: ~* 'red'
- Original Message -
From: "Michael Gay" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, September 09, 2001 11:02 PM
Subject: [GENERAL] Case sensitivity issue
> If I am doing a command such as
>
> sele
COPY expects NULL to be represented by "\N" by default.
Probably easiest to explicitly specify on the command line what you want
COPY to recognize as a NULL: "copy table from wherever with null as
'something';"
- Original Message -
From: "Dwayne Miller" <[EMAIL PROTECTED]>
To: <[EMAIL PRO
COPY is the command used for bulk loading in PostgreSQL (check the "SQL
Commands" in the "Reference Manual" part of the docs).
COPY is not intelligent about interpreting varying data formats. Your
flexibility is limited to specifying the data delimiter and whatever string
you want to represent NU
No. "template0" is new for version 7.1. No doubt a developer can tell you
exactly why dropping "template0" would be a very bad idea; I am just getting
in quickly to make sure you don't do so in the interim :-)
- Original Message -
From: "Andrew Gould" <[EMAIL PROTECTED]>
To: "J.H.M. Das
I think you need to double the single quotes around the sequence name:
(''seq1'').
Statements inside function definitions go through an extra level of parsing,
which strips off one set of single quotes.
- Original Message -
From: "Ron S" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: M
Before doing anything so drastic, you may want to check the archives for
recent messages on a similar error. IIRC, this problem can be caused by
rolling back a "drop table" command. The effect is that the table structure
in the database remains, but the physical file is gone.
The fix is to crea
I think we may be using too many words in this discussion.
Perhaps there is a message in this thread that I have not seen.
Miroslav, have you tested for carriage returns in your data, and if so, what
did you find?
If that is the problem, the carriage returns are easily edited out, and
speculation
ould
cause real problems with any app that tries to use those fields, and a headache
to debug.
- Original Message -
From:
Rob Arnold
To: Jeff Eckermann ; Miroslav Koncar
Cc: [EMAIL PROTECTED]
Sent: Thursday, August 23, 2001 6:32
PM
Subject: Re: problems transferi
Looks like you already have the answer. The
error message is a dead giveaway. Some field, in this case having a null
value (represented as '\N') contains a carriage return character, like:
'\NCR'. PostgreSQL cannot make sense out of this combination, so it
returns an error. The CR contai
You need to declare the variable "ret", i.e. add a line before "BEGIN" like:
DECLARE ret integer;
Your function will not work without that.
You may still get an error for some other unknown reason, or you may not.
I have found that plpgsql errors can be highly uninformative, or downright
misleadin
I would load the 1000 values into a temporary table, and join on the ID
field. I usually find that approach gives much faster results.
> -Original Message-
> From: Zak McGregor [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, June 12, 2001 7:42 AM
> To: [EMAIL PROTECTED]
> Subject: [GENE
I was bitten by the same problem recently. It means that the owner of the
pgsql call handler no longer exists. To find out the id of the owner, do a
select like:
select * from pg_proc where proname like 'plpg%';
Then create a user having that id. You may need to edit pg_shadow to get
the desire
Also:
* Watch out for embedded tabs and carriage returns in your data: these
will cause problems during or after your COPY into PostgreSQL.
* Check the value used in the exported file to represent NULL values
(could be an empty string, or "NULL", or something else), and use that in
you
Try:
SELECT DISTINCT ON (org_id) rpt_id, org_id, period,...
FROM reports
ORDER BY period DESC;
> -Original Message-
> From: Eric G. Miller [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 01, 2001 4:04 AM
> To: PostgreSQL General
> Subject: [GENERAL] Improve a query...
>
> Looking fo
I got good results in a test case, just using a standard PostgreSQL dump
file created with INSERT statements (pg_dump -d). All it needed was a
little editing to change some of the data types in the table definition,
e.g. from text and varchar to varchar2 (if your Oracle table is set up, you
won't
oblem, please let me know. In any case,
pg_dump is now working for me.
Thank you once again for your valuable help.
Regards
> -Original Message-
> From: Tom Lane [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 23, 2001 6:23 PM
> To: Jeff Eckermann
> Cc: '[EMAIL PROTE
Have you dropped and recreated the function since creating the trigger? Try
dropping and recreating the trigger. Errors like this happen because
database objects (tables, functions etc) are referenced by object ids (oids)
behind the scenes. Recreating an object (like a function) will give it a
COPY expects tab delimiters by default, so specifying them is not strictly
necessary in this case.
Specifying "null as xxx" is a good idea, because COPY interprets an empty
field as an empty string, which will cause failure for non text-type fields.
A couple of other things to watch out for when b
My main server is down, so I am using my backup copy on a different
database.
Based on past posts I have read, this error is usually associated with
running out of memory for the query result. Problem is, I am only
expecting about 30 lines of moderate length to be returned I see
nothing in t
In my experience, the best way to find out answers like this is to try it
out and see. Usually I find that I need to fiddle around with the syntax a
bit (I believe it's called debugging) before getting something to work.
Postgresql is very powerful; the capability to utilize that power comes at a
Excel can do this for you, if you use File -> Save As...
You will find various file types available. The list will vary according to
the completeness of your Excel installation. I believe that at minimum you
should have "tab delimited text" available, and probably csv as well (don't
use csv, it'
I would appreciate any advice on getting out of this strange situation. My
table now doesn't exist, but I can't recreate it either (at least under that
name).
jeffe@kiyoko=> psql -V
psql (PostgreSQL) 7.0.0
jeffe@kiyoko=> uname -a
FreeBSD kiyoko.la.verio.net 4.0-STABLE FreeBSD 4.0-STABLE #0: Thu
-
> From: Tom Lane [SMTP:[EMAIL PROTECTED]]
> Sent: Saturday, January 06, 2001 3:41 PM
> To: Jeff Eckermann
> Cc: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] Help with SQL Function
>
> Jeff Eckermann <[EMAIL PROTECTED]> writes:
> > extracts=# create function tes
Isn't this overkill?
Something like:
sed -e 's/\" \"/^I/g' -e 's/\"//g'
would do the job nicely. I'm sure people on this list can suggest even
simpler ways (note: the "^I", or tab character, in the example is created by
typing Ctrl-V then Ctrl-I).
Sed has been (and is) my friend for many
(My first attempt at posting didn't make it to my mailbox, so I am
reposting. Apologies to any who get this twice.)
I have been trying to use the translate function to delete a specific string
from entries in a particular column, as in "translate(, 'string',
'')".
What I find is that "translate"
I have been trying to use the translate function to delete a specific string
from entries in a particular column, as in "translate(, 'string',
'')".
What I find is that "translate" is treating the nominated string as a
character class, and is deleting every instance of every character in that
clas
2000 12:49 AM
> To: Jeff Eckermann
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: [GENERAL] Index on substring?
>
> Jeff Eckermann <[EMAIL PROTECTED]> writes:
> > extracts=# create index c_namesum_i on customers
> (substr(bill_company,1,5));
> > ER
I thought this was possible, but searching the archives & docs I can't find
any reference to it...
Am I doing something wrong?
jeffe@kiyoko=> psql -V
psql (PostgreSQL) 7.0.0
jeffe@kiyoko=> uname -a
FreeBSD kiyoko.la.verio.net 4.0-STABLE FreeBSD 4.0-STABLE #0: Thu Apr 27
10:44:07 CDT 2000 roo
-Original Message-
> From: Tom Lane [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 09, 2000 12:35 PM
> To: Jeff Eckermann
> Cc: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] Query bombed: why?
>
> Jeff Eckermann <[EMAIL PROTECTED]> writes:
> > Af
Maxusers is set to 128. RAM is 256Mg.
Do you think this could be the problem?
> -Original Message-
> From: admin [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, January 11, 2000 12:50 PM
> To: Jeff Eckermann
> Cc: '[EMAIL PROTECTED]'
> Subject: RE: [GEN
FreeBSD port: I don't know enough to know what difference that might make.
Any suggestion you have would be appreciated: thanks.
> -Original Message-
> From: admin [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, January 11, 2000 12:18 PM
> To: Jeff Eckermann
> Cc:
We upgraded to version 6.5.2 recently, running on FreeBSD 3.0. Now we are
having problems with moderately complex queries failing to complete (backend
terminating unexpectedly; last one crashed the server). The most likely
explanation appears to be a memory leak. Is there any known problem with
89 matches
Mail list logo
