I am using Pgpool II 2.3.3 with Postgresql 8.3.8.
When I use command \l at postgresql client the query is working perfectly.
But if I used the command from pgpool II client which is connected with
postgresql in ssl mode, it gets hang.
Again if I use the command from pgpool II client in non-ssl
On 9 May 2010, at 6:49, Rick Yorgason wrote:
So, your first suggestion would look like this:
reginfo(order_id, product_id, reginfo1_columns, reginfo2_columns, FOREIGN
KEY(order_id, product_id) REFERENCES order_items)
For the sake of illustration, let's say that order_item's foreign key
Converting the pdf it text is a gruesome experience on account of
numerous carriage returns that don't belong there, etc.
Converting the docbook file to plain text is a possible solution, but
I don't know exactly how to do that. I will look into it.
The documentation, as is pointed out in
My apologies. This isn't PG-specific, but since this is running on PostgreSQL
8.4, maybe there are specific features which might help.
I have a tree structure in a table and it uses materialized paths to allow me
to find children quickly. However, I also need to sort the results depth-first,
The machine is on IPV4.
How can I retrieve the real IP adrs?
Is 8.3.7 supported on Windows 7?
Thanks a lot
Danny Abraham
BMC Software
CTMD Business Unit
972-52-4286-513
danny_abra...@bmc.com
In response to Abraham, Danny :
The machine is on IPV4.
How can I retrieve the real IP adrs?
kretsch...@tux:~$ psql -h localhost test
Password:
Timing is on.
psql (8.4.2)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type help for help.
test=# select inet_server_addr();
Ovid curtis_ovid_...@yahoo.com writes:
My apologies. This isn't PG-specific, but since this is running on PostgreSQL
8.4, maybe there are specific features which might help.
I have a tree structure in a table and it uses materialized paths to allow me
to find children quickly. However, I
AI Rumman rumman...@gmail.com writes:
The function call pg_catalog.pg_encoding_to_char(d.encoding) somehow makes
the Pgpool hang in SSL mode.
pg_encoding_to_char returns type name, maybe that's somehow confusing
pgpool? Although I seriously doubt there's any connection to SSL mode.
Traffic on the PostgreSQL lists is very high now and I freely admit that
reading every email is simply not possible for me, even the ones that
mention topics that keyword searches tell me are of potential interest.
If anybody knows of a bug or suspected bug in my code, I have no problem
in being
Assume we have a table a with a text column txt
and an index on that column.
A query like the following will then be very perfomant
since it can use the index:
select * from a where txt like 'a%'
(Assume also that the server is using the C locale or the index
is set up with text_pattern_ops,
-- running pg 8.4
i have a table defining geographic locations
id
lat
long
country_id not null
state_id
city_id
postal_code_id
i was given a unique index on
(country_id, state_id, city_id, postal_code_id)
the unique index isn't
Tom Lane wrote:
pgsql pg...@lavabit.com writes:
Tom Lane wrote:
Um, that's not too helpful, we want to see the string it's pointing at.
Sorry about that. All statements are calling one of two pl/pgsql
functions. While that information already helps me a lot, it'll take me
a while to step
2010/5/10 Jonathan Vanasco postg...@2xlp.com:
-- running pg 8.4
i have a table defining geographic locations
id
lat
long
country_id not null
state_id
city_id
postal_code_id
i was given a unique index on
(country_id, state_id,
I realize that, when I have 1 threads perform frequent read, and another 3
threads to perform frequent write. I will get the following error log
*sometimes*
2010-05-07 17:16:10 MYT LOG checkpoints are occurring too frequently (22
seconds apart)
2010-05-07 17:16:10 MYT HINT Consider increasing
On 10/05/10 08:54, Yan Cheng CHEOK wrote:
I realize that, when I have 1 threads perform frequent read, and another 3
threads to perform frequent write. I will get the following error log
*sometimes*
2010-05-07 17:16:10 MYT LOG checkpoints are occurring too frequently (22
seconds apart)
I have been using PostgreSQL for a short while, but I have not had to
use the pg_catalog tables before and the columns are a little cryptic to
me. I think it ties to pg_class, but I am not sure how to relate them.
Also, I have not had a chance to us the \dt function. Can you give me
some
Use unique index as follows:
create unique index unq_idx on table_name (coalesce(country_id,0),
coalesce(state_id,0), coalesce(city_id,0),coalesce(postal_code_id,0) );
On Mon, May 10, 2010 at 6:09 AM, Jonathan Vanasco postg...@2xlp.com wrote:
-- running pg 8.4
i have a table defining
17 matches
Mail list logo