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&#x

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 simil

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 possibilit

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-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-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 d

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... >>> >>> &

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 > bina

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 a

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 Des

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 wha

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 broadcast)

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 th

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

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

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

2007-05-19 Thread Shachar Shemesh
well enough 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 postgre

[HACKERS] PQfmod and varchars

2005-04-22 Thread Shachar Shemesh
1. Is this suspicion correct? 2. If so, how do I detect how much to subtract. 3. If not, what is the meaning of "4"? Thanks, Shachar -- Shachar Shemesh Lingnu Open Source Consulting ltd. Have you backed up today's work? http://www.lingnu.com/backup.html --

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

2005-03-20 Thread Shachar Shemesh
a lot of active projects anyways. Of the three projects that had 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 -- Sh

[HACKERS] Moving a project from gborg to pgfoundry?

2005-03-20 Thread Shachar Shemesh
Shachar -- 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] 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" param

[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

[HACKERS] Unstable timestamp binary representation?

2005-03-18 Thread Shachar Shemesh
ncoded in the same format as it was compiled 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

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

2005-03-17 Thread Shachar Shemesh
uses 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". Sha

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.

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 s

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

2005-03-16 Thread Shachar Shemesh
be a validly encoded text 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 se

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

2005-03-15 Thread Shachar Shemesh
I'll probably add code to handle all unknown types as BLOBs or something, but I cannot give 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

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 in

[HACKERS] type unknown - how important is it?

2004-09-28 Thread Shachar Shemesh
eturned type is 705, which is "unknown". 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". W

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

2004-09-21 Thread Shachar Shemesh
st. In short, I may be missing something painfully simple here, but I 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 broa

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

2004-09-20 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 u

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

2004-09-20 Thread Shachar Shemesh
hen using the results. Shachar -- Shachar Shemesh Lingnu Open Source Consulting ltd. http://www.lingnu.com/ ---(end of broadcast)--- TIP 8: explain analyze is your friend

[HACKERS] No parameters support in "create user"?

2004-09-20 Thread Shachar Shemesh
'm doing is: create user $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/ -

Re: [HACKERS] NLS support for postgreSQL

2004-08-22 Thread Shachar Shemesh
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.

[HACKERS] Compilation problems and extension on Windows

2004-08-22 Thread Shachar Shemesh
ources (8.0 beta 1). 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 -- Sh

[HACKERS] Custom type with width specifier

2004-06-27 Thread Shachar Shemesh
e width specifier into my type? I'm not even sure what function 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.

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 varcha

[HACKERS] Casts question

2004-06-17 Thread Shachar Shemesh
nd that the cast from varchar to varcharci is "as assignment" anyways, shouldn't 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]

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

2004-06-17 Thread Shachar Shemesh
n 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] Using domains for case insensitivity

2004-06-17 Thread Shachar Shemesh
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

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
le of places (say, hash computation 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

[HACKERS] OIDs, CTIDs, updateable cursors and friends

2004-06-03 Thread Shachar Shemesh
d. Are these correct? 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?

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

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

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

2004-05-12 Thread Shachar Shemesh
be on that list. 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] tinyint

2004-05-10 Thread Shachar Shemesh
build from. You 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
CU if you are admin. It makes 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 Shac

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 t

Re: [HACKERS] Relocatable installs

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

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

2004-05-06 Thread Shachar Shemesh
spect, however, that's precisely what PostgreSQL is doing if one is not active. Assuming the OLE DB user uses the Transaction interface, and does not send a "begin" command, I'm capable of knowing whether I'm inside 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

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

[HACKERS] Multiple "selects" returned from a single stored procedure

2004-05-05 Thread Shachar Shemesh
led parameters, and return a rowset, please let me know. Best I 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

Re: [HACKERS] Bringing PostgreSQL torwards the standard regarding

2004-04-27 Thread Shachar Shemesh
peful tone?) 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/ ---(e

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

2004-04-26 Thread Shachar Shemesh
etting, yes. 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 Shemes

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

2004-04-26 Thread Shachar Shemesh
e concensus was that the runtime part was aprox. four lines where the case folding 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 Con

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

2004-04-26 Thread Shachar Shemesh
ets involved 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&

[HACKERS] License question

2004-04-26 Thread Shachar Shemesh
/Downloads_terms.html), 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. -

