On Wed, Apr 18, 2012 at 6:22 PM, F. BROUARD / SQLpro <
sql...@club-internet.fr> wrote:
> Hi there,
>
> when creating a tablespace pointing to an existing directory, PG create a
> subderictory with this pattern :
>
> PG_???_!
>
> where ??? is the version (by instance 9.1)
>
> but I don't kn
On Sat, Dec 31, 2011 at 12:04 AM, Tom Lane wrote:
> Whoever you are, you are forging Devrim Gunduz's name to "signed"
> reposts of all his posts in pgsql-general. This is at best impolite to
> Devrim, and it's annoying everybody else. If it continues I will see
> to it that you get removed from
On Thu, Sep 8, 2011 at 12:53 PM, Adarsh Sharma wrote:
> Thanks I am trying as below ;
>
>
> db_name=# select table_to_xml(tbl master, nulls boolean, tableforest
> boolean, targetns text);
> ERROR: syntax error at or near "master"
> LINE 1: select table_to_xml(tbl master, nulls boolean, tablefores
On Thu, Sep 8, 2011 at 12:53 PM, Adarsh Sharma wrote:
> Thanks I am trying as below ;
>
>
> db_name=# select table_to_xml(tbl master, nulls boolean, tableforest
> boolean, targetns text);
> ERROR: syntax error at or near "master"
> LINE 1: select table_to_xml(tbl master, nulls boolean, tablefores
On Thu, Sep 8, 2011 at 12:11 PM, Adarsh Sharma wrote:
> Dear all,
>
> Today I need to write the output of an postgres table into XML format.
> I think there is an easiest way to do this but not able to find it.
>
> In mysql there is simple query for that :
>
> mysql -X -e "select * from db_name.ma
On Tue, Aug 16, 2011 at 1:11 PM, Lauri Kajan wrote:
> Hi all,
>
> I have made a function returning a custom record type that contains two
> fields.
> Now I want to select from that function. Actually I want to make a
> join with a table.
>
> Let me explain.
>
> Here is my function:
> CREATE TYPE
On Tue, Aug 9, 2011 at 7:10 PM, Adrian Klaver wrote:
> On Tuesday, August 09, 2011 2:18:47 am Adarsh Sharma wrote:
> > Dear all,
> >
> > I installed postgresql from a postgresplus-8.4.1-2-linux-x64 binary and
> > it is working properly in the system.Yesterday i do some work in it.
> >
> > But tod
On Mon, Aug 1, 2011 at 3:00 AM, Aakash Goel wrote:
> Hi,
>
> I am having some trouble installing the db on my Windows 7 machine.
>
> Whenever I try to install from postgresql-9.0.4-1-windows_x64.exe, I get
> these errors:
> http://i.imgur.com/gNCrR.png
> http://i.imgur.com/yEVxT.png
>
> Any help i
On Tue, Jul 12, 2011 at 11:46 PM, hyelluas wrote:
> Hi Chetan,
>
> I'm not sure how I can create a test case, I'm running queryes on 50g of
> data to see this.
>
> My general questions are about locking children when select from a parent,
> I
> have not seen any documentation on it. Does any para
On Tue, Jul 12, 2011 at 6:01 AM, hyelluas wrote:
> Hello,
>
> I’m having a problem with concurrent processing.
> 2 queries are accessing the same parent table that have 24 partitions.
> I see “shared lock is not granted “ for one of them on one of the children
> while the other query is running.
src/backend/utils/adt/geo_ops.c which has code for
conversion between
datum and point and vice-versa.
--
Regards,
Chetan Suttraway
EnterpriseDB <http://www.enterprisedb.com/>, The Enterprise
PostgreSQL<http://www.enterprisedb.com/>
company.
On Mon, Mar 7, 2011 at 2:49 AM, Nick Raj wrote:
> Hi all,
>
> I want to construct an "Composite Index Structure" i.e. a combination of
> gist and btree.
> What i am thinking is that first creating a Rtree structure that is
> pointing to another Btree structure.
> For example, Suppose i want to fi
12 matches
Mail list logo