On Wed, Jun 23, 2004 at 02:43:06PM +0900, Joel Matthew wrote:
We used to have some attempts at optimizing on the assumption that
char(n) fields were physically fixed-width, but we gave it up as a
bad job several major releases back ... it was never more than a
very marginal optimization
Hi Stephan,
it was the problem, but not realy understand the reason. The documentetion
sais that perform doesn't porvide the return value and I thought I do not
need that. But I read absently, and didn't realized that the query to
perform must be a SELECT.
Thank you for opening my eyes. :) Now
In article [EMAIL PROTECTED],
Együd Csaba [EMAIL PROTECTED] writes:
Hi Stephan,
it was the problem, but not realy understand the reason. The documentetion
sais that perform doesn't porvide the return value and I thought I do not
need that. But I read absently, and didn't realized that the
Yes, yes you are right. :)
I had already modified that (using TG_OP variable) before I posted the
letter just didn't mentioned.
By the way the trigger does its task. Rally. :)
Thanks,
-- Csaba
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Harald
hello,
Excuze me,
If I want to add localization support in my language Except the messages
in postgres, what parts, must be done in Glibc? and what parts must be
done in postgres?
LC_COLLATE,LC_CTYPE,LC_MONETARY,LC_NUMERIC,LC_TIME
I found that the collation order must be done in glibc.
What about
On Sun, 2004-06-27 at 00:36, Jay wrote:
Hi group,
I am trying to get pgsql working on my debian system. I installed pgsql
using apt-get. but then i cant connect to it . i am using the following
command
psql -U jay -d jaydb
earlier i used create su postgres 'createdb root' jaydb.
hi oliver
i tried the following command but nothing seems to work
psql -U root -d root
psql: FATAL: IDENT authentication failed for user root
any suggestions
thanks
jay
Oliver Elphick wrote:
On Sun, 2004-06-27 at 00:36, Jay wrote:
Hi group,
I am trying to get pgsql working on my debian system.
Hi,
yes it is vacuumed regulary once a day. And vacuum full is done once a week.
The reasons of the slow seq scan are those two stored procedures in the
field list (get_stock and get_stock_getup). These take 13-20 ms every time
thay executed. Multiplying with the nr of rows we get 11-18 sec.
It
I found this error in /var/log/messages yesterday after a cron job
wouldn't complete:
STATEMENT: ALTER TABLE victoria.eodData DROP COLUMN tickDate;
ERROR: tables can have at most 1600 columns
STATEMENT: ALTER TABLE victoria.eodData ADD COLUMN tickerID INTEGER;
ERROR: tables can have
[EMAIL PROTECTED] (Thomas F. O'Connell) wrote in message news:
postgresql.conf just has the default of 1000 shared_buffers. The
database itself has thousands of tables, some of which have rows
numbering in the millions. Am I correct in thinking that, despite the
hint, it's more likely that I
Thanks Grega your explanation will go a far way, Thanks again
-- Adam --
Grega Bremec wrote:
...and on Sun, Jun 20, 2004 at 07:50:53PM -0700, Adam Smith used the keyboard:
I have posted this and similar questions repeatedly and can't even raise
a single response. I am being led to believe that
I have posted this and similar questions repeatedly and can't even raise
a single response. I am being led to believe that this then 'Must be a
stupid question' although people say that there is no stupid question.
Is that another for political correctness
I am attempting an install of 7.4.3
On Sun, Jun 27, 2004 at 11:11:32AM -0700, Ron St-Pierre wrote:
I found this error in /var/log/messages yesterday after a cron job
wouldn't complete:
STATEMENT: ALTER TABLE victoria.eodData DROP COLUMN tickDate;
ERROR: tables can have at most 1600 columns
STATEMENT: ALTER TABLE
hmmm, not sure that this is the best way.
under linux runing ./configure --help will show you the default instlation
paths. go to each one of them and delete.
On future instelation you can consider
using --prefix=/usr/local/priv_dir_pg_what_ever_ver
dont forget to update PATH and ld.conf
1)from root su postgres
2)createuser the username
3)exit
4)su the user
5)createdb
psql the database
Jay wrote:
hi oliver
i tried the following command but nothing seems to work
psql -U root -d root
psql: FATAL: IDENT authentication failed for user root
any suggestions
thanks
jay
Oliver Elphick
Jay [EMAIL PROTECTED] writes:
i tried the following command but nothing seems to work
psql -U root -d root
psql: FATAL: IDENT authentication failed for user root
You basically cannot use the -U switch when using IDENT authorization;
that auth mode requires that your presented Postgres
=?iso-8859-1?Q?Egy=FCd_Csaba?= [EMAIL PROTECTED] writes:
It is strange that the laptop substantially faster then the server. The
get_stock* functions are executed 2-3 times faster.
So what do those stored procedures do exactly?
What it smells like to me is a bad plan for a query executed in
I have the following situation:
I'm developing an reverse geocoder, so input is lat/lon coordinate and
output is the nearest textual location.
I have a database of +- 2 000 000 records that contains lat/lon and full
name of the location.
These are the steps I take now:
1 'draw' a box around the
[EMAIL PROTECTED] (Thomas F. O'Connell) writes:
Now I'm curious: why does pg_dump require that
max_connections * max_shared_locks_per_transaction be greater than the
number of objects in the database?
Not objects, just tables. pg_dump takes AccessShareLock (the weakest
kind of lock) on each
Alvaro Herrera [EMAIL PROTECTED] writes:
On Sun, Jun 27, 2004 at 11:11:32AM -0700, Ron St-Pierre wrote:
STATEMENT: ALTER TABLE victoria.eodData DROP COLUMN tickDate;
ERROR: tables can have at most 1600 columns
STATEMENT: ALTER TABLE victoria.eodData ADD COLUMN tickerID INTEGER;
ERROR:
Jonathan Raemdonck [EMAIL PROTECTED] writes:
These are the steps I take now:
1 'draw' a box around the lat/lon position we have as input
2 search the DB for all the points in this box
3 measure the distance to each point in the box
Right. All you need is an index amenable to step 2.
Is
hi people
i am trying to connect to ppstgresql on a debian system using perl . i
am getting the following error .can any one please suggest what has to
be done
install_driver(pg) failed: Can't locate DBD/pg.pm in @INC (@INC
contains: /etc/perl /usr/local/lib/perl/5.8.3
On Sun, 2004-06-27 at 21:05, Jay wrote:
hi people
i am trying to connect to ppstgresql on a debian system using perl . i
am getting the following error .can any one please suggest what has to
be done
install_driver(pg) failed: Can't locate DBD/pg.pm in @INC (@INC
contains: /etc/perl
23 matches
Mail list logo