Re: [HACKERS] [Monotone-devel] Re: SCMS question

2007-02-25 Thread Warren Turkal
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


Re: [HACKERS] [Monotone-devel] Re: SCMS question

2007-02-25 Thread Warren Turkal
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] PGSQL and NPGSQL does not display exact errors

2007-02-25 Thread Hiroshi Saito

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

2007-02-25 Thread Tom Lane
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

2007-02-25 Thread 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


Re: [HACKERS] [Monotone-devel] Re: SCMS question

2007-02-25 Thread Warren Turkal
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] SCMS question

2007-02-25 Thread Matthew D. Fuller
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

2007-02-25 Thread Matthew D. Fuller
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: [Monotone-devel] Re: [HACKERS] SCMS question

2007-02-25 Thread Neil Conway
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

2007-02-25 Thread Andrew Dunstan



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: [HACKERS] SCMS question

2007-02-25 Thread Neil Conway
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

2007-02-25 Thread Matthew D. Fuller
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] error in cvs head: bogus varattno for OUTER var: 5

2007-02-25 Thread Tom Lane
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] help required regarding queryin postgis database from google maps

2007-02-25 Thread Andrew Dunstan



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: [Monotone-devel] Re: [HACKERS] SCMS question

2007-02-25 Thread hendrik
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


[HACKERS] help required regarding queryin postgis database from google maps

2007-02-25 Thread Phani Kishore
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

2007-02-25 Thread Richard Levitte - VMS Whacker
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


Re: [Monotone-devel] Re: [HACKERS] SCMS question

2007-02-25 Thread Richard Levitte - VMS Whacker
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

2007-02-25 Thread hendrik
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: [HACKERS] [Monotone-devel] Re: SCMS question

2007-02-25 Thread Andrew Dunstan

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


[HACKERS] PGSQL and NPGSQL does not display exact errors

2007-02-25 Thread RPK

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] error in cvs head: bogus varattno for OUTER var: 5

2007-02-25 Thread Jeremy Drake
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


Re: [HACKERS] error in cvs head: bogus varattno for OUTER var: 5

2007-02-25 Thread Tom Lane
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