.
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions !
Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses.
Hi,
On Mon, 2006-11-06 at 10:58 +0530, surabhi.ahuja wrote:
> I am currently using 8.0.0 and I want to upgrade to 8.0.9 Please tell
> if i can just install the rpms for 8.0.9
http://www.postgresql.org/ftp/binary/v8.0.9/linux/rpms/
Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503
surabhi.ahuja wrote:
Hi,
I am currently using 8.0.0 and I want to upgrade to 8.0.9
Please tell if i can just install the rpms for 8.0.9
Upgrading from 8.0.x to 8.0.9 will use your current datafiles without
problems. Upgrading to 8.1.5 will need a dump/restore.
Will I not have to rebuild my
Hi,
I am currently using 8.0.0 and I want
to upgrade to 8.0.9
Please tell if i can just install the rpms for
8.0.9
Will I not have to rebuild my application with new
libpq.so?
or does the libpq.so still remain the
same.
Thanks,
regards
Surabhi
Dear All,
I had open the backup file of PostgreSQL created by pg_dump command. I found that pg_dump make a comment line as header for each module it backup. I try to understand the meaning of value contained on header for my sample header
TOC entry 1427 (class 1259 OID 1216127)-- Depend
CSN <[EMAIL PROTECTED]> writes:
> Also, would this approach add up to equal the output of pg_dumpall, or
> does pg_dumpall dump additional things (if so, please describe how
> they'd also be dumped)?
You'd be missing roles (user/group definitions) and tablespace
definitions. pg_dump doesn't emit
On 11/6/06, CSN <[EMAIL PROTECTED]> wrote:
Anybody know of a script that dumps all databases into corresponding dump
files, e.g.
$ ./dump
template0 -> template0.sql
template1 -> template1.sql
db1 -> db1.sql
db2 -> db2.sql
...
Also, would this approach add up to equal the output of pg_dumpall,
Anybody know of a script that dumps all databases into corresponding dump
files, e.g.
$ ./dump
template0 -> template0.sql
template1 -> template1.sql
db1 -> db1.sql
db2 -> db2.sql
...
Also, would this approach add up to equal the output of pg_dumpall, or does
pg_dumpall dump
additional things (i
Hello,
Due to some customer requirements, I may not be able to make USENIX
LISA. This is a 2 day exhibition on December 6/7. Josh Berkus, Robert
Bernier, Robert Treat and in theory someone from eDB will be there.
Can someone take my place?
Sincerely,
Joshua D. Drake
--
=== The Postgre
If you do not want to amend your table with extra information, this is
how you do it:
Suppose you have a table
create table events (
time timestamp,
object int refers objects(id), -- The thing that had its ignition
turned on or off at this time
ignition boolean,
comment varchar
);
You can th
Hi all, I am drawing the schema diagram for my postgres database. I wanted to add child tables to the master table in my diagram but I am not sure how to do it. I couldnt find any sample diagram for this in the web. If somebody can help me out with this that will be great. Thanks a lot for
Michael Fuhr wrote:
On Sat, Nov 04, 2006 at 10:12:00PM +0100, stig erikson wrote:
a handy thing in mysql is FEDERATED tables that allows one to open a
channel from one MySQL-server to another MySQL-server.
it helps a lot when writing stored procedures that transfer data to other
servers. you ca
Bob Pawley wrote:
Can anyone point me to an overview of PostgreSQL geometry ?
Bob Pawley
Try www.postgis.org
A third party add-on to Postgres implementing OGC SFS compliant
functionality. This is more complete & useful that the built in Postgres
spatial data support.
Brent Wood
novnov wrote:
I would really prefer it if simple names like Item and ItemName not be
double quoted. You're saying that postgres itself would only require double
quotes if the table was originally decribed that way (and it is, being
created by pgAdmin). Seems like an odd mismatch between pgsql an
Check this out:"= articletype.articletype_id AND"and in your from clause you have something like this:"from articles, articletypes, department"So you need to fix "articletypes" or if it is "articletype"
Regards,---Shoaib MirEnterpriseDB (www.enterprisedb.com)On 11/6/06, Alain Roger <
[EMAIL PRO
On Sunday 05 November 2006 11:42 am, Alain Roger wrote:
> Hi,
>
> i've tried to run a basic SQL request as followed :
> select *
> from articles, articletypes, department
^ s
> where
> articles.articletype_id = articletype.articletype_id AND
You wrote articletype instead of articletypes in the first WHERE
clause: is this the problem?
Regards
Marco
--
Marco Bizzarri
http://iliveinpisa.blogspot.com/
---(end of broadcast)---
TIP 4: Have you searched our list archives?
htt
Hi,i've tried to run a basic SQL request as followed :select *from articles, articletypes, departmentwhere articles.articletype_id = articletype.articletype_id AND articles.department_id =
department.department_id AND articles.validity_period_end > now()and i got the following error messa
On Sun, Nov 05, 2006 at 08:51:52AM -0800, novnov wrote:
> I would really prefer it if simple names like Item and ItemName not be
> double quoted. You're saying that postgres itself would only require double
> quotes if the table was originally decribed that way (and it is, being
> created by pgAdmi
Hmm well that's interesting. I had posted to the pgAdmin list too re this
issue, thinking that the quotes issues was something with that interface to
pgsql. There I was told
"PostgreSQL does require you to use double quotes in some circumstances
(for example, if you use upper case letters). pgAd
On Nov 5, 2006, at 15:32 , Alain Roger wrote:
I would like to allow web site user to fill a field and for that i
would need a large varchar()...maybe something around 100.000
characters.
i guess that VARCHAR can not hold so many character and that i
should turn to bytea.
Am I right or is t
Andreas Kretschmer schrieb:
>
> Mark Morgan Lloyd <[EMAIL PROTECTED]> wrote:
> > > test=# select now()::time;
> > > now
> > >
> > > 11:16:18.22527
> > > (1 row)
> >
> > Thanks Andreas, I've ended up using CAST( ... AS TIME). I think the ::
> > notation might be fragile in t
Hi,I would like to allow web site user to fill a field and for that i would need a large varchar()...maybe something around 100.000 characters.i guess that VARCHAR can not hold so many character and that i should turn to bytea.
Am I right or is there some other possibility ?i'm asking that because
Mark Morgan Lloyd <[EMAIL PROTECTED]> schrieb:
> > test=# select now()::time;
> > now
> >
> > 11:16:18.22527
> > (1 row)
>
> Thanks Andreas, I've ended up using CAST( ... AS TIME). I think the ::
> notation
> might be fragile in this instance because of the machine-generat
Andreas Kretschmer schrieb:
>
> Mark Morgan Lloyd <[EMAIL PROTECTED]> wrote:
> > What is the correct (or even any :-) way of converting a timestamp into a
> > time (without timezone etc.)?
>
> You can CAST it:
>
> test=# select now();
> now
> ---
> 2006
Naz Gassiep <[EMAIL PROTECTED]> schrieb:
> NOTICE: number of page slots needed (27056) exceeds max_fsm_pages (2)
> HINT: Consider increasing the configuration parameter "max_fsm_pages" to a
> value over 27056.
> VACUUM
> conwatchlive=#
>
> What does this mean? I assume it has nothing to do
I just did a vacuum analyze and I got a message I've never seen before:
conwatchlive=# vacuum analyze;
NOTICE: number of page slots needed (27056) exceeds max_fsm_pages (2)
HINT: Consider increasing the configuration parameter "max_fsm_pages"
to a value over 27056.
VACUUM
conwatchlive=#
Pedro Doria Meunier <[EMAIL PROTECTED]> schrieb:
>
> Hi all!
>
> This is most certainly a lame question but perhaps someone is gracious enough
> to lend me a hand& ;-)
>
> I have the following setup in a table:
>
> The first record which is to be found (ok easy enough :D) with a timestamp
>
Mark Morgan Lloyd <[EMAIL PROTECTED]> schrieb:
> What is the correct (or even any :-) way of converting a timestamp into a time
> (without timezone etc.)?
You can CAST it:
test=# select now();
now
---
2006-11-05 11:16:05.205235+01
(1 row)
test=# select
On Sat, Nov 04, 2006 at 08:35:28AM -0800, novnov wrote:
> So pgSQL is case sensitive and that include keywords like UPDATE and SET.
No it's not. Only identifiers in double quotes (") are case-sensetive.
So, in your example below, because the function was created with double
quotes, you now have t
On Fri, Nov 03, 2006 at 02:03:59PM -0800, [EMAIL PROTECTED] wrote:
> You're right (I dug around in the documentation and edjoocated myself).
> However:
> sales=# select 1/2::float;
> ?column?
> --
> 0.5
> (1 row)
Note that in this case the "float" cast only applies to the last
nu
Tom Lane wrote:
Russell Smith <[EMAIL PROTECTED]> writes:
I got this error the other day, I was under the impression that vacuum could
get a concurrently updated tuple. I could be wrong. It is possible for
somebody to quickly explain this situation? Message follows;
vacuumdb:
On Fri, Nov 03, 2006 at 08:25:25PM +, Benjamin Weaver wrote:
> Dear Martijn,
>
> Wow, didn't know about arrays. Did lots of sql, but, as I think about it,
> that was 7 years ago, and we didn't know about arrays then
>
> Are their performance problems with arrays? We will not likely be work
I'm in the middle of moving a production database from 7.1 to 8.1 and have hit a
slight problem.
On the old system I've got a query including
datastamp AS datastamp, date(datastamp ) as datadate,
time(datastamp ) as datatime, status, -- etc.
This is actually generated on the client to possibly
34 matches
Mail list logo
