I just did a fresh build from current cvs and found the following
regression from 7.2:
create table test (cola bigint);
update test set cola = 100;
In 7.3 the update results in the following error:
ERROR: column "cola" is of type 'bigint' but expression is of type
'double precision'
Tom Lane wrote:
> Joe Conway <[EMAIL PROTECTED]> writes:
>>... I have not started RescanExprContext() yet, but will do it
>>when I address rescans in general.
>
>>I still have a couple of issues related to VIEWs that I need to figure
>>out, then I'll start the rescan work.
>
> It's not unlikel
Joe Conway <[EMAIL PROTECTED]> writes:
> ... I have not started RescanExprContext() yet, but will do it
> when I address rescans in general.
> I still have a couple of issues related to VIEWs that I need to figure
> out, then I'll start the rescan work.
It's not unlikely that those issues are
Tom Lane wrote:
> Um. I don't like that; it assumes not only that ExecutorEnd is the only
> kind of callback needed, but also that there is at most one function
> per ExprContext that needs a shutdown callback. Neither of these
> assumptions hold water IMO.
>
> The design I had in mind was more
[Cc:ed to hackers]
(trying select convert(lower(convert('X', 'LATIN1')),'LATIN1','UNICODE');)
> Ok, this is working now (I cann't reproduce why not at the first time).
Good.
> Is it planned to implement it so that I can write lower()/ upper() for multibyte
> according to SQL standard (without
Jan Wieck wrote:
>
> Hiroshi Inoue wrote:
> > Tom Lane wrote:
> > >
> >
> > What should the backends return for complicated rewrites ?
> > And how should/could clients handle the results ?
> > It doesn't seem easy to me and it seems a flaw of rule
> > system. Honestly I don't think that the psqlod
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> HPUX's behaviour is broken, because in spanish LL (as well as CH)
> stopped being a special symbol some five years ago (it used to be
> treated as one collating element sorted after "L", so HPUX behaviour was
> right then).
Well, this is an old release
Tom Lane escribió:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > The assumption here is that all locales will choose the same sort order as
> > long as they're dealing only with the core 26 letters.
>
> Nope. For instance, on HPUX I get this sort order in English:
[...]
> because the Sp
Hannu Krosing <[EMAIL PROTECTED]> writes:
> Was it not the case that lazy vacuum had problems freeing tuples that
> have toasted fields ?
News to me if so.
regards, tom lane
---(end of broadcast)---
TIP 4: Don't 'kill -9' t
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> For that purpose I have changed the permissions on these options to
> USERSET. (I'm still debating making lc_messages SUSET, because otherwise
> users can screw with admins by changing the language of the log output all
> the time. Comments?)
Hm.
On Thu, 2002-05-09 at 14:21, Mark kirkwood wrote:
> On Wed, 2002-05-08 at 01:45, Tom Lane wrote:
>
> > Which files grew exactly? (Main table, indexes, toast table, toast index?)
>
> Here a listing (from another run - I dumped and reloaded before getting
> any of that info last time...)
>
>
>
On Sat, 2002-05-11 at 02:25, Peter Eisentraut wrote:
> The remaining issue is the sort order. I think this can be solved for
> practical purposes by creating two expected files for each affected test,
> say char.out and char-locale.out. The regression test driver would try
> the first one, if th
On Sat, 2002-05-11 at 02:25, mlw wrote:
> A binary version of PostgreSQL for Windows should not use the cygwin dll. I
> know and understand there is some disagreement with this position, but in this
> I'm sure about this.
...
> I believe we can use the cygwin development environment, and direct
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> The assumption here is that all locales will choose the same sort order as
> long as they're dealing only with the core 26 letters. This does not have
> to be true in theory, but I think it works for the vast majority of
> practical cases.
Not for
> Hi everybody,
> I'm a hookie in this discussion list. Well, my intent is to get some
> informations about PostgreSQL internals to work on a project. There
> is an excellent GPL'ed tool to work with Oracle called TOra. It is as
> good as TOAD and SQL Navigator from Quest Software. As a meaning o
A binary version of PostgreSQL for Windows should not use the cygwin dll. I
know and understand there is some disagreement with this position, but in this
I'm sure about this.
The tools used to create the binary need not be Microsoft, many venders have
used Borland or Watcom, the run of the mill
Since locale support is now enabled by default, it is desirable that the
regression tests can pass if the clusters locale is not C.
As a first step I have included the following statements in pg_regress
right after the database is created:
alter database "$dbname" set lc_messages to 'C';
alter d
Hi everybody,
I'm a hookie in this discussion list. Well, my intent is to get some informations
about
PostgreSQL internals to work on a project. There is an excellent GPL'ed tool to work
with Oracle
called TOra. It is as good as TOAD and SQL Navigator from Quest Software. As a meaning
of
colla
On Fri, May 10, 2002 at 09:13:20PM +0200, Peter Eisentraut wrote:
> Nigel J. Andrews writes:
>
> > BTW, I had been wondering what to call the Schema tab now that that label is
> > required for schemas rather than design.
>
> "Design"?
Thought about it, but it seems to 'active' for what's behind
Tom Lane wrote:
> Jan Wieck <[EMAIL PROTECTED]> writes:
> >> Hmm. So your vision of PREPARE would allow the backend to reply
> >> with a list of parameter types. How would you envision that working
> >> exactly?
>
> > I guess there's some sort of statement identifier you use to
> > refe
Nigel J. Andrews writes:
> BTW, I had been wondering what to call the Schema tab now that that label is
> required for schemas rather than design.
"Design"?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checke
Joe Conway <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Adding a list of callbacks to
>> ExprContext seems pretty reasonable, but you'd also need some link in
>> ReturnSetInfo to let the function find the ExprContext to register
>> itself with. Then FreeExprContext would call the callbacks.
Tom Lane wrote:
> I don't much care for the thought of trawling every expression tree
> looking for functions-returning-set during plan shutdown, so the thought
> that comes to mind is to expect functions that want a shutdown callback
> to register themselves somehow. Adding a list of callbacks t
Mark kirkwood <[EMAIL PROTECTED]> writes:
>> Was the FSM size parameter set large enough to cover the amount of space
>> you need the system to be able to recycle --- viz, the amount used
>> between vacuum runs? As with most everything else in PG, the default
>> value is not real large: 1 pag
Jan Wieck <[EMAIL PROTECTED]> writes:
>> Hmm. So your vision of PREPARE would allow the backend to reply
>> with a list of parameter types. How would you envision that working
>> exactly?
> I guess there's some sort of statement identifier you use to
> refer to something you've prepare
Tom Lane wrote:
> Jan Wieck <[EMAIL PROTECTED]> writes:
> > There are DB interfaces that allow a generic application to
> > get a description of the result set (column names, types)
> > even before telling the data types of all parameters.
>
> > Our ODBC driver for example
Tom Lane wrote:
>
> mlw <[EMAIL PROTECTED]> writes:
> > Without some buy-in from the core team, I'm not sure I am willing to spend my
> > time on it. If someone would be willing to fund the 100 or so man-hours
> > required to do it, then that would be a different story.
>
> You are not going to
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Lane
> Sent: Friday, May 10, 2002 12:31 PM
> To: Dave Page
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: [HACKERS] FW: Cygwin PostgreSQL Information and Suggestions
>
>
>
> "Dave Page" <
> > 1. Cygwin's setup.exe supports categories and dependencies.
> > Hence, there is no reason to install all Cygwin packages in
> > order to ensure properly PostgreSQL operation. Someone just
> > has to determine what is the minimal set of packages
> > necessary for PostgreSQL and I will update t
"Dave Page" <[EMAIL PROTECTED]> forwards:
> 4. Cygwin PostgreSQL is perceived to have poor performance. I have
> never done any benchmarks regarding this issue, but apparently Terry
> Carlin (from the defunct Great Bridge) did:
> http://archives.postgresql.org/pgsql-cygwin/2001-08/msg00029.p
On Fri, May 10, 2002 at 11:17:39AM -0400, Tom Lane wrote:
> Jan Wieck <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> For this particular application, at least, I do not see the value ...
> >> in fact this seems more likely to break stuff than help. If the
> >> application does not know what
mlw <[EMAIL PROTECTED]> writes:
> Without some buy-in from the core team, I'm not sure I am willing to spend my
> time on it. If someone would be willing to fund the 100 or so man-hours
> required to do it, then that would be a different story.
You are not going to get any buy-in with such ridicu
On Fri, 10 May 2002 10:58:28 +0200
"Iavor Raytchev" <[EMAIL PROTECTED]> wrote:
> Hello everybody,
>
> After Marc Fournier commented, it is time for pgaccess.org to make a
> decision.
>
> It is clear the project needs the following tools.
>
> - web site
> - mailing list(s)
> - cvs
> - bug track
Jan Wieck <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> For this particular application, at least, I do not see the value ...
>> in fact this seems more likely to break stuff than help. If the
>> application does not know what the datatypes are supposed to be,
>> how is it going to call the pr
Hannu Krosing <[EMAIL PROTECTED]> writes:
> The problem seems to be that recent changes broke updatable views for a
> few users. So have these basic options:
> 1. revert the changes until we have a consensus on doing the right thing
>(seems best to me)
Reverting is not an option, unless you
Jan Wieck <[EMAIL PROTECTED]> writes:
> IMHO the answer should only be a number if the rewritten
> querytree list consists of one query of the same command
> type. everything else has to lead into "unknown".
I think you can easily generalize that to the statement that the
r
> Then what is the point?
We need more information about Cygwin. See Jason Tishler mail forwarded by
Dave Page.
> Don't get me wrong, I would love it if Windows were no longer around. I
> think a cygwin version of PostgreSQL will not further your objective.
> Windows users will not be seeing th
Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> What should the backends return for complicated rewrites ?
Well, given that we have only two or three fields to work in,
it obviously has to be a very simplified view of what happened.
But we have to define *something*.
> And how should/could clients h
Jean-Michel POURE wrote:
>
> Le Vendredi 10 Mai 2002 15:33, mlw a écrit :
> > The first time it doesn't work because of anti-virus software, they'll call
> > it junk. When they test performance and see that it sucks, they'll remove
> > the software.
>
> Dear Mark,
>
> PostgreSQL will work well
Some comments from Jason Tishler the Cygwin-PostgreSQL maintainer...
> -Original Message-
> From: Jason Tishler [mailto:[EMAIL PROTECTED]]
> Sent: 10 May 2002 15:00
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: Cygwin PostgreSQL Information and Suggestions
>
>
> Dave,
>
> Would y
Le Vendredi 10 Mai 2002 15:33, mlw a écrit :
> The first time it doesn't work because of anti-virus software, they'll call
> it junk. When they test performance and see that it sucks, they'll remove
> the software.
Dear Mark,
PostgreSQL will work well if cygwin.dll is compiled in a separate work
Jean-Michel POURE wrote:
>
> Dear Mark,
>
> Agreed except for paths (see below). But now that we agree, why not move to
> Windows in three steps:
> 1) Release a minimal Cygwin + PostgreSQL installer,
> 2) Have 100.000 downloads or more Windows developpers,
> 3) Work as a team on a Windows port.
Dear Mark,
Agreed except for paths (see below). But now that we agree, why not move to
Windows in three steps:
1) Release a minimal Cygwin + PostgreSQL installer,
2) Have 100.000 downloads or more Windows developpers,
3) Work as a team on a Windows port.
By the way : Cygwin accepts both Windows
Hi everyone,
Jean-Michel POURE wrote:
>
> - second move : release a bundle of pgAdmin2 + PostgreSQL on
> http://www.postgresql.org, Bloodshed and other sites.
Don't know if it's useful to know, but a PostgreSQL project got setup on
Sourceforge recently (no CVS), pretty much just so PostgreSQL
Jean-Michel POURE wrote:
>
> Le Vendredi 10 Mai 2002 14:06, mlw a écrit :
> > Sorry, I'm not interested in a cygwin version of PostgreSQL. I think it
> > will do more harm than good. If we make it something that people want to
> > try, and then they TRY it, they will find that is sucks, then we l
Hi all
Do u know that there are huge ammount of PRODUCTION(!!!) Windows NT
servers runnini apache , php and mysql? Just because the administrators
are lame, or because some companies cant afford more than one server,
and before they decided to use Windows NT (because they did not knew
about UNIX/
Dear all,
Here is a copy of a mail received from
"Robert Collins" <[EMAIL PROTECTED]>.
Jean-Michel POURE
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 10, 2002 6:30 PM
>
> Does setup.exe support uninstalling just like rpm -e package
> n
Hello everybody,
After Marc Fournier commented, it is time for pgaccess.org to make a
decision.
It is clear the project needs the following tools.
- web site
- mailing list(s)
- cvs
- bug tracking system
It is clear, that there is a small new group with fresh desire to contribute
in a dedicate
Hi everybody,
I think, that our "job" is to help this project to grow up to fit the
needs of the people that are using it. In the last months I didn't
notice any activity around it. And there are real expectations that are
still unsatisfied.
This project really needs the fresh air. I think, t
On Thu, May 09, 2002 at 10:24:00PM +0200, Iavor Raytchev wrote:
> PROPOSAL
>
> What pgaccess needs is some fresh air - it needs a small and fresh team. It
> needs own web site, own cvs, own mailing list. So that the people who love
> it, write for it and really need it can be easy to identify
On Thu, May 09, 2002 at 06:33:58PM +0100, Nigel J. Andrews wrote:
>
> On Thu, 9 May 2002, Thomas Lockhart wrote:
> > gborg is another way to organize, and of course www.pgaccess.org is a
> > way too. It partly depends on how you see the future of pgaccess. If it
> > stays tightly coupled to pgsql
Le Vendredi 10 Mai 2002 14:06, mlw a écrit :
> Sorry, I'm not interested in a cygwin version of PostgreSQL. I think it
> will do more harm than good. If we make it something that people want to
> try, and then they TRY it, they will find that is sucks, then we lose. It
> is very hard to remove the
Jean-Michel POURE wrote:
> > Without some buy-in from the core team, I'm not sure I am willing to spend
> > my time on it. If someone would be willing to fund the 100 or so man-hours
> > required to do it, then that would be a different story.
>
> I suggest we focuss on providing a minimal Postgr
Le Vendredi 10 Mai 2002 13:13, mlw a écrit :
> I am starting to come to the conclusion that the PostgreSQL group is
> satisfied with cygwin, and the will to create a native Win32 version does
> not exist outside of a few organizations that are paying developers to
> create one.
The more important
Robert wrote:
>
> Hi,
>
> Win32 & threads support are both going to be a lot of work and maybe
> we'll need in the future one or both - is there any chance Postgres
> developers look at the Apache experience? Briefly, Apache 2 had the some
> problems as are discussed here (need to support Win,
Hi,
if it is acceptable for subtransactions to use up transaction numbers,
then here is a half baked RFC for a possible implementation.
If not, forget the rest of this message.
The proposed implementation works much like the current transaction
handling. It needs an additional system table
pg_s
Tom Lane wrote:
> Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> > Of cource it is nice to have a complete solution
> > immediately but it doesn't seem easy. My patch is
> > only a makeshift solution but fixes the most
> > siginificant case(typical updatable views).
>
> I would like to devise a compl
Hiroshi Inoue wrote:
> Tom Lane wrote:
> >
> > Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> > > Of cource it is nice to have a complete solution
> > > immediately but it doesn't seem easy. My patch is
> > > only a makeshift solution but fixes the most
> > > siginificant case(typical updatable views
Tom Lane wrote:
> Jan Wieck <[EMAIL PROTECTED]> writes:
> > I have a little patch that actually allows SPI_prepare() to
> > use UNKNOWN_OID in the passed in parameter type array and
> > put's the choosen datatypes Oid back into there.
>
> > The parser treats those parame
1) Cygwin latest CVS installer version supports command lines.
2) Cygwin setup.exe is not needed. According to Robert Collins, an appropriate
setup.ini file can be used for automatic installation.
Cheers,
Jean-Michel POURE
---(end of broadcast)---
On Fri, 2002-05-10 at 06:27, Tom Lane wrote:
> I'm also concerned about having an understandable definition for the
> OID returned for an INSERT query --- if there are additional INSERTs
> triggered by rules, does that mean you don't get to see the OID assigned
> to the single row you tried to ins
Hi,
Win32 & threads support are both going to be a lot of work and maybe
we'll need in the future one or both - is there any chance Postgres
developers look at the Apache experience? Briefly, Apache 2 had the some
problems as are discussed here (need to support Win, problems with Win32
fork, qu
62 matches
Mail list logo