On Wed, 31 Mar 2010, Bruce Momjian wrote:
Faheem Mitha wrote:
I submitted a modified self-contained email as requested, but it does not
appear to have made it to the list, and I never got any kind of reject
message. It was around 1000 lines with no attachments. Is there a size
limit for pos
In about 30 seconds I found the following unanswered threads relating to
installation on Windows Vista. If anybody is interested I can find more.
And I can tell you that a lot of our customers are facing the same
problem with this 1-click gimmicky installer.. something that they never
faced t
Folks,
Here is my original ticket. It has the screen shot as well as the logs.
Like many other threads on this forum it remains unresolved.
http://forums.enterprisedb.com/posts/list/2235.page
If you want to know the number of people who complain about this
one-click installer, just search t
Hi,
I ran below command to list out all privileges of objects if "mydb" schema.
Actually, I want to know what are the permissions "user1" has on mydb
schema. Could you please tell me how to do this?
mydb=# select pc.relname, pc.relacl from pg_class pc, pg_namespace pn where
pc.relnamespace=pn.oid
Joshua D. Drake wrote:
> If EDB was failing for a long time, we would hear a lot more about it.
> They host the most downloaded installer .Org has.
True. And sorry for grumping.
I've had the misfortune to maintain a win32 installer (in my own time)
before, so this is a bit of a hot button. Sure,
On Thu, 2010-04-01 at 11:30 +0800, Craig Ringer wrote:
> Nikhil G. Daddikar wrote:
>
> > I strongly recommend that you start
> > supporting the win32 binary on postgresql.org site again because that
> > used to work till 8.3 and enterprisedb is failing for a long time.
>
> Oh: As for the old inst
Nikhil G. Daddikar wrote:
> I strongly recommend that you start
> supporting the win32 binary on postgresql.org site again because that
> used to work till 8.3 and enterprisedb is failing for a long time.
Oh: As for the old installer - are you volunteering to maintain it? It
wasn't maintaining it
Nikhil G. Daddikar wrote:
> Hi,
>
> I have been trying to install 8.4 on my Vista without success. Earlier
> I'd tried to install 8.3 and that failed too.
"Failed" how?
Installer logs?
Details?
> I tried installing these
> on other Vista machines and they failed too. I searched for google and
Hi,
I have been trying to install 8.4 on my Vista without success. Earlier
I'd tried to install 8.3 and that failed too. I tried installing these
on other Vista machines and they failed too. I searched for google and
enterprisedb forums and there are innumerable requests like mine. Same
with
Hi all,
I wanted to share the solution to $SUBJECT. I noticed that the stats
collector process for one of our servers was pegged around 80-100% CPU
usage, and looked to have been that way for several days or weeks.
Server info:
* Postgres 8.3.4
* Linux 2.6.18-92.1.13.el5 #1 SMP x86_64
* CentOS
Hi All,
Which parameter will come into existence for the performance issue on the
REINDEX. As maintenance_work_mem for CREATE INDEX, does the same will be for
the REINDEX.
Thanks in advance.
Regards
Raghavendra
Another concern is "PL/Tcl call handler must be compiled
with -DPLTCL_UNKNOWN_SUPPORT set." to use the features I want.
Dunno where you got that idea from, but it's not so.
The "magic tables" are to be created by hand, there is no automatic
installation of them.
Hmm - seems that this was a v
"Carlo Stonebanks" writes:
> The Windows builds (in our case, 8.3) still seem to be missing
> magic tables: pltcl_modules and pltcl_modfuncs.
> scripts: pltcl_loadmod, pltcl_listmod and pltcl_delmod
It does appear that no one's gotten around to making the MSVC build
scripts install those tcl scri
> Hello,
>
> I found some subjects like mine on many forums, but the given solution
> doesn't work for me.
>
> I'm using PostgreSQL 8.4. I'm working on a C# application.
>
> When connecting to the application, a temporary table myTableTemp is created.
> This table is available for all the appl
On Wed, Mar 31, 2010 at 12:44 PM, Chris Barnes
wrote:
> I have deleted the rows in a table and vacuumed full, there appears to be
> space allocated that after a truncate it removes.
>
> Why is this?
It's how PostgreSQL is designed. It recycles the space at a later
time, after vacuum has reclaime
In response to Sylvain Lara :
> Hello,
>
> I found some subjects like mine on many forums, but the given solution
> doesn't work for me.
>
> I'm using PostgreSQL 8.4. I'm working on a C# application.
>
> When connecting to the application, a temporary table myTableTemp is created.
> This table
Faheem Mitha wrote:
>
>
> On Sun, 28 Mar 2010, Tom Lane wrote:
>
> > Faheem Mitha writes:
> >> ... In any case, feedback would be helpful. Details of my attempts
> >> at optimization are at
> >> http://bulldog.duhs.duke.edu/~faheem/snppy/opt.pdf
> >
> > By and large, this is not the way to ask
Hello,
I found some subjects like mine on many forums, but the given solution doesn't
work for me.
I'm using PostgreSQL 8.4. I'm working on a C# application.
When connecting to the application, a temporary table myTableTemp is created.
This table is available for all the application duration, a
I have deleted the rows in a table and vacuumed full, there appears to be space
allocated that after a truncate it removes.
Why is this?
\d t8000_us_ts_size_test_2d
Table "dbprc001.t8000_us_ts_size_test_2d"
Column | Type | Modifiers
---+---
The Windows builds (in our case, 8.3) still seem to be missing
magic tables: pltcl_modules and pltcl_modfuncs.
scripts: pltcl_loadmod, pltcl_listmod and pltcl_delmod
In 2006 I reported this problem (see below) with the PG 8.1 Windows build.
This issue came up, and I when I looked to see if it w
On 31/03/2010 16:32, Christophe Dore wrote:
> Hi
>
> We are building a solution using some dedicated postgresql servers (and
> dedicated C++ and Java apps). For security reasons, we'd like to prevent
> users to connect (from our apps at least) to those servers with
> passwords stored in files such
On Wed, 2010-03-31 at 17:32 +0200, Christophe Dore wrote:
> Hi
>
> We are building a solution using some dedicated postgresql servers (and
> dedicated C++ and Java apps). For security reasons, we'd like to prevent
> users to connect (from our apps at least) to those servers with
> passwords stored
Hi
We are building a solution using some dedicated postgresql servers (and
dedicated C++ and Java apps). For security reasons, we'd like to prevent
users to connect (from our apps at least) to those servers with
passwords stored in files such as pgpass.conf.
Is there any configuration that can b
Anssi Kääriäinen wrote:
>
> So, the question is: Is there any (relatively easy) way to use gist
> index with dual-temporal tables? I think this will be asked a lot
> when 9.0 with exclusion constraints is released. The feature seems
> really powerful, but unfortunately supporting data types seem
Hello list,
My problem is that I would like to use the gist index with box datatype
for dual-temporal valid_from values. Querying dual-dimensional tables
using boxes is much easier to write, and hopefully the query will also
run more efficiently, than when using the standard approach of direct
co
paulo matadr wrote:
>>> When I try to import big file base.txt( 700MB),I get this:
>>>
>>> x=# create table arquivo_serasa_marco( varchar(3000));
>>> x=# COPY arquivo_serasa_marco from
>>>
>>> ERROR: literal newline found in data
>>> HINT: Use "\n" to represent newline.
>>> CONTEXT: CO
On 31/03/2010 10:27 PM, Joshua Berry wrote:
My vote would be to follow Craig Ringer's advice to run the pg server in
a virtual machine. I'd choose something like vmware/fusion or if you
want license free options, I think they exist that can run hosts on
win32 and BSD/MacOS.
But if you wanted to
My vote would be to follow Craig Ringer's advice to run the pg server in a
virtual machine. I'd choose something like vmware/fusion or if you want
license free options, I think they exist that can run hosts on win32 and
BSD/MacOS.
But if you wanted to avoid dual booting altogether and
parallels/fu
On 31/03/2010 15:09, Tom Lane wrote:
> Mary's the one who's trying to port forward from some neolithic PG
> version.
Lots of pain, but hopefully lots of gain too! :-)
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.o
Carsten Kropf writes:
> I have a question according to a customly built index. I want to force the
> query planner to search in my index structure, whenever I have a query that
> uses my specified operator. Until now, I always have to insert a quite amount
> of tuples (~ 2-3) for being
Steve Atkins writes:
> On Mar 30, 2010, at 4:23 PM, Wang, Mary Y wrote:
>> Now, the source code doesn't work any more. Here is the SQL - INSERT INTO
>> activity_log (day,hour,group_id,browser,ver,platform,time,page,type,user_id)
>> VALUES
>> (20100330,'16','','MOZILLA','5.0','Win','1269990036',
Now attached.
- Mensagem encaminhada
De: paulo matadr
Para: Albe Laurenz
Cc: GENERAL
Enviadas: Quarta-feira, 31 de Março de 2010 11:03:01
Assunto: Res: [GENERAL] COPY ERROR
Txt file,
I belive that file not put \n on the end of line,this is possible?
follow example in attach.
Txt file,
I belive that file not put \n on the end of line,this is possible?
follow example in attach.
De: Albe Laurenz
Para: paulo matadr *EXTERN* ; GENERAL
Enviadas: Terça-feira, 30 de Março de 2010 4:03:51
Assunto: Re: [GENERAL] COPY ERROR
paulo matad
In article ,
"Marc G. Fournier" writes:
> Has anyone either played with, or gotten to work, a plPgSQL function
> that would take: 192.168.1.1/24 and determine the start and end IP
> from that? Or even start IP + # of IPs in the subnet?
Just install ip4r from pgfoundry, and you'll never look bac
On Wed, Mar 31, 2010 at 3:25 AM, dipti shah wrote:
> Thanks Guys. DBI works fine. I have written below code but it executes only
> on the server where I installed postgresql. Is there any way to run this
> code from remote host. I get an error when trying to run it from remote
> host. I think it i
Le 31/03/2010 07:11, Craig Ringer a écrit :
> Joshua Berry wrote:
>> Hello All,
>>
>> I have a few PHP/Clarion based applications that don't currently track
>> who created and modified records. I'd like to be able to track all user
>> and timestamp pairs for INSERT/UPDATEs by way of triggers.
>>
>>
That was cool ! Thanks a ton. Got my things done.
On Wed, Mar 31, 2010 at 1:13 PM, John R Pierce wrote:
> dipti shah wrote:
>
>> Thanks Guys. DBI works fine. I have written below code but it executes
>> only on the server where I installed postgresql. Is there any way to run
>> this code from re
dipti shah wrote:
Thanks Guys. DBI works fine. I have written below code but it executes
only on the server where I installed postgresql. Is there any way to
run this code from remote host. I get an error when trying to run it
from remote host. I think it is obvious because in below code there
Hi *,
I have a question according to a customly built index. I want to force the
query planner to search in my index structure, whenever I have a query that
uses my specified operator. Until now, I always have to insert a quite amount
of tuples (~ 2-3) for being able to get an index scan
Thanks Guys. DBI works fine. I have written below code but it executes only
on the server where I installed postgresql. Is there any way to run this
code from remote host. I get an error when trying to run it from remote
host. I think it is obvious because in below code there is no information
wher
40 matches
Mail list logo