Dear all,
I googled a lot and find data of all countries , cities , location
etc from Geo Spatial websites but I am able to find the data that shows
all *states & their respective capitals* in world.
Please let me know if anyone as prior information about this ?
Thanks
2011/9/25 pasman pasmański :
> My english is not perfect, by accumulative i think about monotonically
> increasing function.
>
> It works that for clause WHERE f(x)=const:
> 1. Read root page of index_on_x and get x1 ... Xn
> 2. Calculate f(x1) ... f(xn) for this page
> 3. When f(x1)<=const<= f(xn)
I am running PostgreSQL 9.0.1 32bit on windows 2003. Last night my disk had
some problem and i lost some file in data\global.
Is there anyway to recovery postgresql.
Thanks in advance. Sorry for my English.
Tuan Hoang Anh
Thanks for all your inputs !
Our problem is -
We had mistakenly executed "rsync" on the running PostgreSQL data directory
(production) and we did not run "pg_start_backup()".
Will this harm production ? can this lead to corruption ?
Thanks -
On Mon, Sep 26, 2011 at 10:29 PM, Alan Hodgson wro
On Mon, Sep 26, 2011 at 4:22 PM, Marti Raudsepp wrote:
> On Mon, Sep 26, 2011 at 18:59, Andy Chambers wrote:
>> ...and I want to select the data from that table, adding a "group_id"
>> column, and a "record_id" column. The "group_id" would start at 1,
>> and increment by 1 every 100 rows, and th
On 09/26/11 5:53 PM, Jov wrote:
>
> Most are bigint and one field is varchar.
> There is no index.
>
>
well, scalar bigint values will be 8 bytes, plus a bit or 2 of overhead
per field. each complete tuple has a dozen bytes of header overhead.
tuples are stored as many as fit in a 8K block, unles
Most are bigint and one field is varchar.
There is no index.
在 2011-9-27 上午3:34，"John R Pierce" 写道：
>
> On 09/26/11 6:59 AM, Jov wrote:
>>
>>
>> Hi all,
>> We are going to use pg as data warehouse,but after some test,we found
that plain text with csv format is 3 times bigger when load to pg.we use
Rich
On Mon, 2011-09-26 at 11:38 -0700, Rich Shepard wrote:
> Rather than writing an application right now to enter data into a table I
> thought of trying LibreOffice as a front end. But, it doesn't seem to work
> as OO.o did. This leads to two questions:
>
>1) Can someone show me how to
2011/9/26 Rich Shepard
> Rather than writing an application right now to enter data into a table I
> thought of trying LibreOffice as a front end. But, it doesn't seem to work
> as OO.o did.
It does, albeit you will need libreoffice-base which is not always installed
by default (not in my Ubun
On Tue, Sep 27, 2011 at 01:43, Edson Carlos Ericksson Richter
wrote:
>> create index on foobar (txt text_pattern_ops); create index on foobar
>> (reverse(txt) text_pattern_ops);
>
> I got the following error:
>
> ERROR: function reverse(text) does not exist
> Hint: No function matches the given na
2011/9/27 Diego Augusto Molina
> Hi, I had to implement a logging system for some DBs in work. It's
> generic and implemented using plperl. I've seen tons of mails on the
> list from newbies asking for something like this using plpgsql, but no
> specific solution is pointed for them. I think this
Hi, I had to implement a logging system for some DBs in work. It's
generic and implemented using plperl. I've seen tons of mails on the
list from newbies asking for something like this using plpgsql, but no
specific solution is pointed for them. I think this may discourage
some of them.
The system
This message has been digitally signed by the sender.
RES___GENERAL__Does_postgresql_9_0_4_use_index_on_PREFIX_SUFFIX_queries_.eml
Description: Binary data
-
Hi-Tech Gears Ltd, Gurgaon, India
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> -Mensagem original-
> De: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] Em nome de Marti Raudsepp
> Enviada em: segunda-feira, 26 de setembro de 2011 17:42
> Para: Edson Carlos Ericksson Richter
> Cc: pgsql-general@postgresql.org
> Assunto: Re: [GENERAL
On Mon, Sep 26, 2011 at 15:16, Edson Carlos Ericksson Richter
wrote:
> select * from notafiscal where numeroctc like ‘POA%34345’;
>
> Prefix is normally 3 characters, suffix varyies.
>
> Is Postgresql 9.0.4 able to use an BTREE index on notafiscal.numeroctc to
> execute this query?
As mentioned
On Mon, Sep 26, 2011 at 18:59, Andy Chambers wrote:
> ...and I want to select the data from that table, adding a "group_id"
> column, and a "record_id" column. The "group_id" would start at 1,
> and increment by 1 every 100 rows, and the "record_id" would increment
> by 1 every row, but restart a
On 09/26/11 6:59 AM, Jov wrote:
Hi all,
We are going to use pg as data warehouse,but after some test,we found
that plain text with csv format is 3 times bigger when load to pg.we
use copy to load data.we try some optimize and it reduce to 2.5 times
bigger.other db can avarage compress to 1/
On Mon, Sep 26, 2011 at 2:23 PM, Guillaume Lelarge
wrote:
> And I would agree (that the current behaviour is broken). Using a
> database name as a flag to replication connection was a false good idea.
> But, actually, I failed to find a better one.
Well, that may or may not be a good idea, but th
On Mon, 2011-09-26 at 14:13 -0500, Merlin Moncure wrote:
> On Mon, Sep 26, 2011 at 1:47 PM, Guillaume Lelarge
> wrote:
> > On Mon, 2011-09-26 at 11:58 -0500, Merlin Moncure wrote:
> >> On Sat, Sep 24, 2011 at 10:07 PM, Rajesh Kumar Mallah
> >> wrote:
> >> > Dear List ,
> >> >
> >> > It is been fo
On Mon, Sep 26, 2011 at 1:47 PM, Guillaume Lelarge
wrote:
> On Mon, 2011-09-26 at 11:58 -0500, Merlin Moncure wrote:
>> On Sat, Sep 24, 2011 at 10:07 PM, Rajesh Kumar Mallah
>> wrote:
>> > Dear List ,
>> >
>> > It is been found that the entry
>> >
>> > local all all
Edson,
1. PostgreSQL IS able to use btree index to execute this query.
More generally, it is able to use btree index for all PREFIX search.
2. You will need a special (NOT spatial) index for it
CREATE INDEX notafiscal_numeroctc_tpo_idx ON notafiscal (numeroctc
text_pattern_ops);
( see http://www.
On Mon, 2011-09-26 at 11:58 -0500, Merlin Moncure wrote:
> On Sat, Sep 24, 2011 at 10:07 PM, Rajesh Kumar Mallah
> wrote:
> > Dear List ,
> >
> > It is been found that the entry
> >
> > local all all trust
> >
> > does not renders below redundant in pg_hba.c
Rather than writing an application right now to enter data into a table I
thought of trying LibreOffice as a front end. But, it doesn't seem to work
as OO.o did. This leads to two questions:
1) Can someone show me how to use LO as a front end to a postgres table?
2) Is there another tool
Hi,
If I am retrieving row(s) into a sql descriptor in ECPG, and my last row
column is of type timestamp, then I I will consistently receive a segmentation
fault as shown below. If I redefine the table so that the timestamp field is
not the last field of the table row, the routine runs suc
On September 26, 2011 10:47:20 AM Bob Pawley wrote:
> Hi
>
> I have an error somewhere in one of the trigger functions in my database.
> The error message only told me it was a ‘Select * From (table name).
>
> Is there a global method of finding where this expression resides other
> than searchin
On Mon, Sep 26, 2011 at 12:47 PM, Bob Pawley wrote:
> Hi
>
> I have an error somewhere in one of the trigger functions in my database.
> The error message only told me it was a ‘Select * From (table name).
>
> Is there a global method of finding where this expression resides other than
> searching
Hi
I have an error somewhere in one of the trigger functions in my database. The
error message only told me it was a ‘Select * From (table name).
Is there a global method of finding where this expression resides other than
searching each script individually.
Bob
On September 26, 2011 05:49:50 AM Venkat Balaji wrote:
> I tried restoring the backup, after taking the full backup.
>
> Below is what i see in the "archive destination".
>
> Postgres was asking for "00010193006F" and i tried to find the
> same and below is what i find...
>
> -rw
At 18:18 26/09/2011, you wrote:
Eduardo Morras wrote:
>>
>> At 08:04 25/09/2011, haman...@t-online.de wrote:
>>
>> > >> select * from items where regexp_matches(items.code,'(ABC) (DE1)
>> > >> (any_substring)')<>{};
>> > >>
>> >
>> >Hi Eduardo,
>> >
>> >it is clear that scanning the table once
Sorry, Gregg. I did not noticed I was disturbing...
Can you please tell me what you mean by "top posting"? I've created an
specific topic for this discussion, and I'm not using "urgent" or html
format... so I suppose that I've been following the rules...
BTW, I've repeated the query to easy peo
On Sat, Sep 24, 2011 at 10:07 PM, Rajesh Kumar Mallah
wrote:
> Dear List ,
>
> It is been found that the entry
>
> local all all trust
>
> does not renders below redundant in pg_hba.conf
>
> local replication replicator01 trust
I noticed this too,
Because the error message saying so (I do use pgAdmin III):
"An error has occurred:
ERROR: the datatype character varying has no standard operator class for
"gist" access method
HINT: You should specify na operator class for the index or define one
standard operator class for the data type."
(I'
Alban Hertroys wrote:
>> > Hi,
>> >=20
>> > the strings are not really known before.
>> > Let me explain the scenario; there is one table about products, and =
>> code is the
>> > manufacturer's (or resellers') product id.
>> > So, if ABC were a maker of laptops, ABC123 and ABC456 might be two
Eduardo Morras wrote:
>>
>> At 08:04 25/09/2011, haman...@t-online.de wrote:
>>
>> > >> select * from items where regexp_matches(items.code,'(ABC) (DE1)
>> > >> (any_substring)')<>{};
>> > >>
>> >
>> >Hi Eduardo,
>> >
>> >it is clear that scanning the table once with a list of matches will
>>
Hi,
I have a need to write a query that batches up rows of a table into
groups of n records. I feel like this should be possible using the
existing window functions but I can't figure out how to do it from the
examples.
So I have some table, let's say
create table addresses (
line_1 text,
l
On 26 September 2011 17:15, Edson Carlos Ericksson Richter
wrote:
> Just discovered, I can’t use GIST over character varying...
Why do you think that?
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.
--
Sent via pgsql-general mailing list (pgsql-g
thx a lot for your help. it worked great :)
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/upgrade-postgres-to-8-4-8-centos-5-3-tp4822762p4841782.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-g
You can create your own type, but that means writing bit code in C.
Please, stop the top posting!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Just discovered, I can’t use GIST over character varying...
Any other tips on how to optimize the query? Here are about 1,000,000 (one
million) records in this table, table scan takes about 5 to 6 seconds on actual
hardware (SAS, 1 Xeon, 2Gb memory on CentOS with all normal performance hacks)
Venkat Balaji wrote:
> We have had situations where-in "rsync" was executed without executing
"pg_start_backup()" on the
> production data directory and on the next runs, "pg_start_backup()"
has been executed with "rsync".
> This was to avoid high IO load on production. We ended up getting
unmatche
On Mon, Sep 26, 2011 at 6:49 AM, Albe Laurenz wrote:
> Jeff Adams wrote:
>> I need to send the results (SETOF RECORDS) from one function into
> another
>> function, to produce another result (SETOF RECORDS). I am not quite
> sure how
>> to do get this done. The first function filters a large table
>
> From what I can see, PG_VERSION is written at database creation to document
> the
> major version of the Postgres instance used to create the database. Since
> it
> only holds the major version string (i.e. 9.0) it is not touched during
> minor
> updates, for example 9.0.0 --> 9.0.1. Grepping
Hi all,
I have a Linux/Ubuntu (10.04) x64 server on which I have installed PostgreSQL
9.0.4 by source compilation.
I have also installed PostgreSQL 9.1.0 with source compilation on the same
server, and I try to migrate my data using pg_upgrade.
For PostgreSQL 9.0.4, the installation directories
On Mon, Sep 26, 2011 at 8:50 AM, Gregg Jaskiewicz wrote:
> Thanks Merin.
>
> It does, and that's probably what I'll do. Your solution isn't great
> either, because it requires extra function to be run on the postgresql
> side. Me no likeey that ;)
If you are sending a bytea as encoded text, you h
On Mon, Sep 26, 2011 at 5:51 AM, Gregg Jaskiewicz wrote:
> So consider this code C++, using libpqxx:
>
> string = "INSERT INTO foo(x) VALUES( E'" + T.esc_raw(data) + "' )";
>
> foo(x) is bytea , before you ask.
>
> On 8.3, it works fine.
> On 9.x:
>
> ERROR: invalid byte sequence for encoding "UT
Thanks for the tip, unfortunately, split it does not work for me, since it’s a
free text field, that users fill as they wish...
But looking most slow queries, this one pops up with more frequency...
So GIST would work; I’ll give a try.
Regards,
Edson.
De: pgsql-general-ow...
Hi all,
We are going to use pg as data warehouse,but after some test,we found that
plain text with csv format is 3 times bigger when load to pg.we use copy to
load data.we try some optimize and it reduce to 2.5 times bigger.other db
can avarage compress to 1/3 of the plain text.bigger data means
On 26 September 2011 14:39, Merlin Moncure wrote:
> urk -- I have to be honest -- that's a pretty lousy way to send bytea.
> Personally, I'd encode the string as hex and send it like this:
>
> "INSERT INTO foo(x) VALUES( decode('" + hex_string + "'))";
>
> libpqxx doesn't have the ability to para
Malm Paul wrote:
> I have a database created on ver 8.3 an have restored the database in
a new database in PostgreSQL
> 9.0.
> In the database i'm using a column storing "bytea".
>
> When trying to read the database with my java application, I have
problems reading from the bytea-
> stream.
> Inte
I am trying to set up master/slave warm standby streaming replication (9.1). I
am not doing archiving/log shipping. I have read that you cannot reverse roles
between the master and slave, and that once a slave is "promoted", you need to
use pg_basebackup or rsync to copy files from the newly
You can always store it divided in the database into two columns.
Gist could also work for you.
I tried restoring the backup, after taking the full backup.
Below is what i see in the "archive destination".
Postgres was asking for "00010193006F" and i tried to find the
same and below is what i find...
-rw--- 1 postgres postgres 3.3M Sep 26 02:06 00010193006F.gz
-
Dear experts,
I have the following query:
select * from notafiscal where numeroctc like POA%34345;
Prefix is normally 3 characters, suffix varyies.
Is Postgresql 9.0.4 able to use an BTREE index on notafiscal.numeroctc to
execute this query?
Should I create GIST index or somet
Jeff Adams wrote:
> I need to send the results (SETOF RECORDS) from one function into
another
> function, to produce another result (SETOF RECORDS). I am not quite
sure how
> to do get this done. The first function filters a large table down a
more
> manageable dataset. I want to send the results o
In article
,
Pavel Stehule writes:
> 2011/9/25 pasman pasmański :
>> I found second use case. Look at expression:
>>
>> where left(str,n)='value'
>>
>> function left(str,n) increase monotonically for str and n. With this
>> feature it can use index on str.
>>
>> Classic index needs recreating
Hello Everyone,
We have had situations where-in "rsync" was executed without executing
"pg_start_backup()" on the production data directory and on the next runs,
"pg_start_backup()" has been executed with "rsync". This was to avoid high
IO load on production. We ended up getting unmatched files (e
So consider this code C++, using libpqxx:
string = "INSERT INTO foo(x) VALUES( E'" + T.esc_raw(data) + "' )";
foo(x) is bytea , before you ask.
On 8.3, it works fine.
On 9.x:
ERROR: invalid byte sequence for encoding "UTF8": 0x00 (if \000 is in
the string).
Now, I can take out the E'' and it
Malm Paul wrote:
> Hi,
> I have a database created on ver 8.3 an have restored the database in a new
> database in PostgreSQL 9.0.
> In the database i'm using a column storing "bytea".
>
> When trying to read the database with my java application, I have problems
> reading from the bytea-stream
Hi,
I have a database created on ver 8.3 an have restored the database in a new
database in PostgreSQL 9.0.
In the database i'm using a column storing "bytea".
When trying to read the database with my java application, I have problems
reading from the bytea-stream.
Integers read is not correct.
Recently I noticed there are only 1-4, 9-14 parts in SQL:2008 standard:
ISO/IEC 9075-1:2008. Here is:
http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=45498
why don't they define 5-8 parts in this standard?
I also noticed there is a standard for data mining: ISO
60 matches
Mail list logo
