Re: [GENERAL] How is sorting work?

As your query contains order by on host_id, so it will be sorted only based on host_id. Since in your case host_id is same for both rows, the order in which host_name will be selected will be absolutely random. If you want query to returns rows sorted on host_name also, then you should add host

Re: [GENERAL] any way for a transaction to "see" inserts done earlier in the transaction?

Regards, Kumar Rajeev Rastogi From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Susan Cassidy Sent: 17 April 2014 05:36 To: Steven Schlansker Cc: Tom Lane; pgsql-general@postgresql.org Subject: Re: [GENERAL] any way for a transaction to "see&quo

Re: [GENERAL] Disable an index temporarily

ecute command, which enable index scan. set enable_indexscan to on; Thanks and Regards, Kumar Rajeev Rastogi -- 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] Doubts on startup costs

p cost is lesser. Thanks and Regards, Kumar Rajeev Rastogi -- This e-mail and its attachments contain confidential information from HUAWEI, which is intended only for the person

Re: [GENERAL] COPY error with null date

COPY from such source file will always fail except for the case if the column data-type is string. In your case COPY is failing or it is able to insert empty string? Thanks and Regards, Kumar Rajeev Rastogi

Re: [GENERAL] Consistent file-level backup of pg data directory

Peter > > You can better try to use pg_basebackup (if you are not very particular about rsync), which will be easy to use and will give you consistent backup. You will be required to make configuration changes of all servers. Check for PostgreSQL documentation for mo

[GENERAL] Regarding pc-lint on PostgreSQL code

Dear Sir, We are in process of evaluating the PostgreSQL static report. So wanted to know if there is any available result for pc-lint on latest source code of PostgreSQL (preferably on 9.2 Beta 3). Thanks and Regards, Kumar Rajeev Rastogi Cell No - +91 8971367787

[GENERAL] Regarding pgTAP

Dear Sir, We were trying to collect list of PostgreSQL suites available. While collecting this data we came across pgTAP Unit test suite. Can you please let us know if this suite is still formal suite from PostgreSQL or it has been discarded. Thanks and Regards, Kumar Rajeev Rastogi Cell

[GENERAL] Info regarding bug list for all previous releases

then to which list I should send. Thanks and Regards, Kumar Rajeev Rastogi Cell No - +91 8971367787