Dnia poniedziałek, 14 marca 2005 19:32, Scott Marlowe napisał:
> On Mon, 2005-03-14 at 12:03, Marcin Giedz wrote:
> > Hello...
> >
> >
> > Our company is going to change SQL engine from MySQL to PSQL. Of course
> > some performance problems occured. Our server is Dual Xeon 3.0GHz + 8GB
> > RAM + RA
Hi,
I made an update from 7.4.2 to 7.4.7 and pgadmin II
does not connect anymore. The error message is: "The database does not exist on
the server or user authentication failed.". The settings are good, I can connect
with pgadmin III without no problem.
Do you know also any other postgre
Not
stand-alone [web-based and required PHP] but phppgadmin works pretty
well.
http://phppgadmin.sourceforge.net/
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Andrei
BintintanSent: Tuesday, March 15, 2005 5:50 AMTo:
pgsql-admin@postgr
Hello all
I am trying to grant privs to a user on all tables. I think I understood
there was no command to do that :// so I wrote the following:
create or replace function granting() RETURNS integer AS '
declare
v_schema varchar;
v_user varchar;
begin
v_user := "user"
Hello list,
I am trying to create a table that hould countain a number formatted
this way: MMDD##
Where the hashes should be padded to '0'.
I have tried the following
template_test=# CREATE TEMP TABLE test (
template_test(# counter SERIAL,
template_test(# foobar CHAR(18)
template_test
Werner vd Merwe wrote:
Output of VACUUM ANALYSE VERBOSE pg_listener:
Query OK, 0 rows affected (0.06 sec)
INFO: vacuuming "pg_catalog.pg_listener"
INFO: "pg_listener": found 0 removable, 0 nonremovable row versions in 0
pages
INFO: analyzing "pg_catalog.pg_listener"
INFO: "pg_listener": 0 pages
CREATE TABLE test(
counter SERIAL,
foobar CHAR(100)
DEFAULT to_char(CURRENT_DATE, 'DDMM') ||
trim(to_char(nextval('test_counter_seq'),'00')),
tekst TEXT);
I don't know exactly why the white space is in, but the trim function takes
it out.
Best regards,
Andy.
- Original Message -
CREATE TABLE test(
counter SERIAL,
foobar CHAR(18)
DEFAULT to_char(CURRENT_DATE, 'DDMM') ||
trim(to_char(nextval('test_counter_seq'),'00')),
tekst TEXT);
I don't know exactly why the white space is in, but the trim function takes
it out.
Best regards,
Andy.
- Original Message -
On Tue, 2005-03-15 at 02:59, Marcin Giedz wrote:
> Dnia poniedziaÅek, 14 marca 2005 19:32, Scott Marlowe napisaÅ:
> > On Mon, 2005-03-14 at 12:03, Marcin Giedz wrote:
> > > Hello...
> > >
> > >
> > > Our company is going to change SQL engine from MySQL to PSQL. Of course
> > > some performance prob
Dnia wtorek, 15 marca 2005 17:08, Scott Marlowe napisaÅ:
> On Tue, 2005-03-15 at 02:59, Marcin Giedz wrote:
> > Dnia poniedziaÅek, 14 marca 2005 19:32, Scott Marlowe napisaÅ:
> > > On Mon, 2005-03-14 at 12:03, Marcin Giedz wrote:
> > > > Hello...
> > > >
> > > >
> > > > Our company is going to chan
On Tue, 2005-03-15 at 10:17, Marcin Giedz wrote:
> Dnia wtorek, 15 marca 2005 17:08, Scott Marlowe napisaÅ:
> > On Tue, 2005-03-15 at 02:59, Marcin Giedz wrote:
> > > Dnia poniedziaÅek, 14 marca 2005 19:32, Scott Marlowe napisaÅ:
> > > > On Mon, 2005-03-14 at 12:03, Marcin Giedz wrote:
> > > > > He
I am far to lazy to bother actually trying it, but I believe prefixing
your format string for the bigint returned by nextval with 'FM' will
eliminate your need for the trim.
On Mar 15, 2005, at 11:15 AM, Andrei Bintintan wrote:
CREATE TABLE test(
counter SERIAL,
foobar CHAR(18)
DEFAULT to_char(C
Question on vacuuming.
When you do a vacuum , are the "freed" tuples available only the
table, or to the entire db, or to the entire cluster?
The reason I'm asking is that we are getting ready to preform a major
upgrade to our application that involves adding some new fields to
almost every tab
http://madpenguin.org/cms/html/62/3677.html
I for one think that Postgres 8.0 is great and that the largest hurdle for the
project is the lack of [easy] developer tools that MySQL has. This in turn,
seems to make learning Postgres and SQL more difficult for less experienced
users that turn to
I am not certain that this is the correct forum for Kudos, but after
taking a long break from using PostgreSQL I am also delighted with how
good it is doing. I always hated the fact the it was missing table
spaced and I am also excited about Point In Time backups.
Maybe it is just because I
Hi Brad,
Just before I carry on - I am not sure if top-posting is 'allowed' on this
list, if not, please let me know and I'll stop :)
Will gently be level 15?
There are a couple of locks, both exclusive and shared...
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED
-Original Message-
From: weiping [mailto:[EMAIL PROTECTED]
Sent: 15 March 2005 05:55 PM
To: Werner vd Merwe
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Performance Question
what' your JDBC version?
if it's pretty old, then upgrade to newest one is a bet.
Don't know if it could s
"Chris Hoover" <[EMAIL PROTECTED]> writes:
> We have also had one test occurrence where after the upgrade, a vacuum
> full would not recover the space. However, when we bounced the
> postmaster, and then performed a vacuum full, the space was recovered.
> Any ideas on what might cause this?
M
18 matches
Mail list logo
