Tom Lane wrote:
> But ... um ... did you restart the postmaster with the new path argument?
> Or only change the script?
Well, now I can't remember the exact sequence I used originally - I probably
tried to restart only after all the changes had taken place. I do remember
getting the error "can't
I assume that if I keep on adding to an INT4, at some point it will
roll over and become negative, and then if I add some more, it could
become positive. Is there a way to prevent this? Ie, I would like
for it to end with an error instead of wrapping around. Or is there a
way to check for this
Thanks.
Tim
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Tim Barnard" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 3:30 PM
Subject: Re: [GENERAL] PQclear question...
> "Tim Barnard" <[EMAIL PROTECTED]> writes:
> > Is it necessary to call P
"Tim Barnard" <[EMAIL PROTECTED]> writes:
> Is it necessary to call PQclear if a query that
> would normally return tuples fails?
If you got a non-NULL result from PQexec, you'd better PQclear it,
or suffer the consequences (memory leak -> eventual application crash).
reg
"Gilbert Wong" <[EMAIL PROTECTED]> writes:
> [ doesn't like the default timezone ]
Try setting TZ in the postmaster's environment. Note this is not the
same as your client program's environment. Also check to see if
AOLServer is sending a timezone-set command when it connects; if
plain psql sho
Hello all,
Is it necessary to call PQclear if a query
that
would normally return tuples fails? What if
the
query returns 0 tuples? In other words, is
it
only necessary to call it if you get back
one
or more tuples?
Thanks in advance!
Tim
Hi Denis and Ben,
> > I searched all the pgsql mailing list (and the
> > internet) to find if there
> > is a dbexpress driver or some way to get pgsql into Borland
> > Kylix. The only
> > solution i've found is the beta driver from EasySoft
> > "dbExpress Gateway to
> > ODBC".
>
> Try
Is it necessary to call PQclear if a query
that
would normally return tuples fails? What if
the
query returns 0 tuples? In other words, is
it
only necessary to call it if you get back
one
or more tuples?
Tim
On Tue, 29 May 2001, Mihai Gheorghiu wrote:
> I have a database with multiple referential integrity links.
> I want to make important changes to one of the tables, which is referenced
> by other tables for foreign keys (like deleting some columns, or changing
> data type).
> What would be the eas
I have a database with multiple referential integrity links.
I want to make important changes to one of the tables, which is referenced
by other tables for foreign keys (like deleting some columns, or changing
data type).
What would be the easiest way to do it (without re-creating all the other
ta
I am running PostgreSQL 7.0.3 on HPUX 11.0. I get the expected behavior if
my PGTZ environment variable is not set:
select current_timestamp;
timestamp
2001-05-29 12:56:16-04
(1 row)
The I ran the date command in the shell and received the following output:
T
I don't know if it's really needed. The examples at the
end of the libpq doc worked just great for me. I found
them to be very straight forward. Regarding libpq++,
I understand that whole api is being reworked. At least
I got that impression from past thread postings. For more
info on this see the
Page 4 of the programmers reference states:
"At any time during connection, the status of the
connection may be checked, by calling PQstatus."
I use it and so far its worked great, by which I mean
it has subsequently reported bad connections after
having reported CONNECTION_OK, which has
happened
Thanks for the helpful tip!
Tim
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Tim Barnard" <[EMAIL PROTECTED]>
Cc: "Jim" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 7:50 AM
Subject: Re: [GENERAL] Re: [SQL] Difficult SQL Statement
> I wrote:
>
Lamar Owen <[EMAIL PROTECTED]> writes:
> I have considered making the default back to TCP/IP listening
I think that's a bad idea, for the "be secure by default" reason.
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)---
TIP 4: Don't
I wrote:
> select ASMT_CODE, PASSED, TOTAL, PASSED::float4/TOTAL::float4
> from
> (select ASMT_CODE, count(*) as TOTAL from RESULTS
> group by ASMT_CODE) as tmp1
> natural join
> (select ASMT_CODE, count(*) as PASSED from RESULTS
> where STATUS='PASSED' group by ASMT_CODE) as t
sorry, my fault, just fixed all the links in teh ftp ...
On Tue, 29 May 2001, Alexey Borzov wrote:
> Greetings, Martín!
>
> At 29.05.2001, 17:28, you wrote:
>
> MM> Where can I get 7.1.2? The primary ftp server refuses me to enter, and the
> MM> mirror sites are not updated.
> In fact they
"Karen Ellrick" <[EMAIL PROTECTED]> writes:
> ... Then I tried creating /var/pgdata fresh and doing initdb -D
> /var/pgdata, and that was okay until I tried to create the database again,
> when it said a database of that name already existed. Yes, I have changed
> my startup script to reflect the
True, true... but the next time I need the code to fire I would need ot remember that
I had set it to 1 and set it to something else...
Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: [EMAIL PROTECTED]
>>> Rene Pijlman <[EMAIL PROTECTED]> 05/26
"Tim Barnard" <[EMAIL PROTECTED]> writes:
> To my thinking there's got to be a better way to do this whithout so many
> temporary tables.
In 7.1 you can frequently replace temp tables with subselect-in-FROM.
Cutting-and-pasting freely from your solution:
select ASMT_CODE, PASSED, TOTAL, PASSED::
Dixit Martín Marqués <[EMAIL PROTECTED]> (le Tue, 29 May 2001 09:57:17 +0300) :
» Where can I get 7.1.2? The primary ftp server refuses me to enter, and the
» mirror sites are not updated.
I found that on some mirrors the symlink v7.1.2 -> source/v7.1.2 is
missing so that you may believe that 7
Title: RE: [GENERAL] Kylix, dbexpress & PostgreSql
Try using ZeosDBO at http://www.zeoslib.org/ this has just been ported to Kylix. Not sure how stable it is but the windows version is great :).
Regards
Ben
> -Original Message-
> From: Denis Gasparin [mailto:[EMAIL PROTECTED]]
>
Right after a new installation (7.1.1) and building my first table with the
data directory being the normal /usr/local/pgsql/data, I decided I wanted to
put my data directory on a different partition, for space reasons (room for
database growth) - I chose /var/pgdata. At first I tried just copying
I'm writing a pool manager to manage x connections to a pgsql postmaster.
The getConnection method has to check if the connection is still valid,
and try to reconnect if it ain't.
Do you guys have a good way of doing this?
Can I use PQstatus?
Should I make a little runCommand on it to try it
Zeos (www.zeoslib.org) has released the last version of their library and
now it supports kylix! Obviously, it isn't dbexpress but it uses directly
the pgsql.so library. Give it a try! It works...
Denis Gasparin
At 23.16 28/05/01, [EMAIL PROTECTED] wrote:
>Hello,
>
>There is one under developm
25 matches
Mail list logo
