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 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 configuration parameter
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 seems that for an empty bytea (only the size of the header), i get
*) 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 Fadida
Blog: http://tzahi.blogsite.org
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:
:
[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 PostgreSQL work, they may link to others doing the same. You
should probably see
.
--
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
[ Attachment, skipping... ]
---(end of broadcast)---
TIP 3: Have you
there are in the data.
---
Tzahi Fadida wrote:
On Friday 11 August 2006 07:18, Bruce Momjian wrote:
I have looked over this addition, and I think I finally understand it.
Given three tables, A, B, C, which join as A-B, B-C, C
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
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:
I used
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.info
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 it to postgresql src files
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
---(end
to 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 some
attributes, to blank
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 | Home Site
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.
I have a question about CTID invalidation when you
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.uk/my2nis
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 the backend I think you could use
Backend
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 this in a query with the :: cast operator.
The problem
, Jun 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 parser/parse_oper.c, in particular oper
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
CTID?
Err, the fact
.
--
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: explain analyze is your friend
that the 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 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
WHERE a=3, b=6,. ...)
UNION
(SELECT * FROM R
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
better for the planner
@svana.org 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 lots of unions.
Do you need UNION, or do you actually mean UNION ALL?
Also, couldn't you just do
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
---(end
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
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.
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 snapshot. It's not that different
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
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
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
36 matches
Mail list logo