On 12 Feb 2004, Greg Stark wrote:
> Tom Lane <[EMAIL PROTECTED]> writes:
>
> > > Hmmm ... maybe query_work_mem and maintenance_work_mem, or something
> > > similar?
> >
> > I'll go with these unless someone has another proposal ...
>
> dml_sort_mem and ddl_sort_mem ?
I like those. Are they a
On Thu, 5 Feb 2004, Rod Taylor wrote:
> > > Don't know. But apparently different users will have
> > > different demands From a database.
> >
> > Of course, but I would argue that my claim that PostgreSQL is reliable
> > is backed up by the lack of people posting messages like 'we had a
> > powe
On Thu, 6 May 2004, Tom Lane wrote:
> sdv mailer <[EMAIL PROTECTED]> writes:
> > The point is pre-forking can *potentially* speed up
> > connections by 5x as shown in this simplistic
> > non-conclusive benchmark.
>
> I think this "benchmark" proves no such thing.
>
> The thing that pgpool is doi
On Thu, 6 May 2004, Richard Huxton wrote:
> Bruce Momjian wrote:
> > Tom Lane wrote:
> >
> >>Richard Huxton <[EMAIL PROTECTED]> writes:
> >>
> >>>Does that mean I'll want to disable triggers while I do this?
> >>
> >>Hrm. Right now the code does not fire triggers at all, but that seems
> >>wrong
On Wed, 5 May 2004, Rod Taylor wrote:
> > And, of course, most development environments (perl, php, java etc)
> > have their own language specific connection pooling solutions.
>
> Yes, the one for php is what I was thinking of when I made my statement.
> They work on a per backend basis as Apach
On Wed, 5 May 2004, sdv mailer wrote:
> Forking is quite fast on Linux but creating a new
> process is still 10x more expensive than creating a
> thread and is even worse on Win32 platform. CPU load
> goes up because the OS needs to allocate/deallocate
> memory making it difficult to get a steady
On Tue, 4 May 2004, David Garamond wrote:
> scott.marlowe wrote:
> > For me, the only features I'm likely to use in the upcoming releases are
> > nested transactions. While PITR is a great selling point, and the Windows
> > Port is something I do look forward to
For me, the only features I'm likely to use in the upcoming releases are
nested transactions. While PITR is a great selling point, and the Windows
Port is something I do look forward to, having to do half my job
programming windows boxes, nested transactions are a feature I can
genuinely use i
On Tue, 27 Apr 2004, Andrew Payne wrote:
>
> Scott Marlowe wrote:
>
> > While Apache is and has been wildly popular for bulk hosing and domain
> > parking, for serious commercial use, Netscape's enterprise server, now Sun
> > One, has long been a leader in commercial web sites.
>
> Netscrape/Su
On Tue, 27 Apr 2004, Richard Huxton wrote:
> On Tuesday 27 April 2004 14:27, Bruce Momjian wrote:
> > Here are features that are being worked on, hopefully for 7.5:
> >
> > o tablespaces (Gavin)
> > o nested transactions (Alvaro)
> > o two-phase commit (Heikki Linnakangas)
> > o
On Mon, 26 Apr 2004, Andrew Payne wrote:
> For those that look to Apache: Apache never had a well-established
> incumbent (Oracle), an a well-funded upstart competitor (MySQL). Rob
> McCool's NCSA httpd (and later, Apache) were good enough and developed
> rapidly enough that they prevented any o
On Wed, 21 Apr 2004, Shalu Gupta wrote:
> Hello,
>
> We are trying to import the TPC-H data into postgresql using the COPY
> command and for the larger files we get an error due to insufficient
> memory space.
>
> We are using a linux system with Postgresql-7.3.4
>
> Is it that Postgresql canno
On Wed, 21 Apr 2004 [EMAIL PROTECTED] wrote:
> Hi
> I am working on a project in postgres..in which i designed customized data type
> and operations on it.it requires a look up table..
> I have three options regarding this table...
> 1. Every time a query is executed it creates table assigns value
On Mon, 26 Apr 2004, Andrew Payne wrote:
>
> Bruce asked an excellent question:
>
> > My question is, "What can we learn from MySQL?" I don't know there is
> > anything, but I think it makes sense to ask the question.
>
> After watching the traffic on this, the biggest MySQL lesson has gone
>
On Tue, 27 Apr 2004, Jochem van Dieten wrote:
> [EMAIL PROTECTED] wrote:
> > (5) Programming languages. We need to make a programming language standard
> > in PostgreSQL. plpgsql is good, but isn't someone working on a Java
> > language. That would be pretty slick.
>
> IMHO SQL/PSM would be the o
On Mon, 26 Apr 2004, Josh Berkus wrote:
> > I think that a talented manager could make the case for certain features.
>
> So? So could any community member with a good grasp of database engineering
> and an ability to write persuasive e-mails.
I'd like to inject here that I was the one who st
On Mon, 26 Apr 2004, Josh Berkus wrote:
> Shachar,
>
> > I think the concensus was that the runtime part was aprox. four lines
> > where the case folding currently takes place. Obviously, you would have
> > to get a var, and propogate that var to that place, but not actually
> > change program
On Fri, 23 Apr 2004, Bruce Momjian wrote:
> Here is a blog about a recent MySQL conference with title, "Why MySQL
> Grew So Fast":
>
> http://www.oreillynet.com/pub/wlg/4715
>
> and a a Slashdot discussion about it:
>
>
> http://developers.slashdot.org/article.pl?sid=04/04/20/22292
I almost agree, but I think things that are being actively developed to
eventually move into the backend, like autovacuum or slony-I should be in
contrib. Things that aren't destined for backend integration should be
removed though, like pgbench or dblink or whatnot.
On Wed, 21 Apr 2004, Joshu
On Tue, 20 Apr 2004, Bruce Momjian wrote:
> Andrew Dunstan wrote:
> > >past. I think createuser is much worse. :-)
> > >
> > >
> > >
> > Agreed. Actually, the big problem with the name "initdb" is that the
> > name is misleading, and newbies often get confused by it. You are
> > preparing a
On Fri, 16 Apr 2004, Christopher Kings-Lynne wrote:
> > I always ran one of the 2 scripts (can't remember which one) and after that
> > started checking the dump file, because there were things that didn't get
> > changed correctly[1].
> >
> > [1]: I always remember the first conversion I did.
On Thu, 8 Apr 2004, Bruce Momjian wrote:
> Fabien COELHO wrote:
> >
> > > > This would help me, at least, write correct and portable SQL. :)
> > >
> > > Added to TODO:
> > >
> > > * Add a session mode to warn about non-standard SQL usage
> >
> > So it seems that having C-like operators would h
On Wed, 7 Apr 2004, Dennis Bjorklund wrote:
> On Wed, 7 Apr 2004, Dennis Bjorklund wrote:
>
> Replying to myself here :-)
>
> > wants to import it into a 7.3 database. Use the 7.3 dump you might say,
> > but since BY does not do anything why not remove it from the dump output?
>
> I just reali
On 31 Mar 2004, elrik wrote:
> [EMAIL PROTECTED] (elrik) wrote in message news:<[EMAIL PROTECTED]>...
> > In information i have:
> >
> > 1. when creating view : PostgreSQL parse the query and stock the tree query.
> > 2. when using : PostgreSQL use this tree like a subselect.
> >
> > my question
On Wed, 31 Mar 2004, Philip Warner wrote:
> At 12:13 AM 31/03/2004, Bruce Momjian wrote:
> >Yes, they have to check for a proper exit from pg_dump, but there is
> >still a file sitting around after the dump, with no way to tell if it is
> >accurate.
>
> Why don't we write a hash into the header o
On Mon, 29 Mar 2004, Marc G. Fournier wrote:
> On Mon, 29 Mar 2004, Dave Page wrote:
>
> > It's rumoured that Euler Taveira de Oliveira once said:
> > > Hi Christopher,
> > >
> > >> > "The \l command should only list databases that the current user is
> > >> > authorized for, the \du command shou
On Wed, 24 Mar 2004, Andrew Dunstan wrote:
> . Peter Eisentraut's program
> pro: portable, better featured, no license issues
> con: code state uncertain, less well tested
Where is Peter's code available, I'd like to try it out.
---(end of broadcast)-
On Thu, 11 Mar 2004, Josh Berkus wrote:
> Scott,
>
> > I like it. Would a multiplier be acceptable?
> > default_stats_index_multiplier = 10
>
> Yeah, I thought about that, but a multiplier would be harder to manage for
> most people.I mean, what if your default_stats are at 25 and you wa
On Wed, 10 Mar 2004, Li Yuexin wrote:
> Who can tell me how to complete oracle's hierarchical_query through
> postgresql?
Look in the contrib/tablefunc directory for the connect_by function.
---(end of broadcast)---
TIP 3: if posting/reading
On Sun, 7 Mar 2004, Tom Lane wrote:
> Neil Conway <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> This is something we need to consider, but we'll need more evidence
> >> before making a choice. One thing that we have very little data about
> >> is how much difference it makes in the quality
On Mon, 8 Mar 2004, Joe Maldonado wrote:
> Hello,
> I see that there is an item "Queries across databases or servers (two-phase
> commit)" on the todo list's urgent header. I have tried asking this question on the
> other lists and have not yet gotten a suitable answer to this question...W
On Fri, 5 Mar 2004, Thomas Swan wrote:
> [EMAIL PROTECTED] wrote:
>
> ><[EMAIL PROTECTED]> writes:
> >
> >
> >
> >>>[EMAIL PROTECTED] wrote:
> >>>
> >>>
> >"Zeugswetter Andreas SB SD" <[EMAIL PROTECTED]> writes:
> >
> >
> My feeling is that we need not suppor
On 27 Feb 2004, Chad wrote:
> Is it possible for Postgres Btrees to support access by logical row number ?
> If not available is ti a huge job to support for sombebody willing to have a go ?
Are talking about logical row operators as maintained by your own code
outside the database, or having po
On Fri, 27 Feb 2004, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > Is possible / reasonable / smart and or dumb to look at implementing the
> > tablespaces as riding atop the initlocation handled stuff.
>
> In my mind, one of the main ben
On Fri, 27 Feb 2004, Gavin Sherry wrote:
> On Thu, 26 Feb 2004, Alex J. Avriette wrote:
>
> > On Thu, Feb 26, 2004 at 11:22:28PM +1100, Gavin Sherry wrote:
> >
> > > Certainly, table spaces are used in many ways in oracle, db2, etc. You can
> > > mirror data across them, have different buffer siz
On Fri, 27 Feb 2004, Zeugswetter Andreas SB SD wrote:
>
> > > Ahh. I forgot to detail my ideas on this. It seems to me that we cannot
> > > drop a table space until the directory is empty.
>
> Agreed.
>
> >
> > How would it get to be empty? Are you thinking of some sort of "connect
> > databa
On Tue, 24 Feb 2004, Shridhar Daithankar wrote:
> http://www.osnews.com/printer.php?news_id=6136
That page gets a "please don't link to printer ready pages error" and
redirects to here:
http://www.osnews.com/story.php?news_id=6136
---(end of broadcast)---
On Tue, 10 Feb 2004, Rodrigo wrote:
> Shridhar Daithankar wrote:
> > Just stumbled upon this. just an FYI,
> >
> > http://www.microsoft.com/sql/yukon/productinfo/top30features.asp
> >
> > Shridhar
>
> From the page:
>
> > A new Snapshot Isolation (SI) level will be provided at the
> > data
On Thu, 12 Feb 2004, Stef wrote:
> > > case in point, the example trigger. i would have expected
> > > deliberate schemaname.table during an insert to work, but
> > > instead the parser complains about cross-database.
> >
> > I would think just changing the error message to "no schema by the name
U. Postgresql doesn't natively support cross database queries...
On Thu, 12 Feb 2004, Stef wrote:
> Hey there everyone.
>
> Sorry for what seems to be a rather strange
> thought but, could we change the seperator used to
> distinguish 'cross-database' vs 'cross-schema' ?
>
> Fo
On Thu, 12 Feb 2004, Stef wrote:
> > U. Postgresql doesn't natively support cross database queries...
> >
>
> I know, but it does schema's, and currently, the same
> notation is used to specify schema's as 'cross database'.
>
> So the planner often reports 'cross-database not allowed'
> in
On Thu, 12 Feb 2004, Rod Taylor wrote:
> > But for seperating out applications from each other, there's really
> > nothing to be gained by putting each seperate database application into
> > it's own cluster.
>
> I believe the initial email requested individual logs, and presumably
> the abilit
On Wed, 11 Feb 2004 [EMAIL PROTECTED] wrote:
> Thank you very much for your reply.
>
> Yes, that's true. But it seems not a good idea if I have many databases
> and I want them totally seperated with each other.
>
> What's your opinion? Thanks.
OK, here's the issue. Postgresql uses certain res
share data and logs could gain me something.
> And if I have 2 databases totally not relevant, I think the most natural
> way is to make them totally seperated. Does the sharing buys me
> anything? If not, what's the reason of doing it?
>
> Thank you very much.
>
>
On Wed, 11 Feb 2004 [EMAIL PROTECTED] wrote:
> Hi, all
>
> What should I do if I want to have 2 completely seperated databases in
> PostgreSQL? I want each database to have its own data, log and
> everything needed to access that database. I don't want them to share
> anything. Has anyone done th
On Tue, 10 Feb 2004, Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> No it doesn't. EOF will do fine. The source program doesn't
> >> necessarily have to know anything about COPY, as long as its output is
> >> in a format COPY can cope with (eg, tab-delimited
On Fri, 6 Feb 2004, Joe Conway wrote:
> scott.marlowe wrote:
> > gives me nothing. Shouldn't a negative offset, or even 0 offset result in
> > an error or something here? Or is there a special meaning to a negative
> > offset I'm not getting?
>
&g
I'm using substring. Since I'm a coder more than a database guy, I
expected this:
select substring('abcdefgh',0,4);
would give me
abcd
but it gives me a left aligned 'abc'
select substring('abcdefgh',1,4);
works fine.
select substring('abcdefgh',-4,4);
gives me nothing. Shouldn't a nega
On Wed, 4 Feb 2004, Michael Brusser wrote:
> We have customers who prefer to use their backup facilities
> instead of what we provide in the app (we use pg_dump)
> I hear speed is at least one consideration.
>
> The questions I need to answer are these:
>
> 1) Is this absolutely safe to do file
On Mon, 2 Feb 2004, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > any chance of having some kind of max_total_sort_mem setting to keep
> > machines out of swap storms, or would that be a nightmare to implement?
>
> I don't see any
On Mon, 2 Feb 2004, Augusto Cesar Castoldi wrote:
> How can I configure postgreSQL to search without acents?
>
> Is PostgreSQL have this support?
>
> I configured my locale to pt_BR, that support acents, create table with
> enconding "latin1", but nothing works. I know that I can use function
>
On Mon, 2 Feb 2004, Tom Lane wrote:
> Jeff <[EMAIL PROTECTED]> writes:
> >> On Sat, 31 Jan 2004, Tom Lane wrote:
> > Well, maybe. What's in the back of my mind is that we may come
> > across other cases besides CREATE INDEX and VACUUM that should use a
> > "one-off" setting. I think it'd make mo
On Wed, 28 Jan 2004 [EMAIL PROTECTED] wrote:
> I agree I MAY have an hardware problem. What happens is more a system
> freeze than a system crash (there's no panic, no nothing, just freezes, no
> disk activity, not network)
I would suspect either bad hardware,a flakey SCSI driver, or a possible
On Thu, 22 Jan 2004, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > On Wed, 21 Jan 2004, Tom Lane wrote:
> >> The GEQO planner module contains six different recombination algorithms,
>
> > considering the recent discussion about
On Wed, 21 Jan 2004, Tom Lane wrote:
> The GEQO planner module contains six different recombination algorithms,
> only one of which is actually used --- the others are ifdef'd out, and
> have been ever since we got the code. Does anyone see a reason not to
> prune the deadwood?
considering the r
On Fri, 16 Jan 2004, Michael Brusser wrote:
> Is there a way to force database to load
> a frequently-accessed table into cache and keep it there?
Nope. But there is a new cache buffer handler that may make it into 7.5
that would make that happen automagically.
---(end
On Mon, 12 Jan 2004, Martin Marques wrote:
> Mensaje citado por "Marc G. Fournier" <[EMAIL PROTECTED]>:
>
> >
> > Native Win32 is planned for it (whether it makes it or not is another
> > question, but it is the goal) ...
>
> Replication wasn't another BIG one?
Actually, I think it was PITR (P
On Fri, 19 Dec 2003, Bruce Momjian wrote:
> Robert Treat wrote:
> > Wasn't there a patch posted many months ago for PITR. IIRC it wasn't
> > complete, but would be a good starting point for those interested in
> > helping out. If it's in the archives it would be nice to add a link to
> > it on the
On Tue, 16 Dec 2003, Jon Jensen wrote:
> On Tue, 16 Dec 2003, Jan Wieck wrote:
>
> > If you want to prevent "accidential" access, start postmaster on a
> > non-standard port.
>
> That seems like an unfriendly thing to do. You'd have to check to see what
> port is "standard" for this particular
On Sun, 9 Nov 2003, Jan Wieck wrote:
> scott.marlowe wrote:
>
> > On Fri, 7 Nov 2003, Matthew T. O'Connor wrote:
> >
> >> - Original Message -
> >> From: "Jan Wieck" <[EMAIL PROTECTED]>
> >> > Tom Lane wrote:
> &g
On Fri, 7 Nov 2003, Matthew T. O'Connor wrote:
> - Original Message -
> From: "Jan Wieck" <[EMAIL PROTECTED]>
> > Tom Lane wrote:
> > > Gaetano and a couple of other people did experiments that seemed to show
> > > it was useful. I think we'd want to change the shape of the knob per
> >
On Wed, 5 Nov 2003, Tom Lane wrote:
> Rod Taylor <[EMAIL PROTECTED]> writes:
> >> I'm not sure if that will actually change the default_statistics_target
>
> > Hmm.. I was under the impression that it would work for any tables that
> > haven't otherwise been overridden.
>
> It will. I think Sco
On Wed, 5 Nov 2003, Rod Taylor wrote:
> Since this is a large query, attachments for the explains / query.
>
> Configuration:
> dev_iqdb=# select version();
> version
>
On Tue, 4 Nov 2003, Gaetano Mendola wrote:
> I agree in general with you for these "general" arguments, but here we
> are talking about to introduce a sleep ( removable by guc ) or not! What
> about the hash refactoring introduced with 7.4? Are you going to
> discourage people to use the hash?
Is this a bug we should fix for 7.3.5 when it eventually comes out?
On Tue, 4 Nov 2003, Andrew Rawnsley wrote:
>
> Just build RC1 today on Panther, no problems.
>
>
> On Nov 4, 2003, at 5:06 PM, Jeff Hoffmann wrote:
>
> > Tom Lane wrote:
> >> [EMAIL PROTECTED] writes:
> >>> After spending a f
On Tue, 4 Nov 2003, Tom Lane wrote:
> Jan Wieck <[EMAIL PROTECTED]> writes:
> > What still needs to be addressed is the IO storm cause by checkpoints. I
> > see it much relaxed when stretching out the BufferSync() over most of
> > the time until the next one should occur. But the kernel sync at
On Thu, 30 Oct 2003, Joshua D. Drake wrote:
> If I understood correctly, Josh was complaining about VACUUM sucking too
>
> >much of his disk bandwidth. autovacuum wouldn't help that --- in fact
> >would likely make it worse, since a cron-driven vacuum script can at
> >least be scheduled for low-
On Thu, 30 Oct 2003, Joshua D. Drake wrote:
> Hello,
>
>I know I will probably be flamed into oblivion for this but I would
> like to make a suggestion about
> the upcoming release.
>
>What if we delayed until the end of the year?
>
>The two reasons that I can come up with are:
>
On Thu, 30 Oct 2003, ivan wrote:
>
> you can also patch your kernel and when you write cat /etc/passwd system
> give you only your line , whitout any others users, so exacly what you
> need ,
> in pgsql i think that users dont need to know about others , and also
> them
> databases, i call it sec
On 30 Oct 2003, Vatsal Avasthi wrote:
>
> Hi,
> I am facing a strange problem and thats bugging me for a long time,
> I am using postgres version 7.2.1.
Is it possible for you to upgrade to 7.2.4 just to make sure it's not a
problem that was fixed from 7.2.1 to 7.2.4?
--
On 29 Oct 2003, Doug McNaught wrote:
> Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
>
> > FreeBSD 4.9 was released today. In the release notes was:
> >
> > 2.2.6 File Systems
> >
> > A new DIRECTIO kernel option enables support for read operations that
> > bypass the buffer cache and pu
On Tue, 28 Oct 2003, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > Is it possible to remove the implicit search path of pg_catalog from a
> > psql session without it breaking lots of stuff?
>
> Do you consider "+", "count
On Tue, 28 Oct 2003, Tom Lane wrote:
> Rod Taylor <[EMAIL PROTECTED]> writes:
> > I say leave it the way it is. If you want system table tab completion,
> > simply:
> > ALTER USER ... SET search_path =3D pg_catalog,...;
>
> Unfortunately, that *does not* affect the tab-completion behavior
On Fri, 24 Oct 2003, Michael Brusser wrote:
> But this seems to work correctly on 7.3.2 and 7.3.4:
> psql -c "select round (2.5)"
> Password:
> round
> ---
> 3
> (1 row)
>
> =
> >
> > I just tried that on my 7.2.4 and 7.4 beta 4 machines and I get 2 for
> > round(2.5)
A
On Wed, 22 Oct 2003, Jochen Westland [invigo] wrote:
> Hi All,
> i'm running Postgresql 2.2x, so i am not quitse sure wether the bug i am reporting
> is already fixed
> in newer versions or not.
>
> In my version
> select round(2.5); returns 2;
> select round(2.501) returns 3;
>
> refering
Sounds like your drives are full.
On Thu, 23 Oct 2003, Yuval Lieberman wrote:
> Hi!
>
> I'm doing a select (from an OACS page or from psql) and I get:
> ERROR: Failed to create temporary file pgsql_tmp/pgsql_tmp27212.775
>
> The same select work ok a different database (which is on a different
On Wed, 22 Oct 2003, Tom Lane wrote:
> Richard Huxton <[EMAIL PROTECTED]> writes:
> > On Wednesday 22 October 2003 06:55, Peter Eisentraut wrote:
> >> The idea is that you give each function its own schema search path at
> >> creation time, and that path applies to that function for the rest of it
On Wed, 22 Oct 2003, Tom Lane wrote:
> Rod Taylor <[EMAIL PROTECTED]> writes:
> > That said, perhaps the TODO for changing LIMIT / OFFSET to be expression
> > based should also mention bumping them to int8.
>
> Can't get excited about it ... this would slow down the normal use of
> the facility f
On 14 Oct 2003, Greg Stark wrote:
>
> Michael Brusser <[EMAIL PROTECTED]> writes:
>
> > > Michael Brusser <[EMAIL PROTECTED]> writes:
> > > > 2003-10-10 22:37:05 ERROR: cannot read block 0 of s_noteimportlinks:
> > > > Interrupted system call
> > >
> > > Hmm. I found this hard to believe at f
OK, I've done some more testing on our IDE drive machine.
First, some background. The hard drives we're using are Seagate
drives, model number ST380023A. Firmware version is 3.33. The machine
they are in is running RH9. The setup string I'm feeding them on startup
right now is: hdparm -c3
On Tue, 30 Sep 2003, Steve Yalovitser wrote:
> Hello,
>
> I'd like to know if its possible to coopt the postgres storage subsystem to
> rely entirely on ram based structures, rather than disk. Any documentation
> or ideas would be appreciated.
Sure, create a ram disk. Set $PGDATA to it with pro
On Wed, 1 Oct 2003, Darko Prenosil wrote:
> Two mails with updated translations for /src/backend/po/hr.po are lost.
> First time I send clear po file, second tar.gz - no result.
> Is something blocking mails with attachment ? I didn't receive notification
> that mail is blocked or something li
On Wed, 1 Oct 2003, Joshua D. Drake wrote:
>
> >With 7.4 I'm finding upgrading to be easier. I'll likely upgrade out
> >production servers to 7.4.0 when it comes out and wind up skipping 7.3
> >altogether.
> >
> >
>
> Sure but I talking about people who are running 7.3 and are happy with
>
On Tue, 30 Sep 2003, Tom Lane wrote:
> It seems some junior electrician in Panama pulled the wrong circuit
> breaker ... and then the mail.postgresql.org server spent an
> unreasonable number of hours fsck'ing. (Why is Marc a FreeBSD fan
> anyway? Don't ask me, I work for Red Hat.) Anyhow, due
On Tue, 30 Sep 2003, Joshua D. Drake wrote:
> Hello,
>
> With the recent stint of pg_upgrade statements and the impending
> release of 7.4 what
> do people think about having a dedicated maintenance team for 7.3? 7.3
> is a pretty
> solid release and I think people will be hard pressed to upg
On Fri, 26 Sep 2003, Peter Eisentraut wrote:
> scott.marlowe writes:
>
> > table name too, like Bruce said. The bothersome bit is that in pg_dump,
> > it says the line, relative to just this part of the copy command, so you
> > don't even know which table is givin
On Fri, 26 Sep 2003, Tom Lane wrote:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > scott.marlowe writes:
> >> but I get basically the same thing if I dump it to a .sql file and do:
> >> psql dbname
> > Use psql -f dbname.sql instead.
>
> This
On Fri, 26 Sep 2003, Peter Eisentraut wrote:
> scott.marlowe writes:
>
> > but I get basically the same thing if I dump it to a .sql file and do:
> >
> > psql dbname
> Use psql -f dbname.sql instead.
and the output is:
psql:webport.sql:803: ERROR: function &quo
On Fri, 26 Sep 2003, Peter Eisentraut wrote:
> Bruce Momjian writes:
>
> > The argument that you want a warning because you might have mixed
> > newlines in the file seems less likely than this case where they are
> > using a literal carriage return as a data value at the end of the line.
>
> I
On Fri, 26 Sep 2003, Bruce Momjian wrote:
> scott.marlowe wrote:
> > > OK, 'vi' shows it as:
> > >
> > > COPY people2 (id, persons) FROM stdin;
> > > 59 Chance Terry--S
> > > 60 ^M
> > > \.
> > >
On Fri, 26 Sep 2003, Bruce Momjian wrote:
> scott.marlowe wrote:
> > > OK, 'vi' shows it as:
> > >
> > > COPY people2 (id, persons) FROM stdin;
> > > 59 Chance Terry--S
> > > 60 ^M
> > > \.
> > >
On Fri, 26 Sep 2003, Bruce Momjian wrote:
> scott.marlowe wrote:
> > The attached file produces this problem. Note it's a blank trailing field
> > that looks to be causing it. The error for this .sql file is:
> >
> > ERROR: literal carriage return foun
On Fri, 26 Sep 2003, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > I'm running into issues where 7.4's pg_dump/pg_dumpall from a 7.2 database
> > to a 7.4beta3 database is producing some errors like this:
>
> > ERROR: li
On Fri, 26 Sep 2003, Bruce Momjian wrote:
> Tom Lane wrote:
> > Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > > Tom Lane writes:
> > >> so it appears that cygwin's "echo" generates a different newline style
> > >> than what got put into sql_features.txt. A possible way to fix this is
> > >> to
On Fri, 26 Sep 2003, Christopher Kings-Lynne wrote:
> >>Is there any chance we could have initdb show the version of postgresql
> >>it is running as when initdb is run?
> >
> >
> > If you install many different versions in parallel, don't you give your
> > installation paths some meaning that co
On 25 Sep 2003, Robert Treat wrote:
> oh.. and i'm not forgetting plphp, but it has both licensing issues and
> isn't ready for prime time.
I thought there weren't any license issues, except mayhaps with the name.
http://www.php.net/license/3_0.txt
---(end of broadcast)
On Fri, 19 Sep 2003, Joshua D. Drake wrote:
> Hello,
>
> I just read a rather disturbing post
>
> PostgreSQL does not support read uncommited and repeatable read
> isolation levels? If that is so... then PostgreSQL is NOT ACID compliant?
>
> What is the real deal on this?
Postgresql
On Tue, 9 Sep 2003, Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Is our maximum table size limited by the maximum block number?
>
> Certainly.
>
> > Is the 16TB number a hold-over from when we weren't sure block number
> > was unsigned, though now we are pretty sure it is hand
On Mon, 8 Sep 2003, Bruce Momjian wrote:
> Dann Corbit wrote:
> > Mingw uses the native Win32 libraries.
> >
> > Porting from a Mingw port to VC++ will be trivial compared to what we
> > have now.
> >
> > > where can I access latest dev source code and dev docs in
> > > the/from CVS ?
> >
> >
Would it be possible to catch an unconstrained max(id)/min(id) and rewrite
it as "select id from table order by id [desc] limit1" on the fly in the
parser somewhere?
That would require fairly little code, and be transparent to the user.
I.e. low hanging fruit.
On 5 Sep 2003, Greg Stark wrote:
1 - 100 of 252 matches
Mail list logo
