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
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 working
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 02:03:59PM -0800, [EMAIL PROTECTED] wrote:
You're right (I dug around in the documentation and edjoocated myself).
However:
snip
sales=# select 1/2::float;
?column?
--
0.5
(1 row)
Note that in this case the float cast only applies to the last
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 to
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
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
meets a
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=#
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 with the
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-11-05
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-generated SQL which
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
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 this instance because of
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
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).
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 pgAdmin).
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 message
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?
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
Check this out:= articletype.articletype_id ANDand in your from clause you have something like this:from articles, articletypes, departmentSo you need to fix articletypes or if it is articletype
Regards,---Shoaib MirEnterpriseDB (www.enterprisedb.com)On 11/6/06, Alain Roger
[EMAIL PROTECTED]
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
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
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
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
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
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
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 (if
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, or
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
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)--
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
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,
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.
.
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.
34 matches
Mail list logo
