I chose temp only for illustration purposes. Actually the regression test
"tablespace" fails too,
for the same reason, when run from sources (which creates a tablespace
directory under
src/test/regress)
--
Deepak
On Wed, Nov 25, 2015 at 2:15 PM, John R Pierce <pie...@hogran
f I use 'c:/windows/temp/testtablespace' for location, it works.
If I look at properties for c:/windows/temp and c:/windows/temp1, they look
identical (same ownership and read/write permissions).
Any thoughts on what else to check?
This is with Postgresql 9.1.9.
--
Deepak
?
---
The observed performance is within my requirement. My question was aimed at
getting it to stay that way and your answers have helped.
Thanks again
-Deepak
On Fri, Aug 14, 2015 at 6:19 PM, David Rowley david.row...@2ndquadrant.com
wrote:
On 15 August 2015 at 00:09, Deepak Balasubramanyam
after which Postgresql will ask the disk for data Vs the caches?
Thank you for taking the time to read my question.
- Deepak
.
--
Deepak
Yes, I'm using a customized fork of 9.1.9.
Ok, adding back spi and dummy_seclabel makes all regression tests pass.
I now have one concern though. Inspite of adding pgcrypto to the
exclude list, it still ends up being built and installed. Any way to avoid
this?
Thanks,
Deepak
On Thu, Jan 8
Thanks.
I tried putting all the modules under the contrib directory to the
exclude list. Although I could compile, 3 of 153 regression tests
fail. I have attached the regression.diffs file.
Maybe some contrib modules are absolutely needed?
--
Deepak
On Wed, Jan 7, 2015 at 6:19 PM, Michael
Hi,
I would like to exclude building and installing contrib modules on Windows.
Is there an easy way to do this? I largely rely on the tools available in
src\tools\msvc to build using Visual Studio 2008.
Thanks,
Deepak
Hi! Sounds good, thanks.
--
Deepak
On Thu, Jan 31, 2013 at 9:11 AM, Magnus Hagander mag...@hagander.netwrote:
On Thu, Jan 31, 2013 at 12:20 AM, deepak deepak...@gmail.com wrote:
Hi !
We bundle Postgres into a Windows MSI, Postgres built with VS2008.
One of the issues we ran
a
+# later date.
+my $d = sprintf(%02d%03d, ($year - 100), $yday);
if (Solution::IsNewer($dir\\win32ver.rc,'src\port\win32ver.rc'))
{
--
Deepak
Thanks, I have put one of the other developers working on this issue, to
comment.
--
Deepak
On Mon, May 21, 2012 at 10:55 PM, Tom Lane t...@sss.pgh.pa.us wrote:
deepak deepak...@gmail.com writes:
We could reproduce the start-up problem on Windows 2003. After a reboot,
postmaster, in its
the writing of PID file is complete so that pg_ctl doesn't timeout?
Any other suggestions for working around this problem?
Thanks,
Deepak
On Tue, May 8, 2012 at 12:13 PM, deepak deepak...@gmail.com wrote:
On Tue, May 8, 2012 at 3:09 AM, Alban Hertroys haram...@gmail.com wrote:
On 8 May
On Tue, May 8, 2012 at 3:09 AM, Alban Hertroys haram...@gmail.com wrote:
On 8 May 2012, at 24:34, deepak wrote:
Hi,
On Windows 2008, sometimes the server fails to start due to an existing
postmaster.pid' file.
I tried rebooting a few times and even force shutting down the server
in the file is running or not.
Does any one have this same problem? Any way to fix it besides removing
the PID file
manually each time the server complains about this?
Thanks,
Deepak
waiting for server to shut downLOG: received smart shutdown request
LOG: shutting down
...LOG: database system is shut down
. done
server stopped
Restoring user relation files
Restoring user relation files
pg_upgrade: out of memory
pg_upgrade: out of memory
Thanks for any pointers,
Deepak
on this one?
--
Deepak
On Fri, Nov 18, 2011 at 6:35 PM, deepak deepak...@gmail.com wrote:
Hi!
It appears that when I try to configure listen_addresses in
postgresql.conf (on Windows)
with '0.0.0.0' , pg_ctl doesn't properly detect that server has started
and blocks forever.
C:\pg
Thanks!
On Thu, Nov 17, 2011 at 7:33 PM, Adrian Klaver adrian.kla...@gmail.comwrote:
On Thursday, November 17, 2011 3:41:22 pm deepak wrote:
Hi !
Although, it is not clear what options I have to use while
building/configuring?
This same configuration used to work with Postgres 9.0.3
use
'0.0.0.0' to listen on
all IPv4 addresses:
http://www.postgresql.org/docs/9.1/static/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS
Did something change in 9.1.1 in this area or am I missing something?
--
Deepak
?
This same configuration used to work with Postgres 9.0.3, though.
Any thoughts?
--
Deepak
OK, so you're building it within the main Pg build system. Pg was
successfully compiled, including files that use elog.h . Yet your extension
doesn't compile, complaining about a macro/typedef conflict.
This makes me wonder: what's different?
Can you post the full sources of your extension,
' :
redefinition; previous definition was 'typedef'
C:\Program Files (x86)\Microsoft Visual Studio 2008 Professional
Edition
- ENU\VC\INCLUDE\crtdefs.h(548) : see declaration of 'errcode'
--
Deepak
On Mon, Feb 14, 2011 at 10:25 PM, Craig Ringer
cr...@postnewspapers.com.auwrote:
On 15/02/11 06:28
an
inherent incompatibility..
--
Deepak
command line I'm using to compile:
cl /I \pgsql\include\server /I \pgsql\include\server\port\win32 /LD
\pgsql\lib\postgres.lib c-filename
--
Deepak
hi,,
i have to insert whole xml file in database ,there is a text field
for that.but it shows error parse error where there are attribute ..plz
help me out.
i am fatching record's from data base between two date range for
registration_date coloum and than group by an count it using
count(registration_date) i have to show all dates even if date is not there
in registration_date ,it should show date and 0 in count.,how can i do it
plz healp...
hi i want to add a coloum called serial numer in my record set how could i
do it..that column is not in table.
hi can we make a field auto incrementing field using Time Stamp data type
hi i want to convert 238.000 to 238.0 value 238.000 i got from database how
to use to_char() function...??
hi,
i am new for postgres sql.i have downloaded driver for postgres sql and trying to do connectivity through it.is it type 2 driver or type 4 driver..??-- Deepak PalSoftware Developer
Wicenet ltd.Pune(M.H)
hi,
can anydody tell me what steps nee to configure postgres for java application.plz give me link frm where i got driver for it.-- Deepak PalSoftware DeveloperWicenet ltd.Pune(M.H
)
hi
how to select second heigest salary from employeetable field are id,name ,salary...plz help-- Deepak PalSoftware DeveloperWicenet ltd.Pune(M.H)
hi
i am trying to make script file for my database by using pg_dump in windows as u say i open psqlto postgres then a prompt postgres# open then i write \i pg_dump it shows error.what should i do...plz hepl
hi
i have to make ine field autonumber field what datatype should be used..??
plz reply meee..
On 4/3/06, William Leite Araújo [EMAIL PROTECTED] wrote:
You can make a function to do this.
CREATE FUNCTION drop_operators(text) RETURNS BOOL AS
$$
DECLARE
op record;
BEGIN
hi i have to create a database script file using pg_dump ,but i do not understant how to run it under windows enviornment plz hep me and replay mee soon...
Hi Guys,
Do you know any companies in the San Diego Area(or nearby) who can give
consulting expertise. This is for getting us up and running with postGresql
I would appreciate if I can get emails addresses/compnaies names who do this
..
Thx
Deep
-Original Message-
From: [EMAIL
Hi,
Assume I have a bank app.. When customer withdraws $10 from his accouint I
have to do following
-- update account_summary table [subtract $10 from his account]
-- update account detail_table [with other transaction details]
Requirement:
either both transactions
Can I use a set transaction type mechanism within a function?
thx
Deep
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 10:17 AM
To: Thapliyal, Deepak
Cc: 'Richard Huxton'; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re: [GENERAL
I am getting this error
postgres=# \i a.sql
psql:a.sql:10: ERROR: parser: parse error at or near return at character
26
--
a.sql
--
create function loadme() return text as '
Declare
s_out text ;
Begin
For i in 1..1 loop
insert into test values (i,''Test'');
end loop;
return
(1 row)
Can u pls advice if u know whats going on.. Am I missing somin obvious here.
..
Thx in advance
Deep
-Original Message-
From: Doug McNaught,,, [mailto:[EMAIL PROTECTED] On Behalf Of Doug
McNaught
Sent: Monday, January 12, 2004 4:44 PM
To: Thapliyal, Deepak
Cc: '[EMAIL PROTECTED
...
Thapliyal, Deepak wrote:
create function loadme() return text as '
try RETURNS instead of RETURN
[the guys writing the function parser might want to consider reporting
what the parser was expecting at this point]
Declare
s_out text ;
Begin
For i in 1..1 loop
insert into test
: Monday, January 12, 2004 5:29 PM
To: Thapliyal, Deepak; 'PostgreSQL General'
Subject: Re: [GENERAL] Parse error help needed...
--On Monday, January 12, 2004 17:24:14 -0800 Thapliyal, Deepak
[EMAIL PROTECTED] wrote:
Made the change and used returns in both places now .. Gives me error
postgres
41 matches
Mail list logo