Since we just had the discussion about index size, I have written a
section for our administration manual that shows ways of finding the
disk usage for specific tables and databases:
http://candle.pha.pa.us/main/writings/pgsql/sgml/diskusage.html
I also updated README.oid2name to show a
Just so you know, current CVS HEAD passes all tests on FreeBSD/Alpha (a
64bit machine) with this configure:
./configure --prefix=/home/chriskl/local --enable-integer-datetimes --enable
-debug --enable-depend --enable-cassert --with-pam --with-openssl --with-CXX
Chris
--
> On Wed, 2002-06-12 at 19:41, Bruce Momjian wrote:
>> Ewe, appropriate entries?
I'm thinking we should just import the current state of the files
and not worry about preserving their change history.
regards, tom lane
---(end of broadcast)
> > What is a TRUNCATE TABLE but a drop create anyway? Is there some
> > technical difference?
> >
> It doesn't kill indexes/triggers/constraints/Foreign Key Stuff, etc.
Hrm - last time I checked it did...
Chris
---(end of broadcast)---
TIP 1:
> Do we need to do any more work to document this problem?
Better documetation will be welcome. However which document?
--
Tatsuo Ishii
> ---
>
> Tatsuo Ishii wrote:
> > > Oops. How about:
> > >
> > > foo'; DROP TABLE t1;
On Wed, 2002-06-12 at 19:41, Bruce Momjian wrote:
> Larry Rosenman wrote:
> > >
> > > I think we will just give you CVS access. Not sure how to get the CVS
> > > history. I think if you send me the CVS root I can use CVS import to
> > > load it.
> > If you "Repocopy" the files, the history will
Larry Rosenman wrote:
> >
> > I think we will just give you CVS access. Not sure how to get the CVS
> > history. I think if you send me the CVS root I can use CVS import to
> > load it.
> If you "Repocopy" the files, the history will stay intact. Basically
> move his CVS/ files to your reposit
On Wed, 2002-06-12 at 17:30, Bruce Momjian wrote:
> Jeroen T. Vermeulen wrote:
> > On Wed, Jun 12, 2002 at 05:48:46PM -0400, Bruce Momjian wrote:
> > >
> > > I can add it to CVS as interfaces/libpqxx and we can then let others
> > > merge your configure tests into our main configure. Let me know
Dann Corbit wrote:
> > > So now, I started getting down to the details. One global
> > structure...
> > > I started a major rewrite to repair it. Then (to my abject
> > horror) I
> > > discovered there is no SQLCA at all. Project abandoned
> > (actually, just
> > > switched to libpq and ever
> -Original Message-
> From: Bruce Momjian [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 12, 2002 3:20 PM
> To: Dann Corbit
> Cc: Michael Meskes; [EMAIL PROTECTED]
> Subject: Re: [HACKERS] PostGres Doubt
>
>
> Dann Corbit
> > > I assume this is because you wrote your code assuming
Thomas Lockhart wrote:
> Right. I'm not certain about the regex syntax defined by SQL99; I used
> the syntax that we already have enabled and it looks like we have a
> couple of other variants available if we need them. If someone wants to
> research the *actual* syntax specified by SQL99 that wou
Jeroen T. Vermeulen wrote:
> On Wed, Jun 12, 2002 at 05:48:46PM -0400, Bruce Momjian wrote:
> >
> > I can add it to CVS as interfaces/libpqxx and we can then let others
> > merge your configure tests into our main configure. Let me know when
> > you want it dumped into CVS.
>
> Might as well do
Bradley Kieser wrote:
> Well in Ingres there is a WORLD of difference! For a start, you don't
> lock out the system catalog. Secondly it is an unlogged event, so it
> beats "delete from table_name" hands down! Then, of course, it preserves
> all permissions, you keep the same OID, so views, et
On Wed, Jun 12, 2002 at 05:48:46PM -0400, Bruce Momjian wrote:
>
> I can add it to CVS as interfaces/libpqxx and we can then let others
> merge your configure tests into our main configure. Let me know when
> you want it dumped into CVS.
Might as well do it right now, with 0.5.2. We'll call th
Dann Corbit
> > I assume this is because you wrote your code assuming a feature was in
> > ecpg, but it wasn't, right?
>
> I have written lots of programs that use embedded SQL. I have (for
> instance) several ODBC drivers that use embedded SQL and C++ as part of
> an ODBC driver system. I mer
> -Original Message-
> From: Bruce Momjian [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 12, 2002 2:42 PM
> To: Dann Corbit
> Cc: Michael Meskes; [EMAIL PROTECTED]
> Subject: Re: [HACKERS] PostGres Doubt
>
>
> Dann Corbit wrote:
> > I should apologize for being rather harsh about em
Well in Ingres there is a WORLD of difference! For a start, you don't
lock out the system catalog. Secondly it is an unlogged event, so it
beats "delete from table_name" hands down! Then, of course, it preserves
all permissions, you keep the same OID, so views, et al, can remain in
tact, as wi
Jeroen T. Vermeulen wrote:
> On Wed, Jun 12, 2002 at 04:04:36PM -0400, Neil Conway wrote:
> >
> > Otherwise, if you put the code into src/interfaces/libpqxx and modify
> > the PostgreSQL build system to be aware of it (as well as removing
> > libpqxx's autoconf stuff), it shouldn't be too difficul
Dann Corbit wrote:
> I should apologize for being rather harsh about embedded SQL for
> PostgreSQL.
>
> To be fair, it does function and it certainly isn't trivial to
> implement. I am sure that those who have worked on this project have
> invested very many hours of blood, sweat and tears makin
Dann Corbit wrote:
> > -Original Message-
> > From: Michael Meskes [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, June 12, 2002 5:41 AM
> > To: Dann Corbit
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: [HACKERS] PostGres Doubt
> >
> >
> > On Mon, Jun 10, 2002 at 02:08:22PM -0700, Dann Corb
I am not sure that this has enough general interest to be included in
our code. If you make a loadable module, we can add it to our web site.
---
Alex Shevlakov wrote:
> New 'path' functions (test results can be found at
On Wed, Jun 12, 2002 at 04:04:36PM -0400, Neil Conway wrote:
>
> Otherwise, if you put the code into src/interfaces/libpqxx and modify
> the PostgreSQL build system to be aware of it (as well as removing
> libpqxx's autoconf stuff), it shouldn't be too difficult.
One concern I have on this point
On Wed, 12 Jun 2002 20:29:21 +0200
"Jeroen T. Vermeulen" <[EMAIL PROTECTED]> wrote:
> I think libpqxx, the alternative to libpq++, is just about ready for
> prime time.
Great -- I like libpqxx a lot, and I'd like to see it in 7.3. We should
also probably keep libpq++ around for backward compatibi
On Wed, 2002-06-12 at 13:37, Billy O'Connor wrote:
>Deletion of data from a PostgreSQL table is very slow.
>
>It would be nice to have a very fast delete like "truncate table."
>
>Now, truncate is a very dangerous command because it is not logged (but
>the same is true for other
> -Original Message-
> From: Larry Rosenman [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 12, 2002 12:36 PM
> To: Dann Corbit
> Cc: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] Feature request: Truncate table
>
>
> On Wed, 2002-06-12 at 14:32, Dann Corbit wrote:
> > Deletion of data f
Deletion of data from a PostgreSQL table is very slow.
It would be nice to have a very fast delete like "truncate table."
Now, truncate is a very dangerous command because it is not logged (but
the same is true for other operations like bulk copy and select into).
So one needs to
On Wed, 2002-06-12 at 14:32, Dann Corbit wrote:
> Deletion of data from a PostgreSQL table is very slow.
>
> It would be nice to have a very fast delete like "truncate table."
>
> Now, truncate is a very dangerous command because it is not logged (but
> the same is true for other operations like
Deletion of data from a PostgreSQL table is very slow.
It would be nice to have a very fast delete like "truncate table."
Now, truncate is a very dangerous command because it is not logged (but
the same is true for other operations like bulk copy and select into).
So one needs to be careful how
I think libpqxx, the alternative to libpq++, is just about ready for
prime time. That means integrating it with the main source tree, I
suppose, but I have no idea where to start--particularly because libpqxx
has its own configure setup.
Anyone who can help me with this?
Jeroen
PS: find libpq
...
> I would assume that they would use their brain.
Way uncalled for. You must have some other underlying issues to get this
bad 'tude, but please note that ad hominum attacks are *never* welcome
on this or any other PostgreSQL mailing list.
Regards.
- Thomas
-
I should apologize for being rather harsh about embedded SQL for
PostgreSQL.
To be fair, it does function and it certainly isn't trivial to
implement. I am sure that those who have worked on this project have
invested very many hours of blood, sweat and tears making it work.
I actually spent a
Tom Lane wrote:
> I said:
> > Sorry, you used up your chance at claiming that t_hoff is dispensable.
> > If we apply your already-submitted patch, it isn't.
>
> Wait, I take that back. t_hoff is important to distinguish how much
> bitmap padding there is on a particular tuple --- but that's real
Do we need to do any more work to document this problem?
---
Tatsuo Ishii wrote:
> > Oops. How about:
> >
> > foo'; DROP TABLE t1; -- foo
> >
> > The last ' gets removed, leaving -- (81a2).
> >
> > So you get:
> > select
> -Original Message-
> From: Michael Meskes [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 12, 2002 5:41 AM
> To: Dann Corbit
> Cc: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] PostGres Doubt
>
>
> On Mon, Jun 10, 2002 at 02:08:22PM -0700, Dann Corbit wrote:
> > ECPG is single threadin
Michael Meskes wrote:
> Hi,
>
> there were several people at my talk asking if PostgreSQL is available
> on Novell Netware. I know I read about someone working on this, but
> didn't follow the thread at all since I do not have any Netware servers.
Attached is an email message from someone who is
David Ford <[EMAIL PROTECTED]> writes:
> So reentrancy in libpq basically is put on hold until 7.3.
Only if you insist on using "crypt", which is deprecated anyway.
md5 is the preferred encryption method.
My feeling about the proposed patch was that crypt is now a legacy auth
method, and it's no
Michael Meskes wrote:
> On Tue, Jun 11, 2002 at 06:58:54AM -0400, Bruce Momjian wrote:
> > Wow, how did that "A" get into the query string:
>
> Buffer overrun. :-(
>
> I just committed Lee's patch. Thanks a lot.
>
> BTW. I didn't even know that this bug was reported against ecpg. Somehow
> I mi
I.e. "md5" in pg_hba.conf? This is rather disappointing.
Here are a few references:
http://lists.initd.org/pipermail/psycopg/2002-January/000673.html
http://lists.initd.org/pipermail/psycopg/2002-January/000674.html
http://archives.postgresql.org/pgsql-bugs/2002-03/msg00048.php
And finally..
h
John Taylor <[EMAIL PROTECTED]> writes:
> On Wednesday 12 June 2002 16:36, Tom Lane wrote:
>> Queries after the failure aren't run at all; they're only passed through
>> the parser's grammar so it can look for a COMMIT or ROLLBACK command.
>> Normal processing resumes after ROLLBACK. If you were
Hi Michael,
I know all about the story of PostgreSQL for NetWare.
I will tell you the story now:
First I want to introduce myself:
I'm a Novell DeveloperNet SysOp and i'm working with the database
team and the C Library team at Novell in Provo/Utah.
The story starts last year in may at Novell's
Hi,
there were several people at my talk asking if PostgreSQL is available
on Novell Netware. I know I read about someone working on this, but
didn't follow the thread at all since I do not have any Netware servers.
Does anyone out there know more?
Thanks in advance.
Michael
--
Michael Meskes
Good points; not sure why I didn't pick up on this too.
I should point out that I've seen code with heavy Oracle-isms brought
into PostgreSQL using ecpg with amazingly few changes. It is a great
piece of code; any large complaints should perhaps be directed at the
SQL standards themselves...
On Mon, Jun 10, 2002 at 02:08:22PM -0700, Dann Corbit wrote:
> ECPG is single threading. Hence, tools written in ECPG are a pain in
> the neck if you want multiple threads of execution. I recommend against
Did he say he wants to write a multi-threaded app?
> using it for any purpose except por
On Mon, Jun 10, 2002 at 08:09:57PM -, vikas p verma wrote:
> this question of mine. I want to insert/update records into the
> postgres database through C or perl code. The only condition is
> that it should be efficient. Can anybody tell me the difference
> between ecpg and libpq and which
On Tue, Jun 11, 2002 at 06:58:54AM -0400, Bruce Momjian wrote:
> Wow, how did that "A" get into the query string:
Buffer overrun. :-(
I just committed Lee's patch. Thanks a lot.
BTW. I didn't even know that this bug was reported against ecpg. Somehow
I missed it. I guess I need to rescan the bu
Tatsuo Ishii wrote:
>
> > > > > There are "full width alphabets" in Japanese. Thoes include not only
> > > > > ASCII letters but also some European characters.
> > > >
> > > > Are these ASCII and European characters uppercased in some
> > > > Japanese-specific way ?
> > >
> > > Probably not, but
On Tue, 2002-06-11 at 18:36, Josh Berkus wrote:
> Karel,
>
> > The to_interval() will have another (you wanted) behaviour.
>
> Please, please, please do not use to_interval for text formatting of
> intervals.
If he meant what _I_ described then this was exactly that, i.e.
converting (string,
Hi Igor,
Thanks for your information.
I was aware of the "signal" problems and i've done it with thread based
signals
This part is functional on my platform but it isn't fully cooked.
Another problem
is to make this part portable.
Your assumption to replace SysV semaphores with POSIX semaphores
48 matches
Mail list logo
