Re: [HACKERS] .NET driver

2007-08-06 Thread Shachar Shemesh
Andrew Dunstan wrote: Well, contributions come in many forms, not just patches. Note too that almost all the requested features had nothing to do with core postgres, which is what this list is about Well, as a driver developer I can tell you that the core teams attitude toward driver driven

Re: [HACKERS] Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server

2007-05-23 Thread Shachar Shemesh
Tom Lane wrote: Shachar Shemesh [EMAIL PROTECTED] writes: Before you explode at me (again :), I'm not arguing that you can do binary based calculations of decimal numbers without having rounding errors that come to bite you. I know you can't. What I'm saying is that we have two cases

Re: [HACKERS] Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server

2007-05-22 Thread Shachar Shemesh
Tom Lane wrote: Okay, I spent some time googling this question, and I can't find any suggestion that any ARM variant uses non-IEEE-compliant float format. What *is* real clear is that depending on ARM model and a run time (!) CPU endianness flag, there are three or four different possibilities

Re: [HACKERS] Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server

2007-05-22 Thread Shachar Shemesh
Please note - I'm not trying to pick up a fight. Tom Lane wrote: Your source appears fairly ignorant of things-float. That is possible, and even likely, however If they really are using decimal FP, it's easy to demonstrate that a lossless conversion to/from binary representation of similar

Re: [HACKERS] Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server

2007-05-21 Thread Shachar Shemesh
Csaba Nagy wrote: If you care about the +/- for +/-Infinity, you must also care about +/-0 too, so you get the right type of infinity if you divide with 0... so +0 and -0 are far from being semantically identical. Cheers, Csaba. My suggestion accommodates that. Shachar

Re: [HACKERS] Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server

