Greetings.
I'm in the process of indexing a virtual file system (on 9.2.9, build
info below) and I ran into what I perceive as an inconsistency in the
way index viability is assessed by the planner.
Perhaps I'm misinterpreting the docs, but it seems like stable functions
don't behave as
@Adrian Klaver, Thanks for this idea but still m really confused with how
to update the json filed in the DB. is there any way to update the json
field in the DB through view.?
On Wed, Oct 29, 2014 at 7:37 PM, Adrian Klaver adrian.kla...@aklaver.com
wrote:
On 10/29/2014 01:06 AM, VENKTESH
Hi ,
While i try to install psqlDDBC, i get this error , i have SUSE Linux
Enterprise Server 11 , trying to find a solution still have no idea.
./configure
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe
2014-10-30 8:47 GMT+01:00 Postgres India pgbugin...@gmail.com:
Hi ,
While i try to install psqlDDBC, i get this error , i have SUSE Linux
Enterprise Server 11 , trying to find a solution still have no idea.
./configure
checking for a BSD-compatible install... /usr/bin/install -c
checking
Hi !
Can anyone share any experiences with running PostgreSQL on a
tablet ? (Surface Pro 3, ASUS Transformer)
(or point to things I should read, searching the web didn't
turn up anything that seemed relevant to *tablets*)
Thanks,
Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
Fabio Ugo Venchiarutti fa...@vuole.me writes:
As you can see, CONCAT()'s output isn't deemed suitable for an index
scan. The same happens for all type-compatible STABLE functions i tried.
Conversion of the pattern to an index qualification requires that the
pattern be a plan-time constant.
On 10/29/2014 11:26 PM, VENKTESH GUTTEDAR wrote:
@Adrian Klaver, Thanks for this idea but still m really confused with
how to update the json filed in the DB. is there any way to update the
json field in the DB through view.?
Sure, how you would normally update a value. Assuming id is unique:
On 10/29/2014 11:26 PM, VENKTESH GUTTEDAR wrote:
@Adrian Klaver, Thanks for this idea but still m really confused with
how to update the json filed in the DB. is there any way to update the
json field in the DB through view.?
Realized I should have shown at least one concrete example so,
CrabbeS wrote
I am trying to copy a table form one database to another by using this
command in the SQL-query builder:
pg_dump TA2000 -t from Forest -c -s | psql -h localhost postgis;
pg_dump is a standalone application (i.e., something you run in a
shell/command-line) and not an SQL command.
Thanks Adrian Klaver, Its really helped me to solve my problem, ya i have
example_list = jsonfield.JSONField() in models. Apologies i did not mention
that. but anyways thank again.
On Thu, Oct 30, 2014 at 8:09 PM, Adrian Klaver adrian.kla...@aklaver.com
wrote:
On 10/29/2014 11:26 PM, VENKTESH
The psql console still operates mainly at the SQL level of input. You need
to use your OS's shell to run pg_dump.
Both psql and pg_dump are the same kind of application and are run in a
similar fashion.
David J.
On Thu, Oct 30, 2014 at 11:13 AM, CrabbeS [via PostgreSQL]
I need to get an idea of how much WAL space will be required during a long
(many hours) pg_basebackup over a relatively slow network connection. This
is for a server that's not yet running PITR / streaming.
Any thoughts?
* mike.blackw...@rrd.com*
Hi,
I don't know if this is the right mailing list for my question but I
have already emailed pla...@postgresql.org without any response.
What is the correct way to get a blog listed on planet postgres?
The documented way does not work. I registered my blog on Monday. It
still is in Not
On 10/30/2014 12:02 PM, Torsten Förtsch wrote:
Hi,
I don't know if this is the right mailing list for my question but I
have already emailed pla...@postgresql.org without any response.
What is the correct way to get a blog listed on planet postgres?
The documented way does not work. I
* Adrian Klaver (adrian.kla...@aklaver.com) wrote:
On 10/30/2014 12:02 PM, Torsten Förtsch wrote:
I don't know if this is the right mailing list for my question but I
have already emailed pla...@postgresql.org without any response.
That's the correct place to ask. -general is not.
So, what
Conversion of the pattern to an index qualification requires that the
pattern be a plan-time constant. STABLE functions, by definition,
are not that.
Thank you very much
I guess it is correct to assume that the same applies to regular
expressions stored in pl/pgsql variables/arguments
Fabio Ugo Venchiarutti fa...@vuole.me writes:
Conversion of the pattern to an index qualification requires that the
pattern be a plan-time constant. STABLE functions, by definition,
are not that.
I guess it is correct to assume that the same applies to regular
expressions stored in
Hi,
On Thu, 2014-10-30 at 00:47 -0700, Postgres India wrote:
configure: error: odbc_config not found (required for unixODBC build)
I think you need to install unixODBC-devel rpm via yast.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
On 10/22/2014 06:45 PM, Postgres India wrote:
Hi,
I am trying to connect DB2 from postgres using dblink, is there any
configuration required at DB2 and postgres server.
You'll need dbi-link (which uses Perl's DBI drivers) or a foreign data
wrapper.
dblink is for connections between
This is hard to tell, but You can get some estimation.
1. You can have WAL rate estimation from pg_xlog/ dir, i.e. How many WAL
generated per minutes
2. How long this pg_basebackup will last. Lets say for 3 hours.
Then You can multiple values in #1 and #2 to get rough estimation.
Hope this would
20 matches
Mail list logo
