[GENERAL] PQConnectdb SSL (sslmode): Is this a bug

hi, I am not sure if this is a bug. My PG_HBA.CONF local all all trust host all all 127.0.0.1 255.255.255.255 trust host all all 192.168.0.0/16 trust hostssl dbm all 192.168.200.201 255.255.255.255 md5 CODE --- PGConn* connection=PQconnectdb("h

Re: [GENERAL] PQConnectdb SSL (sslmode): Is this a bug

sorry, but forgot to mention, when i change to sslmode=allow, it lets me connect and runs my query on 'select * from test_table' which is a dummy table ... [EMAIL PROTECTED] serv]# ./bin/test_lib ret=0 GOT CONNECTION NAME AGE me

Re: [GENERAL] PQConnectdb SSL (sslmode): Is this a bug

hi tom and michael, thanks for your response ... i guess i am not that smart with libraries ... I am not sure as to how i can find the version of libpq that i am using on my server. My test file has sslmode=prefer. This is what i did: (a) [EMAIL PROTECTED] serv]# ./bin/test_lib Connection failed:

Re: [GENERAL] PQConnectdb SSL (sslmode): Is this a bug

return a certificate On 8/26/05, Michael Fuhr < [EMAIL PROTECTED]> wrote: On Fri, Aug 26, 2005 at 01:57:36PM -0700, vishal saberwal wrote:> I am not sure as to how i can find the version of libpq that i am> using on my server. My test file has sslmode=prefer. This is what i> did

Re: [GENERAL] PQConnectdb SSL (sslmode): Is this a bug

[EMAIL PROTECTED] serv]# This is what i am curious about: (a) Where am i going wrong? (b) Why are the error messages different? (c) When LD_LIBRARY_PATH is set to /usr/local/pgsql/lib, then why does it matter if the links on /usr/lib/libpq.so are changed? thanks, vish On 8/26/05, Michael Fuhr &l

Re: [GENERAL] PQConnectdb SSL (sslmode): Is this a bug

  database system is ready LOG:  could not accept SSL connection: peer did not return a certificate LOG:  could not accept SSL connection: peer did not return a certificate [EMAIL PROTECTED] serv]# Where am i going wrong? thanks, vish On 8/29/05, Michael Fuhr <[EMAIL PROTECTED]> wrote: On Mon

Re: [GENERAL] PQConnectdb SSL (sslmode): Is this a bug

Why do i have to be the one doing such a silly mistake ... thanks for your help and yes you were right ... this fixed my problem ... thanks, vishOn 8/30/05, Michael Fuhr <[EMAIL PROTECTED]> wrote: On Tue, Aug 30, 2005 at 10:40:26AM -0700, vishal saberwal wrote:> Root user:> /root/.po

[GENERAL] Performance question (FOR loop)

hi, I have this preformance question. create view test_v as select 'text'::varchar as Field1, 'text'::varchar as Field2; create or replace function test()  returns setof test_v as $$ declare    res test_v%ROWTYPE; begin   for res in     select t1.field1, t1.field2  from table1 t1;  loop  return

Re: [GENERAL] Problem with libpq3 & postgresql8

hi, tom and many others helped me with someting similar to this. Check for the following: (a) in /usr/lib check what libpq you have installed. It should be libpq3.2 or higher. If it is not, you can copy from your compiled source and then create the symbolic links there. (b) Try using etheral and s

Re: [GENERAL] returning the primary key value

hi, If this primary key is a guid or a number that you create as unique, create it local to your function and then return the same after inserting within the function. create or replace function test_insert() returns guid as $$ DECLARE  ret guid; BEGIN    select into ret newid();    -- ret is the

Re: [GENERAL] Getting the amount of overlap when using OVERLAPS

