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:
http
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 written
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:
http://www.postgresql.org/docs/7.4/interact
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 written
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 returns
On Sun, Aug 9, 2009 at 4:06 AM, 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
>
On Sun, Aug 9, 2009 at 10:22, Abraham, Danny 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).
--
Magnus Hagand
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 th
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 of
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 http:/
2009/8/9 Scott Marlowe
> On Sun, Aug 9, 2009 at 4:06 AM, 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
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 retur
On Sun, Aug 9, 2009 at 5:04 PM, Brent Wood 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 view;) it
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 transactio
On Mon, Aug 10, 2009 at 9:10 AM, Scott Marlowe wrote:
> On Sun, Aug 9, 2009 at 5:04 PM, Brent Wood 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;
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:
http://www.nabble.com/using-COPY-and-PARTITON-tp24894446p248944
I believe triggers can do it.
On Sun, Aug 9, 2009 at 11:15 PM, cjm1010 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 pgsql-general mailin
20 matches
Mail list logo
