Rikard Bosnjakovic, 27.11.2009 08:49:
[...]
I'm just curious which setting defines whether monday or sunday is
considered the first day in a week
Read 9.9.2 on http://www.postgresql.org/docs/8.1/static/functions-datetime.html
and you will see that even if you find such setting, date_trunc()
hi all,
I don't why PQbinaryTuples function returns 1
even the select statement only returns two integer fields.
Although there are some columns with type bytea in the table.
Are there any documents describe this?
--
Regards
Sam
--
Regards
Sam
Hi,
not all to zero : that are less significant than the selected one set
to zero (or one, for day and month)
so
select extract('dow' from date_trunc('week', current_date))
returns always 1 (i think accordingly to ISO-8601)
see
Can't we have a data type called say image that is just a
representation of the bytes and nothing else?
It seems to me that bytea is a hangover from the old days.
Is there some underlying physical reason why postgresql and other
databases cannot handle binary data without going through all this
Thomas Markus, 27.11.2009 09:41:
Hi,
not all to zero : that are less significant than the selected one set
to zero (or one, for day and month)
Sorry, I missed the or one part.
see
http://www.postgresql.org/docs/8.1/static/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT
dow: The day of
Andrew Maclean wrote:
Can't we have a data type called say image that is just a
representation of the bytes and nothing else?
It seems to me that bytea is a hangover from the old days
um, thats what BYTEA is.
Is there some underlying physical reason why postgresql and other
databases
Hi all,
I'm wondering if anyone has experience of storing and getting images to and
from a database? We currently have the problem of images being uploaded to
a single gateway used by many companies, most of which run several
websites. As it stands, once they upload the image, it then has to be
On 27 Nov 2009, at 8:49, Rikard Bosnjakovic wrote:
Read 9.9.2 on
http://www.postgresql.org/docs/8.1/static/functions-datetime.html
and you will see that even if you find such setting, date_trunc() will
always return monday as start of week:
=[snip]
source is a value expression of
Andrew Maclean wrote:
Is there some underlying physical reason why postgresql and other
databases cannot handle binary data without going through all this
silly escape stuff which must have a massive impact on performance. Or
is it just because databases originally were built to handle just
Chris Barnes wrote:
Is there anyone that has installed enterpriseDB (833) and upgraded to
later version or 8.4.1 using rpms?
I am wondering what the best path would be to upgrade from
enterpriseDB.
I don't know the precise changes between the E-DB rpms and the community
ones, but the
On 27/11/2009 7:04 PM, Thom Brown wrote:
But now we wish to redesign our various image upload systems into one
system which will also make images available across various
sites/companies and therefore servers. So one solution is to store
images in a database. What I'm wondering is if this
Thom,
I'm wondering if anyone has experience of storing and getting images to and
from a database?
Yes. For a customer I have one application running for ~8 years which
stores images (and various other BLOBS) within a PostgreSQL database.
Started with 7.something, now running on 8.3; allways
When I execute the command cmd_archiver -I I am getting the following
response
Traceback (most recent call last):
File /export/home/postgres/8.4/pitrtools/cmd_archiver, line 56, in ?
config.read(configfile)
File /usr/lib/python2.4/ConfigParser.py, line 262, in read
for filename in
On Fri, Nov 27, 2009 at 14:19, akp geek akpg...@gmail.com wrote:
[...]
TypeError: iteration over non-sequence
I am not able to interpret any thing from the above message. Can you please
give me some thoughts
I can't say anything about the application itself, but the cryptic
message means
From: Craig Ringer cr...@postnewspapers.com.au
Before you do re-create the cluster, if the data is unimportant is there
any chance you could take a copy of it so it can be examined to see what
happened? PostgreSQL should recover cleanly after a hard crash, and
unless there's a storage subsystem
Thomas Kellerer spam_ea...@gmx.net writes:
I'm just curious which setting defines whether monday or sunday is considered
the first day in a week
A look at the source code (timestamptz_trunc) shows that truncation to
week start follows the ISO week conventions --- so weeks start on
Monday,
On Fri, Nov 27, 2009 at 4:53 AM, Sam Jas samja...@yahoo.com wrote:
I will check that one. Also i have read one forum which tells that whenever
you face disk i/o run dmesg command it will give you detail information.
Today again i face disk i/o and i have run dmesg it has given me below o/p.
PostgreSQL 8.2.12 on i386-pc-solaris2.10, compiled by GCC gcc (GCC) 3.4.3
(csl-sol210-3_4-branch+sol_rpath)
CREATE TABLE items
(
field1 character(9) NOT NULL,
field2 character varying(17) NOT NULL
};
CREATE INDEX field1-field2
ON items
USING btree
(field1, field2);
About 15 million
Jeff Amiel becauseimj...@yahoo.com writes:
It appears that somehow the empty string is causing the planner to abandon
the index.
You didn't actually show us such a case...
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
hmm...ok...planner is not using the index effectively (as effectively as when a
non-empty value is passed in)
--- On Fri, 11/27/09, Tom Lane t...@sss.pgh.pa.us wrote:
From: Tom Lane t...@sss.pgh.pa.us
Subject: Re: [GENERAL] empty string causes planner to avoid index. Makes me
sad.
To: Jeff
I am looking for some help regarding an python OperationalError that I
recently received while executing a python script using sqlalchemy and
psycopg2. The python script parses an xml file stored on a networked
drive and enters the information into a pgsql database. Sometimes
these xml
Jeff Amiel becauseimj...@yahoo.com writes:
hmm...ok...planner is not using the index effectively (as effectively as when
a non-empty value is passed in)
You didn't show us any evidence of that, either. Both of your test
cases are using the index.
regards, tom lane
--
Pete Erickson redl...@redlamb.net writes:
I am looking for some help regarding an python OperationalError that I
recently received while executing a python script using sqlalchemy and
psycopg2. The python script parses an xml file stored on a networked
drive and enters the information
I thought 'vacuumdb -z dbname' also reindex is this true?
I've had a simple update running for over 4 hours now (see results from
pg_top below). The sql is:
The database has 1016789 records, vacuumdb -z is ran once a day. I have
not ran 'reindexdb' in weeks. The system is a:
2xIntel 4-core
Le vendredi 27 novembre 2009 à 22:17:50, Irene Barg a écrit :
I thought 'vacuumdb -z dbname' also reindex is this true?
No. vacuumdb -z is a VACUUM ANALYZE. Moreover, vacuumdb has no option to do a
REINDEX.
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
--
Sent via
--- On Fri, 11/27/09, Tom Lane t...@sss.pgh.pa.us wrote:
You didn't show us any evidence of that, either. Both
of your test
cases are using the index.
Ok...third try. The cost when passing in an empty string is SIGNIFICANTLY
higher than when not. Wouldn't seem that the planner is using
Le vendredi 27 novembre 2009 à 23:32:14, Jeff Amiel a écrit :
--- On Fri, 11/27/09, Tom Lane t...@sss.pgh.pa.us wrote:
You didn't show us any evidence of that, either. Both
of your test
cases are using the index.
Ok...third try. The cost when passing in an empty string is SIGNIFICANTLY
Thanks. Out of curiosity, if memory exhaustion was the problem, any idea
why the task manager would show that I'm only using 1.2GB of the 3GB of
memory?
On 11/27/2009 5:15 PM, Tom Lane wrote:
Pete Erickson redl...@redlamb.net writes:
I am looking for some help regarding an python
On Fri, Nov 27, 2009 at 2:17 PM, Irene Barg ib...@noao.edu wrote:
I've had a simple update running for over 4 hours now (see results from
pg_top below). The sql is:
Have you looked in pg_locks and pg_stat_activity?
The database has 1016789 records, vacuumdb -z is ran once a day. I have not
On Fri, 27 Nov 2009, Jeff Amiel wrote:
--- On Fri, 11/27/09, Tom Lane t...@sss.pgh.pa.us wrote:
You didn't show us any evidence of that, either.? Both
of your test
cases are using the index.
Ok...third try. The cost when passing in an empty string is
SIGNIFICANTLY higher than when
Jeff Amiel becauseimj...@yahoo.com writes:
Ok...third try. The cost when passing in an empty string is SIGNIFICANTLY
higher than when not.
That just reflects the fact that it's expecting a lot more rows matching
that query. I suppose this is because the statistics show you've got a
lot more
Peter Erickson redl...@redlamb.net writes:
Thanks. Out of curiosity, if memory exhaustion was the problem, any idea
why the task manager would show that I'm only using 1.2GB of the 3GB of
memory?
Well, it would've failed to allocate the next copy of the string that it
needed ... and I think
thats exactly the same i'm looking for:
http://wiki.postgresql.org/wiki/Todo
http://archives.postgresql.org/pgsql-patches/2005-07/msg00458.php
(todo list for plpgsql)
*Server-Side Languages
*PL/pgSQL
*
*[D] Allow listing of record column names, and access to record columns
*via variables,
As said by Filip Rembiałkowski-3, you could try using some software that will
help you in managing the transfer.
I can recommend the use of data integration software such as Datastage (It
is a licensed program) or Talend Open Studio (Talend is open source). Tell
us how it went.
mrciken wrote:
hy group,
i currently look for a solution to access a resultset in a db-stored
function by number. in plpgsql thats not possible.
so i checked out plpython. so far so good, thats working:
CREATE OR REPLACE FUNCTION dokv_dorecnokeywords(sqlstatement VARCHAR)
RETURNS VOID AS
$$
rv =
hi all,
I don't why PQbinaryTuples function returns 1
even the select statement only returns two integer fields.
Although there are some columns with type bytea in the table.
Are there any documents describe this?
--
Regards
Sam
Hello,
I am trying to restore my databases stored by a pg_dumpall command in
the Karmic Koala box. The restore command is the following:
psql -f /media/disk/.../backup -U postgres
I have a PostsgreSQL 8.4 installed from repositories with postgis1.4.1.
I recognized that the tables with spatial
In order to restore a backup taken with pg_dumpall you'll want to
ensure that the postgis installed in your new system is identical to
the postgis in your old one. This is because the postgis function
definitions will be looking for a particular postgis library name...
the name of the library from
On Fri, Nov 27, 2009 at 10:09 AM, Daniel Schuchardt
d.schucha...@prodat-sql.de wrote:
thats exactly the same i'm looking for:
http://wiki.postgresql.org/wiki/Todo
http://archives.postgresql.org/pgsql-patches/2005-07/msg00458.php
(todo list for plpgsql)
*Server-Side Languages
*PL/pgSQL
*
39 matches
Mail list logo
