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
"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
<[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
<[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
"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
"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
"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
--- [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
--- 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
"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
<[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
>
""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
""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
""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
"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
"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
"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
""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
--- "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
--- 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
--- 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
--- "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.
>
>
--- 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
--- 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
--- 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
--- 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
--- 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.
--- 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
--- 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
<[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,
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
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
--- 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
--- [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.
--- 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
--- 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
--- 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
--- 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/
--- 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
--- 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
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
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
--- 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
--- 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
--- 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
--- 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
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
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
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
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
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 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
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
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
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
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,
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
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
--- 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
--- 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?
_
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
--- 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
--- 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
--- 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
--- 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,
--- 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
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
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 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
(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"
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
-
> 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
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
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'
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
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
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
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
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
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
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
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
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
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
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
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:
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
-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
89 matches
Mail list logo
