Re: [pgeu-general] [GENERAL] Call for design: PostgreSQL mugs

2013-09-05 Thread Heikki Linnakangas
Put a small elephant logo *inside* the mug. With a text: "also for embedded systems" - Heikki -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [pgeu-general] [GENERAL] Call for design: PostgreSQL mugs

2013-09-05 Thread Atri Sharma
Make an elephant in a space suit, or with lots of equipments. Text: 'Ready for mission critical systems' On Thu, Sep 5, 2013 at 12:30 PM, Heikki Linnakangas wrote: > Put a small elephant logo *inside* the mug. With a text: "also for embedded > systems" > > - Heikki > > > -- > Sent via pgsql-gener

Re: [pgeu-general] [GENERAL] Call for design: PostgreSQL mugs

2013-09-05 Thread Jean-Paul Argudo
Hi, Le jeudi 05 septembre 2013 à 12:33 +0530, Atri Sharma a écrit : > Make an elephant in a space suit, or with lots of equipments. Text: > 'Ready for mission critical systems' Despite I like this idea a lot, I think we should avoid messages like "Ready for.." or such, since it implies PG wasn't

Re: [pgeu-general] [GENERAL] Call for design: PostgreSQL mugs

2013-09-05 Thread Atri Sharma
On Thu, Sep 5, 2013 at 12:51 PM, Jean-Paul Argudo wrote: > Hi, > > Le jeudi 05 septembre 2013 à 12:33 +0530, Atri Sharma a écrit : >> Make an elephant in a space suit, or with lots of equipments. Text: >> 'Ready for mission critical systems' > > Despite I like this idea a lot, I think we should av

[GENERAL] Hello

2013-09-05 Thread Sandy
Hello, how is everything? Losing weight with this has made my life more enjoyable. http://bitly.com/14cCXSw This is the best and you can try it for free. I love hearing back on how well this works.

Re: [pgeu-general] [GENERAL] Call for design: PostgreSQL mugs

2013-09-05 Thread Alban Hertroys
What about "Don't ignore the elephant in the room"? On 5 September 2013 09:24, Atri Sharma wrote: > On Thu, Sep 5, 2013 at 12:51 PM, Jean-Paul Argudo > wrote: > > Hi, > > > > Le jeudi 05 septembre 2013 à 12:33 +0530, Atri Sharma a écrit : > >> Make an elephant in a space suit, or with lots of

Re: [pgeu-general] [GENERAL] Call for design: PostgreSQL mugs

2013-09-05 Thread Atri Sharma
Sent from my iPad On 05-Sep-2013, at 13:28, Alban Hertroys wrote: > What about "Don't ignore the elephant in the room"? > > > On 5 September 2013 09:24, Atri Sharma wrote: >> On Thu, Sep 5, 2013 at 12:51 PM, Jean-Paul Argudo >> wrote: >> > Hi, >> > >> > Le jeudi 05 septembre 2013 à 12:33 +

[GENERAL] How to check if any WAL file is missing in archive folder

2013-09-05 Thread ascot.m...@gmail.com
Hi, I am planing to backup archived WAL files from master to another machine, is there a way to check and make sure the backup archive file are all good and no any file missing or corrupted? regards -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [pgeu-general] [GENERAL] Call for design: PostgreSQL mugs

2013-09-05 Thread Marc Balmer
Am 05.09.13 09:00, schrieb Heikki Linnakangas: > Put a small elephant logo *inside* the mug. With a text: "also for > embedded systems" For german speaking folks, just a mug with an elephant an the text "ProstgreSQL". -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To m

Re: [GENERAL] Old record migration to another table made the db slower

2013-09-05 Thread Tomas Vondra
On 5 Září 2013, 8:52, Arun P.L wrote: > Hi all, > I have moved a lot of old records from one table say original_data_table > to another table say old_data_table which is newly created for the old > records. There were around 15 milliion old records to move. After this > migration I have done standa

Re: [GENERAL] Spurious error messages from pg_restore

2013-09-05 Thread Evan Martin
No version boundaries. I can reproduce this on 9.2.4 by backing up and immediately restoring a new DB with PostGIS: CREATE DATABASE test; CREATE EXTENSION postgis; -- Version 2.1 pg_dump --format custom --file test.bak test pg_restore --jobs 4 --dbname test test.bak On 04.09.2013 23:31, David J

[GENERAL] Question About WAL filename and its time stamp

2013-09-05 Thread ascot.m...@gmail.com
Hi, From the pg_xlog folder, I found some files with interesting time stamps: older file names with newer timestamps, can you please advise why? Set 1: How come 00040F49008D is 10 minutes newer than 00040F49008E? -rw--- 1 111 115 16777216 Sep 4 15:28 00040F4

Re: [GENERAL] Spurious error messages from pg_restore

