Re: [GENERAL] Error creating Tablespace on Windows

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 wrote: > On 11/25/

[GENERAL] Error creating Tablespace on Windows

denied If 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

Re: [GENERAL] Postgresql jsonb

is the observed performance? --- 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 wrote: > On 15 August 2015 at 00:09, Deepak Ba

[GENERAL] Postgresql jsonb

alculation (or close to it), to determine a point after which Postgresql will ask the disk for data Vs the caches? Thank you for taking the time to read my question. - Deepak

[GENERAL] Prepared statements with bind parameters for DDL

Please clarify. -- Deepak

Re: [GENERAL] How to exclude building/installing contrib modules on Windows

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,

Re: [GENERAL] How to exclude building/installing contrib modules on Windows

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

[GENERAL] How to exclude building/installing contrib modules on Windows

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

Re: [GENERAL] Version numbers for binaries

Hi! Sounds good, thanks. -- Deepak On Thu, Jan 31, 2013 at 9:11 AM, Magnus Hagander wrote: > On Thu, Jan 31, 2013 at 12:20 AM, deepak wrote: > > Hi ! > > > > We bundle Postgres into a Windows MSI, Postgres built with VS2008. > > > > One of the issues we ran

[GENERAL] Version numbers for binaries

ce it is from a +# later date. +my $d = sprintf("%02d%03d", ($year - 100), $yday); if (Solution::IsNewer("$dir\\win32ver.rc",'src\port\win32ver.rc')) { -- Deepak

Re: [GENERAL] FATAL: lock file "postmaster.pid" already exists

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 wrote: > deepak writes: > > We could reproduce the start-up problem on Windows 2003. After a reboot, > > postmaster, in its start-up sequenc

Re: [GENERAL] FATAL: lock file "postmaster.pid" already exists

ere, specifically to somewhere after 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 wrote: > > > On Tue, May 8, 2012 at 3:09 AM, Alban Hertroys wrote

Re: [GENERAL] FATAL: lock file "postmaster.pid" already exists

On Tue, May 8, 2012 at 3:09 AM, Alban Hertroys 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 tim

[GENERAL] FATAL: lock file "postmaster.pid" already exists

PID 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

[GENERAL] pg_upgrade: out of memory

out of memory Thanks for any pointers, Deepak

Re: [GENERAL] 0.0.0.0 addresses in postgresql.conf on Windows

y thoughts on this one? -- Deepak On Fri, Nov 18, 2011 at 6:35 PM, deepak 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 &

[GENERAL] 0.0.0.0 addresses in postgresql.conf on Windows

till mentions that one could 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

Re: [GENERAL] Authentication configuration for local connections on Windows

Thanks! On Thu, Nov 17, 2011 at 7:33 PM, Adrian Klaver wrote: > 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 wo

[GENERAL] Authentication configuration for local connections on Windows

o use while building/configuring? This same configuration used to work with Postgres 9.0.3, though. Any thoughts? -- Deepak

Re: [GENERAL] Building extensions on Windows using VS2008

> 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 exte

Re: [GENERAL] Building extensions on Windows using VS2008

same error. (about redefinition of errcode). Somehow, it seems to me that there's an inherent incompatibility.. -- Deepak

Re: [GENERAL] Building extensions on Windows using VS2008

r\utils/elog.h(118) : error C2365: 'errcode' : 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

[GENERAL] Building extensions on Windows using VS2008

ommand line I'm using to compile: cl /I \pgsql\include\server /I \pgsql\include\server\port\win32 /LD \pgsql\lib\postgres.lib -- Deepak

[GENERAL] how to store whole XML file in database

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.

[GENERAL] show all record between two date after group by and aggrigation...

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...

[GENERAL] how to show serial number of record

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.

[GENERAL] Time Stamp auto Field

hi can we make a field auto incrementing field using Time Stamp data type

[GENERAL] problem in to_char() function

hi i want to convert 238.000 to 238.0 value 238.000 i got from database how to use to_char() function...??

[GENERAL] question for JAVA developer who r using postgres sql as backend

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)

[GENERAL] what step need to configure postgres for java application

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 )

[GENERAL] how to select second heigest salary...

hi   how to select second heigest salary from employee  table field are id,name ,salary...plz help-- Deepak PalSoftware DeveloperWicenet ltd.Pune(M.H)

[GENERAL] what datatype is for autonumbering.in postgress

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; >

[GENERAL] how to create script of database in postgres..sql(winxp)

hi   i am trying to make script file for my database by using pg_dump in windows as u say i open psql to postgres  then a prompt postgres# open then i write \i pg_dump it shows error.what should i do...plz hepl  

[GENERAL] how to use pg_dump in windows xp

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...  

[GENERAL] postGresql Consulting ??

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 PROTECTE

[GENERAL] Nested transaction - I am a bank ??

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] S

[GENERAL] Nested transaction - I am a bank ??

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 sho

Re: [GENERAL] Parse error help needed...

om: Larry Rosenman [mailto:[EMAIL PROTECTED] Sent: 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]> wro

Re: [GENERAL] Parse error help needed...

ral Subject: Re: [GENERAL] Parse error help needed... 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

Re: [GENERAL] Parse error help needed...

- plpgsql | t (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 C

[GENERAL] Parse error help needed...

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 s_