2007-05-21 Thread Shachar Shemesh
Peter Eisentraut wrote: I want to use the binary format but I don't like what it does. It doesn't do anything. The set of circumstances under which it is useful has been limited, on purpose, and, as far as I can see, without any good reason. Spending not much time (and I suggested to spend it

Re: [HACKERS] Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server

2007-05-20 Thread Shachar Shemesh
Greg Smith wrote: On Sun, 20 May 2007, Shachar Shemesh wrote: This is not data given to store. It's data being exported. Data being exported has a funny way of turning around and being stored in the database again. It's kind of nice to know the damage done during that round trip

[HACKERS] Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server

2007-05-19 Thread Shachar Shemesh
to comment on floating point format there. Julian Heeb wrote: Shachar Shemesh schrieb: Julian Heeb wrote: Hello Our acounting software can use the PostgreSQL OLE DB driver to access a postgreSQL database. With the pg server installed on windows, everything works fine. I moved now

Re: [HACKERS] Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server

2007-05-19 Thread Shachar Shemesh
Stefan Kaltenbrunner wrote: Shachar Shemesh wrote: Hi guys of the pgsql-hackers list. I've received a bug report on the OLE DB list, which I suspect is actually a server bug. The correspondence so far is listed further on, but, in a nutshell, user runs an OLE DB client on windows (OLE DB

Re: [HACKERS] Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server

2007-05-19 Thread Shachar Shemesh
Tom Lane wrote: Shachar Shemesh [EMAIL PROTECTED] writes: I've received a bug report on the OLE DB list, which I suspect is actually a server bug. The correspondence so far is listed further on, but, in a nutshell, user runs an OLE DB client on windows (OLE DB uses the binary interface

Re: [HACKERS] Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server

2007-05-19 Thread Shachar Shemesh
Tom Lane wrote: Shachar Shemesh [EMAIL PROTECTED] writes: I'll reiterate - the problem is not that PG is exporting the internal ARM FP format. The problem is that the server is exporting the internal ARM FP format when the server is ARM, and the IEEE format when the server is Intel. It's

Re: [HACKERS] Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server

2007-05-19 Thread Shachar Shemesh
Tom Lane wrote: Binary format has other goals that are not always compatible with 100% platform independence --- that's unfortunate, sure, but it's reality. Maybe the misunderstanding is mine. What are the goals for the binary format? Shachar ---(end of

Re: [HACKERS] Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server

2007-05-19 Thread Shachar Shemesh
Heikki Linnakangas wrote: But sometimes, like now, PG puts me in an impossible position. You are essentially telling me you will get the numbers in an unknown format, you will not have any way of knowing whether you got them in a strange format or not, nor will you have any docs on what that

Re: [HACKERS] Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server

2007-05-19 Thread Shachar Shemesh
Tom Lane wrote: Sure it's possible. Send a Parse command, ask for Describe Statement output, then specify the column formats as desired in Bind. Now this does imply an extra server round trip, which might be annoying if your client code doesn't have another reason to need to peek at Describe

Re: [Oledb-dev] [HACKERS] Re: double precision error with pg linux server, but not with windows pg server

2007-05-19 Thread Shachar Shemesh
Tom Lane wrote: Obviously, if you are transporting the dump across platforms then that may be an impossibility. In that case you use a text dump and accept that you get an approximation. ‎That's something that I've been meaning to ask about, but you all seemed so sure of yourself. What you are

Re: [Oledb-dev] [HACKERS] Re: double precision error with pg linux server, but not with windows pg server

2007-05-19 Thread Shachar Shemesh
Andrew Dunstan wrote: Why the heck do the OLE DB specs care about the internals of the client-server prototocol? It is documented fairly clearly that text is the only portable way to transfer data. Is it? Perhaps we need to expand this sentence in the docs: Keep in mind that binary

Re: [HACKERS] Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server

2007-05-19 Thread Shachar Shemesh
Tom Lane wrote: Shachar Shemesh [EMAIL PROTECTED] writes: Tom Lane wrote: No, not unless you can make the case why this handles NaNs and denormalized numbers compatibly across platforms... NaNs and infinite (plus and minus) should not be a problem. Really? Need I

[HACKERS] Moving a project from gborg to pgfoundry?

2005-03-20 Thread Shachar Shemesh
-- Shachar Shemesh Lingnu Open Source Consulting ltd. Have you backed up today's work? http://www.lingnu.com/backup.html ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Moving a project from gborg to pgfoundry?

2005-03-20 Thread Shachar Shemesh
anything new to say in over a month, two have just stated that they don't care about the rest of the info anyways. To summarize, just give me read only access to the old project's data and I'm set. Shachar -- Shachar Shemesh Lingnu Open Source Consulting ltd. Have you backed up today's work

[HACKERS] Unstable timestamp binary representation?

2005-03-18 Thread Shachar Shemesh
with, not stopping to ask what the other side was compiled with. Is this a bug in postgres as well? Shachar -- Shachar Shemesh Lingnu Open Source Consulting ltd. Have you backed up today's work? http://www.lingnu.com/backup.html ---(end of broadcast

[HACKERS] Version 1.0.0.18 of OLE DB released

2005-03-18 Thread Shachar Shemesh
DB in the near past. I strongly recommend upgrading, especially prior to filing any new bug reports. The new version can be obtained from http://gborg.postgresql.org/project/oledb/download/download.php. Shachar -- Shachar Shemesh Lingnu Open Source Consulting ltd. Have you backed up

Re: [HACKERS] Unstable timestamp binary representation?

2005-03-18 Thread Shachar Shemesh
Tom Lane wrote: Shachar Shemesh [EMAIL PROTECTED] writes: In other words, it seems that I, as a client, needs to guess whether postgres was compiled with or without HAVE_INT64_TIMESTAMP. No, you need to inquire of the value of the integer_datetimes parameter. (At least as of 8.0

Re: [HACKERS] type unknown - how important is it?

2005-03-17 Thread Shachar Shemesh
Tom Lane wrote: Dave Cramer [EMAIL PROTECTED] writes: Shachar Shemesh wrote: I don't know type 705 well enough to decide which would work best. If it's guaranteed to be a validly encoded text string, then I'll just put it in as DBTYPE_WSTR, and get it done with. I think it's

Re: [HACKERS] type unknown - how important is it?

2005-03-17 Thread Shachar Shemesh
pqlib's exec with params to pass parameters around, and also to make sure that data is returned in binary format. As a result, it requires PG version 7.4 and above. It may well be that the answer is It's irrelevant for our supported backends. Shachar -- Shachar Shemesh Lingnu Open Source

Re: [HACKERS] type unknown - how important is it?

2005-03-16 Thread Shachar Shemesh
string, then I'll just put it in as DBTYPE_WSTR, and get it done with. On another note are you aware of any issues with transactions? Specifically with using the dated autocommit mode ? I'm not sure what dated autocommit is. What are the issues you are seeing? Dave Shachar -- Shachar

Re: [HACKERS] type unknown - how important is it?

2005-03-16 Thread Shachar Shemesh
Shachar Shemesh wrote: Dave Cramer wrote: Shachar, I think with type oid 705 (unknown) it's safe to treat it as text. Certainly better than punting. Question is what DBTYPE to report it as. Options are DBTYPE_WSTR (UTF-16 string, which means the input string must be a valid UTF-8 string

Re: [HACKERS] type unknown - how important is it?

2005-03-15 Thread Shachar Shemesh
a time frame for that. I'm also not certain how helpful that would be for most cases. On the good news front, Version 1.0.0.17 is about ready to be released (initial schema support). I am resuming development after about half a year of doing other stuff. Shachar -- Shachar Shemesh

[HACKERS] type unknown - how important is it?

2004-09-28 Thread Shachar Shemesh
. My question is - what is unknown used for? Is it important to support binary send and receives with this type? Does postgresql know how to convert it to other types? I was under the impression that 'a' would be text. Why is unknown used instead? Shachar -- Shachar Shemesh Lingnu Open

Re: [HACKERS] type unknown - how important is it?

2004-09-28 Thread Shachar Shemesh
Joshua D. Drake wrote: Shachar Shemesh wrote: I have a complaint from an OLE DB user that when he does select 'a', he gets an unhanded type error. Since OLE DB uses a binary interface, it has to know about all variable types that pass through it. The debug information for the problem show

Re: [HACKERS] No parameters support in create user?

2004-09-21 Thread Shachar Shemesh
Gaetano Mendola wrote: Shachar Shemesh wrote: Tom Lane wrote: Parameters are only supported in plannable statements (SELECT/INSERT/UPDATE/DELETE; I think there is some hack for DECLARE CURSOR these days too). That's a shame. Aside from executing prepared statements, parameters are also useful

Re: [HACKERS] libpq and prepared statements progress for 8.0

2004-09-21 Thread Shachar Shemesh
don't see the real need for a driver oriented backend communication library. Shachar -- Shachar Shemesh Lingnu Open Source Consulting ltd. http://www.lingnu.com/ ---(end of broadcast)--- TIP 7: don't forget to increase your free space

[HACKERS] No parameters support in create user?

2004-09-20 Thread Shachar Shemesh
$1 with encrypted password $2 Any idea why this is not working? Is it supposed to work? Trying to pass only the password as a parameter does not work either. Shachar -- Shachar Shemesh Lingnu Open Source Consulting ltd. http://www.lingnu.com/ ---(end of broadcast

Re: [HACKERS] No parameters support in create user?

2004-09-20 Thread Shachar Shemesh
cases, they are useful for all commands, not only those that can be prepared. Oh well. I'm not sure whether that's extremely clever or downright insane, but I'm solving this problem by calling Select quote_literal($1) and select quote_id($1), and then using the results. Shachar -- Shachar

[HACKERS] Compilation problems and extension on Windows

2004-08-22 Thread Shachar Shemesh
). The makefiles available through the sources only compile libpq and psql and friends, not the actual database. I have not tried MSYS yet, but do I just run the configure script as usual? Any help with any of these problems would be greatly appretiated. Shachar -- Shachar Shemesh Lingnu Open

Re: [HACKERS] NLS support for postgreSQL

2004-08-22 Thread Shachar Shemesh
on pgfoundry (http://pgfoundry.org/projects/sql2pg/). In particular, check out the varcharci type, that has case preserving varchars. This may provide you with a starting point for what you are trying to do. Shachar -- Shachar Shemesh Lingnu Open Source Consulting ltd. http://www.lingnu.com

[HACKERS] Custom type with width specifier

2004-06-27 Thread Shachar Shemesh
is called in order to say that the type needs a width specifier. Many thanks Shachar -- Shachar Shemesh Lingnu Open Source Consulting ltd. http://www.lingnu.com/ ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Casts question

2004-06-22 Thread Shachar Shemesh
Tom Lane wrote: Shachar Shemesh [EMAIL PROTECTED] writes: Tom Lane wrote: Yes, it can cast to varchar, but that doesn't help because there are no varchar operators ;-). To resolve the operator, it has to promote both sides to text, and you didn't offer a cast to text. I don't get

Re: [HACKERS] Casts question

2004-06-20 Thread Shachar Shemesh
Tom Lane wrote: Shachar Shemesh [EMAIL PROTECTED] writes: I have defined a datatype called varcharci, shamelessly yanking the input, output, recv and send functions from varchar. This means (as far as I understand things) that this type is binary compatible with varchar. Use text

[HACKERS] Using domains for case insensitivity

2004-06-17 Thread Shachar Shemesh
, but for changing constraints of a type. Is it possible to define a domain that will have the same defaults and constraints as the base type, but will have different comparison functions? Will that provide me with what I need? Many thanks, Shachar -- Shachar Shemesh Lingnu

[HACKERS] in out send recv functions - immutable or stable?

2004-06-17 Thread Shachar Shemesh
for this? Shachar P.S. This is PG 7.4 on Debian unstable, coming from the standard deb. -- Shachar Shemesh Lingnu Open Source Consulting ltd. http://www.lingnu.com/ ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[HACKERS] Casts question

2004-06-17 Thread Shachar Shemesh
postgres be able to do the cast implicitly? Shachar -- Shachar Shemesh Lingnu Open Source Consulting ltd. http://www.lingnu.com/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Case preserving - suggestions

2004-06-07 Thread Shachar Shemesh
Robert Treat wrote: On Sunday 06 June 2004 13:47, Shachar Shemesh wrote: Hi list, A postgresql migration I am doing (the same one for which the OLE DB driver was written) has finally passed the proof-of-concept stage (phew). I now have lots and lots of tidbits, tricks and tips for SQL Server

[HACKERS] Case preserving - suggestions

2004-06-06 Thread Shachar Shemesh
and string compares), or would that entail making hundreds of little changes all over the code? Is there anything in the regression testing infrastructure that can help check such a change? Many thanks, Shachar -- Shachar Shemesh Lingnu Open Source Consulting http://www.lingnu.com

[HACKERS] OIDs, CTIDs, updateable cursors and friends

2004-06-03 Thread Shachar Shemesh
? Would adding OID to the rows returned by each Select call, and then doing update blah where oid=xxx when I'm requested to update the row sound like a reasonable stategy, in lieu of updateable cursors? Can anyone suggest a better way? Shachar -- Shachar Shemesh Lingnu Open Systems

Re: [HACKERS] Probably security hole in postgresql-7.4.1

2004-05-12 Thread Shachar Shemesh
. Shachar -- Shachar Shemesh Lingnu Open Source Consulting http://www.lingnu.com/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] Probably security hole in postgresql-7.4.1

2004-05-12 Thread Shachar Shemesh
Bruno Wolff III wrote: On Wed, May 12, 2004 at 10:46:00 +0300, Shachar Shemesh [EMAIL PROTECTED] wrote: Industry practices dictate that we do issue SOMETHING now. The bug is now public, and can be exploited. The description of the problem indicates that it can only be exploited after

Re: [HACKERS] Probably security hole in postgresql-7.4.1

2004-05-12 Thread Shachar Shemesh
Tom Lane wrote: Shachar Shemesh [EMAIL PROTECTED] writes: Also, has anybody checked what other versions are affected? Nothing before 7.4, at least by the known implications of this issue. Again, if we wait a while and let Ken keep running his analysis tool, he might turn up other stuff we

Re: [HACKERS] tinyint

2004-05-11 Thread Shachar Shemesh
are most welcome to start anew if you don't like the structure. -- Shachar Shemesh Lingnu Open Source Consulting http://www.lingnu.com/ ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Relocatable installs

2004-05-09 Thread Shachar Shemesh
installs more complicated, but see 2 for why this will not be necessary. 2. Original suggestion talked about looking up at HKCU, and then (if not found) at HKEY_LOCAL_MACHINE 3. I doubt the same machine will require BOTH service and per-user installation Shachar -- Shachar Shemesh

Re: [HACKERS] Relocatable installs

2004-05-08 Thread Shachar Shemesh
with Registry. That is usually hardcoded for (depending on whether you want it changeable per-user) HKEY_LOCAL_MACHINE\Software\company name\product name (replace HKLM with HKEY_LOCAL_USER if you want per-user config). Shachar -- Shachar Shemesh Lingnu Open Source Consulting http

Re: [HACKERS] Relocatable installs

2004-05-08 Thread Shachar Shemesh
Bruce Momjian wrote: Shachar Shemesh wrote: Bruce Momjian wrote: Comments? What's wrong with the way it's done by everybody else? Have hardcoded paths (determined at configure time), and allow override using a config file. Have a command line option for saying where the config

Re: [HACKERS] Multiple selects returned from a single stored procedure

2004-05-06 Thread Shachar Shemesh
Joe Conway wrote: Shachar Shemesh wrote: I guess what I would like to suggest is for the thus far unused select command in PLPGSQL to be used, in some way, to return values outside the scope of the strict returns context. I guess out variables will also be nice, but that's besides the point

Re: [HACKERS] Multiple selects returned from a single stored procedure

2004-05-06 Thread Shachar Shemesh
a transaction or not. Joe Shachar -- Shachar Shemesh Lingnu Open Source Consulting http://www.lingnu.com/ ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[HACKERS] Multiple selects returned from a single stored procedure

2004-05-05 Thread Shachar Shemesh
came up with so far was to create a temporary table for the out vars or the selects. I can then rig the OLE DB to make it look as if the function returned that. Shachar -- Shachar Shemesh Lingnu Open Systems Consulting http://www.lingnu.com/ ---(end of broadcast

Re: [HACKERS] Bringing PostgreSQL torwards the standard regarding

2004-04-27 Thread Shachar Shemesh
?) I'm not 100% sure on this all, but that seems to be the point Tom and I came to in our discussion, and neither of the two solutions seemed very good at the time. Shachar -- Shachar Shemesh Lingnu Open Source Consulting http://www.lingnu.com/ ---(end of broadcast

[HACKERS] License question

2004-04-26 Thread Shachar Shemesh
), which the FSF define as GPL compatible (http://www.fsf.org/licenses/license-list.html). Yet, the X11 license requires an inclusion of a certain paragraph, which is not mandated by the LGPL, and which gives permissions not granted by the GPL. I'm confused. -- Shachar Shemesh Lingnu Open Source

Re: [HACKERS] [pgsql-advocacy] Do we prefer software that works or software

2004-04-26 Thread Shachar Shemesh
in very unusual cases. That's why we are holding an open thread on the how in hackers. I'm assuming that once the how is sufficiently resolved, and the implications understood, everyone can make a better decision on the do we at all. Shachar -- Shachar Shemesh Lingnu Open Source

Re: [HACKERS] Bringing PostgreSQL torwards the standard regarding case folding

2004-04-26 Thread Shachar Shemesh
currently takes place. Obviously, you would have to get a var, and propogate that var to that place, but not actually change program flow. Shachar -- Shachar Shemesh Lingnu Open Source Consulting http://www.lingnu.com/ ---(end of broadcast

Re: [HACKERS] Bringing PostgreSQL torwards the standard regarding case folding

2004-04-26 Thread Shachar Shemesh
. If you want per database setting, you only need to worry about the shared catalogs If you want server wide setting, you just create the catalogs with the correct name, and get it over with. That's why I said that per-session setting seems like too much trouble. -- Shachar Shemesh Lingnu Open Source

[HACKERS] Bringing PostgreSQL torwards the standard regarding case folding

2004-04-25 Thread Shachar Shemesh
as is. 7. Column headers, however, will have to have a solution. A point still open in current design. I'm hoping this summary helps in furthering the discussion. -- Shachar Shemesh Lingnu Open Source Consulting http://www.lingnu.com/ ---(end of broadcast

Re: [HACKERS] Bringing PostgreSQL torwards the standard regarding

2004-04-25 Thread Shachar Shemesh
the database, the above won't work. Then again, I'm fairly sure that the identifiers you placed as lowercase in your database are not defined by template1. In short, I don't think this suggestion broke your database. Shachar -- Shachar Shemesh Lingnu Open Source Consulting http

Re: [HACKERS] Do we prefer software that works or software that looks good?

2004-04-24 Thread Shachar Shemesh
think we intend to deprecate the lowercase folding any time soon. Shachar Remove advocacy from the CC. I don't think it's related there any more. -- Shachar Shemesh Lingnu Open Source Consulting http://www.lingnu.com/ ---(end of broadcast

Re: [HACKERS] Do we prefer software that works or software that looks good?

2004-04-24 Thread Shachar Shemesh
Robert Treat wrote: On Saturday 24 April 2004 01:23, Shachar Shemesh wrote: Tom Lane wrote: PS: I resisted the temptation to SET THIS MESSAGE IN ALL UPPER CASE to make the point about readability. But if you want to argue the point with me, I'll be happy to do that for the rest

Re: [HACKERS] The case for preserving case.

2004-04-24 Thread Shachar Shemesh
. Shachar -- Shachar Shemesh Lingnu Open Source Consulting http://www.lingnu.com/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Do we prefer software that works or software that looks good?

2004-04-24 Thread Shachar Shemesh
to support both... You are welcome to join the other leg of this thread, then. That one is not CCed to advocacy, as it is 100% technical. Robert Treat Shachar -- Shachar Shemesh Lingnu Open Source Consulting http://www.lingnu.com/ ---(end of broadcast

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Shachar Shemesh
lowercase to the standard, however, means to me that even if I write a patch to start migration, I'm not likely to get it in. Shachar -- Shachar Shemesh Lingnu Open Source Consulting http://www.lingnu.com/ ---(end of broadcast)--- TIP 8

Re: [pgsql-advocacy] [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Shachar Shemesh
. If succeeds, issue a warning. This should allow programs that rely on the folding (such as initdb) to be debugged during the transition period. Shachar -- Shachar Shemesh Lingnu Open Source Consulting http://www.lingnu.com/ ---(end of broadcast

[HACKERS] Do we prefer software that works or software that looks good?

2004-04-23 Thread Shachar Shemesh
to make the point about readability. But if you want to argue the point with me, I'll be happy to do that for the rest of the thread. Yes, it's a well known rhetoric technique. Take whatever argument your opponent say, and exagerate it to an absurd. Shachar -- Shachar Shemesh Lingnu Open

[HACKERS] License question

2004-04-22 Thread Shachar Shemesh
license is LGPL compatible, or what I need to do in order to use it. I have already placed copyright notices copied from the file I copied the actual code from, but do I need to do anything else? Is it at all possible to do this relicensing? Shachar -- Shachar Shemesh Lingnu Open Source

Re: [HACKERS] License question

2004-04-22 Thread Shachar Shemesh
Tom Lane wrote: Shachar Shemesh [EMAIL PROTECTED] writes: In particular, the front page claims that PostgreSQL is under the BSD license. The problem is that there are two. We use the one shown in the COPYRIGHT file in the top directory of the source tree, which is also available for your

Re: [HACKERS] valgrind errors

2004-04-22 Thread Shachar Shemesh
reason of avoiding the problem you describe. Shachar -- Shachar Shemesh Lingnu Open Source Consulting http://www.lingnu.com/ ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's

Re: [HACKERS] valgrind errors

2004-04-22 Thread Shachar Shemesh
Shachar Shemesh wrote: Tom Lane wrote: I suspect valgrind is complaining because XLogInsert is memcpy'ing a struct that has allocation padding in it. Which of course is a bogus complaint ... As far as I remember (couldn't find modern documentation on the matter) Valgrind is resitant

Re: [HACKERS] License question

2004-04-22 Thread Shachar Shemesh
Neil Conway wrote: On Thu, 2004-04-22 at 09:19, Shachar Shemesh wrote: The license given in the web link you mention seems to mandate all related work to be under the same license, which is nowhere near what BSD means. What license text do you think implies this? -Neil provided

Re: [HACKERS] License question

2004-04-22 Thread Shachar Shemesh
Peter Eisentraut wrote: Shachar Shemesh wrote: Can anyone shed more light on this point for me? Am I misreading something? If it is possible to put code into an LGPL project, what is the requirement? You have to display the PostgreSQL license text in the source code or the binary

Re: [HACKERS] valgrind errors

2004-04-22 Thread Shachar Shemesh
) is copy it around, and then copy it some more, it will not. Yes, it does keep uninitialized bits over your registers. Brrr. Shachar -- Shachar Shemesh Lingnu Open Source Consulting http://www.lingnu.com/ ---(end of broadcast)--- TIP 3

