Hi all,
i have a little question on changing the length of a varchar field.
Is there another way than dump and reload if i want to change the length
of a varchar field ?
I have search the idocs and found some docs about the system-table pg_attribute,
where the length of a varchar-field is stored i
On Wed, 15 Jan 2003 11:19:29 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> Andre Schubert <[EMAIL PROTECTED]> writes:
> > Ok, but is there another way to enable STATS_ROW_LEVEL for a special
> > backend not connecting as superuser ?
>
> No: the code is deliberately
On Wed, 15 Jan 2003 10:01:27 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> Andre Schubert <[EMAIL PROTECTED]> writes:
> > I want to enable the collection of STATS_ROW_LEVEL for special backends
> > by setting the environment-variable export PGOPTIONS='-c STATS_ROW_L
Hi all,
I have a devel server where i want to turn on collector statistics.
I want to enable the collection of STATS_ROW_LEVEL for special backends
by setting the environment-variable export PGOPTIONS='-c STATS_ROW_LEVEL=ON'.
After setting this variable i cant connect to my database.
Everytime the
Gaetano Mendola schrieb:
>
> Hi to all,
>
> I configured the log rotation of postgresql started in this way:
>
> su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p
> /usr/bin/postmaster start > /var/log/postgresql.log 2>&1" < /dev/null
>
> with the log rotate file:
>
> /var/log/po
Tom Lane schrieb:
>
> Andre Schubert <[EMAIL PROTECTED]> writes:
> > All three tables use the same sequence to increment their id.
> > I want to know if it is possible to find the id of the inserted value of
> > foo.
>
> Try "currval".
I think i
Marin Dimitrov schrieb:
>
> - Original Message -
> From: "Andre Schubert"
>
> >
> > Can i do a select id from foo order by id desc limit 1 before the end of
> > the transaction,
> > does this return exactly the row i inserted for this tr
Hi all,
i have a little question on getting the last inserted value from a
table.
Lets say i have a transaction which does the following.
insert into foo values(1);
insert into bar values(2);
insert into foobar values(3);
All three tables use the same sequence to increment their id.
I want to
ts) from it. I would try to write your
> query using a NATURAL JOIN or EXISTS to give better performance. My
> drives and system are fairly fast, but checking 56.3M records would take
> quite a while.
>
> - brian
>
> On Mon, 21 Jan 2002, Andre Schubert wrote:
>
>
Hi,
i have a simple question on indices and subselects.
Lets say i have a table foo with a column id int8 as primary_key bar.
If i do a
select * from foo where id = 10 then the index bar is used.
if i do
select * from foo where id in (10,20) then the index is used.
but if id do
select * from
Tom Lane schrieb:
>
> Andre Schubert <[EMAIL PROTECTED]> writes:
> > sometimes i have a curios problem with my Zope.
> > My sysop has traced the protcols before and after the error.
> > Zope sends some data and then a crypted password with the salt.
> > If th
Hi all,
sometimes i have a curios problem with my Zope.
Without any errors in any logs Zope could not authenticate himself with
postgres.
The error message is that there is a wrong password.
After a restart of Zope everything works fine until the eror occurs
again.
My sysop has traced the protco
Hi all,
i think i found a bug in postgresql date/datetime objects.
examples:
select date_trunc('month',date('2002-03-01')+timespan('1
month'))-timespan('24 hours');
returns 2002-03-30 23:00:00+01
select date_trunc('month',date('2002-03-01')+timespan('1
month'))-timespan('23 hours');
returns 2
Hi,
Where can i find the official SRPMS for 7.1.1 or 7.1.1 i won't upgrade,
but i need the SRPMS.
thanks as
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi all,
I have a problem with my Postgres Server.
The last time the servers terminates itself and the following entries in
the log files are written, but i don't no what they say.
I'am running Postgres 7.0.3
On RedHat Immunix 6.2
**
15 matches
Mail list logo
