We are depending on postgres.lib while creating a postgre extension for
windows.
We need to know the equivalent library in Linux to build the same in Linux to
get the symbols resolve correctly.
Any help is appreciated.
-Kiran G
-Original Message-
From: Michael Paquier
equivalent library for postgres.lib in Linux?
Thanks,
Kiran G
was it because there were rows already in the cf_question table
before the trigger function was deployed ?
regards
Kiran
On Mon, Oct 31, 2016 at 3:45 PM, Alban Hertroys <haram...@gmail.com> wrote:
> On 31 October 2016 at 14:41, Adrian Klaver <adrian.kla...@aklaver.com>
> wrote:
>
Hi Adrian,
I want the trigger function to insert a row in cf_user_question_link table
with fields as show in the function once the there is a insert from in the
cf_question table.
I know 94 = 1 + (3 * 31).
I am just having a normal insert statement into cf_question table.
regards
Kiran
Hi Alban,
I agree with you about the UPDATE.
Thanks for pointing out.
regards
Kiran
On Sun, Oct 30, 2016 at 12:49 PM, Alban Hertroys <haram...@gmail.com> wrote:
>
> > On 30 Oct 2016, at 10:31, Kiran <bangalore.ki...@gmail.com> wrote:
> >
> > Dear Folks,
&g
rows in the table.
It would be great if any from the forum point to me where I am doing wrong.
regards
Kiran
Hi Chris,
Thank you very much. Will look into examples and syntax.
regards
Kiran
On Sat, Oct 29, 2016 at 3:18 PM, Chris Mair <ch...@1006.org> wrote:
> Dear folks,
>>
>> I have a table with thousands of rows ( currently 15 thousand but will
>> grow very fast
let me know what is best way to handle this type of queries.
regards
Kiran
in the table is very low but that column will be
in thousands of rows in the near future. hence I wanted to confirm from the
group am I doing something wrong here.
Also to_tsquery is casting to ::text. Is this normal ?
regards
Kiran
On Mon, Sep 19, 2016 at 2:33 PM, Karsten Hilbert <karsten.h
Is this normal ?
It would be of great help if anyone point me into right direction.
regards
Kiran
Hi,
Thanks for the reply. It worked.
But I also fixed the original ts_query as follows which gives the exact
result
SELECT * from question
where
weighted_tsv @@ to_tsquery('Hur');
Thank you .
regards
Kiran
On Mon, Sep 19, 2016 at 11:21 AM, Oleg Bartunov <obartu...@gmail.com> wrote:
&g
into right direction.
Thanks
Kiran
Hi Jim,
The issue is now resolved thanks to Tom and Adrian.
regards
Kiran
On Sun, Sep 11, 2016 at 4:16 AM, Jim Nasby <jim.na...@bluetreble.com> wrote:
> On 9/10/16 6:03 AM, Kiran wrote:
>
>> If I insert a record from my application using following code :
>> db.mys
Dear Tom, Adrian,
Excellent catch!
Thank you very very much to both. It is resolved now. I can sleep now.
Good night from Sweden.
regards
Kiran
On Sat, Sep 10, 2016 at 11:18 PM, Adrian Klaver <adrian.kla...@aklaver.com>
wrote:
> On 09/10/2016 02:09 PM, Kiran wrote:
>
Hi Adrian,
The JSON value is inserted into a column in the database which I can see.
But the trigger which has to convert this JSON value in not tsvector column
is not updating that column.
regards
On Sat, Sep 10, 2016 at 10:27 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Kiran <
Hi Tom,
I have checked and the trigger is not disabled.
and \drds results
Role=blank
database = mydatabase
settings = default_text_search_config=pg_catalog.swedish
Any other tips or suggestions please.
regards
Kiran
On Sat, Sep 10, 2016 at 9:26 PM, Tom Lane <t...@sss.pgh.pa.us>
quot;body") VALUES
($1, $2, $3, $4) RETURNING *
As you can see from the above, there is a LOG which says Trigger called.
This is the statement inside the function which means the trigger is
firing, but why the subsequent column is not updated, I can't understand.
Also, I am us
parameters. Could you please give me some
reference to which I can refer for this type of error checking or any other
tips to solve this issue. I have been looking into this since morning
without any positive outcome :(
Thanks once again.
regards
Kiran
On Sat, Sep 10, 2016 at 5:21 PM, Tom Lane
helpful.
regards
Kiran
On Sat, Sep 10, 2016 at 3:22 PM, Adrian Klaver <adrian.kla...@aklaver.com>
wrote:
> On 09/10/2016 03:59 AM, Kiran wrote:
>
>> Hi,
>>
>> *Problem background :*
>> I have a *function in the DB* as follows
>> CREATE FUNCTION question
be really really appreciated.
Thanks
Kiran
ally appreciated.
Thanks
Kiran
Hi,
As part part of my project, I had to compare the time taken by the Hashjoin
algorithm to that of Nested loop algorithm for the inner join and Natural
join queries, under two cases. I used six tables to join each other each
containing 5000 rows each approximately.
The two cases are given
Hi,
I have installed postgresql-9.4.0 version.
I have started the server from eclipse indigo version using Run
configurations.
There is a table in my database whose name is b. whenever I give a query
which is related to this table I get the error *The connection to the
server was lost.
Hi,
I am using the postgresql-9.4.0 version.
There is a program policy.c which is there in the previous versions. The
following link shows the program.
http://doxygen.postgresql.org/policy_8c.html
But in the version 9.4.0, I cannot find it.
I want to know whether this program being removed
Hi,
I want to know how the relation name is stored in postgres, In which part
of the postgres source code could I find the relation name being stored.
Thank you
--
Regards,
K.Ravikiran
ᐧ
:
Hi
it is in system catalog - table pg_class, column relname
Regards
Pavel Stehule
2015-04-02 15:52 GMT+02:00 Ravi Kiran ravi.kolanp...@gmail.com:
Hi,
I want to know how the relation name is stored in postgres, In which part
of the postgres source code could I find the relation name
Hi,
Also, could you tell me during which stage(whether parser,optimizer or
executor) does the table name gets stored, and if possible could you tell
me which program specifically does that.
ᐧ
On Thu, Apr 2, 2015 at 7:56 PM, Ravi Kiran ravi.kolanp...@gmail.com wrote:
Hi,
Thank you Sir.
Also
hi,
I want to know what kind of hash function postgresql uses while joining. I
was debugging through gdb, I found out that it is not using bob jenkins
hash function but a different hash function *hash_uint32() and
hash_any() *functions
if the joining attribute is an integer, and a different kind
Hi,
I want to know what kind of hash function postgres is using currently, can
someone please explain the algorithm postgres is using for the hash
function in the hash join algorithm.
Thanks,
K.Ravikiran
hi,
I am going through the hashjoin algorithm in postgres. I find a function
ExecHashjoin , which is called each time a new tuple is required by the
hash join *Node.*
could someone explain what exactly node mean in postgres.
Thanks
hi,
I am working with postgresql 9.4.0 source using eclipse(indigo version) in
ubuntu 14.04. I am facing a problem of attaching a client process to
postgresql server.
I am following the steps given in this link
hi all,
Is postgres source code compatible with mysql database?? If it is, could
someone could give me some links so that I can do that.
I want to hack into the postgres source code, but as I am comfortable with
mysql, I want to use the mysql database not postgres.
any references would be
Hi,
I am facing some problem with gdb for the past few days.
I want to debug nestloop.c in postgresql , so I followed the below steps.
I followed the steps given in the below for collecting the stack trace.
hi ,
I am trying to attach a postgres process to gdb, Since I am using only 1
client , I am using the script give by Tom Lane posted in the mailing list.
http://www.postgresql.org/message-id/bd6a35510707221030p694cd515kfeb529078557b...@mail.gmail.com
I started running the client by following
hi,
I am trying to learn how postgresql implements the join algorithms.
So I am trying to learn about the source code of the executor precisely the
file nodenestloop.c .
In the executor file I have nodenestloop.o but no binary executor file.
I am using helios eclipse to edit the source code.
hi,
I am using helios Eclipse for debugging my code in postgresql.
My aim is to know how postgresql uses join algorithms during the join
query, so I started to debug*nodenestloop.c* which is in the Executor
folder.
I gave break points in that file, But whenever I try to debug that file,
the
hi,
can any one help me with the 4th and 5th steps of the following link which
is to debug with a child process in postgres.
*https://wiki.postgresql.org/wiki/Working_with_Eclipse#Debugging_with_child_processes
https://wiki.postgresql.org/wiki/Working_with_Eclipse#Debugging_with_child_processes*
hi,
I am using the environment Eclipse for the execution of the programs in the
executor, whenever I give break points to specific program in eclipse , the
control goes to main.c and finally the process never comes back to the
actual program.
Is there any way that the process be constrained only
hi,
How do we debug specific functions in gdb of eclipse.
Whenever I give break points in nodenestloop.c, it goes to main.c and
finally the process ends there, The control never comes back to
nodenestloop, how can we the proces constrained only to nodenestloop.
Thank you
hi,
How to compile and run the files the source code of postgres in eclipse,
how to compile a c program in the backend directory of postgres??
I followed the steps in
https://wiki.postgresql.org/wiki/Working_with_Eclipse , but when I build
the program nodeNestloop.c in the backend directory, I
Hello, I am Ravikiran, pursuing my third year BITS Pilani, India, I am
doing my thesis in postgress technology,
The project is about implementing new join algorithms in postgres, Since I
am new to postgress, could you help me in which part of source code of
postgres should be looking in postgress
Hello,
I am looking for an example on creating a DBLink from PostrgeSQL 9.2 to
Oracle 11g.
I tried the below link and for some reason the ODBC_Link installation is
failing.
FYI.,
http://vibhork.blogspot.com/2011/05/postgresql-database-link-to-oracle.html
I have the Heterogeneous DB Connection
Hi,
I have tried clicking the unsubscribe mailing list to unsubscribe myself.
But it doesn't seem to work.
Please unsubscribe this email id: kirank...@gmail.com
Thanks,
Kiran
I am using the psqlodbc driver to connect to postgresql... But this is not
supporting all the languages that UTF should support.. Database is of the
correct encoding that is UTF... can you please give a solution so that i can
psqlodbc supports multiple languages. Right now there is support for
only
got the cursor name. We've been trying to access the values for the past one
week. Can you please help me by sending me a sample code as to how to get
the values in a recordset using this refcursor. Please do reply. This is
very urgent.
Thanks and regards
Ravi Kiran L
only
got the cursor name. We've been trying to access the values for the past one
week. Can you please help me by sending me a sample code as to how to get
the values in a recordset using this refcursor. Please do reply. This is
very urgent.
Thanks and regards
Ravi Kiran L
only
got the cursor name. We've been trying to access the values for the past one
week. Can you please help me by sending me a sample code as to how to get
the values in a recordset using this refcursor. Please do reply. This is
very urgent.
Thanks and regards
Ravi Kiran L
47 matches
Mail list logo
