On Sunday 08 April 2007 21:34:52 Peter Eisentraut wrote:
> Tzahi Fadida wrote:
> > What should i do?
>
> Telling what version you use and what error messages you see would help.
SET client_min_messages = warning;
\set ECHO none
+ ERROR: unrecognized configur
installcheck:
SET standard_conforming_strings = off;
SET escape_string_warning = off;
When i remove this lines the stable version make installcheck passes.
What should i do?
10x.
--
Regards,
Tzahi.
--
Tzahi Fadida
Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info
WARNING
On Saturday 07 April 2007 04:08:34 Tom Lane wrote:
> Tzahi Fadida <[EMAIL PROTECTED]> writes:
> > This is an excerpt from my code:
> > newtset->tids = (bytea *) fastgetattr(tupleTSet, LABELS_ALIGNED,
> > fctx->tupleSetDesc, &isnull);
> >
> > It se
ids = (bytea *) fastgetattr(tupleTSet, LABELS_ALIGNED,
fctx->tupleSetDesc, &isnull);
It seems that for an empty bytea (only the size of the header), i get that
VARSIZE(newtset->tids)==534765440
instead of VARHDRSZ.
What can i do?
10x.
--
Regards,
Tzahi.
--
Tzahi Fadi
ote:
> > [EMAIL PROTECTED] (Tzahi Fadida) writes:
> > > Hi,
> > > Is there a LinkedIn group for Postgresql/Hackers list.
> > > If there is, how can i join?
> >
> > The usual way LinkedIn works is that if there are people you know that
> > do Postgre
Hi,
Is there a LinkedIn group for Postgresql/Hackers list.
If there is, how can i join?
Thank you.
--
Regards,
tzahi.
Itzhak Fadida
M.Sc - Technion, Information Systems, IE Faculty
Home Page: Http://tzahi.webhop.info
BLOG: Http://tzahi.blogsite.org
LinkedIn: http://www.linkedin.com/in/tzahi
tes so it all depends on how many join
combination there are in the data.
>
> -------
>
> Tzahi Fadida wrote:
> > On Friday 11 August 2006 07:18, Bruce Momjian wrote:
> > > I have looked over this addi
s pretty complex, so I can see why it should be in /contrib.
> Are there reasonable use cases for this capability?
>
> ---
>
> Tzahi Fadida wrote:
> > Hi,
> > I wish to add the fulldisjunctions function to the contrib.
> > With the help o
Is there a way to tell if there is support for 64 bits bitwise operations
since c.h apparently defines BUSTED for no support for 64 bits variables.
10x.
--
Regards,
Tzahi.
--
Tzahi Fadida
Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info
WARNING TO SPAMMERS: see at
These are .c and .h files on linux.
Also i am using the patched indent and compiled the entab, etc...
From 8.2
On Saturday 29 July 2006 17:57, Andrew Dunstan wrote:
> Tzahi Fadida wrote:
> > I am trying to use pgindent but it adds ^M in my files.
> > However, it doesn't add
I am trying to use pgindent but it adds ^M in my files.
However, it doesn't add it to postgresql src files (i tried).
I guess it is maybe something with encoding?
What can i do?
10x.
--
Regards,
Tzahi.
--
Tzahi Fadida
Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop
10x,
Found my answer thanks to Ragnar.
SELECT DISTINCT ON (a0,a1) a0,a1,ctid FROM t1
To tell the truth, i did not know there was an ON option in SQL.
This thing is very handy.
On Saturday 29 July 2006 03:37, Tzahi Fadida wrote:
> Hi,
> I have a query i am having trouble to formulate:
&g
er to use group by technique.
What are my options?
(I am using 8.2 or 8.1)
--
Regards,
Tzahi.
--
Tzahi Fadida
Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info
WARNING TO SPAMMERS: see at
http://members.lycos.co.uk/my2nis/spamwarning.html
--
know that value).
10x.
--
Regards,
Tzahi.
--
Tzahi Fadida
Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info
WARNING TO SPAMMERS: see at
http://members.lycos.co.uk/my2nis/spamwarning.html
---(end of broadcast)---
TIP 6
Hi,
In 8.2 the function tuplestore_gettuple in tuplestore.h is either missing or
deprecated? can someone shed some light on this?
(it appears in the tuplestore.c file and there is no deprecation warning
there)
10x.
--
Regards,
Tzahi.
--
Tzahi Fadida
Blog: http://tzahi.blogsite.org
On Tuesday 11 July 2006 17:27, Martijn van Oosterhout wrote:
> On Tue, Jul 11, 2006 at 01:50:40AM +0300, Tzahi Fadida wrote:
> > As i understand rowids, i.e ctids, are supposed to allow for fast access
> > to the tables. I don't see the rational, for example, when casting som
On Tuesday 11 July 2006 00:35, Martijn van Oosterhout wrote:
> On Mon, Jul 10, 2006 at 11:47:23PM +0300, Tzahi Fadida wrote:
> > Hi,
> > First, i use CTIDs to immensely speed up my function which is inherently
> > slow because of the problem itself.
> >
>
thing to return ctids if the query is read only. where
is it invalidated anyway?
I highly prefer not to use CTID as an attribute since it is going to greatly
lower the performance since it is sitting on a bottleneck.
--
Regards,
Tzahi.
--
Tzahi Fadida
Blog: http://tzahi.blogsite.org | H
On Monday 10 July 2006 00:29, Martijn van Oosterhout wrote:
> On Sun, Jul 09, 2006 at 10:08:42PM +0300, Tzahi Fadida wrote:
> > They return format_type_be(INT4OID) = "integer" or
> > format_type_be(FLOAT8OID) = "double precision"
> > I need to use th
On Sunday 09 July 2006 21:49, Michael Fuhr wrote:
> On Sun, Jul 09, 2006 at 09:03:21PM +0300, Tzahi Fadida wrote:
> > How do i get a char * type from a type Oid. i.e.
> > getStringTypeFromOid(INT4OID) will return "int4".
>
> Server-side or client-side? In th
Hi,
How do i get a char * type from a type Oid. i.e. getStringTypeFromOid(INT4OID)
will return "int4".
10x.
--
Regards,
Tzahi.
--
Tzahi Fadida
Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info
WARNING TO SPAMMERS: see at
http://members.lycos.co
On Thursday 06 July 2006 21:55, Martijn van Oosterhout wrote:
> On Thu, Jul 06, 2006 at 07:43:20PM +0300, Tzahi Fadida wrote:
> > The downside is that i noticed that the CTID is removed from the tuple
> > if a cast occurs. Is there a way to tell postgresql to not remove the
> &g
28, 2006 at 03:25:57PM +0300, Tzahi Fadida wrote:
> >> I need help finding out how to determine if two types are equality
> >> compatible and compare them.
> >
> > Fortunatly the backend contains functions that do all this already.
> > Check out
to compare the two values.
--
Regards,
Tzahi.
--
Tzahi Fadida
Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info
WARNING TO SPAMMERS: see at
http://members.lycos.co.uk/my2nis/spamwarning.html
---(end of broadcast)---
TIP
rhout writes:
> > On Fri, Jun 23, 2006 at 03:57:19PM +0300, Tzahi Fadida wrote:
> >> (SELECT * FROM R
> >> WHERE a=3, b=6,. ...)
> >> UNION
> >> (SELECT * FROM R
> >> WHERE b=5, d=2,. ...)
> >> UNION
> >>
> >> And
On Friday 23 June 2006 17:47, Martijn van Oosterhout wrote:
> On Fri, Jun 23, 2006 at 05:12:14PM +0300, Tzahi Fadida wrote:
> > My initial reasoning was to avoid extra sorts but i guess that the
> > planner just doesn't get the LIMIT 1. I see now that UNION should be
> >
On Friday 23 June 2006 16:14, Martijn van Oosterhout wrote:
> On Fri, Jun 23, 2006 at 03:57:19PM +0300, Tzahi Fadida wrote:
> > R contains indices but not on all attributes or not on
> > all ordered subset of keys.
> >
> > Query example:
> > (SELECT * FROM R
&g
planner will do
this.
P.s.:
I am currently just writing the query as a string and open a cursor.
Is there a simple way to use Datums instead of converting the attributes to
strings to create a plan for SPI.
10x.
--
Regards,
Tzahi.
--
Tzahi Fadida
Blog: http://tzahi.blogsite.org | Home Site
On Thu, 2006-06-01 at 12:45 -0400, Tom Lane wrote:
> Tzahi Fadida <[EMAIL PROTECTED]> writes:
> > I am not sure about the definition of a context of a single SQL command.
>
> Well, AFAICS selecting a disjunction ought to qualify as a single SQL
> command using a single
I am not sure about the definition of a context of a single SQL command.
Example of a run:
A <- SELECT getfdr('Relation1,Relation2,Relation3');
to get the result schema (takes a few milliseconds).
SELECT * FROM FullDisjunctions('Relation1,Relation2,Relation3') AS
RECORD A;
Can take a long time.
I am using CTID for the concept of a tuple set.
For example, the set of t1 from relation1, t1 from relation2, t10 from
relation3 will be represented in my function as a list
of (TableID:CTID) pairs.
For example {(1:1),(2:1),(3:10))
I then save these in bytea arrays in a tuplestore.
This is essentia
to temporarily duplicate the relations but
this is less appealing (plus it's already working great with CTIDs).
--
Tzahi Fadida
Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info
WARNING TO SPAMMERS: see at
http://members.lycos.co.uk/my2nis/spamwarning.html
--
Hi,
While trying to determine if SPI_cursor_move can rewind
(and receiving a great help from the guys at the irc), we
found out that since the count parameter is int
and FETCH_ALL is LONG_MAX then setting
the count parameter to FETCH_ALL to rewind
will not work on 64bit systems.
On my pIII 32 bit
Hi,
I hope its not off topic.
I have an algorithm to implement where it needs
to hold the tuples (complete tuples - all columns)
either in a b+tree or a hashtable.
I am concerned about the space such an index will require.
What is the difference in percentages from the size of all
the data not inde
Just my 2 cents.
I am not a super statistics guy but besides increasing the sample size
and
assumming things on the distribution, I understand you want to get more
info on what distribution the data represents.
usualy the problem with these things is that the data needs to be sorted
on the
index ke
Hi All,
As part of my thesis I need to implement a new algorithm for
Full-Disjunctions and 2 older ones.
A short explanation of what Full-Disjunction is, is that it comes to
solve what A natural outer join
usually can't do when you have more than 2 relations.
The main goal is to retrieve maximal
36 matches
Mail list logo