Re: [HACKERS] Bringing PostgreSQL torwards the standard regarding

2004-04-25 Thread Shachar Shemesh
roblem is that "lower" is defined in template1. If we don't uppercase it when we create 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

[HACKERS] Bringing PostgreSQL torwards the standard regarding case folding

2004-04-25 Thread Shachar Shemesh
. As such, maybe it's best to just leave the data 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://

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

2004-04-24 Thread Shachar Shemesh
a way 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 broa

Re: [HACKERS] The case for preserving case.

2004-04-24 Thread Shachar Shemesh
an't help you there, unless you want to compile Postgres yourself. 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
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 o

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

2004-04-24 Thread Shachar Shemesh
;s just that I don't think this is a big issue, given the fact that I don't 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

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

2004-04-23 Thread Shachar Shemesh
ving a lesser quality driver to seeing ugly uppercase. regards, tom lane 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 of the thread. Yes, it

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

2004-04-23 Thread Shachar Shemesh
ails, fold lower. 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/ ---

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

2004-04-23 Thread Shachar Shemesh
G to standard compliency. I find these issues legitimate, though solveable. Getting a "we prefer 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

Re: [HACKERS] License question

2004-04-22 Thread Shachar Shemesh
at noone except me can touch this project without removing the BSD code (or relicensing, but I'm assuming here I accept your claim that I cannot relicense), except me. Creating free software with conflicting licenses code is legal but highly recommended against. regards, tom lane Shachar

Re: [HACKERS] valgrind errors

2004-04-22 Thread Shachar Shemesh
at the point where uninitialized and initialized data 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 L

Re: [HACKERS] License question

2004-04-22 Thread Shachar Shemesh
ttp://www.x.org/Downloads_terms.html), which is interpreted by the FSF 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

Re: [HACKERS] valgrind errors

2004-04-22 Thread Shachar Shemesh
from it, valgrind will complain. If all you do (as in your example) 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 ht

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] 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] 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 resita

Re: [HACKERS] valgrind errors

2004-04-22 Thread Shachar Shemesh
for the explicit 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 y

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 availab

[HACKERS] License question

2004-04-22 Thread Shachar Shemesh
reSQL 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 S

Re: [HACKERS] Remove MySQL Tools from Source?

2004-04-18 Thread Shachar Shemesh
fined 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 L

[HACKERS] postgres on windows page update

2004-03-23 Thread Shachar Shemesh
t;" section. Current status 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.lingn

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 a

Re: [HACKERS] tinyint and type problems

2004-03-15 Thread Shachar Shemesh
uble. This is a database system, not a C programming language. People who need the extra range can use the NUMBER type. I also don't see the use for a signed 1 byte type - its range is too small in both direction. Shachar -- Shachar Shemesh Lingnu Open Systems Consulting http:/

[HACKERS] tinyint and type problems

2004-03-15 Thread Shachar Shemesh
e) into postgres. If this is impossible, would it be at least possible to reserve an OID for this type, and decide what 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

Re: [HACKERS] Scalable postgresql using sys_epoll

2004-03-10 Thread Shachar Shemesh
s available 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]

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 Hm

[HACKERS] one byte data type

2004-03-08 Thread Shachar Shemesh
of the variable 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] 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 qu

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 &quo

[HACKERS] Tom lane - your email server is broken

2004-01-25 Thread Shachar Shemesh
lp me out with this, or at least 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,

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

[HACKERS] Getting the results columns before execution

2004-01-19 Thread Shachar Shemesh
mmand 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 se

Re: [HACKERS] OLE DB driver

2004-01-12 Thread Shachar Shemesh
said, there doesn't appear to be any old code to maintain. I have 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 fr

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&

Re: [HACKERS] OLE DB driver

2004-01-10 Thread Shachar Shemesh
dead. Should I open 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 colum

Re: [HACKERS] OLE DB driver

2004-01-09 Thread Shachar Shemesh
native Windows port 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 Ope

[HACKERS] OLE DB driver

2004-01-08 Thread Shachar Shemesh
connect 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 Ling

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

2003-12-20 Thread Shachar Shemesh
lation - a performance/memory tradeoff), but I would 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)? Shach

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)--- T

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

2003-11-18 Thread Shachar Shemesh
tion of whether they have any claim on Posix utilities 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 Shemes

  1   2   >