Hello Tom,
While you were busy responding (should have checked email sooner!) my
coworker helped me go through the core file and we found the exact
problem, which was of course what you pointed out. A little wasted time
maybe, but it was neat to see what was really going on. Thanks very much
for
On Wed, May 23, 2001 at 11:55:09AM -0400, George Herson wrote:
> But since i made the original post i rebooted my server and now i think
> that (a reboot) was also needed, as a couple of little things outside
> PHP/Apache/Posgresql (in Netscape, actually) are now working that were
> broken pre-boo
"Norman J. Clarke" <[EMAIL PROTECTED]> writes:
> However, on update to the larger (100k+)columns, the postgres backend
> crashes and dumps core. I've included a backtrace from the core file.
This looks entirely irrelevant to either TOAST or update; I think it is
the known 7.1.1 bug with SELECTs t
I was able to do this, but not with a simple query :-(
Here's the solution I came up with. Perhaps someone else
knows an easier way to do this?
Using your table (called 'RESULTS' in my example):
test=# select ASMT_CODE,count(*)::float4 as TOTAL into tmp1 from RESULTS
group by ASMT_CODE;
Table t
On Fri, May 25, 2001 at 01:45:18AM +0600, Ivan Likhachov wrote:
> Hello!
>
> Does postgreSQL has FULLTEXT search for TEXT data type... like in MS SQL?
See contrib/fulltextindex
You might also want to search the archives -- IIRC, some people have
found this solution a bit lacking.
Cheers,
Nei
On Tue, 22 May 2001, mordicus wrote:
> Stephan Szabo wrote:
> >> explain select * from titles where lower(title) = 'monde';
> >> Seq Scan on titles (cost=0.00..39392.10 rows=14145 width=44)
> >
> > How many rows are in titles? It seems to estimate 14000+
> > rows are going to match. If that's
On Thu, May 24, 2001 at 01:33:46AM +, John wrote:
> Yes I posted a bunch of stuff way to hastily and was not clear. I ran
> perl -e 'use DBD::Pg' and got this:
>
> perl -e 'use DBD::Pg'
> Can't locate DBD/Pg.pm in @INC (@INC contains:
> /usr/lib/perl5/5.00503/i586-linux /usr/lib/perl5/5.005
Hello,
I have some tables with text (TOAST) columns that store xml files of up to
about 100k in size. Most are less than 1-10k, with the 100k columns being
somewhat unusual. I'd like to have the liberty of occaisonally storing up
to about 2MB in these columns without resorting to BLOB columns if
On Thu, 24 May 2001, Carlos Moreno wrote:
>
> Stephan Szabo wrote:
> >
> > Use numeric with appropriate precision information.
>
> I'm assuming that when I use numeric specifying the
> number of decimals, there is no rounding error in
> the arithmetic and storage? (well, other than
That's
Look in the programmer docs
For C: www.postgresql.org/idocs/index.php?libpq.html
For C++: www.postgresql.org/idocs/index.php?libpqplusplus.html
Tim
- Original Message -
From: "Mayan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 21, 2001 10:36 PM
Subject: [GENER
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Trond Eivind Glomsrød writes:
>
> > "pg_ctl restart" seems to not work as documented in postgresql 7.1.2.
> >
> > bash-2.04$ /usr/bin/pg_ctl restart -w -D /var/lib/pgsql/data -m fast
> > waiting for postmaster to shut down..done
> > postmaster s
"mike" <[EMAIL PROTECTED]> writes:
> I'm trying to reset my datestyle which works till I have to log out and log=
> back into my shell.
> the docs have nothign in them ast to how to keep the datestyle set. is this=
> somethign that can
> be done once, or does it have to be done every single time
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Ideally yes, but they're "special cases" by virtue of behaving specially.
> AFAIR, the behaviour couldn't be fitted in exactly, but maybe with the
> "assign hook" it would work.
Even if these variables can't easily be made table-driven,
it seems like
Hi all,
I am running postgres7.1 and php4.0. When I do top while running my
query via browser I notice that the postmaster process takes up almost
100% of the CPU and this is just for one user. What would happen if
multiple users does the same search at the same time would the
postmaster die?
pgsql 7.1 how to --with-tcl
thanks
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
If you are planing to use ecpg :
exec sql declare cuserbase cursor for
select column1, column2, column3 from my_table order by 1;
exec sql open cuserbase;
exec sql whenever not found do break;
while ( true ) {
exec sql fetch cuserbase into ...
// do same work
}
exec sql close cuserb
excusem for the first message in spanish.
I need insert aproximatly 20,000 tuples in one table and i run
psql dbname -f scriptofquerys
so show the next error
query buffer maxlength of 16,384 exceeded
thank for your help
Hector Morales
---(end of broadcast)
I have a windows application using a MSSQL (the free 2gig version) database.
When the application is first started, I have to select 'sql server' and
then I need to
give the sql setup (servername, user+pass) in an ODBC datasource setup
dialog.
Now I am wondering, would there be a chance I could u
Hi,
I have a table in one of my databases which has a row of type char. I would
like to convert it to int data type. Is there an easy way for doing it?
With regards,
Devrim GÜNDÜZ
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you se
KÈmeri Lajos wrote:
> And I call it: select * from LOGIN ('username', 'password');
> Result: 1, 'Lewis'
>
In PostgreSQL you can define only functions, they go a long way, but are
not really stored procedures. A stored procedure can return a tuple just
like you show. A function can only return
"Sergey E. Volkov" <[EMAIL PROTECTED]> wrote in message
news:<9ej088$ulc$[EMAIL PROTECTED]>...
> If you are planing to use ecpg :
>
> exec sql declare cuserbase cursor for
> select column1, column2, column3 from my_table order by 1;
> exec sql open cuserbase;
Thanks, but this is exactly w
Hi Everyone,
I am running Postgres 7.1 and php 4.0.
I have a question: Why does postmaster use 80% of the CPU on a simple sql
query? I have a form that displays a list of customers based on a criteria
they enter. If the user doesn't enter in a criteria it will display all the
customer in th
Hi everybody,
my subject is about : DBI / PostgreSql & Transactions with Perl.
my code is :
$dbh->{AutoCommit} = 0; # begin of transaction
while () {
...
$sql = "insert into $table ($col) values ($val)";
$res = $dbh->do($sql);
}
$dbh->rollback;#
Stephan Szabo wrote:
>
> Use numeric with appropriate precision information.
I'm assuming that when I use numeric specifying the
number of decimals, there is no rounding error in
the arithmetic and storage? (well, other than
rounding on the decimals beyond the ones specified --
e.g., if I
Jason,
Thank you for the insightful post. I did make a typo when I typed DBM. I
guess I was frazzled and really meant DBD. Since I eventuall want to open a
socket and send some data to/from the database, you have made me realize (or
remember) why I was using perl in the first place. Thanks.
-Jo
I've discovered this huge file 16Meg in the data/pg_xlog directory
but information for it is alluding my discover too.
What is it and how can i manage it? Can it be deleted or is some
tool necessary to deal with it?
--
Bob Himes
Pure Matrix, Inc.
303-245-1045ext. 105
http://www.purematrix
Yes, I meant turn off Autocommit for the entire psql session.
Starting every manipulation of the database with a BEGIN is
a bit tiresome, and i often catch myself with forgetting it.
If it isn't possible, it would be a nice featue!?
Björn
Tim Mickol wrote:
> Actually, I think the original que
Hello,
I'm logged on as root, but when I run the install.sh program from the
CD, I get the following error in /tmp/pginstall.log:
Xlib: unexpected async reply (sequence 0x31)!
I see several python programs running via the installation script, but
they never return. I have to kill the installati
Yes I posted a bunch of stuff way to hastily and was not clear. I ran
perl -e 'use DBD::Pg' and got this:
perl -e 'use DBD::Pg'
Can't locate DBD/Pg.pm in @INC (@INC contains:
/usr/lib/perl5/5.00503/i586-linux /usr/lib/perl5/5.00503
/usr/lib/perl5/site_perl/5.005/i586-linux /usr/lib/perl5/site_p
On redhat, if you used the rpms you can start postgres by
cd /etc/rc.d/init.d
./postgresql start
You should set it to start automatically using the gnome configurator
Dave
- Original Message -
From: "Lee Johnson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 22, 2001
hicham bouzdad <[EMAIL PROTECTED]> wrote in message
news:<[EMAIL PROTECTED]>...
> Hi everybody,
>
> my subject is about : DBI / PostgreSql & Transactions with Perl.
> my code is :
>
> $dbh->{AutoCommit} = 0; # begin of transaction
> while () {
> ...
> $sql = "insert into
Hi all,
Does anyone know what the heck CLISP is, and/or if there's a driver for
using PostgreSQL with it? :-)
I'll add it to the techdocs.postgresql.org website if there is too.
:-)
Regards and best wishes,
Justin Clift
Gunjan Varshney wrote:
>
> Dear,
>
> We are working on a project in C
Hello!
Does postgreSQL has FULLTEXT search for TEXT data type... like in MS SQL?
Please answer me to my email!
Thankx!
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
But when I've finished calculating the 4 billion names of God, it wont
matter anyway - end of universe as we know it . . . ;-)
Regards.
SGO.
<[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Remembering past discussions: Yes OID's wrap around. When this happens,
Que tal lista, necesito ayuda con lo siguiente.
Intento levantar desde un archivo de texto una serie de insert
aproximadamente 20,000 tuplas a una tabla en postgres. Ejecuto
psql dbname -f scriptdeinserts
y cunado va insertando la tupla 2,013 me tira el siguiente mensaje
query buffer maxlengt
I need insert aproximatly 20,000 tuples in one table and i run
psql dbname -f scriptofquerys
so show the next error
query buffer maxlength of 16,384 exceeded
thank for your help
Hector Morales
---(end of broadcast)---
TIP 1: subscribe and u
36 matches
Mail list logo
