On 22/08/2003 22:18 Dennis Gearon wrote:
Jeessh, a lot of people have my email address.
I have received about 500 copies of the worm in the last 24 hours. My
mail spool at work was so full I couldn't get out or relay or
anything. The wierd part is that it's my work address, and I'm
subscrib
Claudio Lapidus wrote:
Bruno Wolff III wote:
On Fri, Aug 22, 2003 at 12:17:41 +0530,
Shridhar Daithankar <[EMAIL PROTECTED]> wrote:
>
> Idea of autovacuum is to reduce load on vacuum full. If you set
shared_buffers
> higher and FSM properly for he update/delete load, autovacuum is
expected to
>
I have found an pgsql-mode.el file which I want to install in my xemacs
but sorry, I am lost as to how install it.
Or is there a better solution to pgsql programming in xemacs?
I am using Redhat 9
Alfred
---(end of broadcast)---
TIP 1: subscribe a
Running mozilla on linux and having my mail processed by postini,
_http://www.postini.com_, I haven't had any problems other that lots of
quarantined mail at postini. Having the mail quarantined off site saves
bandwith as well.
I work at an ISP and we use postini for all email that ends up on o
On 22 Aug 2003, Jenny Zhang wrote:
> Last week I reported getting different execution plans for the same
> query against the same database. I did further investigation. After
> building the database, I did:
> vacuumdb -z DBT3
> psql DBT3 -c "analyze supplier"
> psql DBT3 -c "analyze part"
> psq
Jeessh, a lot of people have my email address.
I have received about 500 copies of the worm in the last 24 hours. My
mail spool at work was so full I couldn't get out or relay or
anything. The wierd part is that it's my work address, and I'm
subscribed to almost all my lists through the add
Hi,
Last week I reported getting different execution plans for the same
query against the same database. I did further investigation. After
building the database, I did:
vacuumdb -z DBT3
psql DBT3 -c "analyze supplier"
psql DBT3 -c "analyze part"
psql DBT3 -c "analyze partsupp"
psql DBT3 -c "ana
=?iso-8859-15?q?Herv=E9=20Piedvache?= <[EMAIL PROTECTED]> writes:
> I have a dedicated partition on the disk for the WAL files, 2Gb.
> So I start my script and saw the size of the pg_xlog partition groing quickly
> to be full after 20 min ...
That shouldn't happen, unless there's something preve
On Fri, Aug 22, 2003 at 13:00:57 -0400,
"Johnson, Shaunn" <[EMAIL PROTECTED]> wrote:
> Howdy:
>
> I want to convert all of this into days, but
> I don't think I can use 'to_char' because
> I get things like this:
Converting intervals to days is a problem because months are treated as
having 30
Of course it will Thanks... :)
BTJ
On Fri, 2003-08-22 at 19:47, David Olbersen wrote:
> Bjørn T Johansen muttered:
>
> > I need to get two fields from two tables and append them into one field
> > with CR/LF in between, how is this done using a select?
>
> I believe something along the line
Hi,
A small question ... and your opinions are well done ...
I have tested one thing today ...
I have a script in charge to insert a lot of files inside one of my db.
I have a perl script where I read the files ... check if some similar data are
in the db ... then delete them ... and insert the
Bjørn T Johansen muttered:
> I need to get two fields from two tables and append them into one field
> with CR/LF in between, how is this done using a select?
I believe something along the lines of:
SELECT column1||'\r\n'||column1 FROM table;
will do the trick.
--
David Olbersen
iGuard Engi
I need to get two fields from two tables and append them into one field
with CR/LF in between, how is this done using a select?
Regards,
BTJ
--
---
Bjørn T Johansen (BSc,MNIF)
Executive Manager
[EMAIL P
> <[EMAIL PROTECTED]> writes:
> > I HAVE used pg_dumpall -g to make a backup of of users and groups, but
> > this output does not include the ALTER DATABASE commands.
Another related problem. pg_dump/pg_restore doesn't properly restore GRANT
CREATE ON DATABASE
pg_restore --create db.dump:
--Samp
Tom Lane writes:
> Also, a pg_dump script doesn't (and shouldn't, IMHO) assume it knows the
> name of the database it's being restored into.
That is pretty much it; pg_dump doesn't record any information about the
database, no matter whether that information happens to be represented in
the comma
Title: convert interval info into days
Howdy:
Running PostgreSQL 7.2.1 on RedHat Linux 7.2.
How can I convert data in a table that has been created
with the INTERVAL data type into a numeric format?
Say, I have a table with this type of data:
[snip]
-1 years | 00:00
00:00 | 1 y
> <[EMAIL PROTECTED]> writes:
>> I HAVE used pg_dumpall -g to make a backup of of users and groups,
>> but this output does not include the ALTER DATABASE commands.
>
> No, it looks like pg_dumpall dumps ALTER DATABASE operations for a
> particular database when it dumps that database.
>
>> Does t
<[EMAIL PROTECTED]> writes:
> I HAVE used pg_dumpall -g to make a backup of of users and groups, but
> this output does not include the ALTER DATABASE commands.
No, it looks like pg_dumpall dumps ALTER DATABASE operations for a
particular database when it dumps that database.
> Does the ALTER DAT
NO No no, do not mess with set locale,
You will need to hack your own version of strxfrm which takes an
aragument for locale. If you mess with locale,you will corrupt the
indexes I've been told.
Greg Stark wrote:
Dennis Gearon <[EMAIL PROTECTED]> writes:
I was thinking of INGNORING local
javier garcia - CEBAS wrote:
Hi all;
Up to date. I've used Microsoft Access as a WindowsXP Client for Postgres.
But I want to know if pgAdmin can do the job.
I've downloaded pgAdminII Version 1.6.0 for Windows.
My current Postgres version is 7.2
And I can acces it from Microsoft Access2000
.
When
Dennis Gearon <[EMAIL PROTECTED]> writes:
> I was thinking of INGNORING locale, since it is basically fixed for a DB for
> long periods of time.
>
> If a table/column HAD it's own locale, that could be used,
> but I was more interested in a function taht would allow the explicit
> declaration of
I was thinking of INGNORING locale, since it is basically fixed for a DB
for long periods of time.
If a table/column HAD it's own locale, that could be used,
but I was more interested in a function taht would allow the explicit
declaration of the encoding(s) to look for.
BTW, what is l10n
Greg
On Fri, 22 Aug 2003, Claudio Lapidus wrote:
> Bruno Wolff III wote:
> > On Fri, Aug 22, 2003 at 12:17:41 +0530,
> > Shridhar Daithankar <[EMAIL PROTECTED]> wrote:
> > >
> > > Idea of autovacuum is to reduce load on vacuum full. If you set
> shared_buffers
> > > higher and FSM properly for he upd
On 22 Aug 2003 at 12:35, Claudio Lapidus wrote:
> Bruno Wolff III wote:
> > On Fri, Aug 22, 2003 at 12:17:41 +0530,
> > Shridhar Daithankar <[EMAIL PROTECTED]> wrote:
> > >
> > > Idea of autovacuum is to reduce load on vacuum full. If you set
> shared_buffers
> > > higher and FSM properly for he
Greg Stark <[EMAIL PROTECTED]> writes:
> Dennis Gearon <[EMAIL PROTECTED]> writes:
>
> > I think it would be nice, and I may write it eventually, to have a function
> > called:
> >
> > COLLATION_VALUE( 'string', 'encoding' )
>
> Indeed that would be really nice. I wish I had that and a pony.
>
Bruno Wolff III wote:
> On Fri, Aug 22, 2003 at 12:17:41 +0530,
> Shridhar Daithankar <[EMAIL PROTECTED]> wrote:
> >
> > Idea of autovacuum is to reduce load on vacuum full. If you set
shared_buffers
> > higher and FSM properly for he update/delete load, autovacuum is
expected to
> > catch most o
> > On Tue, 19 Aug 2003, Jules Alberts wrote:
> >
> > > This is not a troll and I certainly don't want to start a holy war but
> > > wouldn't it be a good idea to move the postgresql lists from the
> > > mailing list approach to usenet? IMHO it's more open and easier to work
> > > with. As it is
This sounds an awful lot like crosstab functionality, Check out the
tablefunc module in contrib, I think there is something in there that
will help you with this.
Robert Treat
On Thu, 2003-08-21 at 16:11, Stephan Szabo wrote:
>
> On Thu, 21 Aug 2003, Egor Shipovalov wrote:
>
> > I have a lot of
On Fri, Aug 22, 2003 at 10:28:56AM -0400, Carmen Gloria Sepulveda Dedes wrote:
> Thanks.
> Exists a one to one relationship between schemas and users?
No.
--
Alvaro Herrera ()
"Crear es tan dificil como ser libre" (Elsa Triolet)
---(end of broadcast)-
> <[EMAIL PROTECTED]> writes:
>> The problem I have is that the SQL DDL and DML produced by pg_dump
>> fails to include the ALTER DATABASE ... SET search_path ... statement
>> that sets the search path for when I re-load the database from a dump
>> file.
>
> This functionality is in pg_dumpall, no
On Fri, 22 Aug 2003, Carmen Gloria Sepulveda Dedes wrote:
> Hi!
>
> I want to know if the statement "create schema" exists for postgres 7.3.x.
Yes it does.
---(end of broadcast)---
TIP 8: explain analyze is your friend
Thanks.
Exists a one to one relationship between schemas and users?
Bruno Wolff III wrote:
> Yes. Schemas got added to Postgres in 7.3.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-
32 matches
Mail list logo
