Ari Jolma <[EMAIL PROTECTED]> writes:
> Is this kind of behavior intended. When I try to rename a table to
> a reserved word - I have tried to use 'lseg' which is a type - postgres
> gives me an error but the change has been partly done and the
> only way back seems to be to go to the database d
Ari Jolma <[EMAIL PROTECTED]> writes:
> template1=> create table a (a int);
> CREATE
> template1=> select a from a union select a from a where a in (select a from
> a);
> NOTICE: _outNode: don't know how to print type 1044119613
> NOTICE: _outNode: don't know how to print type 1044119613
Inte
> Well, when you have 2.7 million records in a database, the code might be
as good
> as it can be.
I have recoverd the performance lost when I moved to Postgres 7.0 by
executing
SET enable_indexscan = OFF before creating my cursors and turning it back on
for the inner loop query. It may even be
> I have set index_scan off for tomorrow morning's run. I will let you know
> what happens.
I think my problem is fixed. By disabling index scan while creating the
cursors and then turning it back on again for the small query that occurs in
my inner loop the performance has returned to normal (
Does anyone have a startup script for Postgres 7.0 that I can throw into my
/etc/rc.d/init.d directory? (RedHat 6.1)
Thanks,
Sam
--
_
/ Samuel A. Mullen \
| Programmer Analyst |___
| Opportunities Unl. | More to be desired
"Terry Van Belle" <[EMAIL PROTECTED]> writes:
>
>
>
>
>
>
>
> Hi All,
>
> I've been trying to automatically parse th=
> e SQL'92=20
> grammar, based on the BNF found in the ISO spec. So far no luck throw=
> ing=20
> yacc, yay, or JavaCC at it. Does anyone know what type of grammar it =
Ari Jolma wrote:
> template1=> select a from a union select a from a where a in (select a from
> a);
> NOTICE: _outNode: don't know how to print type 1044119613
> NOTICE: _outNode: don't know how to print type 1044119613
> a
> -
> (0 rows)
Hmm, I may be missing something, but "select a from a"
"Samuel A. Mullen" wrote:
>
> Does anyone have a startup script for Postgres 7.0 that I can throw into my
> /etc/rc.d/init.d directory? (RedHat 6.1)
A complete startup script is distributed with the RedHat RPMS for
PostgreSQL 7.0, available at
ftp://ftp.postgresql.org/pub/binary/v7.0/redhat-RPM
[EMAIL PROTECTED] (Jan Wieck) writes:
> Do you mean the TOAST snapshot I provided?
No, he's just griping about the fact that manipulating many thousand
Large Objects in one transaction stresses the system unpleasantly.
(Too many table locks grabbed is the usual killer, I think.) TOAST
sh
"Bryan White" <[EMAIL PROTECTED]> writes:
> I have recoverd the performance lost when I moved to Postgres 7.0 by
> executing SET enable_indexscan = OFF before creating my cursors and
> turning it back on for the inner loop query. It may even be faster
> then before so I am happy.
OK, so it was t
> "Bryan White" <[EMAIL PROTECTED]> writes:
> > I have recoverd the performance lost when I moved to Postgres 7.0 by
> > executing SET enable_indexscan = OFF before creating my cursors and
> > turning it back on for the inner loop query. It may even be faster
> > then before so I am happy.
>
> O
On Fri, 26 May 2000, Martijn van Oosterhout wrote:
> Ari Jolma wrote:
> > template1=> select a from a union select a from a where a in (select a from
> > a);
> > NOTICE: _outNode: don't know how to print type 1044119613
> > NOTICE: _outNode: don't know how to print type 1044119613
> > a
> > -
What distribution U utlize folks?
I have tried Mandrake 7 and it run perfectly just until I try to recompile
it (from RC1 to definitive) (remember Postgresql instability messages from
me?); After have totally reconfigured and recompiled 3 times I am trying a
shiteous suse6.4 demo(1CD) that
planx plnetx wrote:
>
> What distribution U utlize folks?
> I have tried Mandrake 7 and it run perfectly just until I try to recompile
> it (from RC1 to definitive) (remember Postgresql instability messages from
RedHat 6.2.
Thomas Lockhart has Mandrake 7, and is one of the core developers --
On Thu, 25 May 2000, planx plnetx wrote:
> What distribution U utlize folks?
> I have tried Mandrake 7 and it run perfectly just until I try to recompile
> it (from RC1 to definitive) (remember Postgresql instability messages from
> me?); After have totally reconfigured and recompiled 3 time
* planx plnetx <[EMAIL PROTECTED]> [000525 12:51] wrote:
> What distribution U utlize folks?
> I have tried Mandrake 7 and it run perfectly just until I try to recompile
> it (from RC1 to definitive) (remember Postgresql instability messages from
> me?); After have totally reconfigured and re
Hi,
I am developing an application that will use the
C API for postgreSQL and I need to know this:
1 - How many tuples can be returned as a result of a
query using a CURSOR? (Is it possible to do a SELECT
* on a table that has 2 million records and OPEN a
CURSOR for that SELECT and show all r
Martijn van Oosterhout wrote:
>
> Ari Jolma wrote:
> > template1=> select a from a union select a from a where a in (select a from
> > a);
> > NOTICE: _outNode: don't know how to print type 1044119613
> > NOTICE: _outNode: don't know how to print type 1044119613
> > a
> > -
> > (0 rows)
>
> Hm
Hi-
I'm a newbie at postgresql and was working on
sorting by category. What my question is, how do you
sort by category when using a variable. For instance,
you can sort by name in perl by doing:
$sqh = $dbh->prepare(q{select name from company order
by name;});
$sqh->execute();
but what if
Peter Landis wrote:
>
>
> How do you sort by the variable?
>
> $sqh = $dbh->prepare(q{select name from company order
> by $sort_selection;});
> $sqh->execute();
Your problem is not Perl specific. The order by column
must be in the result set (projection). Why not doing
it this way:
my @fields
Ari Jolma <[EMAIL PROTECTED]> writes:
> It seems that there needs to be a union and a subselect.
Yes.
> And the really curious thing is that this problem seems
> to depend on which redhat version there is!
It was trying to interpret a pointer-to-character-string as
a pointer to a Node, so the r
Marcos Barreto de Castro <[EMAIL PROTECTED]> writes:
> 1 - How many tuples can be returned as a result of a
> query using a CURSOR? (Is it possible to do a SELECT
> * on a table that has 2 million records and OPEN a
> CURSOR for that SELECT and show all records'contents
> using FETCH FORWARD, for
HI!
i rescently upgraded my system from PG6.53 to PG7.0. after a few days of
work i am unable to do a vacuum on one of tables:
nat=# VACUUM verbose analyze osoby;
NOTICE: --Relation osoby--
NOTICE: Pages 189: Changed 0, reaped 24, Empty 0, New 0; Tup 3436: Vac
29, Keep/VTL 0/0, Crash 0, UnUsed
Tom Lane writes:
> The idea I suggested a couple of days ago was that initdb should refuse
> to run if PGDATA exists and is nonempty. Sound reasonable?
Okay, let's do that. How do you find out if a directory is empty? The best
way I could think of is this:
test x"`ls -A "$PGDATA"`" = x
Are we
Marcin Inkielman <[EMAIL PROTECTED]> writes:
> i rescently upgraded my system from PG6.53 to PG7.0. after a few days of
> work i am unable to do a vacuum on one of tables:
> nat=# VACUUM verbose analyze osoby;
> NOTICE: FlushRelationBuffers(osoby, 182): block 186 is referenced
> (private 0, glob
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> How do you find out if a directory is empty?
Good question.
> The best way I could think of is this:
> test x"`ls -A "$PGDATA"`" = x
The embedded quotes might confuse some shells, no? Perhaps better
CONTENTS=`ls -A "$PGDATA"`
if t
On Thu, 25 May 2000, Tom Lane wrote:
> Date: Thu, 25 May 2000 19:49:00 -0400
> From: Tom Lane <[EMAIL PROTECTED]>
> To: Marcin Inkielman <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] PG 7.0 vacuum problem
>
> Marcin Inkielman <[EMAIL PROTECTED]> writes:
> > i rescently up
Hello:
Novice, just installed PGSQL 7.0 on Redhat 6.1.
Everything went smoothly with initial installation and db setup.
However, I've run into some problems subsequently.
To keep it simple, here is a specific problem. Attempting to create a
database in an alternate location, I went through
Try createdb -D $PGDATA2 testdb
At 11:26 PM 5/25/00, J.R. wrote:
> Hello:
>
>Novice, just installed PGSQL 7.0 on Redhat 6.1.
>
>Everything went smoothly with initial installation and db setup.
>However, I've run into some problems subsequently.
>
>To keep it simple, here is a specific problem
> Try createdb -D $PGDATA2 testdb
I will be surprised if that works. The initlocation manual says -D can
be a path or an environment variable which will be referenced. Not sure
what that means.
>
> At 11:26 PM 5/25/00, J.R. wrote:
> > Hello:
> >
> >Novice, just installed PGSQL 7.0 on Redh
> Try createdb -D $PGDATA2 testdb
>
> At 11:26 PM 5/25/00, J.R. wrote:
> > Hello:
OK, I see this in the code, so it seems $PGDATA2 and 'PGDATA2' are the
same:
if [ "$?" -ne 0 -a ! -d "$Location" ]; then
PGALTDATA=`printenv $Location 2> /dev/null`
if [ -z "$PGALTDATA" ]; then
For those people using pg_dump and pg_dumpall, are you making sure your
dump files are not world-readable?
--
Bruce Momjian| http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ C
I have completed my book. New chapters include:
Chapter 18, Functions and Triggers
Chapter 20, Administration
I still need to work on the appendix and index.
I want to thank the many people who e-mailed me with suggestions and
encouragement. This helped make the book better,
On Thursday 25 May 2000, at 18 h 56, the keyboard of "planx plnetx"
<[EMAIL PROTECTED]> wrote:
> Help me I don't wanna run the debian whith his diabolique
> dselect & apt-get
I run PostgreSQL on Debian without problems, it's much simpler than on Tru64, it works
fine and I seize the opportu
34 matches
Mail list logo
