[GENERAL] DB Locks

Hello everyone, I had a concern about DB locks lately. If have a scenario where in a Cron job is running. This cron job updates a table and would take about 20 minutes to complete. In the meantime, if I query the same table using an application, will my application have to wait as the cron job has

Re: [GENERAL] SPI_execute (result of a select statement)

, 2006 at 02:24:32AM -0400, Jasbinder Bali wrote: > Hi,>> While using SPI_execute for a select statement, how do we store the result> returned by select statement (say a C variable)?> SPI_execute returns different values for success or failure only as per the > postgres manual.Did

[GENERAL] SPI_execute (result of a select statement)

Hi,While using SPI_execute for a select statement, how do we store the result returned by select statement (say a C variable)?SPI_execute returns different values for success or failure only as per the postgres manual. Thanks,Jas

Re: [GENERAL] Version 1 Calling convention

Does that mean if I am passing a char value to the version 1 function from a function in the database then in the version 1 function it needs to be treated as text*??On 8/30/06, Martijn van Oosterhout <kleptog@svana.org> wrote: On Wed, Aug 30, 2006 at 05:38:34AM -0400, Jasbinder Bali

Re: [GENERAL] Version 1 Calling convention

from text* to char* and it gives me a warning like: "initialization makes pointer from integer without a cast" at line 6 as commented above.Can any1 point why?~JasCompiling this code gives me the follwoing error:Compiling this code throws the follwoing error On 8/30/06, Jasbinder Ba

Re: [GENERAL] Version 1 Calling convention

How does the SPI manager know which database to connect using SPI_CONNECT()As there can be more than one datbase in the postgres server, how does it make out which database to connect as we don't specify the datbase name we intend to connect. ~JasOn 8/30/06, Jasbinder Bali <[EMAIL P

Re: [GENERAL] Version 1 Calling convention

OK..i got it..spi.h was in /usr/include/pgsql/server/executorJasOn 8/30/06, Jasbinder Bali <[EMAIL PROTECTED] > wrote:Isn't there any rpm to download the SPI ?? On 8/30/06, Martijn van Oosterhout < kleptog@svana.org> wrote: On Wed, Aug 30, 2006 at 01:01:32AM -0400, Jasbinder B

Re: [GENERAL] Version 1 Calling convention

Isn't there any rpm to download the SPI ??On 8/30/06, Martijn van Oosterhout <kleptog@svana.org> wrote: On Wed, Aug 30, 2006 at 01:01:32AM -0400, Jasbinder Bali wrote:> Do i need to download spi.h from somewhere or what? I can't see it anywhereYou need the backend header files

Re: [GENERAL] Version 1 Calling convention

Do i need to download spi.h from somewhere or what? I can't see it anywhereOn 8/30/06, Jasbinder Bali <[EMAIL PROTECTED] > wrote:OK. I've removed the ECPG code and error has gone away.Thanks jasOn 8/30/06, Alvaro Herrera < [EMAIL PROTECTED] > wrote:Jasbinder Bali wrote: >

Re: [GENERAL] Version 1 Calling convention

OK. I've removed the ECPG code and error has gone away.ThanksjasOn 8/30/06, Alvaro Herrera <[EMAIL PROTECTED] > wrote:Jasbinder Bali wrote:> I have a .pgc file and i have the following code snippet in it: >> PG_FUNCTION_INFO_V1 (test);>> Datum> test (PG_FUNCTION_ARGS)> {>  EXEC SQL BEGIN DECLARE SE

Re: [GENERAL] Version 1 Calling convention

