On 07/26/2012 02:14 PM, Johann Spies wrote:
Hallo Tom,
I believe the problem is that the one-argument form of to_tsquery() uses
the default TS configuration, which you have probably not got set to
"simple". For me, the default TS configuration is "english", which will
stem "polity" as "politi"
> > Has there been any discussion of providing the ability to re-order
> > table columns through an ALTER TABLE command? I would love to see
> > this; when I add in a new column, I often want to put it next to
> > something just to be more visually appealing when I'm running ad-hoc
> > queries. I
On Thu, Jul 26, 2012 at 04:19:02PM +0800, Craig Ringer wrote:
> You'll need to store language information alongside each text value
> if you want to do anything more sophisticated.
I was afraid that that will be the case :)
I will have to update more than 32 entries which currently have
inc
On Wed, Jul 25, 2012 at 1:41 PM, Mark Phillips
wrote:
> I am seeking suggestions for business intelligence and data mining tools
> compatible with postgresql. A new manager at a client's shop is leaning
> toward the MS offerings. I would like to be able to speak to the issue.
>
I'm in the same
I think simple requirements would fit reporting tools space better.
Another alternative worth looking into may be Eclipse BIRT
On 26 Jul 2012, at 13:18, Chris Curvey wrote:
> On Wed, Jul 25, 2012 at 1:41 PM, Mark Phillips
> wrote:
>> I am seeking suggestions for business intelligence and da
On Thu, Jul 26, 2012 at 08:17:19AM -0400, Chris Curvey wrote:
> 1) a tool for power users to be able to get their own data. There are
> a few folks here who are smart enough to be trusted with direct access
> to the database, but I don't want to ask them to learn SQL. Something
> like an open sou
Hi there,
I've looked at Pentaho and Jasper, but I have not had much success.
(Can't remember exactly the issue right now, but I recall that they
seemed to be huge products and I could never quite figure out how to
do something simple with them.)
My advice here is to analyse the requirements a
Le lundi 23 juillet 2012 à 11:53 -0700, Marcus Túlio Ramos a écrit :
> I´m using Visual Studio 2010 - C# and Postgres with NPGSQL for data
> provider.
>
> I´d like to know what´s the best option for a Report Builder on this
> scenario.
If you can separate it from your application, I find that a
Le mercredi 25 juillet 2012 à 10:41 -0700, Mark Phillips a écrit :
> I am seeking suggestions for business intelligence and data mining tools
> compatible with postgresql.
> A new manager at a client's shop is leaning toward the MS offerings. I would
> like to be able to speak to the issue.
mmm
On 07/25/2012 08:19 PM, Chris Bartlett wrote:
Ah! The bob schema has no access privileges set. I had used pgAdmin3 -
the schema definition pgAdmin3 reports is:
CREATE SCHEMA bob AUTHORIZATION bob;
(i.e., no grants)
So:
GRANT ALL ON SCHEMA bob TO bob;
DROP VIEW bob.people;
CREATE OR REPLACE V
Le jeudi 26 juillet 2012 à 08:17 -0400, Chris Curvey a écrit :
> 1) a tool for power users to be able to get their own data. There are
> a few folks here who are smart enough to be trusted with direct access
> to the database, but I don't want to ask them to learn SQL. Something
> like an open s
Johann Spies writes:
> On Thu, Jul 26, 2012 at 04:19:02PM +0800, Craig Ringer wrote:
>> You'll need to store language information alongside each text value
>> if you want to do anything more sophisticated.
> I was afraid that that will be the case :)
I'm not sure that there's anything horribly
On Thu, Jul 26, 2012 at 9:04 AM, Vincent Veyron wrote:
> Le mercredi 25 juillet 2012 à 10:41 -0700, Mark Phillips a écrit :
>> I am seeking suggestions for business intelligence and data mining tools
>> compatible with postgresql.
>> A new manager at a client's shop is leaning toward the MS offer
FATAL : could not read directory base": Invalid argument
8.2.4 on Windows. Service will not start. Any idea
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Jul 25, 2012 at 4:12 PM, Tom Lane wrote:
> Mike Christensen writes:
>> On Wed, Jul 25, 2012 at 1:35 PM, Tom Lane wrote:
>>> Yeah, this has been discussed multiple times. The sticking point is
>>> the extra infrastructure needed to have a physical column numbering
>>> different from the
hello everyone
who can explain it ?thanks!
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/how-to-calculate-or-know-seq-scan-scan-how-many-blocks-every-time-tp5717892p5718082.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via
On Thu, Jul 26, 2012 at 11:02 AM, Mike Christensen wrote:
> I don't really think you'd need to decouple the internal column order
> from what the user sees. A REORDER COLUMNS command should re-build
> the table with the columns in the specified order. Internally, it
> should be no different from
Merlin Moncure writes:
> On Thu, Jul 26, 2012 at 11:02 AM, Mike Christensen wrote:
>> I don't really think you'd need to decouple the internal column order
>> from what the user sees. A REORDER COLUMNS command should re-build
>> the table with the columns in the specified order.
> That's a cont
On Thu, Jul 26, 2012 at 9:12 AM, Merlin Moncure wrote:
> On Thu, Jul 26, 2012 at 11:02 AM, Mike Christensen wrote:
>> I don't really think you'd need to decouple the internal column order
>> from what the user sees. A REORDER COLUMNS command should re-build
>> the table with the columns in the s
On Sun, Jul 15, 2012 at 08:54:53PM +0200, Bartosz Dmytrak wrote:
> 2012/7/13 Chris Angelico
>
>
> Does that help?
>
>
> Sure :)
> I know what unlimited means, but I suggest to change docs to be more accurate.
> Those "limits" are huge (e.g. number of indexes limited by pg_class table
> siz
On Thu, Jul 26, 2012 at 11:19 AM, Tom Lane wrote:
> Merlin Moncure writes:
>> On Thu, Jul 26, 2012 at 11:02 AM, Mike Christensen
>> wrote:
>>> I don't really think you'd need to decouple the internal column order
>>> from what the user sees. A REORDER COLUMNS command should re-build
>>> the ta
Tom Lane wrote:
> > That's a controversial point: doing it that way makes reordering of
> > large tables highly impractical.
>
> In particular, if the implementation works like that, you hardly need
> any system support at all. You can do the equivalent today with a few
> SQL commands: c
I looked on the http://jdbc.postgresql.org/
and could not find any docs on the jdbc string to use my old one with
localhost and 127.0.0.1 do not work any more.
here is the conf
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0
Le jeudi 26 juillet 2012 à 10:02 -0500, Merlin Moncure a écrit :
> job, heh). For an end to end BI stack microsoft is a decent choice
> if (and only if) you're already heavily invested in the microsoft
> platform;
You're right. Because he posted on the list, I had assumed the OP _was_
using Po
I'm hoping someone can help me figure out how to better tune my WAL parameters.
Right now I am seeing WAL activity that is faster than I think it should be -
we average about 30 write queries a second at our peak, and yet we're getting a
new WAL file every 15-20 seconds.
Our postgresql.conf p
Hi,
I have two virtual machines with two different versions of Postgresql. One
machine contains Postgres 7.4.19 and another has Postgres 8.4.3. I also
have other instances of these two virtual machines. I need to transfer the
database from one machine to other. Both machines contain a datab
On Thu, Jul 26, 2012 at 3:39 AM, Manoj Agarwal wrote:
> Hi,
>
>
>
> I have two virtual machines with two different versions of Postgresql. One
> machine contains Postgres 7.4.19 and another has Postgres 8.4.3. I also
> have other instances of these two virtual machines. I need to transfer the
>
Manoj Agarwal wrote on 26.07.2012 12:39:
Hi,
I have two virtual machines with two different versions of
Postgresql. One machine contains Postgres 7.4.19 and another has
Postgres 8.4.3. I also have other instances of these two virtual
machines. I need to transfer the database from one machine
2012/7/26 Bruce Momjian
>
> What is the pg_class table size limit then? Is that really helping
> anyone?
>
>
Fist of all - thanks for Your attentions, I really appreciate it.
is that helping? - as it has been mentioned before: a small audience has
noticed that fact, so probably not. I think it i
On Thu, Jul 12, 2012 at 8:53 AM, Adrian Klaver wrote:
> On 07/12/2012 06:44 AM, Tom Lane wrote:
>>
>> Adrian Klaver writes:
>>>
>>> If a table has a maximum size and rows have size then at some point you
>>> will reach a limit on number of rows per table.
>>
>>
>> I think the "unlimited" should b
Hello everybody,
For PCI compliance I need to log user access to my PCI columns in a table and
retain for 2 years.
I know I can grep the log, but with 1m log rows/day and infrequent PCI access,
I'm thinking this isn't the most efficient method.
I've been thinking about a SELECT rule, for the
On Thu, Jul 26, 2012 at 4:32 PM, Little, Douglas
wrote:
>
> Hello everybody,
>
>
>
> For PCI compliance I need to log user access to my PCI columns in a table
> and retain for 2 years.
>
> I know I can grep the log, but with 1m log rows/day and infrequent PCI
> access, I’m thinking this isn’t th
Hi,
we are using "pg_dump -s" (schema-only) to copy the structure of a
template/prototype database as a set-up for several dozen Fedora boxes. The
dump used to work alright until very recently. Now, across new machines that
are to be introduced into the network it consistently refuses to dump
On Tue, Jul 17, 2012 at 07:42:38AM +1000, Chris Angelico wrote:
> On Tue, Jul 17, 2012 at 4:35 AM, Sergey Konoplev
> wrote:
> > On Mon, Jul 16, 2012 at 8:01 PM, Chris Angelico wrote:
> >> On Tue, Jul 17, 2012 at 1:58 AM, Michael Nolan wrote:
> >>> As I understand the docs for rsync, it will use
On Fri, Jul 27, 2012 at 9:53 AM, Bruce Momjian wrote:
> You might want to look at the hackers list thread I started about the
> same topic a week before your post:
>
> http://archives.postgresql.org/pgsql-hackers/2012-07/msg00416.php
>
> Basically, you can only use mtime/size if you are re
On 07/26/2012 11:27 PM, Abraham, Danny wrote:
FATAL : could not read directory base": Invalid argument
8.2.4 on Windows. Service will not start. Any idea
Which version of Windows? Is it on a business network that might have
group policy?
Where is the data directory? Could you have tried t
On 07/25/2012 07:38 PM, leo xu wrote:
hello:
i know oracle scatter read blocks,can set db_file_multiblock_read_count
every time,
i see postgres,it exists scatter read blocks,it is seq_scan,how to know
scan many bloks every time?
If I understand correctly, you want to have a sequential
On Fri, Jul 27, 2012 at 09:57:55AM +1000, Chris Angelico wrote:
> On Fri, Jul 27, 2012 at 9:53 AM, Bruce Momjian wrote:
> > You might want to look at the hackers list thread I started about the
> > same topic a week before your post:
> >
> > http://archives.postgresql.org/pgsql-hackers/201
On Wed, Jul 18, 2012 at 04:11:21PM +0200, jg wrote:
> Hi,
>
> The PostgreSQK documentation refers to diskchecker.pl on the page
> http://brad.livejournal.com/2116715.html
> But on this page, the given link for diskchecker.pl does not exist anymore.
> After some unsuccessfull queries on Google to
Hello Craig:
I want to know a sequential scan( full scan table) it can read how many
blocks every io?
I know scan index read is one block every io.
Oracle parameter db_file_multiblock_read_count it can control scattered
read (full scan table),
assume db_file_multiblock_read_count =10,wh
On 07/26/2012 10:59 AM, BJ Freeman wrote:
I looked on the http://jdbc.postgresql.org/
and could not find any docs on the jdbc string to use my old one with
localhost and 127.0.0.1 do not work any more.
here is the conf
# "local" is for Unix domain socket connections only
local all all trust
# IPv
On 07/26/2012 04:09 PM, Marek Kielar wrote:
Hi,
we are using "pg_dump -s" (schema-only) to copy the structure of a
template/prototype database as a set-up for several dozen Fedora boxes. The dump used to
work alright until very recently. Now, across new machines that are to be introduced into
On 07/27/2012 10:04 AM, leoxu wrote:
> Hello Craig:
> I want to know a sequential scan( full scan table) it can read how many
> blocks every io?
>I know scan index read is one block every io.
>
>Oracle parameter db_file_multiblock_read_count it can control scattered
> read (full sca
I'm using postgres 9.1.4 on Suse Linux Enterprise Server 11.
After successful installation I by default have one database installed
called postgres.
I'm starting the process of migrating some database schemas off Oracle and
mysql onto postgres but I want to understand how to best set up the
"datab
Hi,
On 27 July 2012 08:07, hartrc wrote:
> What is the purpose of the postgres database? I try and drop it and get
> "maintenance database can't be dropped" error.
'postgres' database is something like 'mysql' database in MySQL.
You should be able to see additional database like 'template0' and
On Fri, Jul 27, 2012 at 9:57 AM, Chris Angelico wrote:
> On Fri, Jul 27, 2012 at 9:53 AM, Bruce Momjian wrote:
>> You might want to look at the hackers list thread I started about the
>> same topic a week before your post:
>>
>> http://archives.postgresql.org/pgsql-hackers/2012-07/msg0041
46 matches
Mail list logo