2013-09-05 Thread Evan Martin
There may be implementation reasons for this, but try to see it from a user's point of view. An error, to a user, means "something went wrong; whatever you tried to do didn't work". If a message is harmless, it should be, at best, a warning. From a more practical point of view, it's not realist

[GENERAL] EF / npgsql and VIEWs

2013-09-05 Thread Mike Blackwell
I understand from one of our developers there may be issues using VIEWs with Entity Framework and npgsql. Can anyone with some experience using PostgreSQL in a .NET environment comment? __ *Mike Blackwell | Technical

Re: [GENERAL] EF / npgsql and VIEWs

2013-09-05 Thread Joshua D. Drake
On 09/05/2013 07:04 AM, Mike Blackwell wrote: I understand from one of our developers there may be issues using VIEWs with Entity Framework and npgsql. Can anyone with some experience using PostgreSQL in a .NET environment comment? You might want to check with the npgsql list. You are likely

Re: [GENERAL] Call for design: PostgreSQL mugs

2013-09-05 Thread Merlin Moncure
On Tue, Sep 3, 2013 at 5:08 PM, Andreas 'ads' Scherbaum wrote: > > PostgreSQL folks! > > We are looking for the next big thing. Actually, it's a bit smaller: a new > design for mugs. So far we had big blue elephants, small blue elephants, > frosty elephants, white SQL code on black mugs ... Now it

Re: [GENERAL] Call for design: PostgreSQL mugs

2013-09-05 Thread Vincent Veyron
Le mercredi 04 septembre 2013 à 14:10 -0700, John R Pierce a écrit : > ages ago, a former employer had some neat mugs made that had a thermal > sensitive layer that disappeared when it was hot (as in filled with > coffee) and revealed something underneath.I'm not quite sure what > the postg

Re: [GENERAL] invalid frontend message type 136

2013-09-05 Thread David Johnston
It would help to at least know against which version of the database you are trying to connect and also what client (with version) you are using. Any other connection-related information (password based; ident; etc...) would be helpful as well. David J. -- View this message in context: http:

Re: [GENERAL] [PERFORM] Can you please suggest me some links where I can learn:

2013-09-05 Thread Kevin Grittner
M Tarkeshwar Rao wrote: > I want start contributing in Postgres in code level. Welcome!  You should probably start with this page and its links: http://wiki.postgresql.org/wiki/Developer_FAQ > Can you please suggest me some links where I can learn: > 1.   Transaction Isolation in Database

Re: [pgeu-general] [GENERAL] Call for design: PostgreSQL mugs

2013-09-05 Thread Steve Crawford
On 09/05/2013 12:21 AM, Jean-Paul Argudo wrote: Hi, Le jeudi 05 septembre 2013 à 12:33 +0530, Atri Sharma a écrit : Make an elephant in a space suit, or with lots of equipments. Text: 'Ready for mission critical systems' Despite I like this idea a lot, I think we should avoid messages like "Re

[GENERAL] invalid frontend message type 136

2013-09-05 Thread Steve Crawford
I got this message immediately after a connection to the server. I haven't seen it before and Googling has come up short so far. There are no other indications of trouble. Ideas or suggestions where to look? Cheers, Steve -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

Re: [pgeu-general] [GENERAL] Call for design: PostgreSQL mugs

2013-09-05 Thread Marc Balmer
ACID. Actually Coffee Inside, Drinkable. Am 05.09.2013 um 20:49 schrieb Steve Crawford : > org) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [pgeu-general] [GENERAL] Call for design: PostgreSQL mugs

2013-09-05 Thread Marc Balmer
My SQL is PostgreSQL Atri Sharma schrieb: >On Fri, Sep 6, 2013 at 12:35 AM, Marc Balmer wrote: >> ACID. Actually Coffee Inside, Drinkable. >> >> Am 05.09.2013 um 20:49 schrieb Steve Crawford >> : >> >>> org) > >Something of the lines of evolution? > >A small elephant, growing more powerful? >

Re: [pgeu-general] [GENERAL] Call for design: PostgreSQL mugs

2013-09-05 Thread Atri Sharma
On Fri, Sep 6, 2013 at 12:35 AM, Marc Balmer wrote: > ACID. Actually Coffee Inside, Drinkable. > > Am 05.09.2013 um 20:49 schrieb Steve Crawford > : > >> org) Something of the lines of evolution? A small elephant, growing more powerful? -- Regards, Atri l'apprenant -- Sent via pgsql-gener

Re: [pgeu-general] [GENERAL] Call for design: PostgreSQL mugs

2013-09-05 Thread patrick keshishian
Here is an idea, but not sure how well it'll be accepted. Inside the cup, names of current/active developers/contributors, represented using tag/keyword cloud[1] form. Using a combination of code check-in count and importance of check-in, contributions on mailing lists, other factors to make it fa

Re: [pgeu-general] [GENERAL] Call for design: PostgreSQL mugs

