Thomas Lockhart wrote:
>
> Just a quick note to mention that I've resigned from the PostgreSQL
> steering committee.
Wow. That was totally unexpected.
A sad day. :-/
> It has been a lot of fun and very rewarding to
> participate in PostgreSQL development over the last six years, but it is
>
> Just a quick note to mention that I've resigned from the PostgreSQL
> steering committee. It has been a lot of fun and very rewarding to
> participate in PostgreSQL development over the last six years, but it is
> time to take a break and to move on to other projects.
Thanks for all your work, T
Just a quick note to mention that I've resigned from the PostgreSQL
steering committee. It has been a lot of fun and very rewarding to
participate in PostgreSQL development over the last six years, but it is
time to take a break and to move on to other projects.
Thanks to Marc, Bruce, and Vadim
J.R. are you still around? Do you want your patch reviewed/applied?
---
J. R. Nield wrote:
> This is the same patch as 20020822_01_pitr.patch.gz, but in the correct
> format (context diff), and the 'wal_arch_dir' parameter
Looks pretty sweet, Neil.
Maybe you could look at column triggers while you're at it, per comment on
Compiere page ;)
Triggers
Compiere uses triggers to ensure data consistency. It seems that in general,
Oracle triggers are relatively easy to convert. In addition to the Function
issues, a proced
> On Sunday 10 November 2002 08:51 am, Hannu Krosing wrote:
> > snpe kirjutas L, 09.11.2002 kell 22:51:
> > > Hello,
> > > I work with JDeveloper and PostgreSQL JDBC and I have one problem.
> > > I get error :
> > > sub-SELECT in FORM must have an alias
> > > I can't change SQL command, but it
On Thu, 14 Nov 2002, Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > If we are going to go for a beta6, I vote we reverse out the patch. Of
> > course, I prefer neither.
>
> I read this several times and am still not quite sure which path you are
> voting for. We can:
>
> 1. not
I'd like to implement FOR EACH STATEMENT triggers. AFAICS it shouldn't
be too tricky -- so if there's some show-stopper that prevented it
from being done earlier, let me know now, please :-)
Some random notes on the implementation I'm thinking of:
- in the function called by a per-stateme
I have moved more variables into the log_* GUC category in an attempt to
make log control more understandable. Changes to postgresql.conf
attached.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard
> > Well, doing create or replace as a drop/create might very well
> do the same
> > thing, and even if it got the same oid, we'd have to be really sure that
> > nothing would misbehave upon receiving that extra column before allowing
> > it for purposes of avoiding recreation of dependencies.
> >
On Thursday 14 November 2002 10:36 pm, Stephan Szabo wrote:
> On Thu, 14 Nov 2002, snpe wrote:
> > Problem is when I want change view (or functions) with a lot of
> > dependecies I must drop and recreate all dependent views (or functions) -
> > I want add only one column in view
> > I don't know if
It was Solaris awk. The fix will be in RC1.
---
Christopher Kings-Lynne wrote:
> Hi Guys,
>
> I emailed a few people to try to get some platform reports. What was the
> solution to this problem? It was AWK or something w
Christopher Kings-Lynne wrote:
> > Sorry, I was vague. I think we should apply and go to RC1 tomorrow.
> > There will always be tweaks and fixes. If we expect it to be perfect,
> > we will never make a final release. We are 2.5 months into beta, and
> > if we don't want +3 months beta, we shoul
Hi Guys,
I emailed a few people to try to get some platform reports. What was the
solution to this problem? It was AWK or something wasn't it? Will Martin
have to try RC1?
Chris
> > We are trying to get our supported platforms list together, and
> so far we
> > have not had any platform repor
> Problem is when I want change view (or functions) with a lot of
> dependecies
> I must drop and recreate all dependent views (or functions) - I
> want add only
> one column in view
> I don't know if solution hard for that.
This is definitely something that will cause some anguish in 7.3. I thin
> Sorry, I was vague. I think we should apply and go to RC1 tomorrow.
> There will always be tweaks and fixes. If we expect it to be perfect,
> we will never make a final release. We are 2.5 months into beta, and
> if we don't want +3 months beta, we should get going.
>
> We have to start taki
> Tom, would you really be able to ask Permaine to retest 7.3? Have a
> feeling we might be able to leverage the PlayStation2 brand name here
> for the Advocacy project.
>
> :-)
>
Anyone try it on an Xbox yet?
---(end of broadcast)---
TIP 6: Have y
On Thu, 14 Nov 2002, snpe wrote:
> Problem is when I want change view (or functions) with a lot of dependecies
> I must drop and recreate all dependent views (or functions) - I want add only
> one column in view
> I don't know if solution hard for that.
Well, doing create or replace as a drop/cr
Tom Lane <[EMAIL PROTECTED]> writes:
> 2. apply the patch, and ship RC1 tomorrow;
I think that's the best bet.
(That said, the philosophy of "there's always 7.3.1" that Bruce alluded
to is not one that I agree with.)
Cheers,
Neil
--
Neil Conway <[EMAIL PROTECTED]> || PGP Key ID: DB3C29FC
--
On Thursday 14 November 2002 08:01 pm, Stephan Szabo wrote:
> On Thu, 14 Nov 2002, Scott Shattuck wrote:
> > It might just be me but it seems that this discussion is missing the
> > point if we believe this request is about saving some characters. I
> > don't think it is. I think it's about being a
Tom Lane wrote:
Seriously, I agree with Marc's opinion that issuing an RC1 is the best
way to flush out some more port reports. I do not know what else we can
do to get people off their duffs and onto last-minute testing.
If testing is the problem, I think publicizing the betas would help
mor
On Thursday 14 November 2002 05:45 pm, Tom Lane wrote:
> snpe <[EMAIL PROTECTED]> writes:
> > On Thursday 14 November 2002 05:22 pm, Bruno Wolff III wrote:
> >> Are you trying to save typing a few characters or what?
> >
> > Yes, it is 'create or replace view', not ?
>
> The statement was not inven
Patrick Welche <[EMAIL PROTECTED]> writes:
> Believe it or not, I'm trying to compile today's cvs pgsql on a
> Debian 2.2.19 system. Compilation dies while compiling pg_dump with
> ../../../src/interfaces/libpq/libpq.so: undefined reference to `atexit'
Did you run configure? AFAICT that call on
Bruce Momjian wrote:
>
> Tom Lane wrote:
> > Personally I think this is a low-risk patch and so choice 2 is
> > appropriate.
If this is the only change, then 2 does seem like the best mix of
risk/progress.
:-)
Regards and best wishes,
Justin Clift
> Sorry, I was vague. I think we should ap
Believe it or not, I'm trying to compile today's cvs pgsql on a
Debian 2.2.19 system. Compilation dies while compiling pg_dump with
../../../src/interfaces/libpq/libpq.so: undefined reference to `atexit'
In the mail archives there is a mention of upgrading libc to
libc6-dev_2.2.5-3_i386.deb. As f
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > If we are going to go for a beta6, I vote we reverse out the patch. Of
> > course, I prefer neither.
>
> I read this several times and am still not quite sure which path you are
> voting for. We can:
>
> 1. not apply the patch to f
Bruce Momjian <[EMAIL PROTECTED]> writes:
> If we are going to go for a beta6, I vote we reverse out the patch. Of
> course, I prefer neither.
I read this several times and am still not quite sure which path you are
voting for. We can:
1. not apply the patch to fix Ross' problem, and ship RC1 t
Bruce Momjian <[EMAIL PROTECTED]> writes:
> If we are going to go for a beta6, I vote we reverse out the patch.
It's not applied yet.
regards, tom lane
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
htt
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> I'd ask for a quick beta6 ... even knowing everyone would hate me :)
What's wrong with calling it "RC1"?
I think pushing out an RC tarball is the only way we'll shake loose any
more port reports. Putting out "beta6" isn't going to attract attentio
If we are going to go for a beta6, I vote we reverse out the patch. Of
course, I prefer neither.
Do we have to do a delay/feature analysis on this?
Marc, there will always be 7.3.1 to fix any problems. They will surely
happen so I think it is safe to push forward for tomorrow's RC1. Of
course
I'd ask for a quick beta6 ... even knowing everyone would hate me :)
On Thu, 14 Nov 2002, Tom Lane wrote:
> I said:
> > Well, we could define it as a bug ;-) --- that is, a performance regression.
> > I'd be happier about adding a dozen lines of code to sort quals by
> > whether or not they co
"Ross J. Reedstrom" <[EMAIL PROTECTED]> writes:
> I've tested this under 7.3, and it works beautifully for the cases I've
> built over the last 2 days. I can no longer bugger a plan up mearly
> by reordering the WHERE clauses. Note that 2 of the five parts won't
> patch in (involving constantqual).
On Thu, 14 Nov 2002, Scott Shattuck wrote:
> It might just be me but it seems that this discussion is missing the
> point if we believe this request is about saving some characters. I
> don't think it is. I think it's about being able to write simple SQL
> scripts that don't produce errors when yo
Philip Warner <[EMAIL PROTECTED]> writes:
> At 12:39 AM 14/11/2002 -0500, Neil Conway wrote:
>> Perhaps when the function is defined, we run all the SQL queries in
>> the function body through the parser/analyzer/rewriter, and then
>> generate dependencies on the Query trees we get back?
> Won't w
Tom Lane wrote:
snpe <[EMAIL PROTECTED]> writes:
On Thursday 14 November 2002 05:22 pm, Bruno Wolff III wrote:
Are you trying to save typing a few characters or what?
Yes, it is 'create or replace view', not ?
The statement was not invented to save a few characters of typing.
It was in
On Thu, Nov 14, 2002 at 06:13:56PM +, Patrick Welche wrote:
> On Wed, Nov 13, 2002 at 07:53:00PM +0100, Peter Eisentraut wrote:
> > Tom Lane writes:
> >
> > > We can't just wait around indefinitely for port reports that may or may
> > > not ever appear. In any case, most of the "<7.3" entries
Ports list updated:
http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html
---
Patrick Welche wrote:
> On Wed, Nov 13, 2002 at 07:53:00PM +0100, Peter Eisentraut wrote:
> > Tom Lane writes:
> >
> > > We
I said:
> Well, we could define it as a bug ;-) --- that is, a performance regression.
> I'd be happier about adding a dozen lines of code to sort quals by
> whether or not they contain a subplan than about flip-flopping on the
> original patch. That would actually solve the class of problem you
>
On Wed, Nov 13, 2002 at 07:53:00PM +0100, Peter Eisentraut wrote:
> Tom Lane writes:
>
> > We can't just wait around indefinitely for port reports that may or may
> > not ever appear. In any case, most of the "<7.3" entries in the list
> > seem to be various flavors of *BSD; I think it's unlikely
snpe <[EMAIL PROTECTED]> writes:
> On Thursday 14 November 2002 05:22 pm, Bruno Wolff III wrote:
>> Are you trying to save typing a few characters or what?
> Yes, it is 'create or replace view', not ?
The statement was not invented to save a few characters of typing.
It was invented to allow peop
"Ross J. Reedstrom" <[EMAIL PROTECTED]> writes:
> Sorry to be a pest, but I'd like to re-raise the issue I brought up
> regarding a performance regression from 7.2.3, when subqueries are pulled
> up and merged with their parent.
> ...
> Tom was not excited about making the original change (we don't
On Thursday 14 November 2002 05:22 pm, Bruno Wolff III wrote:
> On Thu, Nov 14, 2002 at 17:00:30 +,
>
> snpe <[EMAIL PROTECTED]> wrote:
> > On Thursday 14 November 2002 05:01 pm, Bruno Wolff III wrote:
> > > On Thu, Nov 14, 2002 at 16:49:42 +,
> > >
> > > snpe <[EMAIL PROTECTED]> wrote:
On Thu, Nov 14, 2002 at 17:00:30 +,
snpe <[EMAIL PROTECTED]> wrote:
> On Thursday 14 November 2002 05:01 pm, Bruno Wolff III wrote:
> > On Thu, Nov 14, 2002 at 16:49:42 +,
> >
> > snpe <[EMAIL PROTECTED]> wrote:
> > > I want that 'create or replace view' work drop-create if view exists
On Thursday 14 November 2002 05:01 pm, Bruno Wolff III wrote:
> On Thu, Nov 14, 2002 at 16:49:42 +,
>
> snpe <[EMAIL PROTECTED]> wrote:
> > I want that 'create or replace view' work drop-create if view exists else
> > only create
>
> Why do you want this?
>
Why 'create or replace' ?
--
On Thu, Nov 14, 2002 at 16:49:42 +,
snpe <[EMAIL PROTECTED]> wrote:
>
> I want that 'create or replace view' work drop-create if view exists else only
> create
Why do you want this?
---(end of broadcast)---
TIP 5: Have you checked our extens
On Thursday 14 November 2002 04:38 pm, Rod Taylor wrote:
> On Thu, 2002-11-14 at 11:17, snpe wrote:
> > On Thursday 14 November 2002 02:41 pm, Bruno Wolff III wrote:
> > > On Thu, Nov 14, 2002 at 13:41:18 +,
> > >
> > > snpe <[EMAIL PROTECTED]> wrote:
> > > > Hello,
> > > > When I change vi
On Thu, 2002-11-14 at 11:17, snpe wrote:
> On Thursday 14 November 2002 02:41 pm, Bruno Wolff III wrote:
> > On Thu, Nov 14, 2002 at 13:41:18 +,
> >
> > snpe <[EMAIL PROTECTED]> wrote:
> > > Hello,
> > > When I change view and change number of column PostgreSQL return error
> > > : 'cannot
Zeugswetter Andreas SB SD wrote:
>
> > > I don't have AIX 5 here, so cannot test, sorry.
> > > But yes, it should definitely work.
> > >
> > > There is a known possible performance improvement for concurrent sessions on
> > > multiprocessor AIX machines. The now depricated "cs(3)" used for the A
> > I don't have AIX 5 here, so cannot test, sorry.
> > But yes, it should definitely work.
> >
> > There is a known possible performance improvement for concurrent sessions on
> > multiprocessor AIX machines. The now depricated "cs(3)" used for the AIX TAS
> > implementation should be replaced
On Wed, Nov 13, 2002 at 11:43:14PM -0500, Bruce Momjian wrote:
> Tom Lane wrote:
> > "Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> > > It seems to me that about the only major issue right now is testing the
> > > various platforms ... would anyone disagree with putting out an RC1 on
> > > Friday
On Thursday 14 November 2002 02:41 pm, Bruno Wolff III wrote:
> On Thu, Nov 14, 2002 at 13:41:18 +,
>
> snpe <[EMAIL PROTECTED]> wrote:
> > Hello,
> > When I change view and change number of column PostgreSQL return error
> > : 'cannot change number of column in view'
> > Is it too hard set
Zeugswetter Andreas SB SD wrote:
> I don't have AIX 5 here, so cannot test, sorry.
> But yes, it should definitely work.
>
> There is a known possible performance improvement for concurrent sessions on
> multiprocessor AIX machines. The now depricated "cs(3)" used for the AIX TAS
> implementatio
> > > > We received a query through the Advocacy site about whether we support
> > > > AIX 5.1 or not, so am trying to find out.
> > >
> > > It should work. Andreas just submitted a port confirmation on AIX
> > > 4.3.2 ...
> > Do you feel there's anyone around that would be able to give a
> > d
Thanks. Fixed.
---
Magnus Naeslund(f) wrote:
> Bruce Momjian <[EMAIL PROTECTED]> wrote:
> > Ports list updated:
> >
> > http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-
> > platforms.html
> >
> > Also, I assume
Bruce Momjian <[EMAIL PROTECTED]> wrote:
> Ports list updated:
>
> http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-
> platforms.html
>
> Also, I assume the "(f)" is part of your name, right?
>
Cool.
No the (f) part is really a mail account thing that (I/we)'ve
traditionally had.
If i
On Thu, Nov 14, 2002 at 13:41:18 +,
snpe <[EMAIL PROTECTED]> wrote:
> Hello,
> When I change view and change number of column PostgreSQL return error :
> 'cannot change number of column in view'
> Is it too hard set this command
> if view exits drop view
> and then change view
>
> It is li
Ports list updated:
http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html
Also, I assume the "(f)" is part of your name, right?
---
Magnus Naeslund(f) wrote:
> Tom Lane <[EMAIL PROTECTED]> wrote:
> > T
Tom Lane <[EMAIL PROTECTED]> wrote:
> Too low processes-per-user limit, likely.
Yes, ofcourse...
This is what happens when you're in a hurry and tries to make everything
happen at the same time :)
Now it all passes:
OpenBSD 3.1 i386
./configure \
--with-perl\
--enable-odbc
Justin Clift wrote:
> Tom Lane wrote:
> >
> > Justin Clift <[EMAIL PROTECTED]> writes:
> > > We received a query through the Advocacy site about whether we support
> > > AIX 5.1 or not, so am trying to find out.
> >
> > It should work. Andreas just submitted a port confirmation on AIX
> > 4.3.2
Tom Lane wrote:
>
> Justin Clift <[EMAIL PROTECTED]> writes:
> > We received a query through the Advocacy site about whether we support
> > AIX 5.1 or not, so am trying to find out.
>
> It should work. Andreas just submitted a port confirmation on AIX
> 4.3.2 ...
Thanks Tom. :)
Do you feel th
"Magnus Naeslund(f)" <[EMAIL PROTECTED]> writes:
> OK OK, before anyone rubs my nose in it, i see the fork() failures :)
> I'll see what's causing the fork() problems...
Too low processes-per-user limit, likely.
regards, tom lane
---(end of broadc
Justin Clift <[EMAIL PROTECTED]> writes:
> We received a query through the Advocacy site about whether we support
> AIX 5.1 or not, so am trying to find out.
It should work. Andreas just submitted a port confirmation on AIX
4.3.2 ...
regards, tom lane
---
Hello,
When I change view and change number of column PostgreSQL return error :
'cannot change number of column in view'
Is it too hard set this command
if view exits drop view
and then change view
It is like with return type in function
Now 'or replace' don't help too much
regards
--
On Sunday 10 November 2002 08:51 am, Hannu Krosing wrote:
> snpe kirjutas L, 09.11.2002 kell 22:51:
> > Hello,
> > I work with JDeveloper and PostgreSQL JDBC and I have one problem.
> > I get error :
> > sub-SELECT in FORM must have an alias
> > I can't change SQL command, but it is internal J
Magnus Naeslund(f) <[EMAIL PROTECTED]> wrote:
>
> Well, OpenBSD isn't dead :)
> But i have problems compiling 7.3b5 on it (OpenBSD 3.1 i386).
> I figured i should give it a go, since nobody else did, but i get many
> regression failures.
>
OK OK, before anyone rubs my nose in it, i see the fork()
Yeah, we made an announcement to -general a few weeks ago, but didn't cross-post to
-hackers.
Cheers to all. Obviously as a co-founder of Great Bridge, I'm a big believer in
Postgres. OpenMFG makes extensive use of pl/pgsql for most of its ERP business logic.
We've also been beta testing Peer
Tom Lane <[EMAIL PROTECTED]> wrote:
[snip]
>
>> Note that we have *zero* reports for any flavor of NetBSD and
>> OpenBSD.
>
> Maybe they're both dead platforms? ;-)
>
Well, OpenBSD isn't dead :)
But i have problems compiling 7.3b5 on it (OpenBSD 3.1 i386).
I figured i should give it a go, since n
On Tue, Nov 12, 2002 at 02:58:17PM -0400, Marc G. Fournier wrote:
>
>
> if (ic_flag == 1) {
> /*only select those non-IC/Spyder nodes that has full update set*/
> EXEC SQL DECLARE full_dyn_node CURSOR FOR
> SELECT node_name FROM NODE
> WHE
Mats,
Patch applied. (I also fixed the 'length' problem you reported as well).
thanks,
--Barry
Mats Lofkvist wrote:
(I posted this on the bugs and jdbc newsgroups last week
but have seen no response. Imho, this really needs to
be fixed since the bug makes it impossible to use the
driver in a
69 matches
Mail list logo
