2005/11/23, Joshua D. Drake <[EMAIL PROTECTED]>:
>
> >I **REALLY** wish you would STOP saying that, Bruce. The current OpenServer
> >Compiler (UDK), is the same as on UnixWare, and is **MUCH** better than the
> >Old SVR3 compiler.
> >
> >We **REALLY** **SHOULD** look at it.
> >
> >
> Well actually
Bruce Momjian wrote:
> Tom Lane wrote:
> > Since we were breaking our usual rule by re-indenting the 8.1 branch,
> > I took the time to eyeball the whole "cvs diff" for changes that weren't
> > just comment block fixes. I found a few things that need attention.
> >
> > This change is disturbing f
Actually, there are really only a few errors people want to trap I
imagine:
- CHECK constraints (all handled in ExecConstraints)
- Duplicate keys
- Foreign key violations (all handled by triggers)
Rather than worry about all the events we can't safely trap, how about
we simply deal with the hand
Seems similar to the pgloader project on pgfoundry.org.
It is similar and good, but I regard that as a workaround rather than
the way forward.
Yes, your way would be rad :)
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, ple
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Jim C. Nasby wrote:
>> Along those lines, is there anything else that would benefit from being
>> moved? pg_clog and pg_subtrans come to mind; but maybe pg_multixact and
>> pg_twophase are candidates as well?
> Hmm, I doubt moving any of the SLRU files
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> If we are going to move toward libedit then libedit should be included
> in core.
We already do support libedit; support does not mean "include", for
either readline or libedit.
I think it'd be reasonable to provide a configure option to control
se
Wolfgang <[EMAIL PROTECTED]> writes:
> Here are some little changes to the postgreSQL server backend I found
> beeing convenient for me
You don't seriously expect any of this to get applied, do you?
nullstr0 reverts a deliberate change made in PG 7.3. It's way past
time to be complaining about
Chuck McDevitt wrote:
Another vote for libedit support... We at Greenplum definitely want to
use it.
If we are going to move toward libedit then libedit should be included
in core. Otherwise
you are creating a dependency on the largest postgresql used OS (linux).
The advantage
here of cours
I **REALLY** wish you would STOP saying that, Bruce. The current OpenServer
Compiler (UDK), is the same as on UnixWare, and is **MUCH** better than the
Old SVR3 compiler.
We **REALLY** **SHOULD** look at it.
Well actually no, we shouldn't. Regardless of the technical good or
bad.. We ar
Here are some little changes to the postgreSQL server backend I found
beeing convenient for me
while I was attempting to get interoparability with a binary only
program. The patch attached is tested and works
for 8.0.0beta3.
The so called big ones under these DBMS eat the following kind of joi
On Nov 22, 2005, at 7:04 PM, Alvaro Herrera wrote:
Larry Rosenman wrote:
Sorry for the top post. If you can get a UDK license, that will work
better.
Oh, so one gets a buggy compiler by default and has to pay for a
better
one? Cool! I'm drooling already, I want one of those SCO things,
Larry Rosenman wrote:
> Sorry for the top post. If you can get a UDK license, that will work
> better.
Oh, so one gets a buggy compiler by default and has to pay for a better
one? Cool! I'm drooling already, I want one of those SCO things, where
do I get it? Pity those GCC guys, having only
On Wed, 23 Nov 2005 11:23 am, Gavin Sherry wrote:
> > Along those lines, is there anything else that would benefit from being
> > moved? pg_clog and pg_subtrans come to mind; but maybe pg_multixact and
> > pg_twophase are candidates as well?
>
> pgsql_tmp
Does anyone have any recommendations about
On Tue, Nov 22, 2005 at 06:11:01PM -0500, Bruce Momjian wrote:
> [EMAIL PROTECTED] wrote:
> > A solution enhancing the above mentioned indexes, to maintain a count
> > for whole index blocks, would allow whole index blocks that satisfy
> > the WHERE clause to be counted, assuming the whole index bl
Another vote for libedit support... We at Greenplum definitely want to
use it.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Jim C. Nasby wrote:
> On Tue, Nov 22, 2005 at 01:38:34PM -0500, Bruce Momjian wrote:
> >
> > * Allow the pg_xlog directory location to be specified during initdb
> > with a symlink back to the /data location
> >
> > I think the only reason it is not done yet is because it is so easy to
Bruce Momjian wrote:
> > And what happened here?
>
> I saw this one to and was stumped at the cause. We have other 'typedef
> enum' lines in the code which were not mangled, just this one. Again,
> needs research.
>
> > Index: src/interfaces/libpq/libpq-fe.h
> > ***
> > *** 35,41 **
Tom Lane wrote:
> Since we were breaking our usual rule by re-indenting the 8.1 branch,
> I took the time to eyeball the whole "cvs diff" for changes that weren't
> just comment block fixes. I found a few things that need attention.
>
> This change is disturbing first because it seems completely
On Tue, 22 Nov 2005, Jim C. Nasby wrote:
> On Tue, Nov 22, 2005 at 01:38:34PM -0500, Bruce Momjian wrote:
> > Gavin Sherry wrote:
> > > > Related question: are there plans afoot to allow specifying an alternate
> > > > location for pg_xlog (or pg_delete-me-not) to save doing the
> > > > shutdown-
On Tue, Nov 22, 2005 at 01:38:34PM -0500, Bruce Momjian wrote:
> Gavin Sherry wrote:
> > > Related question: are there plans afoot to allow specifying an alternate
> > > location for pg_xlog (or pg_delete-me-not) to save doing the shutdown-DB,
> > > mv
> > > directory to other disk, symlink, start
On Tue, Nov 22, 2005 at 06:11:01PM -0500, Bruce Momjian wrote:
> [EMAIL PROTECTED] wrote:
> Jan has been talking about have a bitmap to track pages that need
> vacuuming, and I am wondering if the same system could be used to track
> the heap-dirty bits. Putting one bit on every 8k disk page means
Sorry for the top post. If you can get a UDK license, that will work
better.
LER
On Nov 22, 2005, at 12:02 PM, Guillaume Lelarge wrote:
Sorry for answering this late.
2005/11/16, Larry Rosenman :
Bruce Momjian wrote:
The SCO compiler is so buggy (and for so many years) I see no reason
to
Jaime Casanova wrote:
the FROM clause is required by default (starting with 8.1) unless you
change a postgresql.conf parameter.
and i don't think that idea will have any fan...
Bruce already replied to your first statement so, what idea won't have
any fan ? It's not that we would change wha
Jim C. Nasby wrote:
> On Fri, Nov 18, 2005 at 02:56:52PM -0500, Gregory Maxwell wrote:
> > However, some great ideas have been proposed here which would not only
> > help in that case but would otherwise be quite useful.
> >
> > *Inclusion of a 'MVCC inflight' bit in indexes which would allow
> >
[EMAIL PROTECTED] wrote:
> On Fri, Nov 18, 2005 at 03:46:42PM +, Richard Huxton wrote:
> > Simon Riggs wrote:
> > >One of the major complaints is always "Select count(*) is slow".
> > Although there seem to have been plenty of ideas on this they all seem
> > to just provide a solution for the
Gregory Maxwell wrote:
> On 11/21/05, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> > What about Greg Stark's idea of combining Simon's idea of storing
> > per-heap-block xmin/xmax with using that information in an index scan?
> > ISTM that's the best of everything that's been presented: it allows for
Since we were breaking our usual rule by re-indenting the 8.1 branch,
I took the time to eyeball the whole "cvs diff" for changes that weren't
just comment block fixes. I found a few things that need attention.
This change is disturbing first because it seems completely unnecessary,
and second be
Tom Lane wrote:
> I see Alvaro and Andrew have landed the patches they were working on
> last week, so maybe today is a good time to do that re-pgindent we
> were discussing.
Done.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610
On Mon, Nov 21, 2005 at 07:50:48PM -0500, Andrew Dunstan wrote:
>
> Nice analysis, but we can't hack configure like that. It has to be able
> to be fully generated from its sources. I think the other source file
> you would need to look at is config/programs.m4. (Not sure about quoting
> $ac_po
On Mon, Nov 21, 2005 at 09:14:33PM +0100, Marcus Engene wrote:
> Jim C. Nasby wrote:
> >It might be more useful to look at caching only planning and not
> >parsing. I'm not familiar with the output of the parsing stage, but
> >perhaps that could be hashed to use as a lookup into a cache of planned
On Fri, Nov 18, 2005 at 09:03:25PM +0100, Martijn van Oosterhout wrote:
> I'd say implement SQL MERGE which doesn't have any really unusual
> features. And seperately implement some kind of INSERT OR UPDATE which
> works only for a table with a primary key.
Is there any reeason this has to be a PK
On Tue, Nov 22, 2005 at 11:57:48AM +0100, Martijn van Oosterhout wrote:
> Rather than trying to make MERGE do something it wasn't designed for,
> we should probably be spending our efforts on triggers for error
> conditions. Maybe something like:
>
> CREATE TRIGGER foo AFTER ERROR ON bar EXECUTE
On Mon, Nov 21, 2005 at 08:40:38PM -0500, Tom Lane wrote:
> You should find out what the problem is before you start writing
> documentation about it ;-). This has nothing whatever to do with
> bigint.
Damn, there's 5 minutes of my life that I won't get back! ;P
> What the code is trying to do
On 11/22/05, Bruce Momjian wrote:
> Jaime Casanova wrote:
> > >
> > > And yes merge CAN be used to do REPLACE (oracle uses their dummy table
> > > for this, we can use the fact that FROM clause isn't required in
> > > postgres).
> > >
> >
> > the FROM clause is required by default (starting with
Jaime Casanova wrote:
> >
> > And yes merge CAN be used to do REPLACE (oracle uses their dummy table
> > for this, we can use the fact that FROM clause isn't required in postgres).
> >
>
> the FROM clause is required by default (starting with 8.1) unless you
> change a postgresql.conf parameter.
>
Gavin Sherry wrote:
> > Related question: are there plans afoot to allow specifying an alternate
> > location for pg_xlog (or pg_delete-me-not) to save doing the shutdown-DB, mv
> > directory to other disk, symlink, start-DB dance?
>
> People have discussed it but I don't know of anyone working on
I have update the first section of the FAQ:
http://www.postgresql.org/docs/faqs.FAQ.html
In particular:
o reordered items to be more logical
o added clarification of license
o added section about bug reporting replies
o added section of feature request
Sorry for answering this late.
2005/11/16, Larry Rosenman :
> Bruce Momjian wrote:
> > The SCO compiler is so buggy (and for so many years) I see no reason
> > to even look at a bug report from someone using it.
> >
>
> I **REALLY** wish you would STOP saying that, Bruce. The current OpenServer
>
On Tue, Nov 22, 2005 at 12:16:00PM -0500, Tom Lane wrote:
> I think the distinction you are proposing between constraint errors
> and datatype errors is entirely artificial. Who's to say what is a
> constraint error and what is a datatype error, especially when you
> start thinking about cases lik
Guillaume Lelarge <[EMAIL PROTECTED]> writes:
>>> I've installed a 8.1.0 PostgreSQL server on a SCO OpenServer 5.0.6.
> Some tests failed.. strangely, it seems int4 and int8 share the same
> range.
This is expected behavior if the platform's C compiler doesn't support
any 64-bit integer type. We
Tom Lane <[EMAIL PROTECTED]> writes:
> > It would be nice to be able to have the former loaded into an actual table
> > where it can be queried and perhaps fixed and reloaded.
>
> > The latter clearly cannot.
>
> Sure it can --- you just have to dump it as raw text (or perhaps bytea,
> as someon
Sorry for this late answer. I tried a lot of things and it still doesn't work.
2005/11/11, Martijn van Oosterhout :
> On Thu, Nov 10, 2005 at 11:53:04PM +0100, Guillaume LELARGE wrote:
> > Hi,
> >
> > I've installed a 8.1.0 PostgreSQL server on a SCO OpenServer 5.0.6. It
> > seemed to work well wi
Greg Stark <[EMAIL PROTECTED]> writes:
> I think that's precisely the point here though. There are basically two
> categories of errors:
> 1) Data that can be parsed and loaded but generates some sort of constraint
>violation such as a UNIQUE violation, foreign key violation, or other
>con
Bob Ippolito <[EMAIL PROTECTED]> writes:
> On Nov 21, 2005, at 5:50 PM, Tom Lane wrote:
>> Hm, do the drop/add constraint functions get executed even when
>> clone_table decides not to make a new table? If so, that would
>> probably explain the pattern I'm seeing in the dump of many updates of t
I found this thread on google,
http://groups.google.nl/group/pgsql.hackers/browse_thread/thread/1ccb7ade8d7e7475/8b10fb1ca5fdd3ef?lnk=st&q=pg_hba.conf+settings+to+be+controlled+via+SQL&rnum=3&hl=nl#8b10fb1ca5fdd3ef
> Bruno Wolff III wrote:
>> On Tue, Nov 22, 2005 at 10:57:19 +0100,
>> [EMAIL
On 2005-11-22, at 17:17, Martijn van Oosterhout wrote:
On Tue, Nov 22, 2005 at 05:14:35PM +0100, Grzegorz Jaskiewicz wrote:
Ok, I hacked btree for my type, and surely I can have both btree and
gist at the same time on the same column.
/me is now going to have a look on btree_gist.
You don't
Tom Lane <[EMAIL PROTECTED]> writes:
> Martijn van Oosterhout writes:
> > On Tue, Nov 22, 2005 at 09:58:44AM -0500, Tom Lane wrote:
> >> The general problem that needs to be solved is "trap any error that
> >> occurs during attempted insertion of a COPY row, and instead of aborting
> >> the copy,
Bruno Wolff III wrote:
On Tue, Nov 22, 2005 at 10:57:19 +0100,
[EMAIL PROTECTED] wrote:
Just out of curiosity. Is there someone involved with ToDo item “%Allow
pg_hba.conf settings to be controlled via SQL”?
pgAdmin with the admin81 functions can handle this...
Regards,
Andreas
--
On Tue, Nov 22, 2005 at 05:14:35PM +0100, Grzegorz Jaskiewicz wrote:
> Ok, I hacked btree for my type, and surely I can have both btree and
> gist at the same time on the same column.
> /me is now going to have a look on btree_gist.
You don't actually have to have a btree defined on your column
On 2005-11-22, at 16:39, Martijn van Oosterhout wrote:
On Tue, Nov 22, 2005 at 04:24:21PM +0100, Grzegorz Jaskiewicz wrote:
Translation: you do know how to define a sortable order (ie,
generate
the text version and compare); you're just too lazy to create the
operators to do it ...
We do ha
On Tue, Nov 22, 2005 at 10:45:50AM -0500, Tom Lane wrote:
> Martijn van Oosterhout writes:
> > Actually, there are really only a few errors people want to trap I
> > imagine:
>
> You've forgotten bad data, eg "foo" in an integer field, or an
> untranslatable multibyte character. The bad-data pro
On Tue, Nov 22, 2005 at 10:57:19 +0100,
[EMAIL PROTECTED] wrote:
> Just out of curiosity. Is there someone involved with ToDo item %Allow
> pg_hba.conf settings to be controlled via SQL?
I don't remember any discussions about this recently, so I doubt it is being
actively worked on right now.
On Tue, 22 Nov 2005, Grzegorz Jaskiewicz wrote:
Thing is, can I have btree and gist indexes at the same time ?
no, we have contrib/btree_gist for this
Regards,
Oleg
_
Oleg Bartunov, sci.researcher, hostmaster
Martijn van Oosterhout writes:
> On Tue, Nov 22, 2005 at 09:58:44AM -0500, Tom Lane wrote:
>> The general problem that needs to be solved is "trap any error that
>> occurs during attempted insertion of a COPY row, and instead of aborting
>> the copy, record the data and the error message someplace
On Tue, Nov 22, 2005 at 04:24:21PM +0100, Grzegorz Jaskiewicz wrote:
> >Translation: you do know how to define a sortable order (ie, generate
> >the text version and compare); you're just too lazy to create the
> >operators to do it ...
> We do have WORKING < , > , etc operators, and ::text cast al
On Tue, Nov 22, 2005 at 09:58:44AM -0500, Tom Lane wrote:
> The general problem that needs to be solved is "trap any error that
> occurs during attempted insertion of a COPY row, and instead of aborting
> the copy, record the data and the error message someplace else". Seen
> in that light, implem
On 2005-11-22, at 15:45, Tom Lane wrote:
"Kevin McArthur" <[EMAIL PROTECTED]> writes:
This is acceptable to create a unique constraint, however, we
cannot mark
the column unique, without defining btree operators, which clearly
are not
possible for sorting. Is there any way to base the opera
Simon Riggs <[EMAIL PROTECTED]> writes:
> I have committed the sin of omission again.
> Duplicate row violation is the big challenge, but not the only function
> planned. Formatting errors occur much more frequently, so yes we'd want
> to log all of that too. And yes, it would be done in the way y
"Kevin McArthur" <[EMAIL PROTECTED]> writes:
> This is acceptable to create a unique constraint, however, we cannot mark
> the column unique, without defining btree operators, which clearly are not
> possible for sorting. Is there any way to base the operators based on the
> text representation
Take the query.
select a,b from dupa where b::text in (select b::text from dupa group by
b::text having count(b) > 2);
This is acceptable to create a unique constraint, however, we cannot mark
the column unique, without defining btree operators, which clearly are not
possible for sorting. Is
I apologise if this isn't the correct list to post this issue to, I just
wanted to give a heads up that the main postgresql.org website doesn't
seem to be giving access to any ftp mirrors. Needless to say, when I
tried to download what I was after from the main server, I just got a
'too many c
On Tue, Nov 22, 2005 at 04:20:12AM +0100, Petr Jelinek wrote:
> It was already said here that oracle and db2 both use MERGE, dunno about
> mssql.
>
> And yes merge CAN be used to do REPLACE (oracle uses their dummy table
> for this, we can use the fact that FROM clause isn't required in postgres
I've noticed that in 8.1 the output of SHOW ALL includes a description
column. This makes the output very wide which makes it hard to use from
psql (I need to make the terminal window 164 characters wide to not get
any line wrapping). I wish I would have noticed this before 8.0 was out
and then I
On Tue, 22 Nov 2005, Dennis Bjorklund wrote:
On Tue, 22 Nov 2005, Dennis Bjorklund wrote:
ps. The cvs server also seems to be down (postgresql.org).
Forgot to say in the last mail, but this also works now. Seems like I
should have waited some more before sending the mail. I waited 30 minutes
On Tue, Nov 22, 2005 at 09:22:18AM +0100, Dennis Bjorklund wrote:
> Something is wrong with the web site for me. I look at:
>
> http://www.postgresql.org/developer/
> Turns out it's related to the ads, so if I just adblock the ad server I
> can see the page just fine. Kind of bad it's needed
On Tue, Nov 22, 2005 at 10:07:15AM +0100, Zeugswetter Andreas DCP SD wrote:
> PS: I'd prefer if readline was only linked where it is needed, namely in
> psql.
The problem as stated is that people don't want to maintain lists of
libraries as needed by each program, so we link all of them.
Since it
Just out of curiosity. Is there someone involved with ToDo item %Allow
pg_hba.conf settings to be controlled via SQL?
Regards,
Gevik.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Mon, 2005-11-21 at 19:05 -0500, Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > Flow of control would be to:
>
> > locate page of index where value should go
> > lock index block
> > _bt_check_unique, but don't error
> > if violation then insert row into ERRORT
On Tue, 2005-11-22 at 10:00 +0800, Christopher Kings-Lynne wrote:
> Seems similar to the pgloader project on pgfoundry.org.
It is similar and good, but I regard that as a workaround rather than
the way forward.
Best Regards, Simon Riggs
---(end of broadcast)
> With AIX 5, the easiest way to get a shared object is to pass
"-bexpall"
> to the linker. This results in all symbols being exported.
Yes, that is another reason not to use this broken switch.
And last time I checked (AIX 4.3.3), -bexpall did not export all needed
symbols
(e.g. globals) from th
On Tue, 22 Nov 2005, Dennis Bjorklund wrote:
> ps. The cvs server also seems to be down (postgresql.org).
Forgot to say in the last mail, but this also works now. Seems like I
should have waited some more before sending the mail. I waited 30 minutes
but I should have waited 40...
--
/Dennis Bjö
On Tue, 22 Nov 2005, Magnus Hagander wrote:
>
> > Turns out it's related to the ads, so if I just adblock the
> > ad server I can see the page just fine. Kind of bad it's
> > needed however :-)
> >
> > I also tried to show the page in opera and it looks the same
> > as in firefox.
>
> Inters
[moved to -www]
> Something is wrong with the web site for me. I look at:
>
> http://www.postgresql.org/developer/
>
> then this is what I see:
>
> http://www.zigo.dhs.org/~dennis/tmp/dev.png
>
> (everything is there except the main content that is not).
Yikes.
> Turns out it's related
Something is wrong with the web site for me. I look at:
http://www.postgresql.org/developer/
then this is what I see:
http://www.zigo.dhs.org/~dennis/tmp/dev.png
(everything is there except the main content that is not).
Turns out it's related to the ads, so if I just adblock the ad server
On Mon, 2005-11-21 at 19:38 -0500, Andrew Dunstan wrote:
>
> Tom Lane wrote:
>
> >Simon Riggs <[EMAIL PROTECTED]> writes:
> >
> >
> >>What I'd like to do is add an ERRORTABLE clause to COPY. The main
> >>problem is how we detect a duplicate row violation, yet prevent it from
> >>aborting the tr
75 matches
Mail list logo
