Does anybody have a proven way to regenerate this problem?
SO that I can tell that the patch really does fix it?
Thanks
Danny
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
googling few days with no success,
for example I have db with ip_src etc ant its data type bigint,
how must look select query what I can see ip address (int) instead of
bigint?
smime.p7s
Description: S/MIME cryptographic signature
Hi,
googling few days with no success,
for example I have db with ip_src etc ant its data type bigint,
how must look select query what I can see ip address (int) instead of
bigint?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Hi,
We have software deployed on our network that need postgres, we have server
that hosts the server and all worked fine until we crossed about 200 users.
The application is written so that it makes a connection right at the start
and keeps it alive for the duration of the app. The app is
Does anybody have a proven way to regenerate this problem?
This way I can decide that the patch does fix it?
Thanks
Danny
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
There is no such thing as converting a bigint into an text ip address,
unless you make it xD Google for postgres INET_ATON (INET_ATON is mysql's
ip-to-int)
However, there are datatypes in postgres which allow you to work directly
with ips and networks:
Hi,
We have software deployed on our network that need postgres, we have server
that hosts the server and all worked fine until we crossed about 200 users.
The application is written so that it makes a connection right at the start
and keeps it alive for the duration of the app. The app is
That's pretty confused C code. The most obvious problem is that you're not
calling the Pqntuples function; you're just examining the value of a
variable called ntuples, when you haven't set that value after calling
Pqexec (and maybe have never set it).
Take it step by step, and check error
On Sun, Aug 9, 2009 at 4:06 AM, Kobus Wolvaardtkobusw...@gmail.com wrote:
Hi,
We have software deployed on our network that need postgres, we have server
that hosts the server and all worked fine until we crossed about 200 users.
The application is written so that it makes a connection right
On Sun, Aug 9, 2009 at 10:22, Abraham, Dannydanny_abra...@bmc.com wrote:
Does anybody have a proven way to regenerate this problem?
SO that I can tell that the patch really does fix it?
No. That's the reason it has taken so long to figure out how to fix it
(which we hopefully have done now).
Kobus Wolvaardt schrieb:
We have software deployed on our network that need postgres, we have server
that hosts the server and all worked fine until we crossed about 200 users.
The application is written so that it makes a connection right at the start
and keeps it alive for the duration of the
Kobus Wolvaardt wrote:
Hi,
We have software deployed on our network that need postgres, we have
server that hosts the server and all worked fine until we crossed
about 200 users. The application is written so that it makes a
connection right at the start and keeps it alive for the duration
Brian A. Seklecki wrote:
All:
Any suggestions on how-to, or comments on a potential NFR, to disable
non-superuser's from viewing the database list via \l?
No, not really. If we ever get row-level security, it could be used to
accomplish what you want.
--
Bruce Momjian br...@momjian.us
2009/8/9 Scott Marlowe scott.marl...@gmail.com
On Sun, Aug 9, 2009 at 4:06 AM, Kobus Wolvaardtkobusw...@gmail.com
wrote:
Hi,
We have software deployed on our network that need postgres, we have
server
that hosts the server and all worked fine until we crossed about 200
users.
The
Hi...
I have a view across 3 tables, total some 5m rows.
I can extract parts of the view, entire rows, with a where clause
(eg: select * from view where cell_id=10;)
If I try to select the entire view (eg: select * from view;) it runs for a
while then gives the error msg Killed and
On Sun, Aug 9, 2009 at 5:04 PM, Brent Woodb.w...@niwa.co.nz wrote:
Hi...
I have a view across 3 tables, total some 5m rows.
I can extract parts of the view, entire rows, with a where clause
(eg: select * from view where cell_id=10;)
If I try to select the entire view (eg: select * from
Kobus Wolvaardt wrote:
We have similar connection settings, same app, same DB, same username,
same settings. What appart from installing pgpool do you need to do to
get it to seamlessly share connections? Do you need to do anything in
code? Do a special query to indicate the end of a
On Mon, Aug 10, 2009 at 9:10 AM, Scott Marlowe scott.marl...@gmail.comwrote:
On Sun, Aug 9, 2009 at 5:04 PM, Brent Woodb.w...@niwa.co.nz wrote:
Hi...
I have a view across 3 tables, total some 5m rows.
I can extract parts of the view, entire rows, with a where clause
(eg: select *
hi~
I want to insert DATA by using the COPY making PARTITON TABLE. By the way,
DATA is inserted only in PARENT TABLE.
Can DATA be inserted in CHILD TABLE by using the COPY?
Thanks,
JM CHAE
--
View this message in context:
I believe triggers can do it.
On Sun, Aug 9, 2009 at 11:15 PM, cjm1010cjm1...@naver.com wrote:
hi~
I want to insert DATA by using the COPY making PARTITON TABLE. By the way,
DATA is inserted only in PARENT TABLE.
Can DATA be inserted in CHILD TABLE by using the COPY?
--
Sent via
20 matches
Mail list logo