[GENERAL] question related to pg_stat_database

2011-10-29 Thread Arvind Singh
Hello pg_users, we have just migrated an application from mysql to postgresql we use csharp+npgsql to develo application I need to monitor Postgresql statistics at regular intervals. I came across pg_stat_database and especially the columns tulip_fetched and tup_returned. Is there

[GENERAL] PostgreSQL Naming Rules - another question

2011-10-29 Thread Szymon Guz
Hi, according to this part of documentation: http://www.postgresql.org/docs/9.1/interactive/sql-syntax-lexical.html#SQL- SYNTAX-IDENTIFIERS if I select some names from database and sort them... which collation is used? regards Szymon

[GENERAL]

2011-10-29 Thread gouse shaik
I know how to be happy with your family!.. http://www.cfecgcreunion.com/sites.friend.php?unsiteid=13z9 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] From select to delete

2011-10-29 Thread David Johnston
Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alexander Farber Sent: Friday, October 28, 2011 1:03 PM Cc: pgsql-general Subject: Re: [GENERAL] From select to delete Thank you, David - On Fri, Oct 28, 2011 at 7:00 PM,

Re: [GENERAL] PG_DUMP error : unexpected chunk number

2011-10-29 Thread Craig Ringer
On 10/28/2011 06:24 PM, mailtolouis2020-postg...@yahoo.com wrote: Hello, I think I got a big problem now, I'm not able to do pg_dump on one of my production database. When I do pg_dump it give me this error: pg_dump: Error message from server: ERROR: unexpected chunk number 18390760 (expected

Re: [GENERAL] From select to delete

2011-10-29 Thread Alban Hertroys
On 28 Oct 2011, at 19:02, Alexander Farber wrote: I'll try that. My own 3 commands suggested above fail with Foreign key violation: 7 ERROR: update or delete on table pref_games violates foreign key constraint pref_scores_gid_fkey on table pref_scores DETAIL: Key (gid)=(1998) is still

Re: [GENERAL] nextval skips values between consecutive calls

2011-10-29 Thread Gavin Flower
On 29/10/11 05:59, Merlin Moncure wrote: On Fri, Oct 28, 2011 at 11:32 AM,depst...@alliedtesting.com wrote: -Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: Friday, October 28, 2011 8:29 PM To: Dmitry Epstein Cc: t...@sss.pgh.pa.us;