[GENERAL] postgreSQL query via JDBC in different OS taking different running time?

2013-10-07 Thread Aftab Ahmed Chandio
Hi, I want to know the reason behind the case: My query processes from JDBC (Java Program) to PostgreSQL. I use system time by invoking java function, I collect one time unit before the query statement perform and second after the execution of query statement. I found 85 ms time unit in DOS (win

Re: [GENERAL] "could not accept SSPI security context"

2012-01-22 Thread Ahmed Shinwari
_id=1000140&release_id=1889>, which is the latest stable release. -Ahmed On Sat, Jan 21, 2012 at 7:31 AM, G_Hosa_Phat [via PostgreSQL] < ml-node+s1045698n5162113...@n5.nabble.com> wrote: > Brar Piening wrote > Just a guess: You don't have something like "host all

[GENERAL] using postgresql

2011-07-31 Thread saeed ahmed
my english is limited and find it difficult to learn new things.only by askiing ,i can learn. i would like to know if i want to make a website where user can insert data and after i use query to get results.how should i begin?from where to start? -- Sent via pgsql-general mailing list (pgsql-gen

Re: [GENERAL] eval function

2011-07-31 Thread saeed ahmed
i am new to postgresql and not very good in english language.i need help to understand,how i can make,(by using postgresql)something like microsofts access.i remebre you see a lot of buttons and functions.when you finish inserting some data,you have something permanent like a software that remains

Re: [GENERAL] "could not accept SSPI security context"

2011-03-10 Thread Ahmed Shinwari
, Ahmed Shinwari wrote: > > > On Sat, Feb 19, 2011 at 11:31 PM, Brar Piening wrote: > >> On Thu, 17 Feb 2011 07:58:46 -0800 (PST), Ahmed >> wrote: >> >>> I tried changing that one line to use UTF-8 encoder, but the password >>> packet >>>

Re: [GENERAL] "could not accept SSPI security context"

2011-02-24 Thread Ahmed Shinwari
On Sat, Feb 19, 2011 at 11:31 PM, Brar Piening wrote: > On Thu, 17 Feb 2011 07:58:46 -0800 (PST), Ahmed > wrote: > >> I tried changing that one line to use UTF-8 encoder, but the password >> packet >> didn't get fixed. It works smoothly if kept in byte array in

Re: [GENERAL] "could not accept SSPI security context"

2011-02-17 Thread Ahmed
Hi Francisco, I tried changing that one line to use UTF-8 encoder, but the password packet didn't get fixed. It works smoothly if kept in byte array instead of string. I think changing the AuthenticationSSPI case to use context.Host may break the cases Brar's mentioned. -- View this message i

[GENERAL] Using Bitmap scan instead of Seq scan

2011-02-14 Thread Ahmed Ossama
result. My question how do I make PostgreSQL always uses bitmap scan instead of seq scan? Any advice is very much appreciated. Best Regards, Ahmed Ossama -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] "could not accept SSPI security context"

2011-02-02 Thread Ahmed
The issue has been addressed and patch has been submitted. Refer to Npgsql mailing thread http://lists.pgfoundry.org/pipermail/npgsql-devel/2011-February/001116.html http://lists.pgfoundry.org/pipermail/npgsql-devel/2011-February/001116.html . -- View this message in context: http://postgresql

Re: [GENERAL] Error during a dump (ts_selectivity, not found)

2011-01-19 Thread Ahmed Ossama
On 19/01/2011 21:51, Tom Lane wrote: Ahmed Ossama writes: I have no problems with the restore without them, and the restore goes fine, but it stops and the point: "WARNING: errors ignored on restore: 6" Well, those are exactly the errors you showed us, no? Yes, these are the only e

Re: [GENERAL] Error during a dump (ts_selectivity, not found)

2011-01-19 Thread Ahmed Ossama
ps at 47GB. So could this extension be the reason behind the failure? I don't see anything in the logs for more details about this error. Best Regards, Ahmed Ossama On 19/01/2011 18:10, Tom Lane wrote: Adrian Klaver writes: On Wednesday 19 January 2011 4:57:42 am Ahmed Ossama wrote: I s

[GENERAL] Error during a dump (ts_selectivity, not found)

2011-01-19 Thread Ahmed Ossama
electivity, but all in vain. Any advice/hint is very much appreciated. Best Regards, Ahmed Ossama -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Error during a dump (ts_selectivity, not found)

2011-01-19 Thread Ahmed Ossama
for the library ts_selectivity, but all in vain. Any advice/hint is very much appreciated. Best Regards, Ahmed Ossama

[GENERAL] information request

2009-06-05 Thread ahmed saeed
hello, i am new to postgresql.actually i use openoffice for my database needs but i see over internet people talking postgresql is the best solution for database needs.i would love to make tables,queries,reports etc.can you guide me what product i should download and use? thanks and GOD ble

[GENERAL] osm2pgsql error

2009-04-16 Thread ahmed soua
Hi all, when i was executing this command : osm2pgsql --slim -v -d gis /home/ ahmed/GreatLakes.osm.gz i had obtained this error : failed: ERREUR: VACUUM ne peut pas être exécuté à partir d'une fonction ou d'une chaîne contenant plusieurs commandes ( VACUUM cannot be executed from a f

[GENERAL] how to disable autovaccum

2009-04-14 Thread ahmed soua
ds) *Error occurred, cleaning up. *I had disabled the parameter autocavcum in the file* postgresql.conf* but i still have the same error. Can you help me please . Thank you in advance *Soua Ahmed* -- Le bonheur est comme l'écho : il vous répond : mais il ne vient pas.

[GENERAL] Query Problem

2008-07-06 Thread Sheikh Salman Ahmed
Hi Fellows I still have problem to access my databank.It shows syntax problem,I am using VC++ 2005 with postgresql 8.3.My table name is Person and it has three column,Person ID,first name and last name (testing version).whole c++ code is // Test_postgres.cpp : Defines the entry point for

[GENERAL] Query Fails

2008-07-01 Thread Sheikh Salman Ahmed
Hallo Fellows I am a new User of postgresql.I have installed it on window XP.I feel it little complicated on Window.I have already connected it with visual c++ 2005,but when i wanted to insert some data in my databank,then it fails and shows sytax error or doesn't recognise my table, but con

[GENERAL] Query Fails

2008-07-01 Thread Sheikh Salman Ahmed
Hallo Fellows I am a new User of postgresql.I have installed it on window XP.I feel it little complicated on Window.I have already connected it with visual c++ 2005,but when i wanted to insert some data in my databank,then it fails and shows sytax error or doesn't recognise my table, but con

[GENERAL] Query Fails

2008-07-01 Thread Sheikh Salman Ahmed
Hallo Fellows I am a new User of postgresql.I have installed it on window XP.I feel it little complicated on Window.I have already connected it with visual c++ 2005,but when i wanted to insert some data in my databank,then it fails and shows sytax error or doesn't recognise my table, but con

[GENERAL] Query Fails

2008-07-01 Thread Sheikh Salman Ahmed
Hallo Fellows I am a new User of postgresql.I have installed it on window XP.I feel it little complicated on Window.I have already connected it with visual c++ 2005,but when i wanted to insert some data in my databank,then it fails and shows sytax error or doesn't recognise my table, but con

RE: [GENERAL] Postgres 7.1RC1 on Solaris 7

2001-04-07 Thread Ahmed Moustafa
Martín, The problem was solved by explicitly defining LD_LIBRARY_PATH in the command line i.e. su - postgres -c "export LD_LIBRARY_PATH=/usr/lib/:/usr/local/lib:/usr/local/pgsql/lib ; /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data start" Best Regards, Ahmed -Origin

Re: [GENERAL] Postgres 7.1RC1 on Solaris 7

2001-04-04 Thread Ahmed Moustafa
problem? Again, thanks a lot for your help. Peter Eisentraut wrote: > Ahmed Moustafa writes: > > > bash-2.03# echo "int main() { return 0; }" >conftest.c > > bash-2.03# gcc -o conftest conftest.c -lz -lresolv -lgen -lnsl -lsocket -ldl > > -lm > > bash-2.03

Re: [GENERAL] Postgres 7.1RC1 on Solaris 7

2001-04-04 Thread Ahmed Moustafa
cket.so.1 libdl.so.1 =>/usr/lib/libdl.so.1 libm.so.1 => /usr/lib/libm.so.1 libc.so.1 => /usr/lib/libc.so.1 libmp.so.2 =>/usr/lib/libmp.so.2 /usr/platform/SUNW,Ultra-5_10/lib/libc_psr.so.1 bash-2.03# So, how can I fix the problem, please?

Re: [GENERAL] Postgres 7.1RC1 on Solaris 7

2001-04-04 Thread Ahmed Moustafa
Hi Peter, Changing line 6846 gave me the same error message. Ahmed Peter Eisentraut wrote: > Ahmed Moustafa writes: > > > Hi, > > > > I downloaded Postgres 7.1RC1 from > > ftp://ftp.postgresql.org/pub/dev/postgresql-7.1RC1.tar.gz. When I did > > ./co

Re: [GENERAL] Postgres 7.1RC1 on Solaris 7

2001-04-04 Thread Ahmed Moustafa
cket.so.1 libdl.so.1 =>/usr/lib/libdl.so.1 libm.so.1 => /usr/lib/libm.so.1 libc.so.1 => /usr/lib/libc.so.1 libmp.so.2 =>/usr/lib/libmp.so.2 /usr/platform/SUNW,Ultra-5_10/lib/libc_psr.so.1 bash-2.03# So, how can I fix the problem, pleas

[GENERAL] Postgres 7.1RC1 on Solaris 7

2001-04-04 Thread Ahmed Moustafa
Hi, I downloaded Postgres 7.1RC1 from ftp://ftp.postgresql.org/pub/dev/postgresql-7.1RC1.tar.gz. When I did ./configure, I got a error with the test program. I could not figure out the problem. Would you take a look at the config.log (http://www.photo.net/users/ahmed/config.log) and tell me the