Great !!!
Many thanks Kristo, it's just what I need
Guy
Kristo Kaiv a écrit :
> i guess this what you meant:
> (not a nice solution though) writing a function that returns the set
> would be a better idea
>
> create table testintarr (iarr int[]);
> insert into testintarr values ('5,6,7,8');
>
>
On 6 5 , 9 12 , [EMAIL PROTECTED] (Brad Nicholson) wrote:
> On Tue, 2007-06-05 at 03:33 -0700, Charles.Hou wrote:
> > how can i know that it's the time to vacuumdb? i set the crontab to
> > vacuumdb 3 times in one day. because my database size increase from
> > 440MB to 460MB in 8 hours.
>
> Have
On 6 5 , 9 25 , [EMAIL PROTECTED] (Andrew Sullivan) wrote:
> On Tue, Jun 05, 2007 at 03:33:09AM -0700, Charles.Hou wrote:
> > how can i know that it's the time to vacuumdb? i set the crontab to
> > vacuumdb 3 times in one day. because my database size increase from
> > 440MB to 460MB in 8 hours.
On Tue, 2007-06-05 at 16:59 -0700, Charles.Hou wrote:
> On 6 5 , 9 12 , [EMAIL PROTECTED] (Brad Nicholson) wrote:
> > On Tue, 2007-06-05 at 03:33 -0700, Charles.Hou wrote:
> > > how can i know that it's the time to vacuumdb? i set the crontab to
> > > vacuumdb 3 times in one day. because my datab
Hi group!
If I want to change the default order of two columns of a table, can I
just manipulate the values in
pg_catalog.pg_attribute.attnum?
I am trying to do this in pg 8.1.9. Works the same in pg 8.2.x I would
assume?
BEGIN;
UPDATE pg_catalog.pg_attribute SET attnum = 4
WHERE attrelid = 12345
Erwin Brandstetter escribió:
> Hi group!
>
> If I want to change the default order of two columns of a table, can I
> just manipulate the values in
> pg_catalog.pg_attribute.attnum?
It works -- as long as the table is empty.
--
Alvaro Herrerahttp://www.CommandPro
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Erwin Brandstetter escribió:
>> If I want to change the default order of two columns of a table, can I
>> just manipulate the values in
>> pg_catalog.pg_attribute.attnum?
> It works -- as long as the table is empty.
And as long as you have no views, fo
On Jun 6, 4:59 pm, [EMAIL PROTECTED] (Tom Lane) wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > Erwin Brandstetter escribió:
> >> If I want to change the default order of two columns of a table, can I
> >> just manipulate the values in
> >> pg_catalog.pg_attribute.attnum?
> > It works -- as
More important question would be, why would you want to do this (change columns
order)?
I can't think of any valid reason for this.
Igor Neyman
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erwin
Brandstetter
Sent: Wednesday, June 06, 2007 11:22 AM
T
On Jun 5, 12:13 pm, [EMAIL PROTECTED] (Kristo Kaiv) wrote:
> i guess this what you meant:
> (not a nice solution though) writing a function that returns the set
> would be a better idea
>
> create table testintarr (iarr int[]);
> insert into testintarr values ('5,6,7,8');
>
> test=# select iarr[idx
I am testing upgrades to 8.2.4 from 8.1.3 and am having problems with
8.2.4balking at the functional indexes I have created. These indexes
exist and
work fine in 8.1.3, so why is 8.2.4 rejecting them?
Index 1:
CREATE INDEX acceptedbilling_to_date_accepted_billing_dt_idx
ON acceptedbilling
USIN
On Tue, Jun 05, 2007 at 05:28:10PM -0700, Charles.Hou wrote:
> Client connected: about 100 pc, 1 pc with 1 connection at least, the
> max is 4 connections
So up to 400 connections? Are they all running transactions? For
any length of time?
> 194 tables on the database, and some of the tables a
Chris Hoover escribió:
> I am testing upgrades to 8.2.4 from 8.1.3 and am having problems with
> 8.2.4balking at the functional indexes I have created. These indexes
> exist and
> work fine in 8.1.3, so why is 8.2.4 rejecting them?
>
> Index 1:
> CREATE INDEX acceptedbilling_to_date_accepted_bill
Maybe I'm blind (wouldn't be the first time), but I can't see a way to find
out how long postgres has been running. Is there a way to tell this from a
query? I am working with some of the stat views and would like to correlate
them to how long the server has been running.
Thanks,
Chris
Greetings..
I'm running 8.0.12 and the system has been very stable for years now with no
significant application changes. I am using Apache::Session::Postgres in a web
application to store session state. This has really been flawless for us so
far, but lately I've caught a few occurrences wh
Our usage pattern has recently left me with some very bloated database clusters.
I have, in the past, scheduled downtime to run VACUUM FULL and tried CLUSTER
as well, followed by a REINDEX on all tables. This does work, however the
exclusive lock has become a real thorn in my side. As our sys
select pg_postmaster_start_time()
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Chris Hoover
Sent: Wednesday, June 06, 2007 3:07 PM
To: pgsql-admin@postgresql.org Admin
Subject: [ADMIN] How to tell how long serve
Hi everyone on the list.
I've been trying to get a way to copy a postgresql table or some columns from
table into another one, but this new table must be in another databse and,
also, could be in another server. I was working on a jdbc app , which run well
when the destiny table was in the sa
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> You can't do this because to_date and other functions are not immutable.
> 8.2 seems to be more picky about this -- the date conversions of
> timestamptz columns are dependent on the current timezone.
The reason 8.2 is more picky is that the function is
Check the pg_locks system view in the pg_catalog schema. It will tell
you a wealth of information.
Peter
Dan Harris wrote:
Greetings..
I'm running 8.0.12 and the system has been very stable for years now
with no significant application changes. I am using
Apache::Session::Postgres in a web
Tom Lane escribió:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > You can't do this because to_date and other functions are not immutable.
> > 8.2 seems to be more picky about this -- the date conversions of
> > timestamptz columns are dependent on the current timezone.
>
> The reason 8.2 is mor
Well, the one index:
CREATE INDEX acceptedbilling_to_date_accepted_billing_dt_idx
ON acceptedbilling
USING btree
(to_date(accepted_billing_dt::text, 'mmdd'::text));.
Reject:
ERROR: functions in index expression must be marked IMMUTABLE
SQL state: 42P17
Is actually a date stored in a varch
Hi All,
We're using postgresql v.8.0.4 on a RHEL ES 4. Its newly installed by my
sys-admin and when trying to use pg_ctl I get this error:
[EMAIL PROTECTED] pgsql]$ pg_ctl -D /usr/local/pgsql/data stop -l log
The programs "postmaster" and "psql" are needed by pg_ctl but
were not found in the dire
> [EMAIL PROTECTED] pgsql]$ pg_ctl -D /usr/local/pgsql/data stop -l log
> The programs "postmaster" and "psql" are needed by pg_ctl but
> were not found in the directory "/usr/bin".
> Check your installation.
Where did you install Postgres to? Did you install a binary package or
compile from sourc
Phillip,
As you can see it,
> Where did you install Postgres to? Did you install a binary package or
> compile from source?
Its from a binary source. The files are in various places but $PGDATA
will be in /usr/local/pgsql. Someone else did the installation.
>You may just need to sym link pos
All,
I realize what the problem is. Somehow multiple versions on pg_ctl
exists...
[EMAIL PROTECTED] pgsql]$ find / -name pg_ctl -print 2>/dev/null
/usr/bin/pg_ctl
/usr/local/pgsql/bin/pg_ctl
/opt/postgresql-8.0.4/src/bin/pg_ctl
/opt/postgresql-8.0.4/src/bin/pg_ctl/pg_ctl
[EMAIL PROTECTED] pgsql]$
Chris Hoover wrote:
Well, the one index:
CREATE INDEX acceptedbilling_to_date
The second index is rather stupid, it was an early index before I
figured out how to split a timestamp.
Anyway, is there a way to make the first index work? Otherwise we end
up with a seq scan on our billing tabl
I am having a problem in restoring from WAL files. I have restored from
a dump file and trying to step through the WAL files.
LOG: starting archive recovery
LOG: restore_command = "cp /home/backup/%f "%p""
LOG: restored log file "0001.history" from archive
PANIC: syntax error in hist
28 matches
Mail list logo
