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
http://www.postgresql.org/docs/8.1/static/functions-datetime.htm
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 o
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 can
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 express
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 pr
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 thi
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 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 that the variable
From: "Craig Ringer"
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 issue or fsync was off th
Thomas Kellerer 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, regardless of local
On Fri, Nov 27, 2009 at 4:53 AM, Sam Jas 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.
> Can some
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 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 changes to your subsc
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 wrote:
> From: Tom Lane
> Subject: Re: [GENERAL] empty string causes planner to avoid index. Makes me
> sad.
> To: "Jeff Amiel"
> Cc: pgsql-general@pos
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 file
Jeff Amiel 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
--
Sent via pgsql-gener
Pete Erickson 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 into a pgsql datab
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 pgsql-
--- On Fri, 11/27/09, Tom Lane 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 the index
effecti
Le vendredi 27 novembre 2009 à 23:32:14, Jeff Amiel a écrit :
> --- On Fri, 11/27/09, Tom Lane 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
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 writes:
I am looking for some help regarding an python OperationalError that I
recent
On Fri, Nov 27, 2009 at 2:17 PM, Irene Barg 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
> ran 'reindex
On Fri, 27 Nov 2009, Jeff Amiel wrote:
> --- On Fri, 11/27/09, Tom Lane 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. Would
Jeff Amiel 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 rows containing the em
Peter Erickson 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 also we try to ke
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, e.g.
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 = plpy.exec
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 ge
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
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
> *
> *[D] Allow list
39 matches
Mail list logo
