Cefull Lo wrote:
I just installed phpPgAdmin-4.1.3, when I try to
login, it always tell me login fail.
Probably the phpPgAdmin list would be the best place to ask, but let's see.
I followed the steps in FAQ but still can't login.
OK
I'm sure that postgresql is running and accepting
tcpip
Hello
On 11/01/2008, Sim Zacks [EMAIL PROTECTED] wrote:
I changed it to where f.commited is not true and the query now takes 1
second as opposed to 60.
(much faster then the 3 seconds it took on 8.0.1, which could also be because
of the coalesce there)
Is it considered better practice (or
Hi,
I want to compare the record's transaction id in sql statements or
PL/pgSQL stored procedure. Are there any system function or operator can
safely(transaction id wraparound safed) compare the transaction id?
Thanks!
---(end of broadcast)---
2008/1/10, Clodoaldo [EMAIL PROTECTED]:
2008/1/10, Tom Lane [EMAIL PROTECTED]:
It would be interesting to see the identical test on Clodaldo's
installations.
This is 8.2.6 in the new server:
cpn= create table foo (f1 int, f2 int, f3 int, f4 real);
CREATE TABLE
cpn= create index fooi on
Gauthier, Dave, 11.01.2008 15:55:
Is there a way to alter a varchar column’s length? Maybe something like
“alter table foo alter column xyz varchar(256)”.
A quick look into the manual would have revealed the correct syntax:
http://www.postgresql.org/docs/8.2/static/sql-altertable.html
On 1/11/08, alphax [EMAIL PROTECTED] wrote:
I want to compare the record's transaction id in sql statements or
PL/pgSQL stored procedure. Are there any system function or operator can
safely(transaction id wraparound safed) compare the transaction id?
In 8.3 there are txid functions that
2008/1/11, Clodoaldo [EMAIL PROTECTED]:
2008/1/10, Clodoaldo [EMAIL PROTECTED]:
2008/1/10, Tom Lane [EMAIL PROTECTED]:
It would be interesting to see the identical test on Clodaldo's
installations.
This is 8.2.6 in the new server:
cpn= create table foo (f1 int, f2 int, f3 int, f4
Hello
CREATE TABLE foog(a varchar(10));
ALTER TABLE foog ALTER COLUMN a TYPE varchar(30);
postgres=# \d foog
Table public.foog
Column | Type | Modifiers
+---+---
a | character varying(30) |
regards
Pavel Stehule
On
Is there a way to alter a varchar column's length? Maybe something like
alter table foo alter column xyz varchar(256).
My alternative seems very messy...
- alter table, add a new column with the desired varchar
length. call it temp
- insert into temp the value of the old
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 11 Jan 2008 14:29:32 -0300
João Paulo Zavanela [EMAIL PROTECTED] wrote:
Hi there,
I want to know how many connections is created simultaneously in data
base per day.
Entirely depends on your machine. I wouldn't suggest having more than
Hi there,
I want to know how many connections is created simultaneously in data base
per day.
Are there some table where i can search it?
All users is connected in the database with postgres user.
Thanks.
João Paulo Zavanela
---(end of
On Jan 11, 2008 1:22 PM, Erik Jones [EMAIL PROTECTED] wrote:
On Jan 11, 2008, at 12:14 PM, Scott Marlowe wrote:
On Jan 11, 2008 12:02 PM, Josh Harrison [EMAIL PROTECTED] wrote:
Hi
We have an Oracle production database with some terbytes of data.
We wanted
to migrate that to
On Jan 11, 2008, at 12:14 PM, Scott Marlowe wrote:
On Jan 11, 2008 12:02 PM, Josh Harrison [EMAIL PROTECTED] wrote:
Hi
We have an Oracle production database with some terbytes of data.
We wanted
to migrate that to Postgresql (rigt now...a test database and not
production) database.
What
Josh Harrison wrote:
Hi
We have an Oracle production database with some terbytes of data. We
wanted to migrate that to Postgresql (rigt now...a test database and
not production) database.
What are the good options to do that?
Please advise me on where to look for more information on this
On 11/01/2008, Jessi Berkelhammer [EMAIL PROTECTED] wrote:
Hello.
I'm trying to figure out why a query I'm doing is incredibly slow (~10
minutes.) The incredibly slow query is something like:
SELECT count(*) from registration LEFT JOIN person USING (person_id)
WHERE
Jessi Berkelhammer [EMAIL PROTECTED] writes:
The hold-up seems to be in a 'Nested Loop Left Join', which is only in
the plan for the slow query.
Here are the first two lines of EXPLAIN ANALYZE on the slow query:
So you've left out all the information that would let anyone guess what
the
I am pleased to announce first commercial use of Analytic SQL Server
(ASQL) based on PostgreSQL.
Analytic SQL Server is implementation of the next generation Data
Warehouse Model (for now available only for PostgreSQL server), with
full OLAP functionality and analytical processing support
Hello.
I'm trying to figure out why a query I'm doing is incredibly slow (~10
minutes.) The incredibly slow query is something like:
SELECT count(*) from registration LEFT JOIN person USING (person_id)
WHERE x_program(registration.x_type_code) = 'blah';
The person view is quite big (~69000
On Jan 11, 2008, at 11:51 AM, Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 11 Jan 2008 14:29:32 -0300
João Paulo Zavanela [EMAIL PROTECTED] wrote:
Hi there,
I want to know how many connections is created simultaneously in data
base per day.
Entirely
On Jan 11, 2008 12:02 PM, Josh Harrison [EMAIL PROTECTED] wrote:
Hi
We have an Oracle production database with some terbytes of data. We wanted
to migrate that to Postgresql (rigt now...a test database and not
production) database.
What are the good options to do that?
Please advise me on
On Jan 11, 2008 11:29 AM, João Paulo Zavanela [EMAIL PROTECTED] wrote:
Hi there,
I want to know how many connections is created simultaneously in data base
per day.
Do you want to know the max simo connections at any given time, or the
total connections in a given day? Assuming you want to
Hi
We have an Oracle production database with some terbytes of data. We wanted
to migrate that to Postgresql (rigt now...a test database and not
production) database.
What are the good options to do that?
Please advise me on where to look for more information on this topic
thanks
josh
On Mon, Jan 07, 2008 at 12:30:50PM -0500, Kevin Hunter wrote:
Hi List,
I have multiple objects to which I'd like to associate comments. I'd like
this to be a many to one relationship, so that each object can have many
different comments. The issue is how to have one comment table. One
Hello.
Thanks for the replies.
Pavel Stehule wrote:
what do you do in x_program function? Are you sure so it is fast?
I do not think the function is the problem, as running the slow query
without it is just as slow, and similar queries using that function are
quick.
Tom Lane wrote:
--- On Fri, 1/11/08, David Fetter [EMAIL PROTECTED] wrote:
One method
that has been proposed is to have a third table which
stores to what object
type a comment belongs, but I don't like this
because the foreign key
relationships then wouldn't be maintained by the
database. The only
I've just tried compiling our project against the 8.3RC1 code. This is the first
time I've tried any release of 8.3.
Several components use ECPG. I'm now getting an ECPG error. Compiling on 8.2.3
is fine. I've checked the 8.3 release documentation and there don't seem to be
any that change
Jessi Berkelhammer [EMAIL PROTECTED] writes:
Here are the 3 EXPLAIN ANALYZE commands followed by the output:
Well, here's the problem:
Join Filter: (clinical_reg_current.client_id = client.client_id)
- Subquery Scan clinical_reg_current (cost=754.36..758.23
rows=1
Marko Kreen wrote:
On 1/11/08, alphax [EMAIL PROTECTED] wrote:
I want to compare the record's transaction id in sql statements or
PL/pgSQL stored procedure. Are there any system function or operator can
safely(transaction id wraparound safed) compare the transaction id?
In 8.3 there are txid
28 matches
Mail list logo