hello,
maybe this has been asked a thousand times, but as the archive seem not to
respond to any search, here is my question:
Is there a way to parametrize the connection time-out, when starting the
postmaster, or something like that? The connection to postgres are timed
out after some 3 or
hello ,
is there any connection time out parameter to be set while
starting the
postmaster.the connection to postgresql are timed out after some 5
minutes.
i am running postgresql 6.5.3 on freeBSD 3.4 and accessing it using
jdbc.
why i get this problem ? can anyone help me out ???!!!
databasename=# explain select DISTINCT (case when resubmitted created then
resubmitted else created end),a.app_id, a.appcode, a.firstname,
a.middlename, a.lastname, a.state, a.degree1, a.d1date, a.degree2, a.d2date,
a.salary, a.skill1, a.skill2, a.skill3, a.objective, a.employer, a.sic1,
a.sic2,
Moin,
I have al small problem with ISNULL in a trigger
function. My definition looks like:
IF NEW.vkp ISNULL THEN
select t1.las into i_kd
from auftrag t1, aufpos t2 where
t2.auftrag = t1.id;
select get_vkp(i_kd, NEW.artikel) into f_vkp;
NEW.vkp:=f_vkp;
END IF;
The following
Hi,
May be this insert will work with your test in your function
insert into aufpos(auftrag, artikel, best_menge, vkp,
lieferwoche, cuser, ctime, uuser, utime) values
('175','8501900','12',NULL,'3500','matthias',
now (), 'matthias',now ())
Nicolas
Matthias Teege a écrit :
Moin,
I have
On Mon, 26 Jun 2000, Tom Lane wrote:
"Dale Anderson" [EMAIL PROTECTED] writes:
I noticed that the DateTime fields and the to_timestamp function
interpret 12 PM as 00:00 and 12 AM as 12:00.
Huh?
Looks fine to me.
No, you overlook "to_timestamp()" in query. This routine really has
"Len Morgan" [EMAIL PROTECTED] writes:
... I cannot seem to make Postgres join two
tables when the type of one is char(9) and the other is character
varying(9). The machine seems to go into an endless loop.
What? Specific example, please.
A similar problem I have is with fix precision
At 10:01 PM 26-06-2000 -0400, Michael Mayo wrote:
- Original Message -
From: "Lincoln Yeoh" [EMAIL PROTECTED]
What are the recommended ways to do transactions in web applications?
Right now I have persistent database connections, but currently they are
shared by multiple sessions. So
On Tue, 27 Jun 2000, Morten W. Petersen wrote:
How do you dump from the Postgre database?
(i.e. as with MySQL, where you have mysqldump)
The PostgreSQL documentation is invisible?
Karel
Lincoln Yeoh writes:
At 10:01 PM 26-06-2000 -0400, Michael Mayo wrote:
- Original Message -
From: "Lincoln Yeoh" [EMAIL PROTECTED]
What are the recommended ways to do transactions in web applications?
Let me illustrate the problem with an example:
page 1
user logs in
page 2
The PostgreSQL documentation is invisible?
Yeah, it just vanished. Not my fault. The bitbucket ate it.
-Morten =)
hi,
i've created a function as follows:
drop function rates_hist_function();
CREATE function rates_hist_function()
returns opaque
as 'BEGIN
if ( old.rt_valid ''P'' or new.rt_valid not in
(''Y'',''N''))
then
new.rt_timestamp =
Here is am example of what I am doing.
danderso=# \d test
Table "test"
Attribute | Type| Modifier
---+---+--
time | timestamp |
danderso=# insert into test values (to_timestamp('1200 PM JUN 27 2000','HHMI PM MON DD
'));
INSERT 22825 1
Hello,
In DBD::Pg one can read (line 134):
$lobj_fd = $dbh-func($lobjId, $mode, 'lo_open');
But how is the LOB retrieved in the first place? If I pass the OID of an
existing LOB instance from a table the returned $lobj_fd is null. What
kind of $lobjId is one supposed to pass to this
*/
On Tue, 27 Jun 2000, Dale Anderson wrote:
Here is am example of what I am doing.
danderso=# \d test
Table "test"
Attribute | Type| Modifier
---+---+--
time | timestamp |
danderso=# insert into test values (to_timestamp('1200 PM
Generally a lot of the questions here on the mailing lists are answered
in the documentation. So read the docs first ;-)
It's: "pg_dump databaseName someFile.sql"
"Morten W. Petersen" wrote:
The PostgreSQL documentation is invisible?
Yeah, it just vanished. Not my fault. The bitbucket
Yeah, it just vanished. Not my fault. The bitbucket ate it.
Ah, so sorry. Use pg_dump.
Hope you find your docs soon ;)
- Thomas
I tried to export an Access Yes/No field to pgsql boolean and got an error
message.
By default, Access (and the ODBC driver) exports Yes/No to bpchar. However,
I want to use bool.
Any suggestions?
Thanks,
Mihai
-Original Message-
From: Stephen Davies [EMAIL PROTECTED]
To: G.L.Lim
Matthias Teege wrote:
Moin,
ist there any limit for the length of an transaction? I'am
using postgreSQL 6.5.1 with PHP and the apache log says:
NOTICE: (transaction aborted): queries ignored until END
Usually that appears right after one of the queries you
did failed for some reason
Tom Lane [EMAIL PROTECTED] writes:
[...]
If I change the function statement as follows:
IF NEW.vkp = 0 THEN
...
END IF;
it works
Shouldn't that give a type error of some sort? You didn't say
what type vkp is, but if it's a string type then comparing it
against a numeric
The PostgreSQL Administrator's Guide which appears on the web
http://www.postgresql.org/docs/admin/index.html
is fairly different from the one which is packed with
the 7.0.2 distribution.
Which is the good one?
I'm puzzled because the web version mentions the release 7.0.2
(the other one,
Thomas Lockhart wrote:
Yeah, it just vanished. Not my fault. The bitbucket ate it.
And what is a bitbucket? My dictioniary knows nothing
about this word. Just for all the people who's mother
tongue is not english. :-)
- Herbie
The BitBucket on unix is /DEV/NULL, or the place where things will disappear.
Herbert Liechti [EMAIL PROTECTED] 06/27/00 09:35AM
Thomas Lockhart wrote:
Yeah, it just vanished. Not my fault. The bitbucket ate it.
And what is a bitbucket? My dictioniary knows nothing
about this word. Just
Hernan Gonzalez [EMAIL PROTECTED] writes:
The PostgreSQL Administrator's Guide which appears on the web
http://www.postgresql.org/docs/admin/index.html
is fairly different from the one which is packed with
the 7.0.2 distribution.
Which is the good one?
The files appearing under
Tom Lane schrieb:
Read it again: the error message is complaining because you tried to
access a database named "dbname=template1". Better check the syntax
on the connection subroutine you are using --- looks like a confusion
between positional parameters and keyword-style connect strings...
Hi Mihai,
Microsoft products store false as (0) and true as
(-1) (Why? I don't know!). Apparently storing a
(-1) requires more than bool provides. So, you
can either edit all of your Access code so that it
interprets (1) as true (practically, I don't
recommend this), or you can migrate your
mikeo [EMAIL PROTECTED] writes:
in oracle, the triggers were smart enough to know not to reference
an old value on insert in an "insert or update" trigger procedure,
apparently.
this is the original oracle trigger that works fine
with the same insert statement:
CREATE OR REPLACE TRIGGER
27 matches
Mail list logo