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 wrote:
> -- running pg 8.4
>
> i have a table defining geographic locations
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 poi
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)
2010-0
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
2010/5/10 Jonathan Vanasco :
> -- 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_i
Tom Lane wrote:
pgsql 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 through the code. T
-- 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 wo
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
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
AI Rumman 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.
Ovid 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 also need to sort the res
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();
inet_se
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
CTM&D Business Unit
972-52-4286-513
danny_abra...@bmc.com
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,
as
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
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 foreig
16 matches
Mail list logo