Re: [HACKERS] License question

2004-04-22 Thread Shachar Shemesh
to be GPL compatible (http://www.fsf.org/licenses/license-list.html#X11License). This means I'm defnitely missing something here. What, however? Oh, or is the license in my link the NEW X11 license, known to be non-GPL compatible? -- Shachar Shemesh Lingnu Open Source Consulting http

Re: [HACKERS] valgrind errors

2004-04-22 Thread Shachar Shemesh
are merged into a single operation. In fact, that may help with getting the errors closer to the place where the actual problem resides. Then again, it may cause it to generate way more false positives. -- Shachar Shemesh Lingnu Open Source Consulting http://www.lingnu.com

Re: [HACKERS] License question

2004-04-22 Thread Shachar Shemesh
. Creating free software with conflicting licenses code is legal but highly recommended against. regards, tom lane Shachar -- Shachar Shemesh Lingnu Open Source Consulting http://www.lingnu.com/ ---(end of broadcast)--- TIP 1: subscribe

Re: [HACKERS] Remove MySQL Tools from Source?

2004-04-18 Thread Shachar Shemesh
type, for porting from SQL Server. Where should I place these? Inside the PG source seemswrong. Then again, gborg does not seem to be accepting new projects at the moment. I can put them on sourceforge/berlios etc, and ask for a link, if you like. Shachar -- Shachar Shemesh Lingnu

[HACKERS] postgres on windows page update

2004-03-23 Thread Shachar Shemesh
is extremely preliminary, though somewhat working. It is being actively developed, however, so I'm hoping to see rapid improvements there. Shachar -- Shachar Shemesh Lingnu Open Systems Consulting http://www.lingnu.com/ ---(end of broadcast

Re: [HACKERS] tinyint and type problems

2004-03-16 Thread Shachar Shemesh
Joe Conway wrote: Shachar Shemesh wrote: I'll stress again - I don't mind doing all the work associated with any once of the above choices. All I'm asking is that we agree on which one will be best for this project. As far as I'm concerned, Choice 2 involves the least amount of work, but I

[HACKERS] tinyint and type problems

2004-03-15 Thread Shachar Shemesh
it actually is later? If that would be possible, I can go on, in the mean time, with my development. The problem is that pglib really has no way of identifying the types except by OID. Shachar -- Shachar Shemesh Lingnu Open Systems Consulting http://www.lingnu.com

Re: [HACKERS] Scalable postgresql using sys_epoll

2004-03-10 Thread Shachar Shemesh
for. Shachar -- Shachar Shemesh Lingnu Open Systems Consulting http://www.lingnu.com/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[HACKERS] one byte data type

2004-03-08 Thread Shachar Shemesh
is important beyond it's legal range). Shachar -- Shachar Shemesh Lingnu Open Systems Consulting http://www.lingnu.com/ ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] one byte data type

2004-03-08 Thread Shachar Shemesh
Tom Lane wrote: Shachar Shemesh [EMAIL PROTECTED] writes: Is there a datatype that means one byte? You might be able to use the char type (note the quotes). I am not sure how well it will cope with storing zeroes (nulls) though. regards, tom lane Hmm, this will also screw up

Re: [HACKERS] OIDs, CTIDs, updateable cursors and friends

2004-02-18 Thread Shachar Shemesh
Dave Page wrote: -Original Message- From: Shachar Shemesh [mailto:[EMAIL PROTECTED] Sent: 18 February 2004 13:18 To: Hackers; PostgreSQL OLE DB development Subject: [HACKERS] OIDs, CTIDs, updateable cursors and friends Would adding OID to the rows returned by each Select call

Re: [HACKERS] OIDs, CTIDs, updateable cursors and friends

2004-02-18 Thread Shachar Shemesh
Dave Page wrote: -Original Message- From: Shachar Shemesh [mailto:[EMAIL PROTECTED] Sent: 18 February 2004 14:10 To: Dave Page Cc: Hackers; PostgreSQL OLE DB development Subject: Re: [HACKERS] OIDs, CTIDs, updateable cursors and friends I would, except I'm not sure how many queries

[HACKERS] Tom lane - your email server is broken

2004-01-25 Thread Shachar Shemesh
forward this request to your mail admin. Many thanks, Shachar -- Shachar Shemesh Lingnu Open Systems Consulting http://www.lingnu.com/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

[HACKERS] Getting the results columns before execution

2004-01-19 Thread Shachar Shemesh
with where 0 appended to it. Neither solutions seem very practical or good performance wise. Shachar -- Shachar Shemesh Lingnu Open Systems Consulting http://www.lingnu.com/ ---(end of broadcast)--- TIP 6: Have you searched our list

Re: [HACKERS] Getting the results columns before execution

2004-01-19 Thread Shachar Shemesh
Tom Lane wrote: Shachar Shemesh [EMAIL PROTECTED] writes: ... This is a problem, as merely preparing a command is not enough to get the returned rows information. Sure it is, if you are using the V3 protocol (new in 7.4). See the Describe message types. regards, tom lane Are those

Re: [HACKERS] OLE DB driver

2004-01-12 Thread Shachar Shemesh
requested a new project on gborg (pgoledb), but getting the current name is just as good. If the current code is somehow recovered, I'll be more than glad to have a look at it. After all - I don't INSIST on writing from scratch. Robert Treat Shachar -- Shachar Shemesh Lingnu Open Systems

Re: [HACKERS] OLE DB driver

2004-01-11 Thread Shachar Shemesh
William ZHANG wrote: Shachar Shemesh [EMAIL PROTECTED] wrote:[EMAIL PROTECTED] Andreas Pflug wrote: I wonder if this could be implemented as a wrapper around libpq. This way, the OLEDB driver would benefit from a proven piece of software. Regards, Andreas That's what I'm doing

Re: [HACKERS] OLE DB driver

2004-01-10 Thread Shachar Shemesh
another one? Shachar -- Shachar Shemesh Lingnu Open Systems Consulting http://www.lingnu.com/ ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do

Re: [HACKERS] OLE DB driver

2004-01-09 Thread Shachar Shemesh
of libpq at the time?). My reason is actually that I'm not a great postgres hacker, and I would rather rely as little as possible on internal structures and things that are likely to change in the future. Shachar -- Shachar Shemesh Lingnu Open Systems Consulting http

[HACKERS] OLE DB driver

2004-01-08 Thread Shachar Shemesh
to Postgresql. If anyone else has written code, was contemplating writing code, has access to the gborg project, or is otherwise interested, please let me know. I'm hoping to be able to do some sort of preliminary release in about a week. Shachar -- Shachar Shemesh Lingnu Open Systems

Re: [HACKERS] Why isn't DECLARE CURSOR ... FOR UPDATE supported?

2003-12-20 Thread Shachar Shemesh
really prefer a true solution to the problem. My question is this - how terrible will it be if we did not lock each individual column, but instead locked entire rows (as Tom suggested in the begining of this thread)? Shachar -- Shachar Shemesh Open Source integration consulting

Re: [HACKERS] [pgsql-advocacy] Not 7.5, but 8.0 ?

2003-11-18 Thread Shachar Shemesh
anyhow, or whether a commercial application using PGSQL should be considered derived work of it, mean to me that there is no problem in distributing a commercial app that uses Cygwin PostgreSQL. Shachar -- Shachar Shemesh Open Source integration consultant Home page resume

Re: [HACKERS] [pgsql-advocacy] Not 7.5, but 8.0 ?

2003-11-18 Thread Shachar Shemesh
Shachar Shemesh wrote: I'm sorry if I'm being alow here alow-slow Just wanted to avoid confusion. -- Shachar Shemesh Open Source integration consultant Home page resume - http://www.shemesh.biz/ ---(end of broadcast)--- TIP 9: the planner

[HACKERS] bidirectional cursors on views

2003-08-17 Thread Shachar Shemesh
. Can anyone comment about this? Is this problem solveable? Shachar -- Shachar Shemesh Open Source integration consultant Home page resume - http://www.shemesh.biz/ ---(end of broadcast)--- TIP 9: the planner will ignore your desire

Re: [HACKERS] bidirectional cursors on views

2003-08-17 Thread Shachar Shemesh
Tom Lane wrote: Shachar Shemesh [EMAIL PROTECTED] writes: When I try to open (using MFC) a non-forward only cursor on a view (i.e. - select * from viewname), I get an error of attribute ctid not found. There are some chances that this is an ODBC problem, but my research suggests

  1   2   >