create or replace function test1() returns text as $$  DECLARE     mm varchar;     ma bool; BEGIN     SELECT into ma (DATE '2001-02-16', DATE '2001-12-21') OVERLAPS (DATE '2001-10-30', DATE '2002-10-30');     if (ma) then         select into mm  (age(DATE '2001-02-16', DATE '2001-12-21')-age(DATE

[GENERAL] Image File System Question

s and can share with me how he/she implemented this. I did do my homework of googling for something like this but may be my search skills were not strong enough to find some substantial information/HOW TOs or examples. thanks, vish (vishal saberwal)

Re: [GENERAL] Image File System Question

go through that layer. Thanks, vishOn 11/4/05, Richard Huxton <dev@archonet.com> wrote: vishal saberwal wrote:> hi,>> My server is Postgres 8.0.1 on fedora core2.> My clients are remote and interface with my server using .NET GUI.>> We are trying to store many images/icons/

Re: [GENERAL] Image File System Question

HFS is the filesystem richard was tlking about. I am not familiar with this file system but i guessed it was HFS+ that he was talking about. yes, i understand all modern filesystems are Hirearchical file systems. thanks, vishOn 11/4/05, Douglas McNaught <[EMAIL PROTECTED]> wrote: vishal sa

Re: [GENERAL] Image File System Question

ile systems as well). What is the best way to do Steps (3) and (4) above? thanks, vish (vishal saberwal) On 11/4/05, Douglas McNaught <[EMAIL PROTECTED]> wrote: vishal saberwal <[EMAIL PROTECTED]> writes:> HFS is the filesystem richard was tlking about. I am not familiar with> th

Re: [GENERAL] BLOB and OID

yes, there is one, but i dont know how would you modify the PostgreSQL code. You can implement a GUID datatype and can use it as indexing which guarantees uniqueness and can be stored in double format. thanks, vishOn 11/4/05, Lolke B. Dijkstra <[EMAIL PROTECTED]> wrote: Hi,OID being a 4 byte int

Re: [GENERAL] Replicating databases

I thought pgreplicator did provide multi-master replication and i did test it as well. http://pgreplicator.sourceforge.net/ vishOn 11/3/05, Andrew Sullivan <[EMAIL PROTECTED]> wrote: On Wed, Nov 02, 2005 at 05:23:34PM -0600, Jim C. Nasby wrote:> > It seems kludgey this way, though.  What you real

Re: [GENERAL] Recuperate each line of a result into a variable ?

if i understand your problem right, you could use a View type as return type ... in this view you declare the fields you want to return ... thanks, vishOn 7 Nov 2005 03:15:21 -0800, ctobini <[EMAIL PROTECTED]> wrote: Hello,I would like to know how to recuperate the results of a request.I read t

Re: [GENERAL] replicator

hi, search for Slony I or pgreplicator ... you can search for it in pgfoundry or try typing the names in google, I have tested with pgreplicator and it works great for multimaster replication ... vishOn 11/10/05, Víctor Narváez <[EMAIL PROTECTED]> wrote: Hi, my name is Victor, and I´m a student

Re: [GENERAL] Choosing PostgreSQL as the database for our next project

hi johny, would pgreplicator help ... i am not sure if it would solve your purpose but may be you want to look at it ... it does offer multimaster replication ... thanks, vishOn 11/11/05, William Yu <[EMAIL PROTECTED]> wrote: Johnny Ljunggren wrote:> 1. Replication - multimaster> I'll try to exp

[GENERAL] Any good HOWTOs on LDAP with PostgreSQL 8.1?

Can anyone point me to a good HOW TO on LDAP with postgreSQL 8.0.x or 8.1? Also, while searching online, i came across dblink-ldap. Is this another ldap utility or is it something i could use to connect/link to a ldap application? thanks, vish

[GENERAL] Selecting Large Object and TOAST

hi, We are storing the Icons/IMages in the database as Large Objects using lo_import functions. (1) what would be the return type if i want to return a large object (XYZ.gif) to the remote client (GUI) using stored procedure. Can anyone give an example please? Are there any size limitations i ne

Re: [GENERAL] Selecting Large Object and TOAST

thanks for all your responses, really appreciate it, I am sorry but I am not as familiar with this as much as you are. So are you suggesting, I need to send the Large object ID to the client? Since the application is time critical, is there a way to skip one of the two steps (querying once for L

Re: [GENERAL] Selecting Large Object and TOAST

   lo_ins(bytea) returns oid >> lo_del(oid) returns void How do you suggest i create lo_get(oid) function returning bytea data.thanks, vishOn 12/5/05, vishal saberwal <[EMAIL PROTECTED] > wrote:thanks for all your responses, really appreciate it, I am sorry but I am not as famili

[GENERAL] ERROR: could not find function

hi all, I am having problems creating functions. Though i can still replace the already existing functions that i had created a while back in postgres 7.4.5 .Now I am running postgres 8.0.1. The code below compiles without errrors. gcc -Wall -I /root/postgresql-8.0.1/src/include -shared -Wl,-sona

Re: [GENERAL] ERROR: could not find function

hi all, guess i should have read the documentation more carefully. Function was created when i did add "link_symbol" to the path. If this is the real reason, then I believe this is something new as it used to work without using link_symbol before. vishOn 12/12/05, vishal saberw

[GENERAL] File access problem access(), stat()

hi all, I have read through the fmgr's readme but havent been able to solve my problem with accessing the file. I gave the permissions: [EMAIL PROTECTED] /]# chmod 777-r /ResourceFS"  and have made sure the file i am trying to access does exist. I am not sure where i am going wrong. /* gcc -Wall

Re: [GENERAL] File access problem access(), stat()

i am sorry for misleading subject line ... thanks for your tip. Perhaps fmgr has more in it that i need to understand and study so as to convert text/varchar to char* . thanks, vishOn 12/12/05, Tom Lane <[EMAIL PROTECTED]> wrote: vishal saberwal <[EMAIL PROTECTED]> writes:> xy

Re: [GENERAL] File access problem access(), stat()

hi, It was a stupid error on my part. I was declaring the function to return varchar when i was actually returning integer. Also, i looked at varchar.c which was a great help. It had a function that shows how to convert varchar to cstring. Thanks tom, vishOn 12/12/05, vishal saberwal <[EM

[GENERAL] Versioning Schema/Stored Procedures

hi all, We installed a first version (1.0.0.1) of our schema. then came a few patches we had for a few stored procedures and tables (1.0.0.2). Then even more (1.0.0.3) (1.0.0.4). Some chose to upgrade to version 1.0.0.3 and stick to it, while some others chose to upgrade to 1.0.0.4. Now when i ha

Re: [GENERAL] libpq++ installation error

I am not very good at this but you might wanna try -I (--include) compile option for the path ./postgresql-8.x.x/src/include and try if it works ...thanks,vishOn 12/19/05, salah jubeh <[EMAIL PROTECTED]> wrote: I am trying to install and compile libpq++ i get this error   configure: error:Ca

Re: [GENERAL] Versioning Schema/Stored Procedures

Dec 16, 2005 at 02:41:58PM -0800, vishal saberwal wrote: > hi all,>> We installed a first version (1.0.0.1) of our schema. then came a few> patches we had for a few stored procedures and tables (1.0.0.2 ). Then even> more (1.0.0.3) (1.0.0.4). Some chose to upgrade to version 1.0.0

Re: [GENERAL] Question on indexes

CREATE INDEX code_idx ON films(code) TABLESPACE indexspace;http://www.postgresql.org/docs/8.1/interactive/sql-createindex.html vishOn 12/19/05, Emil Rachovsky <[EMAIL PROTECTED]> wrote: Hi,Can anyone show me a simple way of creating an indexin PostGre like that:create index indName on someTable(som

[GENERAL] C Function Problem for bytea output

hi all, I am trying to read a file from the File System. The function compiles fine, the function is created fine in postgres but the output is NULL/BLANK. The file does exists and has chmod 777 permission. PG_FUNCTION_INFO_V1(file_export); Datum file_export(PG_FUNCTION_ARGS) {     char *FilePat

Re: [GENERAL] C Function Problem for bytea output

thanks tom, yes it was fopen problem ... the problem was solved when i did chown postgres ... i should have seen that ... thanks, vishOn 12/28/05, Tom Lane <[EMAIL PROTECTED]> wrote: vishal saberwal <[EMAIL PROTECTED]> writes:> I believe its something in the function but i

[GENERAL] Rollback to Previous Version

hi all,I am sure this problem has been thought of before but I haven't found any good solution to this yet. Problem: We release schema with versions 1.0.0.1, 1.0.0.2, 1.0.0.3 for example. Now client installs version 1.0.0.1 in year the 2001 and then upgrades to version 1.0.0.2 in year the 2004 an

Re: [GENERAL] Problem with Timestamp

hi, though i dont use JDBC, i was just interested and found some links (which may be helpful) ... http://archives.postgresql.org/pgsql-bugs/2004-02/msg00028.php http://72.14.203.104/search?q=cache:ptQFfXTM0pgJ:snaga.org/pgsql/cvsweb.cgi/pgsql/src/interfaces/jdbc/org/postgresql/test/jdbc2/Timesta

Re: [GENERAL] Rollback to Previous Version

?thanks,vishOn 1/18/06, vishal saberwal < [EMAIL PROTECTED]> wrote:hi all,I am sure this problem has been thought of before but I haven't found any good solution to this yet. Problem: We release schema with versions 1.0.0.1, 1.0.0.2, 1.0.0.3 for example. Now client installs version

[GENERAL] EXCEPTION Function

hi all,I am using PostgreSQL 8.0.1 on Fedora core 2.My goal is to create a common Exception handling stored function that takes Error Constant (as defined in Error Codes document: AppendixA) and raises a customized exception. The problem is:(a) How do i catch these Error Constants? I was unable to

[GENERAL] SYNTAX ERROR at or near SQLSTATE

        raise notice '% %', sqlstate, sqlerrm; end;  end; $$ language plpgsql; Any help will be highly appreciated, thanks, vish On 1/26/06, vishal saberwal <[EMAIL PROTECTED]> wrote: hi all,I am using PostgreSQL 8.0.1 on Fedora core 2.My goal is to create a common Exception handling

Re: [GENERAL] SYNTAX ERROR at or near SQLSTATE

oh thanks,i didnt know that,highly appreciate your help and quick response ...vishOn 1/26/06, Michael Fuhr < [EMAIL PROTECTED]> wrote:On Thu, Jan 26, 2006 at 03:02:46PM -0800, vishal saberwal wrote: > When i run it on PostgreSQL8.0.1 (on fedora core 2), i get the error:>> dbm=

[GENERAL] User defined EXCEPTIONs

Using postgreSQL 8.1 on fedora.Below is a function RowCount_Select(Table_Name) defined that raises exception (test1) which i intend to catch in test1( ) and raise exception (test2).Do we have a way to catch such user defined exceptions? Can someone direct me to the right resource pages? create or r

Re: [GENERAL] User defined EXCEPTIONs

t('test');    return res;EXCEPTION    when raise_exception then         raise exception 'test2 # %',SQLERRM;END;$$ language plpgsql strict;DB=# select * from test1();ERROR:  test2 # testingthis does solve my problem of catching my exceptions to a good extent. On 3/7/06, vishal s