Herrera <[EMAIL PROTECTED]> wrote: Jasbinder Bali wrote:> I have a .pgc file and i have the following code snippet in it:>> PG_FUNCTION_INFO_V1 (test);>> Datum> test (PG_FUNCTION_ARGS)> {>  EXEC SQL BEGIN DECLARE SECTION; You can't use ecpg in server-side functions. 

[GENERAL] Version 1 Calling convention

I have a .pgc file and i have the following code snippet in it:PG_FUNCTION_INFO_V1 (test);Datumtest (PG_FUNCTION_ARGS){  EXEC SQL BEGIN DECLARE SECTION;   int id = PG_GETARG_INT(0);    char *raw_rawemail1 = PG_GETARG_CHAR_P(1);   char *rawemail1 = (char *)  palloc (VARSIZE(r

Re: [GENERAL] Shared Objects (Dynamic loading)

fixing that]On 8/28/06, Gerald Timothy G Quimpo... wrote: > Any reason why you don't do your functions and triggers in> pl/pgsql instead?  It's simpler to setup and learn> than pl/perl, IMO.On Mon, 2006-08-28 at 03:27 -0400, Jasbinder Bali wrote: > I

Re: [GENERAL] Shared Objects (Dynamic loading)

-0400, Jasbinder Bali wrote:> Also, the triggers that i wrote in C are not all that elaborative.> They are pretty basic triggers. Also, I'm a rookie in perl but don't> need to do something hifi with it. Any reason why you don't do your functions and triggers inpl/pgsql inste

Re: [GENERAL] Shared Objects (Dynamic loading)

Thanks for that reply Martijn,Just wondering what is this SPI all about and where can i read up on that. Any quick pointers please?Thanks ~JasOn 8/28/06, Martijn van Oosterhout <kleptog@svana.org> wrote: On Mon, Aug 28, 2006 at 01:29:11AM -0400, Jasbinder Bali wrote:> Just wondering wh

Re: [GENERAL] Shared Objects (Dynamic loading)

on't need to do something hifi with it. Thanks,~JasOn 8/28/06, Michael Fuhr <[EMAIL PROTECTED]> wrote: On Sun, Aug 27, 2006 at 09:41:39PM -0400, Jasbinder Bali wrote:> The actual scenario is like my perl code is on one computer and database> server is on the other computer. The pe

Re: [GENERAL] Shared Objects (Dynamic loading)

if i have to migrate my triggers and functions written for C to Perl   Thanks, Jas  On 8/27/06, Michael Fuhr <[EMAIL PROTECTED]> wrote: On Sun, Aug 27, 2006 at 05:13:25PM -0400, Jasbinder Bali wrote:> Can you please give me pointers to how to establish clinet server model > using PL/P

Re: [GENERAL] Shared Objects (Dynamic loading)

-0400, Jasbinder Bali wrote:> Do we have any concept of shared objects in perl.> Just wondering, how do we dynamically load something written in perl in> postgresql. A PL/Perl function can load external code with "use", "require",or "do".  Since those are p

Re: [GENERAL] Shared Objects (Dynamic loading)

Hi, Do we have any concept of shared objects in perl. Just wondering, how do we dynamically load something written in perl in postgresql.   Thanks, Jas  On 8/24/06, Michael Fuhr <[EMAIL PROTECTED]> wrote: On Thu, Aug 24, 2006 at 03:46:00PM -0400, Jasbinder Bali wrote:> The way we use ECP

Re: [GENERAL] Shared Objects (Dynamic loading)

what would be the best method to deal with database (postgresql) calls from the perl code.Thanks and regards,Jas On 8/24/06, Michael Fuhr <[EMAIL PROTECTED]> wrote: On Thu, Aug 24, 2006 at 01:03:43AM -0400, Jasbinder Bali wrote:> CREATE OR REPLACE FUNCTION sp_trigger_raw_email(int4, text)&

[GENERAL] Dynamic loading (datatype mismatch)

Hi, I am dynamically loading a shared object in a function.CREATE OR REPLACE FUNCTION sp_trigger_raw_email(int4, char)  RETURNS bool AS'/usr/local/pgsql/jsbali/parser', 'test'  LANGUAGE 'c' VOLATILE STRICT; ALTER FUNCTION sp_trigger_raw_email(int4, text) OWNER TO postgres;    signature of test is t

[GENERAL] Shared Objects (Dynamic loading)

Hi,I have a function in which i dynamicall load my shared object and the function definition is as follows:CREATE OR REPLACE FUNCTION sp_trigger_raw_email(int4, text)   RETURNS bool AS'/usr/local/pgsql/jsbali/parser', 'parse_email'  LANGUAGE 'c' V

Re: [NOVICE] [GENERAL] DB insert Error

My program started working. Its inserting records now. I've done no significant changes in my C code. Thanks alot for your help.   Jasbinder  On 8/17/06, Michael Fuhr <[EMAIL PROTECTED]> wrote: On Thu, Aug 17, 2006 at 10:19:57AM -0400, Jasbinder Bali wrote:> but i don't see

Re: [NOVICE] [GENERAL] DB insert Error

but i don't see any record getting inserted in the table..Why is that happenening.On 8/17/06, Michael Meskes < [EMAIL PROTECTED]> wrote:On Wed, Aug 16, 2006 at 11:40:40AM -0400, Jasbinder Bali wrote: > [2998]: ECPGexecute line 97 Ok: INSERT 0 1This is a backend message saying t

Re: [NOVICE] [GENERAL] DB insert Error

On Wed, Aug 16, 2006 at 02:42:46PM -0400, Jasbinder Bali wrote:> Tried everthing but nothing seems to work. > :(Could you provide a simplified but complete example that shows whatyou're doing?  That is, all SQL statements and C code necessary tocreate a table and whatever functions you'

Re: [NOVICE] [GENERAL] DB insert Error

rs,rec,"Received: "); unlimit_fields(headers,comments,"Comments: "); unlimit_fields(headers,keywords,"Keywords: ");   unlimit_fields(headers,return_path,"Return-Path: "); unlimit_fields(headers,resent_date,"Resent-Date: "); unlimit_fields(headers,resent_from,"Resent-F

Re: [NOVICE] [GENERAL] DB insert Error

Tried everthing but nothing seems to work.:(On 8/16/06, Jasbinder Bali <[EMAIL PROTECTED]> wrote: Also, i tried to mannualy run the insert query in the query tool insert into raw_email ( id  , raw_email  ) values ( 1 ,  'F

Re: [NOVICE] [GENERAL] DB insert Error

6:30AM -0400, Jasbinder Bali wrote:> I changed the datatype from varchar[] to varchar> ECPGdebug(1,stderr) says> [2998]: ECPGexecute line 97 Ok: INSERT 0 1>> Its not inserting any record even though sqlcode is 0. Are you committing the transaction?  See the bottom of thefollowing page:http

Re: [NOVICE] [GENERAL] DB insert Error

t;[EMAIL PROTECTED]>To: testBcc: [EMAIL PROTECTED] Subject: fooMime-Version: 1.0Content-Type: image/gifContent-Dispo (..)"---Also, as i've already told, even after i commit my transaction, it doesn't insert the record. Thanks,~JasOn 8/16/06, J

Re: [GENERAL] DB insert Error

Also, My insert statement is   EXEC SQL INSERT INTO raw_email (id,raw_email) VALUES (1,:ch);    On 8/16/06, Michael Fuhr <[EMAIL PROTECTED]> wrote: On Wed, Aug 16, 2006 at 01:20:08AM -0400, Jasbinder Bali wrote:> This is how the array is formed in

Re: [GENERAL] DB insert Error

I changed the datatype from varchar[] to varchar ECPGdebug(1,stderr) says [2998]: ECPGexecute line 97 Ok: INSERT 0 1  Its not inserting any record even though sqlcode is 0.   ~Jas  On 8/16/06, Michael Fuhr <[EMAIL PROTECTED]> wrote: On Wed, Aug 16, 2006 at 01:20:08AM -0400, Jasbinder Bali

Re: [GENERAL] DB insert Error

rote: On Wed, Aug 16, 2006 at 12:38:42AM -0400, Jasbinder Bali wrote:> table definition of raw_email table is as follows >> CREATE TABLE raw_email (> idint4 NOT NULL,> raw_email  varchar[],> parsed_flag bool NOT NULL DEFAULT false,> CONSTRAINT  pk_rawem

Re: [GENERAL] DB insert Error

not char   ~Jas  On 8/16/06, Michael Fuhr <[EMAIL PROTECTED]> wrote: On Tue, Aug 15, 2006 at 11:55:58PM -0400, Jasbinder Bali wrote:> I'm using ECPG and trying to do follwoing insert in one of the talbes. >> insert into raw_email ( id  , raw_email  ) values ( 1 , :ch);>>

[GENERAL] DB insert Error

Hi, I'm using ECPG and trying to do follwoing insert in one of the talbes.    insert into raw_email ( id  , raw_email  ) values ( 1 , :ch);   ch is an array and defined as follows:    EXEC SQL BEGIN DECLARE SECTION;    char ch[MSG_LEN];EXEC SQL END DECLARE SECTION;  contents of array ch is actually

Re: [GENERAL] [NOVICE] Unable to connect to PostgreSQL 8 from PGAdmin III

Hi Jas,   What is ECPG? Which connection string?   Regards, Walid From: Jasbinder Bali [mailto:[EMAIL PROTECTED]] Sent: quinta-feira, 10 de Agosto de 2006 22:28 To: Walid HaiderCc: [EMAIL PROTECTED] Subject: Re: [NOVICE] Unable to connect to PostgreSQL 8 from PGAdmin III   Walid, Are you usin

Re: [GENERAL] DB connectivity from a client machine

;t have any postgres there. Do you mean to say that I need to install the client version of postgres in the m/c hosting the middle tier component and trying to connect to the postgres server?~JasOn 8/8/06, Scott Marlowe <[EMAIL PROTECTED]> wrote: On Tue, 2006-08-08 at 16:25, Jasbinder Bali wr

[GENERAL] DB connectivity from a client machine

Hi, I have a middle tier application in C on one machine which doesn't have postgres installed.I have a machine that hosts my postgres database.My middle tier application wants to connect to the Db server. Is it mandatory for the m/c that hosts the middle tier application to have postgres installe

Re: [GENERAL] Triggers in Postgres

http://www.postgresql.org/docs/8.1/interactive/triggers.html   it says something like this:   " It is not currently possible to write a trigger function in the plain SQL function language. "   though lately I saw triggers written in pure sql in postgres   ~jas  On 8/1/06, Roman Neuhauser <[EMAIL PR

Re: [GENERAL] Triggers in Postgres

Actually Postgres manual of triggers says that in postgres, you can't write a trigger in conventional sql. You have to write it in a procedural language like C. So wanted some more insight on it. ~Jas  On 7/31/06, Tino Wildenhain <[EMAIL PROTECTED]> wrote: Jasbinder Bali wrote:> Hi,&

[GENERAL] Triggers in Postgres

Hi,Was wondering if one can write triggers with SQL statements as we have in other RDBMS like SQL Server and oracle. Can these be written in procedural languages only?Please put some insight on what needs to be known before working with triggers in postgres. I've already read the postgres manual in

[GENERAL] server administration problem: Database startup and permissions

Hi,I created a database cluster using the following commands as per what is given in the postgres server administration manualroot# mkdir /usr/local/pgsql/jasroot# chown jsbali /usr/local/pgsql/jasroot# su jsbali jsbali# initdb -D /usr/local/pgsql/jasAfter that i tried to start up the postmaster pr

Re: [GENERAL] Permissions to connect to postgres database

How do i turn on the connection logging and then how do you actually check it?On 7/27/06, Richard Huxton wrote:Jasbinder Bali wrote:> Hi,> I have a database in postgres and i've given trusted permissions to all > making required changes> in pg_hba.conf.>> Now, I'm trying to conn

[GENERAL] Permissions to connect to postgres database

Hi,I have a database in postgres and i've given trusted permissions to all making required changesin pg_hba.conf.Now, I'm trying to connect to the database using ECPG. Unfortunately afterEXEC SQL CONNECT dbxyz gives me error -402 that means i don't have permissions to the database.I'm running this

Re: [GENERAL] ECPG. Badly stuck

Hi ,Forget about cursors. Singleton queries are also not working.Tried writing the follwoing code but doesn't give me any result. Don't know if i have to do somethin else apart from what i've already done. include EXEC SQL INCLUDE sqlca;int main (){    EXEC SQL BEGIN DECLARE SECTION;   

[GENERAL] ECPG. Badly stuck

Hi, I had posted this question a few days back. Sending the same question again.   I have a C program and have some ECPG code in it.   How do i display the data that i retrieve from the postgres database using a simple select statment or calling a stored procedure.   Is it mandatory to use cursor

[GENERAL] ECPG (usage of simple select statement)

Hi,   I'm using ECPG in my C code and I want to display the result of a simple select statement.   If i write something like EXEC SQL select * from abc ; (which as of now is not working)   wouldn't this display the result staright away or its always mandatory to use a cursor and then do printf() f

[GENERAL] ECPG usage

Hi,I have the follwing ECPG code.-#include EXEC SQL INCLUDE sqlca;int main (){    EXEC SQL BEGIN DECLARE SECTION;     char movie_type[20];    char *movie_title=NULL;    char query_string[

[GENERAL] calling stored procedure using ECPG

Hi, Can anyone please tell me how do I call a stored procedure using ECPG??A code snippet would really be handy..Thanks,~Jas

[GENERAL] Database connectivity using ECPG

Hi,I'm using ECPG to connect to my postgres database. Doing it for the very first time in my life.The name of my database is postgres and uses a trusted connection. So, i don't think it needs any authentication parameteres like a user name and password.I have the follwoing line of code in my .pgc

[GENERAL] ECPG usage

HiCan anyone help me with the usage of ECPG??Like how to go about it, what all header files to include in my C file and other things that i need to give due considerations before using ECPG~Jas

Re: [GENERAL] Database connectivity using a unix shell

Hi,Before using ECPG, i had a few questions.Lets say i have a C code and want to do something with my postgres database. What all header files do i need for ECPG.Also how and where exactly am i going to write these EXEC SQL statements for ECPG. Can I be briefed about the steps to do this.Regards,~J

Re: [GENERAL] Database connectivity using a unix shell

ote: On Thu, 2006-06-29 at 13:29, Jasbinder Bali wrote:> this is what i've included in my shell script>> query="select * from films";> a=`echo $query|psql -tq postgres`;>> > it gives an error:> role root doesn't exist.>> where do i have to specify th

Re: [GENERAL] Database connectivity using a unix shell

isn't my normal bash script different from psql. In a bash script how wud u specify the db parameters  On 6/29/06, Scott Marlowe <[EMAIL PROTECTED]> wrote: On Thu, 2006-06-29 at 11:08, Jasbinder Bali wrote:>> On 6/29/06, Scott Marlowe < [EMAIL PROTECTED]> wrote:>   

Re: [GENERAL] Database connectivity using a unix shell

in my bash script where and how do i specify the database connection parameters ~Jas  On 6/29/06, Scott Marlowe <[EMAIL PROTECTED]> wrote: On Thu, 2006-06-29 at 10:24, Jasbinder Bali wrote:> Hi> I need to connect to the postgres database using my unix shell. > How should i go abou

[GENERAL] Database connectivity using a unix shell

Hi I need to connect to the postgres database using my unix shell. How should i go about it? Is libpq going to be helpful here?   Thanks and regards, ~Jas

Re: [GENERAL] Dynamic loading of C functions: Badly stuck

I've disabled my SELinux and now postgres is being able to access the shared library i.e test.so file.Don't know if thats the right way to do it or not.PS: I'm using Fedora core 2 OSThanks,~Jas On 6/21/06, Joe Conway <[EMAIL PROTECTED]> wrote: Jasbinder Bali wrote:> Now th

Re: [GENERAL] Dynamic loading of C functions: Badly stuck

erver/test.so This means that the owner of this .so file is root and group is root. Thanks ~JasOn 6/21/06, Joe Conway <[EMAIL PROTECTED]> wrote: Jasbinder Bali wrote:> Now the error is different. It cries something on the permissions.>> ERROR:  could not load library "

Re: [GENERAL] Dynamic loading of C functions: Badly stuck

d Can you comment on this?Thanks,~JasOn 6/21/06, Joe Conway <[EMAIL PROTECTED]> wrote: Jasbinder Bali wrote:> CREATE FUNCTION command(integer) RETURNS integer >  AS 'usr/include/pgsql/server/test_func', 'command'>  LANGUAGE C STRICT;>> when i

[GENERAL] Dynamic loading of C functions: Badly stuck

Hi,I raised this problem yesterday aswell. I'm badly stuck at this point.The problem is as follows:I have a C function that i want to use in my postgres function.I adopt the following steps to do that. --- compile the C file as follows gcc -shared -o test_func.so test_func.c test_func.c is

Re: [GENERAL] Dynamic loading of C functions

I've tried everything so that my .so file is recognized but in vein.Don't know whats going wrong.~JasOn 6/20/06, Tom Lane < [EMAIL PROTECTED]> wrote:Bill Moran < [EMAIL PROTECTED]> writes:> In response to "Jasbinder Bali" <[EMAIL PROTECTED]>:>> I ge

Re: [GENERAL] Dynamic loading of C functions

yes, i've named it as .so file. On 6/20/06, Tom Lane <[EMAIL PROTECTED]> wrote: "Jasbinder Bali" <[EMAIL PROTECTED]> writes:>>> /usr/include/pgsql/server/ is exactly the path where test_func object >>> file resides.Hmmm when you say "object fi

Re: [GENERAL] Dynamic loading of C functions

chmod 666 filename is something i've done to give permissions to all.. still doesn't work.  On 6/20/06, Bill Moran <[EMAIL PROTECTED]> wrote: In response to "Jasbinder Bali" <[EMAIL PROTECTED]>: > I've written a function in C, compiled it and trying to use

[GENERAL] Dynamic loading of C functions

I've written a function in C, compiled it and trying to use the same function in one of my postgres functions like this:CREATE FUNCTION add_one(integer) RETURNS integer AS '/usr/include/pgsql/server/test_func, 'add_one' LANGUAGE C STRICTtest_func is the name of my object file and add_one i

Re: [GENERAL] Help requd in writing functions in C and using in Postgres

n and learn from the discussion.] On Tue, Jun 20, 2006 at 11:39:03AM -0400, Jasbinder Bali wrote:> Well, as in normal Sql server or oracle Stored procedures, you write a> procedure in the database server and some middle tier would invoke it. > Now here what is the concept of server side o

[GENERAL] Help requd in writing functions in C and using in Postgres

Hi, Can you help me in writing functions in C and the using in Postgres. would like to know some pointers and what all needs to be taken into considerations. I'm kind of confused how to do it ~Jas

[GENERAL] pgadmin window closes abnormally

Hi, I'm using pgadmin 3 in fedora core 4. Whenever i try to open postgres help, pgadmin shuts down abnormally. The same thing happens when i try to view postgresql.conf or pg_hba.conf files. Don't know whats going wrong.   Thanks, ~Jas  

[GENERAL] postgres password

Hello,> I'm trying to connect to the local postgres database using pgadmin. It> asks for a password that i never set and hence i'm not able to connect> to my local postgres database. > Also, when i click postgresql help option in the Help tab of pgadmin,> the pgadmin screen would close down. Don't

[GENERAL] new user (need help: fedora core 4)

Hi,I'm a new user of Postgresql and using it on Fedora core 4. After following all the installation steps and completing them successfully, I'm in a confusion. How do i actually work on the database after starting the postgres service at the command line. I can sense that i have to use something ca