Dear Friends,
I am here for a problem regarding MS Access and PostgreSQL connection
through ODBC. I have liked my PostgreSQL database tables to MS Access.
When I am going for inserting/updating any data is just displays
#deleted. I also use MySQL (client's choice). Same problem occurs for
MySQL als
Thanks you. I found it very useful and solved my problem.
Thanks.
CPK
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Hi All,
I am testing the postgresql as a back-end for a project having ms access as
a front-end. I have linked postgresql tables and started using. It works
well for all data except the binary data. When used to insert/retrieve data
from such fields, ms access gives error that it can't recognize th
CODE one. I don't know why, but ISTM that MSAccess
> perform a better type mapping with the ANSI driver...at least, TEXT ->
> Memo, so I probably linked bytea -> OLE using the ANSI driver when I
> tried ?
>
> - --
> Guillaume (ioguix) de Rorthais
>
> C K a écri
Dear Members,
I am switching our ERP and other under development applications from MySQL
to PostgreSQL. While working on this, I got some problems while creating
store procedures. As PG does not support procedures, rather it uses
Functions. While creating a function from MySQL as
CREATE [EMAIL PRO
Dear Friends,
I have written a function as follows. Here I need to get the sum of balance
before the user provided date. The below function works well, but returns
records as a set of values, rather I need individual columns. What to do?
CREATE OR REPLACE FUNCTION aa(date)
RETURNS SETOF record AS
Dear Friends,
I have written a function as follows. Here I need to get the sum of balance
before the user provided date. The below function works well, but returns
records as a set of values, rather I need individual columns. What to do?
CREATE OR REPLACE FUNCTION aa(date)
RETURNS SETOF record AS
Dear Friends,
I want to know if I open a table to view the data a new connection is
opened. If I open another table/execute a query does a another new
connection is opened? As per manual, I know that for a database cluster and
the same port a postgresql instance runs. But if we run multiple SQL
sta
y one instance,
but when another application with same username even from same machine is
started, another PG instance is started. Now we are testing for other
applications and impact on memory.
Regards,
CPK
On Thu, Aug 7, 2008 at 3:09 PM, H. Hall <[EMAIL PROTECTED]> wrote:
> C K wrote:
>
Dear Friends,
I have tried to set datestyle to 'DMY'. As per manual and many other posts
related to this point, I have set datestyle to 'DMY' at database. but still
it is needed to execute each time *set datestyle to 'DMY' *before starting
any new connection. Once this is set, there is no problem f
Dear Friends,
I have tried to set datestyle to 'DMY'. As per manual and many other posts
related to this point, I have set datestyle to 'DMY' at database. but still
it is needed to execute each time *set datestyle to 'DMY' *before starting
any new connection. Once this is set, there is no problem f
I got following error while testing some newly created functions.
ERROR: cache lookup failed for function 111462
CONTEXT: PL/pgSQL function "uf_postdoc" line 25 at FOR over SELECT rows
** Error **
ERROR: cache lookup failed for function 111462
SQL state: XX000
Context: PL/pgSQ
Hello,
I have a question regarding query performance from two pgsql applications.
PGadmin III 1.8 and Navicat for postgresql 8. Both connected to same server
on local machine 8.3 and runs a same query for appox. 1,60,000 rows with one
min, one max and addition of the min and max values on two table
Hello all,
As we are migrating our ERP application from MySQL to PostgreSQL we have
some difficulties. One of them is use of Like and Similar to operators. We
often use LIKE to search a string from front-end without case sensetivity.
As postgreSQL's LIKE is case sensitive, we tried ILIKE and SIMILA
Thanks to all,
I will try to use tsearch2 with some other index and then reply.
Regards,
CPK
On Fri, Aug 22, 2008 at 5:01 PM, Tino Wildenhain <[EMAIL PROTECTED]> wrote:
> Hi,
>
> c k wrote:
>
>> Hello all,
>> As we are migrating our ERP application from MySQL
Hello all,
As I know and have seen that innodb engine of MySQL does an auto-recovery
when MySQL server is crashed or due to power failure. What is with
postgreSQL? Does it makes an auto-recovery? and how?
Thanks
CPK
>
> *From:* [EMAIL PROTECTED] [mailto:
> [EMAIL PROTECTED] *On Behalf Of *c k
> *Sent:* Friday, August 22, 2008 11:02 AM
> *To:* [EMAIL PROTECTED]; pgsql-admin@postgresql.org
> *Subject:* [ADMIN] Auto recovery feature
>
>
>
> Hello all,
> As I know and have seen that i
Hello all,
As I am testing our old mysql based erp app., on postgresql with most of
things are as they are in MySQL db with PG 8.3, Unicode ODBC driver and
Access 2003, I got this error:
ODBC -call failed. Operator does not exist: date < numeric;error while
executing the query. This error does not
Hello,
I have a question regarding secure connections between pg clients and pg
server. As per manual for 8.3 we can use openssl for this purpose. does odbc
driver supports it and how? Is there any other method for this?
Thanks
CPK
Dear PG members,I want to know that does begin and end in plpgsql are
related to begin transactions and commit? if yes/no how? If I start to
execute a function of multiple statements does PG commits each transaction
within a function, or whole function as a transaction.
Also if first statement make
On Mon, Sep 15, 2008 at 11:22 PM, c k <[EMAIL PROTECTED]> wrote:
> If I have a function having:begin
> insert into something ...
> select max(primary key) from something..
> end;
>
> does the second statement within a function can view the results after
> execution of
Hello PG Community,
Does PG uses multiple processors/cores if available by default on various
OSes? What are the limitations on using multiple processors/cores and main
memory?
Thanks
CPK
Is it possible to log all sql statements submitted to database server in a
table in that database it self? This will be different from database logs
which are written by db server.
Regards,
CPK
Hi all,I have a table accgroups and many others. I have written a test
function as follows.
CREATE OR REPLACE FUNCTION uf_testfunction()
RETURNS SETOF associates AS
$BODY$
begin
return query select * from associates;
return;
end;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
This works fine for above tab
I am getting correct results with following query i.e. binary objects as
they are inserted.
select docimages.* from docimages where docimages.accobjecttype=9 ORDER BY
docimages.docimagename;
but when I created a function as follows, binary objects are not shown,
rather a number represting the lar
17, 2009 at 6:13 PM, Tom Lane wrote:
> c k writes:
> > I am getting correct results with following query i.e. binary objects as
> > they are inserted.
>
> > select docimages.* from docimages where docimages.accobjecttype=9 ORDER
> BY
> > docimages.docimagename;
&g
Hello,
how to access large objects from the database when using PGAdmin like client
applications? When a normal select is executed on lo type columns it gives
only the number which refers to large objects stored in 'pg_largeobjects'
table. When records from pg_largeobjects are fetched using select
Hi all,
As I am using MS Access for a long time, many tools like ms access provides
a way to get the list of columns from a query. (using filed list in combo
boxes in ms access). But is it possible to get such list of columns from a
query where it is not known to the user, that which columns are de
better if postgres has support
for this.
Thanks and regards to all,
CPK
On Mon, Aug 23, 2010 at 4:56 AM, Pavel Stehule wrote:
> Hello
>
> 2010/8/22 c k :
> > Hi all,
> > As I am using MS Access for a long time, many tools like ms access
> provides
> > a way to get th
Hello,
Does calling a pl/python function from each database connection load the
python interpreter each time? what are the effects of using pl/python
function in a environment where no. of concurrent connections are more and
each user calls a pl/python function?
Please give the details about how p
Hello,
Does calling a pl/python function from each database connection load the
python interpreter each time? what are the effects of using pl/python
function in a environment where no. of concurrent connections are more and
each user calls a pl/python function?
Please give the details about how p
10 at 11:56:16AM +0530, c k wrote:
> > Hello,
> > Does calling a pl/python function from each database connection load the
> > python interpreter each time? what are the effects of using pl/python
> > function in a environment where no. of concurrent connections are more
>
Hello,
I would like to know how can we execute the queries asynchronously?
If we use and execute plpgsql functions they just completes the execution or
throws an error on error. In between next sql statement waits for the
previous one to complete the execution. But in few situations it is required
Hello,
I have installed postgresql 9 on fedora 14 having python 2.7. Now
created plpythonu language in my database and created a simple
function to calculate sum of two variables.
while importing math libbrary and executing the function i got the error
PL/Python: ImportError: No module named cmath
Dear All,
I updated my development machine with Fedora 15 and as there is python 2.7.
I have also migrated my few postgresql databases. While creating plpython in
one database, I got the following error undefined symbol
PyUnicodeUCS4_AsEncodedString.
Then I recompiled source code and got a plpython
ng on fedora 14 . It seems that I have to recompile
and install python 2.7 at another location and use it for postgresql make
process. But not sure that it will solve error.
Thanks and regards,
C P Kulkarni
On Wed, Jul 6, 2011 at 12:24 AM, Tom Lane wrote:
> c k writes:
> > I updated
yes, shipped with fedora 15 and binary installers are from EnterpriseDB -
all in one.
CPK
On Wed, Jul 6, 2011 at 8:36 AM, John R Pierce wrote:
> On 07/05/11 7:34 PM, c k wrote:
>
>> I have default python 2.7.1 installed along with fedora15. Then installed
>> postgresql from
.
Regards,
C P Kulkarni
On Wed, Jul 6, 2011 at 9:25 AM, John R Pierce wrote:
> On 07/05/11 8:33 PM, c k wrote:
>
>> yes, shipped with fedora 15 and binary installers are from EnterpriseDB -
>> all in one.
>>
>>
> any reason you didn't use the Fedora 15 native v
Dear Friends,
For client requirements, I am testing postgresql 9.0.4 on windows 7 with
plpython. First I installed python 2.7 and then added python installation
path to windows PATH variable. Then installed postgresql from one-click
installer. Server started and every thing was ok. Then I go to cre
without any
error.
Chaitanya Kulkarni
On Wed, Aug 10, 2011 at 12:57 AM, Adrian Klaver wrote:
>
>
> On Tue, Aug 9, 2011 at 7:54 AM, c k wrote:
>
>> Dear Friends,
>> For client requirements, I am testing postgresql 9.0.4 on windows 7 with
>> plpython. First I installed py
ly, there is nothing about the problem.
Chaitanya Kulkarni
On Wed, Aug 10, 2011 at 12:07 PM, Craig Ringer wrote:
> On 9/08/2011 10:54 PM, c k wrote:
>
> Normal python functions returning text etc. are working but when
>> conatining
>>
>> import sys
>> from uuid i
Dear Postgres users,
from last few months I am reading and searching for can postgresql used as
application server? As postgresql supports many languages like pl/perl,
pl/python etc, supports dblink like functions to connect to other postgresql
servers and now features are in development to use ext
, concurrency etc are not the issues at this time. We have to adopt
govt. rules and change the business logic accordingly and it must be fast
enough to save penalties.
Regards,
Chaitanya Kulkarni
On Sat, Aug 13, 2011 at 10:54 PM, s...@bestmx.ru wrote:
> c k wrote:
>
> from last few mo
can u please give me it's link.
I found ngx_postgres module.
Chaitanya Kulkarni
On Sun, Aug 14, 2011 at 12:14 AM, s...@bestmx.ru wrote:
> c k wrote:
>
>> Yes, I know that I can not create a simple web application using only
>> postgresql because we need a web server to
Thanks for everyone.
I will give reply after some experiments.
Regards,
Chaitanya Kulkarni
On Sun, Aug 14, 2011 at 6:04 PM, wrote:
> On Aug 14 2011, Uwe Schroeder wrote:
>
>
>>
>> > can u please give me it's link.
>>> > I found ngx_postgres module.
>>> > >> there is nginx_htttp_postgresql_
I want to use the postgresql for exactly the same use. I want to keep my
database separate and use another postgresql machine just as application
server. Even for load balancing and scaling we can use many techniques mixed
to get the work done.
Chaitanya Kulkarni
On Tue, Aug 16, 2011 at 11:55 PM,
Hello,
I got a error yesterday while I have updated my development database to 9.1
from 9.0.4. I backed up my database from 9.0 and restored in 9.1. It well
successfully. When running a query which calls a function, having date value
as IN parameter, it gives me the error as date/time value out of
ype
may be changed in 9.1.
C P Kulkarni
On Wed, Sep 21, 2011 at 7:05 PM, Adrian Klaver wrote:
> On Wednesday, September 21, 2011 3:08:11 am c k wrote:
> > Hello,
> >
> > I got a error yesterday while I have updated my development database to
> 9.1
> > from 9.0.4. I bac
rom package I have installed postgres 9.1 using EnterpriseDB one click
installer.
ODBC driver has version 9.0.3.10
Should I file a bug for this?
Regards,
C P Kulkarni
On Thu, Sep 22, 2011 at 7:42 PM, Adrian Klaver wrote:
> On Thursday, September 22, 2011 2:25:40 am c k wrote:
> > It shows er
On Fri, Sep 23, 2011 at 3:43 PM, c k wrote:
> As I have connected to postgres from MS Access, it thrown the error.
> Now I have updated ODBC driver, still same problems comes for 9.1 and not
> for 9.0. There should be some thing that has changed in 9.1 release which
> prevents from a
Hello friends,
I am checking some logic which includes two functions. One is plsql
function which returns text. Second function is plpythonu and contains one
statement which outputs notice
e.g.
results = plpy.execute("select * from software.func1();")
plpy.notice("%s" % col for col in results[0])
python will only return the object
> reference.
>
> Lou Picciano
>
> ------
> *From: *"c k"
> *To: *"pgsql-admin" ,
> pgsql-gene...@postgresql.org
> *Sent: *Saturday, December 3, 2011 12:50:16 PM
> *Subject: *[ADMIN] return
when I modified the notice statement as
plpy.notice('%s' %results[0])
it prints notice as
NOTICE: {'func1': 'function return text'}
I didn't understand why it is showing 'func1' in the results[0] ?
C P Kulkarni
On Sat, Dec 3, 2011 at 11:31
value2: ",value2)
>
>
> can you please give me the example
> I am not a python programmer.
>
> Nor am I!
> Looks like your example, btw, is attempting string operations on something
> not yet quite a string!
>
> Pythons are dangerous. Be careful!
>
>
>
Hi friends,
I am working with some xml exporting functionality of our application. I am
testing query_to_xml function supported in PostgreSQL 9.1. XML output
should be
1
COMPANY ACCOUNT
638168
1.
0.
638168
0.
1.
but the output is as follows:
a
Hi,
Can we disable the trust authentication mode?
One of our customer found that few of it's employees are trying to change
the data without having any proper rights. The simplest way is to get the
control of the server and then change the mode of the authentication to
trust and restart the server
superuser accounts.
C P Kulkarni
On Sat, Mar 10, 2012 at 8:39 PM, Jan Lentfer wrote:
> Am 10.03.2012 16:00, schrieb c k:
>
>
> Can we disable the trust authentication mode?
>>
>
> [...]
>
>
> What steps we can take to prevent such access or to dis
It we can disable the TRUST mode then every user have to login with
password and every fraud user have to know the password (at least) of the
user. It is not the case that users from other departments share their
passwords, but fraud users just bypasses the need to know the password.
C P Kulkarni
, Mar 10, 2012 at 8:58 PM, Jan Lentfer wrote:
> Am 10.03.2012 16:21, schrieb c k:
>
> It we can disable the TRUST mode then every user have to login with
>> password and every fraud user have to know the password (at least) of
>> the user. It is not the case that users from ot
59 matches
Mail list logo
