Thanks a lot to all.Pls.Unsubscribe me.
Thanks&Regards
Sandhya R
was done.
->Failed to create process for initdb:Logon failure:the user has not
been granted the requested logon type at this computer.
Please help me
Thank you,
Sandhya
content to it...
please help me...anybody
Thank you all,
Regards
Sandhya
- Original Message -
From: "Marco Bizzarri" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>
Cc: "Postgres"
Sent: Thursday, June 22, 2006 3:33 PM
Subject: Re: [AD
t;Marco Bizzarri" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>
Cc: "Postgres"
Sent: Thursday, June 22, 2006 1:43 PM
Subject: Re: [ADMIN] reg:lo_write
> I'm not sure, but I think you will have problems. As far as I can
> understand, largeobject
.
Regards,
Sandhya
- Original Message -
From:
VivekanandaSwamy R.
To: sandhya
Sent: Thursday, June 22, 2006 1:56
PM
Subject: RE: [ADMIN] reg:lo_write
Dear sandhya,
According to my knowledgeIf u use LO_WRITE function
to write data into an object,it wil
to append the content to the present object is
there anything i need to do?
Please help me in doing
this
I am unable to see the image which i am
exporting...
Thank you,
Sandhya
yes..I got it.
SELECT LIMIT x OFFSET y.Am i
right?
- Original Message -
From:
Andy Shellam
To: 'sandhya'
Cc: pgsql-admin@postgresql.org
Sent: Tuesday, May 16, 2006 6:35 PM
Subject: FW: [ADMIN] reg:Query
Actually, just
real
Thank you.
- Original Message -
From:
Andy Shellam
To: 'sandhya'
Cc: pgsql-admin@postgresql.org
Sent: Tuesday, May 16, 2006 6:26 PM
Subject: RE: [ADMIN] reg:Query
SELECT
.. LIMIT
1
Will get the first
row in the dataset. Then to
Hi
Is there any query for possibility of getting only one
row at a time in a group of records?
With distinct rows & Columns my query has to return only
one record at a time with out any condition.Will it be possible?
Thank you,
Sandhya
ne is
also win2000 only.
Why it is happening in Win2000,Anybody can pls explain me?
- Original Message -
From: "David Bonilla" <[EMAIL PROTECTED]>
To:
Sent: Thursday, May 11, 2006 5:03 PM
Subject: Re: [ADMIN] Fw: reg:logon failure
> sandhya escribió:
> > H
th my Linux server.But in Windows i am facing this problem.
Thank you,
Regards
Sandhya
Is there any document which explains clarly about how to load
files in binart format and how to retrieve itAs far as i read i got only
files storing in OID format.
Thanks for your help...
Sandhya
- Original Message -
From:
Andy Shellam
To: 'sandhya'
..It is very much
needed for me..
Thank you,
sandhya
- Original Message -
From:
Andy Shellam
To: 'sandhya'
Cc: pgsql-admin@postgresql.org
Sent: Thursday, May 11, 2006 12:56
PM
Subject: RE: [ADMIN] regarding image
files in DB
I would think a da
Regards,
Sandhya
. imported file into DB) and the exported file from the DB
are different.
What is the wrong i did?In which format i have to load my
file.Is it only for image files or for all types of files(like js,asp,htm
etc)
Please help me in resolving this issue.
Thanks in advance
Regards,
Sandhya
the .gif file and checked
for the size also.The size it self is different.
Please tell me if there is any other procedure to store .gif
files in DB as large objects and getting them with out any
difference.
I am very thankful to you.Please give me suggestion to solve
this.
Regards,
Sandhya
into DB and retrieve it.
Help me.
Thank you
Sandhya
these files will there be any difference in this
case if the files are in DB than the local file system.
Is it ok if i have files which will replace the variac\bles
with actual values at run time.
Please explain me .
Thank you
Sandhya
files will there be any difference in this
case if the files are in DB than the local file system.
Is it ok if i have files which will replace the variac\bles
with actual values at run time.
Please explain me .
Thank you
Sandhya
Hi...
I want to know more about alter user /creating users.I
am facing error if i give user with Login/Nologin..Why is it so?
But it is working fine for
Createdb/NoCreatedb.etc.
sample=# ALTER user sandhya with LOGIN;ERROR: syntax
error at or near "LOGIN" at character 25LIN
changing column type of a table.
Incase of int to char/varchar/text/ etc.
What are the different datatypes we should think
about?
Thank you,
Sandhya
oh.ok
Now, just because you can do this doesn't mean it's a very good idea...
Why?
- Original Message -
From: "Jim C. Nasby" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>
Cc: "Michael Fuhr" <[EMAIL PROTECTED]>; &q
: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>
Cc: "Postgres"
Sent: Monday, March 27, 2006 12:15 PM
Subject: Re: [ADMIN] reg:create database
> On Mon, Mar 27, 2006 at 12:11:40PM +0530, sandhya wrote:
> >I want to
Hi...
I want to have a database/table with dot(
. ) in its name.But i am unable to create a database with a dot
in the middle of its name..Is there any possibility of doing it?If yes pls tell
me.
Thank you,
Sandhya
have both in my release folder of postgres.
How can i use this static library(libpq.lib) so that it should not ask for
libpqdll.lib?or Is it must that we need to give
Any one pls help me.
Thanks in advance.,
Sandhya
r-process communication. "localhost" - 127.0.0.1, also used on any
> TCP/IP configured system, including Windows, which does not support UNIX
> domain sockets, by default - _is_ a special network address, the
> loopback device and is used generally to ensure proper func
Hi Andy,
Now it is working fine.After mentioning listen_address = '*' ..I have
restarted the postgres server.
Then it is working fine.
Thanks for your help.
-Sandhya
- Original Message -
From: "Andy Shellam" <[EMAIL PROTECTED]>
To: "'sandhya
Yes Andy..Thats what i did.
i checked by giving '*' in listen_address
also i gave IP of my system.Both things got failed.
Whether reload is enough...
or we need to restart it?
- Original Message -
From: "Andy Shellam" <[EMAIL PROTECTED]>
To: "'san
age i sent in last mail?
What is wrong if i mention the localhost IP instead of localhost in my
connection information?
- Original Message -
From: "Andy Shellam" <[EMAIL PROTECTED]>
To: "'sandhya'" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, March 20,
t; <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>
Cc: "Postgres"
Sent: Monday, March 20, 2006 2:28 PM
Subject: Re: [ADMIN] reg:conninfo
> Try looking at the manual for the postmaster process ...
>
> A simple way of achieving what you want is adding the -i o
of localhost?
Please tell me.
Thank you,
Sandhya
?
Bcoz of this \b,\n and \r characters..I am unable to store my
data into the database and retrieve it.
Is there any Solution that we have?Or we need to Take care of
these situations/cases?
Please give me your Suggestions to resolve this
issue..
Thank you very much..
Regards,
Sandhya R
is not permitted.The server must be started
under an unprivileged user ID to preventpossible system security
compromises. See the documentation for more information on how to properly
start the server.
Thank you,
Sandhya
word.
- Original Message -
From:
Mohamed
Fazil
To: sandhya
Cc: pg-admin postgre
Sent: Monday, March 13, 2006 11:39
AM
Subject: Re: [ADMIN] pls help me(How to
start Postgres)
Hi,
You made a mistake while typing syntax
E:\PostgreSql>runas
/u
g_ctl.exe start
-D"\PostgreSql\data -l \sanur:Attempting to
start "pwd" as user "SANDHYAR\Postgres\bin\pg_ctl.exe
start-D"\PostgreSql\data -l \sanur"...RUNAS
ERROR: Unable to run - pwd1326: Logon failure: unknown user name or
bad password.
Sandhya
- Origi
have to give this at command
prompt.
- Original Message -
From:
Mohamed
Fazil
To: sandhya
Sent: Thursday, March 09, 2006 2:46
PM
Subject: Re: [ADMIN] pls help me
Hi,
I am not an expert in PG, still i can help u to some extend as i have
successfully
ble system security
compromises. See the documentation formore information on how to
properly start the server.
and when i tried to start from the service..i am getting the following
message box.
Pls help me..I need it very much
Thanks&Regards,
Sandhya
Is it possible to use lo_open after creating the object while
the application is running?
Hi,
In my application i need to create a file dynamically and load it into
DB.
So.I have created one object at run time .and trying to open
it inorder to write the content into it.
Hi,
In my application i need to create a file dynamically and load it into
DB.
So.I have created one object at run time .and trying to open
it inorder to write the content into it.
But lo_open is returning -1(-ve
value).
where i am doing mistake pls tell me.
lobjId = lo_creat(c
Hi,
In my application i need to create a file dynamically and load it into
DB.
So.I have created one object at run time .and trying to open
it inorder to write the content into it.
But lo_open is returning -1(-ve
value).
where i am doing mistake pls tell me.
lobjId = lo_creat(conn
executing fine.
Why is this so?
Pls tell me what i need to do...In case of complex queries executing
through my application.
Help me in solving this...
Thank You
Sandhya
..In
case of complex queries executing through my application.
Help me in solving this...
Thank You
Sandhya
Thank You Fuhr.
In select lo_unlink(objid) from (select distinct objid from filetbl)AS s;
the above query what is that 'S' stands for in AS 'S'
Can u pls explain me.
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "sandhya&
hi...
Is there any possibility to delete /Unlink a group of
large objects at a time?
Please tell me .To test my application i have loaded somany
files into database.Now i want to unlink all those objects.
Please help me in doing this...
Thanks,
Sandhya
Instead of executing the command from root ...login as postgres user and try
like
su - postgres
- Original Message -
From: "Paolo De Simone" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, February 21, 2006 5:34 PM
Subject: [ADMIN] problems to install PostgreSQL
> Hello all,
>
> i'm trying to
ok...jeff thank you very much.
I checked in pg_hba.conf and reloaded again and did now working fine.
- Original Message -
From: "Jeff Frost" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>
Cc: "Postgres"
Sent: Thursday, January 19, 2006
I am trying on windows..I am getting the following error message.
ERROR: could not open server file
- Original Message -
From: "Jeff Frost" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>
Cc: "Postgres"
Sent: Thursday, January 19, 2006
I am trying on windows
It is not coming.Version is 8.0
- Original Message -
From: "Jeff Frost" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>
Cc: "Postgres"
Sent: Thursday, January 19, 2006 1:00 PM
Subject: Re: [ADMIN] Fw: lo
When i am using lo_import to load files into the database i am
getting the following error.
Please help me what i need to do
Insert into sampletbl
values(lo_import('c:\\sample.txt'),'sample.txt');
ERROR: function lo_import ("unknown") does not
existHINT: No function matches the g
ok.. I will try.
Thank you
- Original Message -
From: "Jeff Frost" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, January 19, 2006 12:30 PM
Subject: Re: [ADMIN] reg:pg_ctl
> Please do not resend questions to me directly that
When i am using lo_import to load files into the database i am
getting the following error.
Please help me what i need to do
ERROR: function lo_import ("unknown") does not
existHINT: No function matches the given name and argument types. You
may need to add explicit type casts.
resolving this
Thank you,
Sandhya
in me what i need to do...
-Sandhya
- Original Message -
From: sandhya
To: postgre
Sent: Monday, January 16, 2006 10:19 AM
Subject: [ADMIN] reg lo_import on windows
- Original Message -
From: sandhya
To: postgre
Cc: sandhya
Sent: Thursday, January 12, 2006 3:00 PM
Subject: [ADMIN] reg lo_import on
- Original Message -
From: sandhya
To: postgre
Cc: sandhya
Sent: Thursday, January 12, 2006 3:00 PM
Subject: [ADMIN] reg lo_import on windows
Hi,
I am using 'lo_import' in windows
applocation and trying to import the files to the database.
If the path i am givi
"
If i give :
C:\\sample.htm
It is importing properly and storing
it in the specified table also.
Why it is not doing in the previous
case.
But the same i did throug command
line and worked file.Through application it is not doing.
Please help me.I need it very
urgently.
Thank you,
Sandhya
hi...
Follow the following website where u can find
installation steps...
http://pginstaller.projects.postgresql.org/
-Sandhya
- Original Message -
From:
aWiryawan
To: pgsql-admin@postgresql.org
Sent: Friday, January 06, 2006 8:09
PM
Subject: [ADMIN
se tell me.
-Sandhya
- Original Message -
From:
Patrick Meylemans
To: sandhya
Sent: Friday, January 06, 2006 12:33
AM
Subject: Re: [ADMIN] reg db access from
windows
Hi,Best is to log in as te user who owns the database
(standard this should be postgres I assume
o database
failedFATAL: no pg_hba.conf entry for host "10.0.0.205",
user "postgres", database "pilot", SSL offPress any key to
continue
Please tell me why is it so?
-Sandhya
- Original Message -
From:
sandhya
To: postgre
Cc: sandhya
x and working
fine.This is first time i am working in windows.
Please suggest me how to proceed.
Thank you...
-Sandhya
, len - nread);
>
> buf[nbytes] = ' ';
>
> nread += nbytes;
>
> }
>
> MessageBox(0,"Inside get","test",MB_OK);
>
> free(buf);
>
> lo_close(conn, lobj_fd);
>
> }
>
>
>
> Thank you.
> Sandhya
>
> > -
);
nread = 0;
while (len - nread > 0)
{
nbytes = lo_read(conn, lobj_fd, buf, len - nread);
buf[nbytes] = ' ';
nread += nbytes;
}
MessageBox(0,"Inside get","test",MB_OK);
free(buf);
lo_close(conn, lobj_fd);
}
Thank you.
Sandhya
&g
OK);
free(buf);
lo_close(conn, lobj_fd);
}
Thank you.
Sandhya
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>
Cc: "postgre"
Sent: Monday, December 26, 2005 9:08 PM
Subject: Re: [ADMIN] reg:lseek&r
Explain clearly the problem facing by
you...
- Original Message -
From:
Alain Rodriguez
Arias
To: sandhya
Cc: postgre
Sent: Saturday, December 24, 2005 12:43
AM
Subject: Re: [ADMIN] lo_ functions
I have a field in a table that I use to save data from
- Original Message -
From: sandhya
To: postgre
Cc: sandhya
Sent: Monday, December 26, 2005 2:27 PM
Subject: reg:lseek&read ..pls
hi..
I stored few files into the database and trying to
open it while accessing webserver...
In that case i need to just read the content
the whole contents of the file.
If i want to get entire file contents...How to
do?
What len i need to specify?
Is there any thing to know the size of the
object?
Please tell me..
Thank you
-Sandhya
You can very well get from the following
link.
http://www.postgresql.org/docs/8.1/interactive/largeobjects.html
- Original Message -
From:
Alain Rodriguez
Arias
To: pgsql-admin@postgresql.org
Sent: Friday, December 23, 2005 12:05
AM
Subject: [ADMIN] lo_ functions
- Original Message -
From: "sandhya" <[EMAIL PROTECTED]>
To: "Michael Fuhr" <[EMAIL PROTECTED]>
Sent: Thursday, December 22, 2005 1:15 PM
Subject: Re: [ADMIN] How to get OID return value(pls help me)
> What function is that? What does it do with t
you,
Regards,
Sandhya
.also it is not getting the
value of "lobjId".
I am new to postgres also this .net stuff.Pls help me to proceed further.
Thank you
Sandhya
- Original Message -
From: "Bruno Wolff III" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>
t?
Mail seems to be little confusing i think.But i don't know how to
explain my problem
I can't proceed further without this.
Please explain me where i am doing mistake...
And tell me what to do?Thank you very much for your help..
-Sandhya
- Original Message -
Hello,
I have install
postgresql on Redhat AS 4.Now we want to migrate data from oracle 8i to
postgresql 8.1 and want to create snapshots , materialized
view,dblink,taking online backup,logical backup and establish
replication between three production server.Plz tell me which
documents,
inux OS.
pls help me in solving out the
problem.
-Sandhya
running the application.Is it possible to do
that?
Please tell me what to do in that
case
Thank you
Sandhya
- Original Message -
From: sandhya
To: postgre
Cc: sandhya
Sent: Thursday, December 15, 2005 11:09 AM
Subject: reg:Import&Export functions
Hi all,
I have my postgres server running on Linux
OS.
I need to export the files from the Linux
OS to Windows drive.
Is there
.
Any thing wrong in this?
Just to inform the solution to your view.
Thanks,
Sandhya
- Original Message -
From: "Magnus Hagander" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>; "postgre"
Sent: Wednesday, December 14, 2005
hi Magnus.
Thank you verymuch.Problem is solved
It is because of "Debug Mulithread ed using DLL" only.
-Sandhya
- Original Message -
From: "Magnus Hagander" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>; "postgre"
Se
IB:librarywebs fatal error LNK1169: one or more multiply defined
symbols found
Please tell me how to rectifyI am
very much in need of this.
help me...
-Sandhya
of postgresql:
http://www.postgresql.org/ftp/source/
Binary version from the,
http://www.postgresql.org/ftp/binary/v8.1.0/linux/
After downloading You can follow the
Install file to know the installation procedure.
-Thanks,
Sandhya
- Original Message -
From:
Murugan G
Initially it worked fine for
tmpdirectory.
when i changed it to...
psql "dbname" -U root
from that time onwards it is not accepting even
/tmp
Where to change for these permissions.Pls explain
me what to do..I just started working on Linux
Thanks,
Sandhya
I did even i am not getting...Not only tmpin
all directories i am unable to export
- Original Message -
From:
R, Rajesh (STSD)
To: sandhya
Sent: Wednesday, December 07, 2005 3:37
PM
Subject: RE: [ADMIN] reg:file transfer
error
Try setting write
hange?
Where to modify inorder to perform
successful operation.
I am in root permission
only.Though it is not working.
Pls tell me what to do as early as possibleI need it urgently..
Thanks&Regards
Sandhya
(STSD)" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>; "Kosol Tuanveeradej"
<[EMAIL PROTECTED]>
Cc: "postgre"
Sent: Friday, December 02, 2005 2:36 PM
Subject: Re: [ADMIN] reg:BLOB
> http://www.postgresql.org/docs/8.0/static/index.htm
where can i found document for this?
- Original Message -
From: "Kosol Tuanveeradej" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>
Sent: Friday, December 02, 2005 2:30 PM
Subject: Re: [ADMIN] reg:BLOB
> Postgresql support BLOB dataty
hi
Please tell me what is BLOB and whether Postgresql
supports this blob datatype?
Where can i found the document?I need this very
urgently..pls tell me
-Sandhya
bject
Is there any other site from where i can learn more
about the above topicsPls suggest me.
Thank you,
Sandhya
g OBJID?Am i right
Pls tell me how to do this?
I need this as early as possible.Help me out in
doing this
Thank you,
Sandhya
hi
After getting OID is there any way to see the
contents of it?
Please tell me.
-Sandhya
'/tmp/ccYefhjF.o(.text+0x37f):
In function `main':: undefined reference to
`lo_import'/tmp/ccYefhjF.o(.text+0x3a9): In function `main':: undefined
reference to `lo_export'/tmp/ccYefhjF.o(.text+0x3bc): In function
`main':: undefined reference to `PQexec'
thanks,
Sandhya
ting the "char/text" type data to
> "int" still i am getting error as,
>
> like,ALTER TABLE sample ALTER COLUMN age TYPE int;
>
> ERROR: column "age" cannot be cast to type "pg_catalog.int4"
>
> Pls tell me how to do this.Am i wrong som
"int" datatype also i can able to conver to
"char"
and why not viceversaPlease tell me where the
problem is.
Suggest me what to do to convert a "char" datatype
to "int".
Thanks&Regards,
Sandhya
Hi John ,
Thank you.
I am using C.
Yes i mean to allocate memory of each tuple resulting from a query.
Is there any function which gives the size of a tuple?
If so...Please tell me/Tell me how to proceed to do that?
Thanks&Regards,
Sandhya R
- Original Message -
From: "Jo
&Regards,
Sandhya
please...tell me if there is possibility of
finding out the size of a record size in the specified table.
I need this Inorder to allocate the memory after
retrieving the records.
Pls suggest me.
Thanks,
Sandhya
ow how to generalize the messages once i get
thisPls any one help me in this regard
Thanks,
Sandhya
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>
Cc: "postgre"
Sent: Wednesday, October 19, 200
In error handling suppose if the database already
exists..
It is returning : database "sample(say)" doesn't
exists.
If i want to return general error messages with out
specifying names how can i?
Tell me where can i get the error codes for this
instead of messages and how can i retrieve
- Original Message -
From: "bramhe manoj" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, September 28, 2005 3:54 PM
Subject: [ADMIN] database access queries
> hi ,
>
> we are working as linux administrators in enng college
> in mumbai(india).
>
> we have created databases in postgresql for a
Access permissions of
it under a database
Can any one please do helpful in the above
cases
Thank you
-Sandhya
Thank you..Hannes
- Original Message -
From: "Hannes Dorbath" <[EMAIL PROTECTED]>
To:
Sent: Thursday, September 22, 2005 3:48 PM
Subject: Re: [ADMIN] Reg: sql commands
> Start psql with -E option to see the statements used internally.
>
> On 22.09.
No...What i need is...
I want to know the equivalent sql queries for \l and \dt commands in order
to list the databases and tables.
I want to do it through programming
Thanks
Sandhya
- Original Message -
From: "Stef" <[EMAIL PROTECTED]>
To: "sandhya" <[E
1 - 100 of 125 matches
Mail list logo
