With the following function I expected to get an iteration through the results. But
the loop seems to be performed two times instead.
The function (postgres 7.2):
create function echt_char_laenge ()
returns integer
as
'
declare
char_auslese record;
begin
for char_auslese in sel
On Wed, 4 Dec 2002, Stefan Reuschke wrote:
> With the following function I expected to get an iteration through the
> results. But the loop seems to be performed two times instead.
I tried you exact example in 7.2.1 and got every row only once. It doesn't
help you find the error perhaps, but it d
Vernon:
Agreed. We use Struts (as our MVC framework), and then a data access
layer (we call persistables) that uses the PreparedStatements. Our JSPs
only get data to render *after* the business logic has decided that all
logic has been performed successfully.
The end-result is easily compartm
I am sending a shema of used
table.
schema0.sql
Description: Binary data
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
When the MVC pattern is employed and EJB is absented, the DAO pattern shall be
utilized. With this system design, the
DB routines are isolated from the rest of system for the purpose of "robust" as you
mentioned. In the future, you only
need to write another set of DAO implemention if you deci
Hi;
I've got a table with several fields. Among others there are the fields
'soil1', 'soil2', and 'soil3' that are char type. A row can have an empty
value in one of these fields, or the three fields can have valid values:
cod_grass |suelo1|suelo2 | suelo3
"Alphasoft" <[EMAIL PROTECTED]> writes:
> In 7.3 when i am trying to recreate the view I received the folowing error :
> find_expr_references_walker: bogus varno 8
Found it --- thanks for the test case. The patch is attached, if you
want to apply it locally.
regards, tom
Hi all.
Twice this week, I've come to work to find my Postgres server out of
connections... effectively freezing my web server.
Today, before I rebooted the entire system, I did a ps -auxw and kept the
file to study. I didn't find too many clients running. But I did find a
whole LOT of postg
On Wed, Dec 04, 2002 at 03:08:35PM -0700, Mike Diehl wrote:
> Hi all.
>
> Twice this week, I've come to work to find my Postgres server out of
> connections... effectively freezing my web server.
>
> Today, before I rebooted the entire system, I did a ps -auxw and kept the
> file to study. I d
You probably didn't need to reboot - I suspect you could have probably
restarted PostgreSQL and Apache (quick version) or killed the extra postgres
processes.
I suspect you need to look carefully at your code and method of connecting
(ie. are you using mod-perl, plain old cgi perl, PHP or what)
Once your done scoping other things out, you might also want to look at
increasing the number of allowed connections (in postgresql.conf). The
defaults can be low for high traffic systems.
Robert Treat
On Wed, 2002-12-04 at 17:29, Steve Crawford wrote:
> You probably didn't need to reboot - I sus
On Wednesday 04 December 2002 03:25 pm, Roberto Mello wrote:
> On Wed, Dec 04, 2002 at 03:08:35PM -0700, Mike Diehl wrote:
> > Can anyone tell me how to fix this? The out put of the ps command
> > can be seen at http://dominion.dyndns.org/~mdiehl/ps.txt
>
> Are you using P
On Wed, Dec 04, 2002 at 02:29:25PM -0800, Steve Crawford wrote:
>
> If you are doing lots of database backed work you may want to check out
> AOLserver (http://www.aolserver.com/). It has a multi-threaded architecture
> featuring connection pooling and persistence "out of the box." Oh, it's
> f
Doing anything unusual? Forking processes, opening multiple connections
within a single CGI?
Have you seen any evidence that a process that opens a connection is failing
to complete normally?
-Steve
On Wednesday 04 December 2002 3:52 pm, Mike Diehl wrote:
> On Wednesday 04 December 2002 03:25
14 matches
Mail list logo
