Hello, David
2014-09-10 4:31 GMT+04:00 David Boreham david_l...@boreham.org:
Hi Dmitriy, are you able to say a little about what's driving your quest
for async http-to-pg ?
I'm curious as to the motivations, and whether they match up with some of
my own reasons for wanting to use
Thank you. Sorry I have been away for a few days and couldn't thank you before.
Wouldn't this have an impact if there are things like views or functions based
on the old table?
On 08/09/2014, at 04:57, Huang, Suya wrote:
Instead of deleting from the original non-partition table which is not
Thank you. I was away for a few days.
This is PG version 9.1. Now, this is in a function. As far as I understand,
every function is a single transaction. I have not created exception blocks
because I don't have any special handling for exceptions. I'm fine with the
default.
The data in each
Thanks for your help, Adrian.
Had a fire to put out before I left for home yesterday, and did not see the
replies from you, Melvin Davidson and Jerry Sievers until this morning. I
read the most recent (yours) first) and ran the query in psql; it complained
about UTF8 encoding characters in
Hello,
I have data in a hierarchical tree structure in one table (tree_tbl) containing
the number of students enrolled in a college course. The college course name is
stored as a tree giving the college name, department, and course name, and
perhaps other descendent nodes such as section name.
Hello,
I need to create a deferrable,unique partial constraint (using a WHERE clause)
on my table, which in addition should also be deferrable. AFAIK deferrable
constraints are just creatable with
ALTER TABLE demand ADD CONSTRAINT unique_salesorderitem_id
UNIQUE (salesorderitem_id) DEFERRABLE
On Sep 9, 2014, at 7:31 PM, David Boreham david_l...@boreham.org wrote:
Hi Dmitriy, are you able to say a little about what's driving your quest for
async http-to-pg ?
I'm curious as to the motivations, and whether they match up with some of my
own reasons for wanting to use
dmigowski wrote
I need to create a deferrable,unique partial constraint (using a WHERE
clause) on my table
I don't know the exact required syntax but the description of the EXCLUDE
clause to CREATE TABLE implies that it can be used to accomplish what you
desire.
Not tested but something like:
Hello,
We are converting the Oracle's CREATE SYNONYM statement into PostgreSQL.
I think to replace the SYNONYM we use search_path in PostgreSQL and the same
thing is explained in the below post also.
http://postgresql.1045698.n5.nabble.com/Synonyms-in-PostgreSQL-9-2-4-td5757986.html
Is there any
any help..
On Tue, Sep 9, 2014 at 4:06 PM, Ramesh T rameshparnandit...@gmail.com
wrote:
Hi,
I had installed pgadmin3 but not selected stackbuilder ,let me know
how to add stackbuilder to pgadmin3 for additional addons..
thanks,
ram
Vinayak wrote:
We are converting the Oracle's CREATE SYNONYM statement into PostgreSQL.
I think to replace the SYNONYM we use search_path in PostgreSQL and the same
thing is explained in the below post also.
http://postgresql.1045698.n5.nabble.com/Synonyms-in-PostgreSQL-9-2-4-td5757986.html
Vinayak vinpok...@gmail.com writes:
Hello,
We are converting the Oracle's CREATE SYNONYM statement into PostgreSQL.
I think to replace the SYNONYM we use search_path in PostgreSQL and the same
thing is explained in the below post also.
On 10/09/2014 10:52, Ramesh T wrote:
any help..
On Tue, Sep 9, 2014 at 4:06 PM, Ramesh T rameshparnandit...@gmail.com
mailto:rameshparnandit...@gmail.com wrote:
Hi,
I had installed pgadmin3 but not selected stackbuilder ,let me
know how to add stackbuilder to
On 09/10/2014 02:52 AM, Ramesh T wrote:
any help..
Have you looked to see if Stack Builder is the Postgres 9.? menu options?
On Tue, Sep 9, 2014 at 4:06 PM, Ramesh T rameshparnandit...@gmail.com
mailto:rameshparnandit...@gmail.com wrote:
Hi,
I had installed pgadmin3 but not
Hello,
I want to change the timezone to Europe/Moscow. Moscow timezone is changing
from +4 to +3
On the box, I have changed the timezone to MSK+3.
From the db side I have modified the following files:
1)postgresql.conf
timezone = 'Europe/Moscow'
2)
Dev Kumkar devdas.kum...@gmail.com writes:
I want to change the timezone to Europe/Moscow. Moscow timezone is changing
from +4 to +3
You'd want to get a new version of the IANA timezone database files for
that. Depending on what packaging you're using, this might be an
operating-system update
On 09/10/2014 06:50 AM, Vinayak wrote:
Hello,
We are converting the Oracle's CREATE SYNONYM statement into PostgreSQL.
I think to replace the SYNONYM we use search_path in PostgreSQL and the same
thing is explained in the below post also.
Vinayak,
* Vinayak (vinpok...@gmail.com) wrote:
We are converting the Oracle's CREATE SYNONYM statement into PostgreSQL.
Ah, I remember having to deal with exactly that issue when migrating
from Oracle.
I think to replace the SYNONYM we use search_path in PostgreSQL and the same
thing is
Stephen Frost sfr...@snowman.net writes:
In general, this has been discussed a number of times in the past (I
brought it up when I ran into the issue originally too..) and I continue
to feel that it'd be good for us to have, but the argument is that
anything done to support synonyms would
Hello, John
2014-09-10 17:25 GMT+04:00 John DeSoi de...@pgedit.com:
On Sep 9, 2014, at 7:31 PM, David Boreham david_l...@boreham.org wrote:
Hi Dmitriy, are you able to say a little about what's driving your quest
for async http-to-pg ?
I'm curious as to the motivations, and whether they
On Sep 10, 2014, at 12:16 AM, Dmitriy Igrishin dmit...@gmail.com wrote:
Hello, David
2014-09-10 4:31 GMT+04:00 David Boreham david_l...@boreham.org:
Hi Dmitriy, are you able to say a little about what's driving your quest for
async http-to-pg ?
I'm curious as to the motivations, and
Hello, Steve
2014-09-10 21:08 GMT+04:00 Steve Atkins st...@blighty.com:
On Sep 10, 2014, at 12:16 AM, Dmitriy Igrishin dmit...@gmail.com wrote:
Hello, David
2014-09-10 4:31 GMT+04:00 David Boreham david_l...@boreham.org:
Hi Dmitriy, are you able to say a little about what's driving
Dear Dmitriy,
To add on to David's suggestions, Data caching is a difficult task to
undertake. Consider an example where your data may not all fit into memory,
when you cache these data outside PostgreSQL you would need to look into
memory management as well as issues around concurrent population
First, I am a Newbie regarding PostgreSQL .
I just started to look at PostgreSQL to implement a large GIS DB (1Tb). The
data must reside in an external disk with eSATA connection and may be moved
to different locations (and Windows desktops/laptops). I was looking to
install PostgreSQL and
On 9/10/2014 2:00 PM, Daniel Begin wrote:
I just started to look at PostgreSQL to implement a large GIS DB
(1Tb). The data must reside in an external disk with eSATA connection
and may be moved to different locations (and Windows
desktops/laptops). I was looking to install PostgreSQL and
On Sep 10, 2014, at 2:00 PM, Daniel Begin jfd...@hotmail.com wrote:
First, I am a Newbie regarding PostgreSQL …
I just started to look at PostgreSQL to implement a large GIS DB (1Tb). The
data must reside in an external disk with eSATA connection and may be moved
to different locations
On 09/10/2014 02:00 PM, Daniel Begin wrote:
First, I am a Newbie regarding PostgreSQL …
I just started to look at PostgreSQL to implement a large GIS DB
(1Tb). The data must reside in an external disk with eSATA connection
and may be moved to different locations (and Windows
Works like a charm! Thank you very much, PostgreSQL really is an awesome
database, and so is the community.
-Ursprüngliche Nachricht-
Von: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] Im Auftrag von David G Johnston
Gesendet: Mittwoch, 10. September
On Sep 10, 2014, at 12:02 PM, Dmitriy Igrishin dmit...@gmail.com wrote:
While this is not related to the %subj%, I've glanced and the link above.
And I found this complex. (As many many many nice featured things
on the market today.) Could you tell me please, for example, why the
URLs like
The views will go with the table. if you rename table, view definition will be
automatically changed accordingly. In your situation, you may need to recreate
views or other objects have dependency on that old table.
But functions will remain the same, so as long as your new table has been
Hello, Allan
2014-09-11 0:29 GMT+04:00 Allan Kamau kamaual...@gmail.com:
Dear Dmitriy,
To add on to David's suggestions, Data caching is a difficult task to
undertake. Consider an example where your data may not all fit into memory,
when you cache these data outside PostgreSQL you would
31 matches
Mail list logo