We may make the changes in the installer so that it displays the COMSPEC
value in the error message itself. Currently, we can get it's value from
the installer log.
But, I wonder why the installer threw the error when the manual run
"%COMSPEC%" /c echo "test ok" returned fine. Let's see what the i
On 11/19/2012 05:14 PM, Dave Page wrote:
>> check %COMSPEC% to see if it really
>> > points to cmd.exe .
> Interesting - thanks for the info Craig. Sandeep; can you please look
> into adding such a check to the installer. We already test the
> VBscript interpreter, so this should go in the same pla
On 03/07/2013 05:08 PM, Natalie Wenz wrote:
Hi!
I am working on updating some of our tables to use appropriate native data
types; they were all defined as text when they were created years ago.
What I am running into, though, is there are some records that have bad data in
them, where they c
On 3/7/2013 8:08 PM, Natalie Wenz wrote:
I am working on updating some of our tables to use appropriate native
data types; they were all defined as text when they were created
years ago.
What I am running into, though, is there are some records that have
bad data in them, where they can't be su
=?iso-8859-1?Q?Fran=E7ois_Beausoleil?= writes:
> I have a view similar to this (regression at end):
> CREATE VIEW published_reports AS
> SELECT true AS aired, *
> FROM published_aired_reports
> UNION ALL
> SELECT false AS aired, *
> FROM published_unaired_reports;
> Given that
On Thu, Mar 7, 2013 at 5:28 PM, akp geek wrote:
> Hi all -
>
>Recently made change on our primary database
>
> default_text_search_config = 'pg_catalog.simple' . After that
> the replication is stopped. Can you please help me ? how to fix the issue. I
> am sure I made
Hi all,
I have a view similar to this (regression at end):
CREATE VIEW published_reports AS
SELECT true AS aired, *
FROM published_aired_reports
UNION ALL
SELECT false AS aired, *
FROM published_unaired_reports;
Given that view definition, I expected a WHERE clause with the har
Hi!
I am working on updating some of our tables to use appropriate native data
types; they were all defined as text when they were created years ago.
What I am running into, though, is there are some records that have bad data in
them, where they can't be successfully converted to int, or floa
Hi all -
Recently made change on our primary database
default_text_search_config = 'pg_catalog.simple' . After that
the replication is stopped. Can you please help me ? how to fix the issue.
I am sure I made the change on the slave also.
How can I start the replicati
Hi,
I am using the crosstab function in Postgresql 9.0.
The functions works fine when the distinct category value is less. But when
it goes to to higher like 100 or more, it creates multiple rows for the
same rowid.
Any idea about it?
Thanks.
hi,
I have a postgres 8.4 on a Ubuntu box at my workplace, and I plan to
implement continuous backup with the WAL technique. This backup is mainly
used to provide the usual backup for the company, but I would also like to
use it as an almost always up-to-date copy for my personal computer, mainly
f
On 03/07/2013 11:09 AM, Little, Douglas wrote:
Adrian,
Thank you for your comments.
This is part of our deployment framework. DDL files are submitted to the
framework, which eventually run as psql scripts.
Just out of curiosity, if you are creating the DDL, do you not already
have the schem
On Thu, Mar 7, 2013 at 5:33 PM, Little, Douglas
wrote:
> both dev and prod are 8.2.15
>
> Version stringPostgreSQL 8.2.15 (Greenplum Database 4.2.2.4 build 1) on
> x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Oct 3
> 2012 20:28:56
>
>
>
> can you tell me what change i
Adrian Klaver wrote on 07.03.2013 19:18:
Not that I know of. If you feel adventurous you could look at
dumpTableSchema in pg_dump.c in the source to see how pg_dump does
it.
I think a function "pg_get_tabledef()" would be very helpful.
We already have a lot of pg_get_XXXdef() functions (pg_get
Adrian,
Thank you for your comments.
This is part of our deployment framework. DDL files are submitted to the
framework, which eventually run as psql scripts.
thanks for the tip about pg_dump.c I'll take a look.
I'll also look at escaping out from psql.
Thanks
-Original Message---
On Mar 7, 2013, at 9:37 AM, Ian Pilcher wrote:
> On 03/07/2013 08:28 AM, Tom Lane wrote:
>> Maybe I'm missing something, but I don't see why you'd expect a
>> different result. That leaves you with no way to validate the server's
>> own certificate.
>
> I don't follow. Why would the server nee
On 03/07/2013 08:42 AM, Little, Douglas wrote:
Thanks for the suggestion Adrian,
Unfortunately, my process is executing from psql, so to start pg_dump from
within psql is a bit challenging.
We have 1 instance where we start an OS process from a function, but it's new
territory for us.
Yeah
On 03/07/2013 09:42 AM, Little, Douglas wrote:
Thanks for the suggestion Adrian,
Unfortunately, my process is executing from psql, so to start pg_dump from
within psql is a bit challenging.
We have 1 instance where we start an OS process from a function, but it's new
territory for us.
My fu
Thanks for the suggestion Adrian,
Unfortunately, my process is executing from psql, so to start pg_dump from
within psql is a bit challenging.
We have 1 instance where we start an OS process from a function, but it's new
territory for us.
My function is dumping everything but the ACL grant
both dev and prod are 8.2.15
Version stringPostgreSQL 8.2.15 (Greenplum Database 4.2.2.4 build 1) on
x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Oct 3
2012 20:28:56
can you tell me what change in 8.3 maybe Greenplum incorporated some of the
changes in their build
On 03/07/2013 07:58 AM, Little, Douglas wrote:
I need a pl/pgsql function that will dump a table ddl so I can export
the definition to a file before I drop the object.
the psql \d command won’t work, since it doesn’t dump the table ddl, it
just lists the table’s attributes and indexes.
I’ve g
I need a pl/pgsql function that will dump a table ddl so I can export the
definition to a file before I drop the object.
the psql \d command won't work, since it doesn't dump the table ddl, it just
lists the table's attributes and indexes.
I've got the function mostly working, but need help
On Thu, 7 Mar 2013 23:39:15 +1030 (CST)
Neanderthelle Jones wrote:
> Was thinking of installing Gitorious but it's weird. You run install
> as root, it downloads and installs programs, dunno which ones, seems
> you don't need to know, but including mysql, and then of all things it
> wants you to
On 03/07/2013 08:23 AM, Kevin Grittner wrote:
Exactly what version was this? Just about any queuing system (and
this definitely includes Slony and some JMS implementations) were
vulnerable to an autovacuum bug fixed with this patch from Jan
Wieck:
Hmm. It's a 9.1.7 release, so if the latest i
On 03/07/2013 03:10 AM, MURAT KOÇ wrote:
Hi list,
In Oracle, it could be created a user profile called "PROFILE" and this
profile could have below specifications:
PASSWORD_LIFE_TIME (that describes when password will expire)
FAILED_LOGIN_ATTEMPTS (specifies number of failed login attempts bef
On 03/07/2013 08:28 AM, Tom Lane wrote:
> Maybe I'm missing something, but I don't see why you'd expect a
> different result. That leaves you with no way to validate the server's
> own certificate.
I don't follow. Why would the server need to validate it's own
certificate?
--
=
Ian Pilcher writes:
> I am trying to configure PostgreSQL 8.4 to trust an intermediate CA for
> client certificate validation -- without trusting everything signed by
> the root CA (or a different intermediate CA). Given the following CA
> hierarchy, for example, I would like to trust *only* clie
Shaun Thomas wrote:
> It is when 90% of a table's 65M rows are part of the result set.
> Calculating the cursor puts the retrieved rows in a temporary space
> until the cursor is freed. Calculating that many rows with that order
> by, on our particular system took about 75 seconds. The problem wa
On 03/07/2013 07:40 AM, Filip Rembiałkowski wrote:
Why do you assume that opening a cursor with ORDER BY is equivalent
to fetching all rows? It is not.
It is when 90% of a table's 65M rows are part of the result set.
Calculating the cursor puts the retrieved rows in a temporary space
until the
On Tue, Mar 5, 2013 at 3:51 PM, Shaun Thomas wrote:
> Hey everyone,
>
> Frankly, I'm shocked at what I just found.
>
> We did a delete last night of a few million rows, and come back this
> morning to find that slony is 9-hours behind. After some investigation, it
> became apparent that slony open
Was thinking of installing Gitorious but it's weird. You run install
as root, it downloads and installs programs, dunno which ones, seems
you don't need to know, but including mysql, and then of all things it
wants you to reboot the host, i.e. it needs a host dedicated to
Gitorious. It seems you
> From: Shaun Thomas
> To: Glyn Astill
> Cc: PostgreSQL General
> Sent: Wednesday, 6 March 2013, 14:35
> Subject: Re: [GENERAL] Why does slony use a cursor? Anyone know?
>
> On 03/06/2013 04:49 AM, Glyn Astill wrote:
>
>> What version of slony are you on? The specifics of what you mention
>
Hi list,
In Oracle, it could be created a user profile called "PROFILE" and this
profile could have below specifications:
PASSWORD_LIFE_TIME (that describes when password will expire)
FAILED_LOGIN_ATTEMPTS (specifies number of failed login attempts before
locking user account)
PASSWORD_LOCK_T
33 matches
Mail list logo
