Re: [HACKERS] error in cvs head: bogus varattno for OUTER var: 5
Jeremy Drake [EMAIL PROTECTED] writes: psql:bogus_varattno_error.sql:23: ERROR: bogus varattno for OUTER var: 5 Any ideas what is causing this? This looks pretty nearly related to stuff I've been hacking on recently, so I suppose I broke something :-(. Will take a closer look tomorrow. regards, tom lane ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] error in cvs head: bogus varattno for OUTER var: 5
On Sun, 25 Feb 2007, Tom Lane wrote: Jeremy Drake [EMAIL PROTECTED] writes: psql:bogus_varattno_error.sql:23: ERROR: bogus varattno for OUTER var: 5 Any ideas what is causing this? This looks pretty nearly related to stuff I've been hacking on recently, so I suppose I broke something :-(. Will take a closer look tomorrow. This should help. I managed to whiddle the example down even further. CREATE TABLE a ( a_a text ); CREATE TABLE b ( b_a text ); CREATE TABLE b_chld () INHERITS (b); EXPLAIN SELECT a_a FROM a LEFT JOIN b ON a_a = lower(b_a); Results in: ERROR: bogus varattno for OUTER var: 2 The function call and the inheritance are both required, remove either and it works fine. -- This is the LAST time I take travel suggestions from Ray Bradbury! ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
[HACKERS] PGSQL and NPGSQL does not display exact errors
PGSQL and NPGSQL does not display exact error while using with VB.NET. We faced a lot of trouble to find out actually where an error occured. For example in a routine we need to insert a record to the table. I forgot to use values clause in the Insert Query, but PGSQL displayed error No source code available in the routine where we opened the connection. Whereas, Oracle displayed exact error that Invalid Insert statement. There are many such situation where we remained puzzled and later found error somewhere else. -- View this message in context: http://www.nabble.com/PGSQL-and-NPGSQL-does-not-display-exact-errors-tf3286839.html#a9142659 Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] [Monotone-devel] Re: SCMS question
Joshua D. Drake wrote: He didn't say *which* dev cycle. He is just enthusiastic and the reality is this project is about 2 years overdue to run screaming from the burning building that is CVS. Does that mean we should change? Only if the people doing development feel a need to change. However, there is a distinct feeling of *OMG CHANGE RUN RUN* whenever it comes to anything infrastructure (and frankly some parts of code) in this project. It is certainly valid that, if it ain't broke don't fix it. CVS is not broke for us, it is however barely maintained. That in itself is enough to consider moving off. The fact that SVN *is* a CVS replacement and does not change most of the workflow of existing developers is an additional strong argument to use it. Joshua, In my case at least you are 180 degrees wrong. The reason I want to wait is that I don't want the replacement to be svn. Why go throught the pain of adjustment just to be in more or less the same place? That's why I encouraged you to try setting up some mirrors to other systems, notably Mercurial which looks to very promising. (It's written in Python, and has a Trac plugin - it should appeal to you strongly). cheers andrew ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [Monotone-devel] Re: [HACKERS] SCMS question
On Fri, Feb 23, 2007 at 10:42:13AM -0300, Alvaro Herrera wrote: Richard Levitte - VMS Whacker wrote: In message [EMAIL PROTECTED] on Fri, 23 Feb 2007 07:57:53 +0100, Markus Schiltknecht [EMAIL PROTECTED] said: markus Uh, yah. But I was refering to the lots of opinions on what markus replacement system to use. This has not much to do with the markus want or need (for lack of a better alternative) to stay with markus CVS, IMO. Oh, it's an academic discussion? Sorry, didn't catch that. It's only academic because Monotone is not ready. As soon as it is ready we will be pushing much harder. This invites the obvious question -- in which ways in monotone not ready? Not that I'm trying to imply that monotone *is* ready, of course. -- hendrik ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [Monotone-devel] Re: [HACKERS] SCMS question
In message [EMAIL PROTECTED] on Fri, 23 Feb 2007 07:57:53 +0100, Markus Schiltknecht [EMAIL PROTECTED] said: markus Uh, yah. But I was refering to the lots of opinions on what markus replacement system to use. This has not much to do with the markus want or need (for lack of a better alternative) to stay with markus CVS, IMO. Oh, it's an academic discussion? Sorry, didn't catch that. Cheers, Richard - Please consider sponsoring my work on free software. See http://www.free.lp.se/sponsoring.html for details. -- Richard Levitte [EMAIL PROTECTED] http://richard.levitte.org/ When I became a man I put away childish things, including the fear of childishness and the desire to be very grown up. -- C.S. Lewis ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [Monotone-devel] Re: [HACKERS] SCMS question
In message [EMAIL PROTECTED] on Fri, 23 Feb 2007 10:42:13 -0300, Alvaro Herrera [EMAIL PROTECTED] said: alvherre Richard Levitte - VMS Whacker wrote: alvherre In message [EMAIL PROTECTED] on Fri, 23 Feb 2007 07:57:53 +0100, Markus Schiltknecht [EMAIL PROTECTED] said: alvherre alvherre markus Uh, yah. But I was refering to the lots of alvherre markus opinions on what replacement system to use. This alvherre markus has not much to do with the want or need (for lack alvherre markus of a better alternative) to stay with CVS, IMO. alvherre alvherre Oh, it's an academic discussion? Sorry, didn't catch that. alvherre alvherre It's only academic because Monotone is not ready. As soon alvherre as it is ready we will be pushing much harder. You know, I wasn't trying to push any SCM in particular, even though I did mention monotone in one post. Cheers, Richard - Please consider sponsoring my work on free software. See http://www.free.lp.se/sponsoring.html for details. -- Richard Levitte [EMAIL PROTECTED] http://richard.levitte.org/ When I became a man I put away childish things, including the fear of childishness and the desire to be very grown up. -- C.S. Lewis ---(end of broadcast)--- TIP 6: explain analyze is your friend
[HACKERS] help required regarding queryin postgis database from google maps
hi ! i think u people could probably help me i how to query the pgsql/postgis from google maps api to display the markers on the google maps which are stored in the postgis database. Phani Kishore Tata Consultancy Services Mailto: [EMAIL PROTECTED] Website: http://www.tcs.com =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you
Re: [Monotone-devel] Re: [HACKERS] SCMS question
On Fri, Feb 23, 2007 at 11:28:07AM -0300, Alvaro Herrera wrote: [EMAIL PROTECTED] wrote: On Fri, Feb 23, 2007 at 10:42:13AM -0300, Alvaro Herrera wrote: Richard Levitte - VMS Whacker wrote: In message [EMAIL PROTECTED] on Fri, 23 Feb 2007 07:57:53 +0100, Markus Schiltknecht [EMAIL PROTECTED] said: markus Uh, yah. But I was refering to the lots of opinions on what markus replacement system to use. This has not much to do with the markus want or need (for lack of a better alternative) to stay with markus CVS, IMO. Oh, it's an academic discussion? Sorry, didn't catch that. It's only academic because Monotone is not ready. As soon as it is ready we will be pushing much harder. This invites the obvious question -- in which ways in monotone not ready? Not that I'm trying to imply that monotone *is* ready, of course. Time to get the initial pull is too long, mostly. Also, having the policy branch stuff will be good, if nothing else because it'll mean having 1.0 out, in turn meaning UI stability, etc. And getting Markus' work on the CVS import will be good too (I haven't tried converting Postgres' entire CVS repo in a while, and that certainly is a must). I don't think we're going to get a one-shot migration, so Cristof's work on CVS takeover would be really nice to have so that some of us can create an alternative repo and cater for those that will continue to use CVS for a while. Yes, interoperability with other revision management systems is a problem for all of the revision management systems. It might be de-facto-solved it one system manages to talk effectively to the important other ones -- it won't be solved permanantly until there are adequate standard, system-independent protocols ... I don't see that coming soon. And there;s the problem of welcoming the prodigal son. A file gets away from the revision management system, and. much later, returns, much changed from the experience. How should we slot it back into the system? -- hendrik ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] help required regarding queryin postgis database from google maps
Phani Kishore wrote: hi ! i think u people could probably help me i how to query the pgsql/postgis from google maps api to display the markers on the google maps which are stored in the postgis database. Phani Kishore Tata Consultancy Services Mailto: [EMAIL PROTECTED] Website: http://www.tcs.com This list is not about how to use postgres. Please ask in the correct forum. cheers andrew ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] error in cvs head: bogus varattno for OUTER var: 5
Jeremy Drake [EMAIL PROTECTED] writes: On Sun, 25 Feb 2007, Tom Lane wrote: This looks pretty nearly related to stuff I've been hacking on recently, so I suppose I broke something :-(. Will take a closer look tomorrow. This should help. I managed to whiddle the example down even further. Pure brain fade :-(. Fix committed. regards, tom lane ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] [Monotone-devel] Re: SCMS question
On Sat, Feb 24, 2007 at 10:27:38PM -0500 I heard the voice of Andrew Dunstan, and lo! it spake thus: This decision really belongs to the handful of people who do most of the maintenance and live with most of any CVS pain that exists: such as Tom, Bruce, Peter, Neil, Alvaro. Othe people have a right to voice an opinion, but nobody should be pushing on it. One thing that the DVCS crowd pushes is that that's _not_ the whole story. With CVS (or other centralized systems), the VCS is a development tool for the few core people, and a glorified FTP/snapshotting system for everyone else. With a DVCS, _everybody_ gets a development tool out of it. ObBias: After much resistance, I drank the distributed Kool-Aid. My poison of choice is bzr, which is very probably not ready performance-wise for Pg. So, I also look forward to a switch happening not now, but in a year or two, when the performance failings are historical and bzr can be chosen 8-} -- Matthew Fuller (MF4839) | [EMAIL PROTECTED] Systems/Network Administrator | http://www.over-yonder.net/~fullermd/ On the Internet, nobody can hear you scream. ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] SCMS question
On Fri, 2007-02-23 at 18:02 -0500, Tom Lane wrote: Yah know, the one bit of these pitches that always sounds like pure snake oil is the claim that they offer some kind of mechanical solution to merge conflicts. AFAICS that has nothing to do with the SCMS in use and everything to do with whether your diff command is AI-complete. Did you do any research to support that assertion? The nature and quality of the merge algorithm used actually differs significantly between SCMs. The ability to do history-sensitive merges actually results in a significant reduction in the need for manual conflict resolution. For one example among many, see the discussion around a new proposed merge algorithm for Codeville: http://lists.zooko.com/pipermail/revctrl/2005-May/05.html http://revctrl.org/PreciseCodevilleMerge Or the Mark Merge algorithm used by Monotone: http://monotone.ca/docs/Mark_002dMerge.html http://revctrl.org/MarkMerge Claiming that all this amounts to snake oil is plainly wrong, I think. I note also that CVS does have the ability to merge changes across branches, we just choose not to use it that way. As far as I know, CVS does not provide a way to do a 3-way merge without considerable manual effort (e.g. using a standalone tool to do the actual merge). -Neil ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [HACKERS] [Monotone-devel] Re: SCMS question
Matthew D. Fuller wrote: On Sat, Feb 24, 2007 at 10:27:38PM -0500 I heard the voice of Andrew Dunstan, and lo! it spake thus: This decision really belongs to the handful of people who do most of the maintenance and live with most of any CVS pain that exists: such as Tom, Bruce, Peter, Neil, Alvaro. Othe people have a right to voice an opinion, but nobody should be pushing on it. One thing that the DVCS crowd pushes is that that's _not_ the whole story. With CVS (or other centralized systems), the VCS is a development tool for the few core people, and a glorified FTP/snapshotting system for everyone else. With a DVCS, _everybody_ gets a development tool out of it. I don't really drink this koolaid, at least not to the extent of disavowing what I said above. There might well be good reasons for using a distributed SCM system, and if you look elsewhere in this thread you'll see me eyeing Mercurial, which is one such, quite favorably, and stating quite definitely that I hope we don't move to Subversion, which would be the main centralised alternative. But no matter what system is used, there will be a smallish number who will maintain the branches that bear our name, and I still think they are the people with the principal responsibility in the matter. I'm more interested in making things as easy as possible for Tom and Bruce than I am for anyone else. cheers andrew ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [Monotone-devel] Re: [HACKERS] SCMS question
On Thu, 2007-02-22 at 14:49 -0300, Alvaro Herrera wrote: For example, currently if I have a patch and somebody reviews it and opines that I have to change foo to bar; then I resubmit the patch. How do they find out whether I actually changed foo to bar? Currently there are two alternatives: 1. trust that I did it 2. review the whole patch again Or use interdiff, and then review the incremental changes. BTW, I think an important benefit of switching to a distributed SCM is that it could make life significantly simpler for people maintaining long-lived branches of the Postgres source. That includes both individual developers working on complex features, but also companies that maintain a branch/fork of the Postgres source for one reason or another. At the moment, this requires considerable manual effort: people often end up manually importing periodic snapshots of the upstream Postgres source into their SCM system at various times, and then merging the changes with their private tree by hand. Personally, I'd definitely be in favour of evaluating the alternative SCMs, and switching *at some point*, although it may be that none of the alternatives are mature enough for us to switch yet. In the past, I've converted the Postgres CVS tree to both darcs and monotone. Darcs was completely unusable: even though I didn't import the initial CVS revision history, after a few months of merging in upstream fixes via Tailor, the merging process began to take days of CPU time (before I killed it off). So unless the Darcs algorithms change fundamentally from the 1.0.4-era approach, I don't think it would be scalable enough for us. Monotone worked pretty well -- I'd include it in the set of plausible SCM candidates, along with Mercurial. I agree with Andrew that there's not much to be gained by switching to SVN. -Neil ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] [Monotone-devel] Re: SCMS question
On Sun, Feb 25, 2007 at 06:28:20PM -0500 I heard the voice of Andrew Dunstan, and lo! it spake thus: I don't really drink this koolaid, at least not to the extent of disavowing what I said above. Oh, don't take my message as You're wrong, you're not taking into account [...]. It was meant more as a This is a convenient place to make [...] explicit. It seems that there are really 3 sequential questions here. 1) Do we switch VCS's? The averaged answer to this is pretty much Probably, but not right now, and not in the very near future. Given that, the rest of the discussion is probably somewhat pointless; at the least it should be carried out with this answer kept firmly in mind. 2) Do we go the DVCS route?, and only after THAT is resolved do we go on to: 3) Which VCS? The feature/capability lists of the various DVCS's contain a mix of those features which are inherent in (or at least pretty much universal among) DVCS's as a class, and those which are more particular to the given system. But in a discussion of which VCS to (hypothetically) use, you really want to separate them out so you can know when you're arguing for/against $SYSTEM, and when you're arguing for/against $CLASS_OF_SYSTEMS. -- Matthew Fuller (MF4839) | [EMAIL PROTECTED] Systems/Network Administrator | http://www.over-yonder.net/~fullermd/ On the Internet, nobody can hear you scream. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] SCMS question
On Sun, Feb 25, 2007 at 06:06:57PM -0500 I heard the voice of Neil Conway, and lo! it spake thus: The ability to do history-sensitive merges actually results in a significant reduction in the need for manual conflict resolution. I would say that a far greater contributor in practice would simply be frequency. If you diverge on your significant feature for 6 months, then try to merge in upstream changes from the main dev, you will be in hell no matter what merge algorithm you use. If you merge in upstream changes every few days, however, you will have many fewer and much simplier conflicts to deal with. A VCS that makes frequent merges easy results in easier conflict handling, not by some magical auto-resolution, but just by letting you do it in ongoing regular and small bites. -- Matthew Fuller (MF4839) | [EMAIL PROTECTED] Systems/Network Administrator | http://www.over-yonder.net/~fullermd/ On the Internet, nobody can hear you scream. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] [Monotone-devel] Re: SCMS question
On Saturday 24 February 2007 23:11, Tom Lane wrote: I also tend to think that a conversion will be easier in a year or two than it is today --- the problems noted upthread are certainly a heads-up that cvs2svn is not yet as robust as one could wish. Cvs2svn seems to make as much sense of CVS data as possible. The only real problem I have seen is with regard to the malformed files I mentioned earlier. I haven't seen any other concrete examples. Could someone fix the previously mentioned files in the CVS respository to be valid? After fixing those files, I get no messages during import except that some commit comments appear to be in some encoding other than ascii. I am in the middle of checking commits involving those files to make sure they make sense. wt -- Warren Turkal (w00t) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] PGSQL and NPGSQL does not display exact errors
RPK wrote: PGSQL and NPGSQL does not display exact error while using with VB.NET. We faced a lot of trouble to find out actually where an error occured. For example in a routine we need to insert a record to the table. I forgot to use values clause in the Insert Query, but PGSQL displayed error No source code available in the routine where we opened the connection. Whereas, Oracle displayed exact error that Invalid Insert statement. There are many such situation where we remained puzzled and later found error somewhere else. You should make sure and check the postgresql logs at all times. They are the definitive source for anything you are trying to do. If PostgreSQL doesn't report an error, you know the problem is in your code. Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] [Monotone-devel] Re: SCMS question
Warren Turkal [EMAIL PROTECTED] writes: On Saturday 24 February 2007 23:11, Tom Lane wrote: I also tend to think that a conversion will be easier in a year or two than it is today --- the problems noted upthread are certainly a heads-up that cvs2svn is not yet as robust as one could wish. Cvs2svn seems to make as much sense of CVS data as possible. The only real problem I have seen is with regard to the malformed files I mentioned earlier. I haven't seen any other concrete examples. It was mentioned upthread that Josh has seen repeated problems with his conversions. I too would like to see some details about that. One thing that I personally would find to be a showstopper for any proposed switch is if it fails to maintain our change histories; in particular, if it's not still possible to pull an exact copy of any given prior release, it'll be no sale. I gather from this thread that svn has by far the closest storage model to cvs of any of the available alternatives ... so if svn has conversion problems, what's it gonna be like with another one? regards, tom lane ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] PGSQL and NPGSQL does not display exact errors
Hi.
Um, I think it is difficult for those messages to be standardized...Certainly different each
DBMS expression makes the user often puzzled. Then, As for each DBMS, the history
of evolution was different. That is, they were not able to share architecture.
Please see the following message.
1.) ORACLE database 10g Express Edition
INSERT INTO saito ('Hiroshi','dummy');
ORA-00928 missing SELECT keyword
2.) SQLServer 2005 Express
INSERT INTO saito ('Hiroshi','dummy')
Incorrect syntax near ')'.
3.) PostgreSQL 8.2.3
INSERT INTO saito ('Hiroshi','dummy');
ERROR: syntax error at or near 'Hiroshi' at character 20
LINE 1: INSERT INTO saito ('Hiroshi','dummy');
^
Therefore, It is seen the expression that PostgreSQL is the best now when comparing it.
P.S)
BTW, The mailing list of Npgsql is here.
http://pgfoundry.org/mailman/listinfo/npgsql-devel
regards,
Hiroshi Saito
From: Joshua D. Drake
RPK wrote:
PGSQL and NPGSQL does not display exact error while using with VB.NET. We
faced a lot of trouble to find out actually where an error occured.
For example in a routine we need to insert a record to the table. I forgot
to use values clause in the Insert Query, but PGSQL displayed error No
source code available in the routine where we opened the connection.
Whereas, Oracle displayed exact error that Invalid Insert statement.
There are many such situation where we remained puzzled and later found
error somewhere else.
You should make sure and check the postgresql logs at all times. They
are the definitive source for anything you are trying to do. If
PostgreSQL doesn't report an error, you know the problem is in your code.
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Re: [HACKERS] [Monotone-devel] Re: SCMS question
On Sunday 25 February 2007 23:23, Tom Lane wrote: It was mentioned upthread that Josh has seen repeated problems with his conversions. I too would like to see some details about that. One thing that I personally would find to be a showstopper for any proposed switch is if it fails to maintain our change histories; in particular, if it's not still possible to pull an exact copy of any given prior release, it'll be no sale. I gather from this thread that svn has by far the closest storage model to cvs of any of the available alternatives ... so if svn has conversion problems, what's it gonna be like with another one? With atomic commits, the exports from svn to other SCMSes seem to work better than from cvs to svn (or any other for that matter). I believe the reason is that you have to infer the commits in cvs whereas it is explicit in the other systems. To convert to git, for instance, I converted to svn and then imported that. wt -- Warren Turkal (w00t) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] [Monotone-devel] Re: SCMS question
On Sunday 25 February 2007 23:23, Tom Lane wrote: It was mentioned upthread that Josh has seen repeated problems with his conversions. I am manually inspecting the diff between CVS tag REL_8_1_0 and SVN tag tags/REL_8_1_0/pgsql, and I am not finding any differences in code short of the $Id$-type keyword lines. However, I am having a problem with encodings in some of the files. How does cvs handle files with different encodings? For instance, it looks like the Chinese documentation gets messed up upon svn conversion. wt -- Warren Turkal (w00t) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