2013-09-05 Thread Richard Sickler
Okay, how about PostgreSQL - The DataBase with 10,000 programmers on your side. PostgreSQL - You wish the rest of your stuff was this good. PostgreSQL - apply many quotes to mug On Thu, Sep 5, 2013 at 12:37 PM, Atri Sharma wrote: > On Fri, Sep 6, 2013 at 12:35 AM, Marc Balmer wrote: >

Re: [GENERAL] Call for design: PostgreSQL mugs

2013-09-05 Thread CS DBA
On 9/3/13 4:08 PM, Andreas 'ads' Scherbaum wrote: PostgreSQL folks! We are looking for the next big thing. Actually, it's a bit smaller: a new design for mugs. So far we had big blue elephants, small blue elephants, frosty elephants, white SQL code on black mugs ... Now it's time to design s

Re: [pgeu-general] [GENERAL] Call for design: PostgreSQL mugs

2013-09-05 Thread Dimitri Fontaine
Marc Balmer writes: > My SQL is PostgreSQL PostgreSQL really is YeSQL! -- you can check http://yesql.org too -- Dimitri Fontaine06 63 07 10 78 http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing lis

Re: [pgeu-general] [GENERAL] Call for design: PostgreSQL mugs

2013-09-05 Thread Eduardo Morras
On Thu, 05 Sep 2013 23:10:20 +0200 Dimitri Fontaine wrote: > Marc Balmer writes: > > My SQL is PostgreSQL > > PostgreSQL really is YeSQL! -- you can check http://yesql.org too > A draw of a hat? Like in "Little Prince/Le Petit Prince", a snake with "Elephant Inside" logo. --- --- Eduard

Re: [GENERAL] [PERFORM] Can you please suggest me some links where I can learn:

2013-09-05 Thread Merlin Moncure
On Thu, Sep 5, 2013 at 10:39 AM, Kevin Grittner wrote: > M Tarkeshwar Rao wrote: > >> I want start contributing in Postgres in code level. > > Welcome! You should probably start with this page and its links: > > http://wiki.postgresql.org/wiki/Developer_FAQ > >> Can you please suggest me some li

Re: [GENERAL] [PERFORM] Can you please suggest me some links where I can learn:

2013-09-05 Thread John R Pierce
On 9/5/2013 3:42 PM, Merlin Moncure wrote: My advise is to start small and pick a very specific topic and focus on that. my advise is to first familiarize yourself with the package from the user perspective before even thinking of diving in and making any changes.I say this, because the

[GENERAL] Levenshtein Distance with more than 255 characters

2013-09-05 Thread Janek Sendrowski
Hi,   I'm searching for an optimized Levenshtein Distance like Postgresql's. My problem is that I want to compare strings with a length over 255 characters. Does anyone know a solution?   Janek Sendrowski

[GENERAL] Is this a bug in ECPG?

2013-09-05 Thread Wang, Jing
Hi, ECPG don't support the following scenario: char cur_name = "cur1"; EXEC SQL DECLARE :cur_name CURSOR FOR ... EXEC SQL OPEN :cur_name; EXEC SQL FETCH cur1 INTO... ... EXEC SQL CLOSE :cur_name; An compile error will occur for above codes because ECPG can't find the "cur1".

Re: [GENERAL] Question About WAL filename and its time stamp

2013-09-05 Thread Suzuki Hironobu
Hi, (13/09/05 22:19), ascot.m...@gmail.com wrote: Hi, From the pg_xlog folder, I found some files with interesting time stamps: older file names with newer timestamps, can you please advise why? Set 1: How come 00040F49008D is 10 minutes newer than 00040F49008E? -rw

Re: [GENERAL] Question About WAL filename and its time stamp

2013-09-05 Thread Haribabu kommi
On 05 September 2013 18:50 ascot.moss wrote: >From the pg_xlog folder, I found some files with interesting time stamps: >older file names with newer timestamps, can you please advise why? >Set 1: How come 00040F49008D is 10 minutes newer than >00040F49008E? >-rw--- 1

Re: [GENERAL] Levenshtein Distance with more than 255 characters

2013-09-05 Thread Szymon Guz
On 6 September 2013 01:00, Janek Sendrowski wrote: > Hi, > > I'm searching for an optimized Levenshtein Distance like Postgresql's. My > problem is that I want to compare strings with a length over 255 characters. > Does anyone know a solution? > > Janek Sendrowski > Hi, I'm not sure there is a

Re: [GENERAL] Levenshtein Distance with more than 255 characters

2013-09-05 Thread Tom Lane
Szymon Guz writes: > On 6 September 2013 01:00, Janek Sendrowski wrote: >> I'm searching for an optimized Levenshtein Distance like Postgresql's. My >> problem is that I want to compare strings with a length over 255 characters. >> Does anyone know a solution? > I'm not sure there is anything di