Hi!
I have the the folowing objects:
CREATE TABLE sao(
id INT4,
type VARCHAR,
ra INT4,
de INT4,
mag INT2
);
create index sao_drm on sao(de,ra,mag);
create index sao_dm on sao(de,mag);
create index sao_i on sao(id);
CREATE TABLE tycho(
reg_id INT2
Hmmm hi all,
Alright I've GOT to be blind (knowing me it's a good possibility)... but
I have a need to allow postgresql users to be able to change their own
password, but if they don't have access to the pg_shadow or update user
command how to I grant them this privilage and/or what command wou
I was having the same problem. In pg_hba.conf I had the following lines:
local all password .superusers
local design password .pg_design
I switched the order of the lines so that the "local all" was last and that
fixed the problem
local design password .pg_design
local all password .superusers
Hi all,
Is there a way to deploy, say, only pgsql to a remote host, so that users
from remote host can connect to the pgsql database server, without deploying
the whole pgsql to the remote host?
TIA,
Eugene
---(end of broadcast)---
TIP 4: Don't
Previous DBA create a lot of triggers and functions without
documentation like:
CREATE TRIGGER trigger_name [BEFORE | AFTER] event ON table_name
FOR EACH ROW EXECUTE PROCEDURE function_name();
Now he is gone. I couldn't find his PL/PGSQL source codes!
I can do
SELECT * FROM pg_proc;
SELECT * F
"Eugene Chiu" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED].;
> Hi all,
>
> Have any of you successfully configured Linux-PAM with Postgresql? When I
> run ./configure --with-pam, I get the following error:
>
>
> checking for inflate in -lz... (cached) yes
> checking for library co
Heni Lolov <[EMAIL PROTECTED]> writes:
> explain select *
> from tyc_glup
> where de>0 and de<100 and ra<10 and ra>0;
> NOTICE: QUERY PLAN:
> Merge Join (cost=42975.66..44050.21 rows=34159 width=50)
> -> Sort (cost=108.53..108.53 rows=26 width=14)
> -> Index Scan using t
"Raymond Chui" <[EMAIL PROTECTED]> writes:
> Previous DBA create a lot of triggers and functions without
> documentation like: ...
> Now he is gone. I couldn't find his PL/PGSQL source codes!
"pg_dump -s" is your friend.
regards, tom lane
---(end
hi,
i am running some tests and i would like to see how long it takes to run a
query. "explain" gives me query plan info, but i want to actually run the
query and then find out how long it took.
is there a way with psql to get the time it takes to perform a query?
thanks.
-lucas
-
On Wed, 27 Feb 2002, Raymond Chui wrote:
> Previous DBA create a lot of triggers and functions without
> documentation like:
>
> CREATE TRIGGER trigger_name [BEFORE | AFTER] event ON table_name
> FOR EACH ROW EXECUTE PROCEDURE function_name();
>
> Now he is gone. I couldn't find his PL/PGSQL sour
On 4 Mar 2002 at 7:28, Lucas Rockwell wrote:
> i am running some tests and i would like to see how long it takes to run a
> query. "explain" gives me query plan info, but i want to actually run the
> query and then find out how long it took.
>
> is there a way with psql to get the time it takes
I'm doing a vacuum on an empty database (except for the system tables). I've
loaded & deleted about 140MB of data 3 times prior to this.
Does it seem reasonable that the vacuum would take more than an hour to run?
It's currently taking all of the idle CPU time, so it's working hard at
something..
Raymond Chui wrote:
> Previous DBA create a lot of triggers and functions without
> documentation like:
>
> CREATE TRIGGER trigger_name [BEFORE | AFTER] event ON table_name
> FOR EACH ROW EXECUTE PROCEDURE function_name();
>
> Now he is gone. I couldn't find his PL/PGSQL source codes!
>
> I can
Lucas Rockwell <[EMAIL PROTECTED]> writes:
> i am running some tests and i would like to see how long it takes to run a
> query. "explain" gives me query plan info, but i want to actually run the
> query and then find out how long it took.
Update to 7.2 and use EXPLAIN ANALYZE.
Hi postgres friends
I have two database that i see in base directory
.
When i connect in database with psql -u and perform
\dt there no tables !!!
What happen ?
Help
___Fouad
FezziIngenieur RéseauIUP Institut Universitaire
ProfessionnaliséUniversite d'Avignon
I'm using postgres as an backend with java servlet/jsp using linux as
operating system but when i see the see the CPU process using TOP command
than what i found that postmaster is using 97% of CPU which raise my system
speed very slow. so could u pls help me to sort out my problem that how can
Hi postgres friends
I have two databases that i see in /base directory .
with psql -u database and perform \dt and i see no tables !!!
but i can see system tables.
What happen ?
Help
___
Fouad Fezzi
Ingenieur Réseau
IUP Institut Universitaire Professionnalisé
Univer
Greetings,
I need help configuring SEMMNI and SEMMNS for postgres 7.1 under Solaris.
We are upgrading from postgres 6.4 to 7.1. When I start postmaster, I get
the following error message in postmaster.out:
--
IpcSemaphoreCreate: semget(key=5432002, num=17, 03600) failed: No space
l
Hi,
When I try and create an index on a text field, I get this response:
"ERROR: btree: index item size 4496 exceeds maximum 2713"
On another PGSQL database I only got that message when the size was above
8192. How can I change my database to use the full 8192 size? Or how can I
get around
Hey again.
Well I got some help from someone on the list already.
Turns out shared_buffers was commented out of postgresql.conf.
I set shared_buffers to 32 and max_connections to 16 just to
try it and it appeared to work.
Thanks to all.
Eric
Eric Scroger wrote:
> Greetings,
>
> I need help
Jon Hassen <[EMAIL PROTECTED]> writes:
> When I try and create an index on a text field, I get this response:
> "ERROR: btree: index item size 4496 exceeds maximum 2713"
> On another PGSQL database I only got that message when the size was above
> 8192.
Perhaps you were using BLCKSZ=32K on t
21 matches
Mail list logo
