Adrian Klaver wrote:
> There is still the issue of the 9.4 binaries and which version of
> Postgres you are running commands from at any given time. I would
> suggest using full paths to the commands until this is resolved.
It reads to me as if the OP's Fedora 23 -> Fedora 24 upgrade didn't
instal
Melvin Davidson wrote:
> Your problem seems strange as it has never been previously reported for
> anyone else that has _successfully_ set up partioning.
At least as of when I asked a very similar question
(http://www.postgresql.org/message-id/flat/547f7e88.7080...@vianet.ca#547f7e88.7080...@viane
Is it possible to return the number of rows inserted to a partitioned
table set up as per the examples on
http://www.postgresql.org/docs/9.1/interactive/ddl-partitioning.html, in
the same way as if you inserted directly into a target table?
I can sort of see why it returns 0, because 0 rows are ac
David G Johnston wrote:
>> http://www.postgresql.org/docs/9.3/interactive/sql-select.html
>>
>> table_name
>>
>> The name (optionally schema-qualified) of an existing table or
>> view. If ONLY is specified before the table name, only that table is
>> scanned. If ONLY is not specified, the ta
I'm writing a tool for web-based management of DNS records, and I've
come up against a UI nuisance that I'm hoping I can get solved in
Postgres instead of some higher layer.
One table contains all of the live records:
CREATE TABLE records (
domain_id integer NOT NULL DEFAULT 0,
rdns_id in
Steve Atkins wrote:
>
> On Jun 21, 2012, at 8:45 AM, Kris Deugau wrote:
>> CREATE TABLE records (
>>domain_id integer NOT NULL DEFAULT 0,
>>rdns_id integer NOT NULL DEFAULT 0,
>>record_id serial NOT NULL,
>>host text DEFAULT '' NOT
