Am Donnerstag, 10. März 2005 18:17 schrieb Tom Lane:
John Sidney-Woollett [EMAIL PROTECTED] writes:
I'm pretty sure I had the same problem when using pg_restore. If
pl/pgsql is installed in template1, then the restore fails.
And I couldn't find any solution to this on the list either.
GIROIRE Nicolas (COFRAMI) wrote:
my sort algorithm is a very particular solution.
In fact, I put record in array to allow me to sort record. I sort them by
using one column of my table but the column indx can have duplicate value
and it's volontary.
I still can't see why you can't sort by that
On Sun, 2005-03-13 at 23:13 -0600, George Essig wrote:
On Fri, 11 Mar 2005 13:26:07 +0100, Steven Verhoeven
[EMAIL PROTECTED] wrote:
[snip problem]
select id, fref as ref from my_table
union
select id, mref as ref from my_table;
union ALL
(see other replies)
gnari
Title: RE: [GENERAL] Convert Cursor to array
hi
i'm a friend of nicolas and i'm working with him on this project
so this is the problem :
we are working on an application allowing to manage documentation in xml format.
At the the first level, there is the root, and at the next level there
Thanks Bruce, then how can I grant an user to create tmp tables and
drop then it, without gives him global drop priv (I can't grant drop
priv for the tmp table because don't exist yet)
Thnx, Alejandro
Sorry 4 my english
On Fri, 11 Mar 2005 10:52:05 -0500 (EST), Bruce Momjian
On Mon, 2005-03-14 at 10:44 +0100, FERREIRA William (COFRAMI) wrote:
so we choice to use a different solution which consist on using the
index of a chapter and its evolution.
if we have this data :
chapter_id | evolution | index
1 | 0 | 1
2 | 0 | 2
Hi,
i dumped my database on server1 with pg_dump -Fc ..., copied the dump to
server2, both same pgsql version 7.4.6
pg_restore says
pg_restore: [custom archiver] could not uncompress data: incorrect data check
But it seems that almost any data was restored.
What does this error mean. I didn't
Hi,
I'm just starting to look at Postgresql. My platform (for better or
worse) is Windows, and I'm quite interested in the pl/python support.
However, when I run the binary installer, it is not offered
to me as an option (it's there, but greyed out). The
plpython.dll file is installed,
Below are some PRELIMINARY results in comparing the performance of pgsql and
mysql.
These results are for a single process populating a table with 934k rows,
and then performing some selects. I also compared the effect of creating
indexes on some of the columns.
I have not yet done any testing
Hi Rick,
the work you are doing is important (at least I think so).
From my experience PosgreSQL performance is also very slow in case
there are several LEFT JOINs and there are varchar() fields. You can see
an example in archive where my problem is described (Subject: How to
read query plan).
Hello,
I am sorry to bring this up again Does anyone have any idea what
might be going on here?... I'm very worried about this situation.. ;-(
- Greg
Something even more peculiar (at least it seems to me..)...
If I drop the index table1_category_gist_idx, I get this:
jobs= explain
I worked around the plpython problem that doesn't allow scripts created on
Windows to be run on the *nix server with the following statement.
update pg_proc set prosrc=replace(prosrc,chr(13),'') where prolang=87238
--plpythonu's oid in my setup is 87238. I don't know if that is a standard
or
On Mon, Mar 14, 2005 at 12:22:57PM +0100, Janning Vygen wrote:
i dumped my database on server1 with pg_dump -Fc ..., copied the dump to
server2, both same pgsql version 7.4.6
How are you copying the file?
pg_restore says
pg_restore: [custom archiver] could not uncompress data: incorrect
Rick Schumeyer wrote:
Below are some PRELIMINARY results in comparing the performance of pgsql and
mysql.
These results are for a single process populating a table with 934k rows,
and then performing some selects. I also compared the effect of creating
indexes on some of the columns.
I have not
Dears,
When i wanna insert to my following code,I receive following error:
Insert into c(t) values('ccc'); -- It's my qurey.
Insert command failed!So i can't continue to insert in your table!
ERROR: pg_atoi: error in ccc: can't parse ccc
my code :
pres =
Mohsen Pahlevanzadeh wrote:
Dears,
When i wanna insert to my following code,I receive following error:
Insert into c(t) values('ccc'); -- It's my qurey.
Insert command failed!So i can't continue to insert in your table!
ERROR: pg_atoi: error in ccc: can't parse ccc
Usually atoi
On Mon, Mar 14, 2005 at 06:52:58AM -0500, Rick Schumeyer wrote:
Below are some PRELIMINARY results in comparing the performance of pgsql and
mysql.
...
I have not yet done any testing of transactions, multiple concurrent
processes, etc.
I would say that doing the concurrency tests is
On Mon, Mar 14, 2005 at 02:37:00PM +0200, Sim Zacks wrote:
I worked around the plpython problem that doesn't allow scripts created on
Windows to be run on the *nix server with the following statement.
update pg_proc set prosrc=replace(prosrc,chr(13),'') where prolang=87238
--plpythonu's
Hi
Tell me please what does it mean the next hint:
TIP 7: don't forget to increase your free space map settings
where can i read about this settings?
--
Igor
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Back in 2002, Jean-Luc Lachance gave a nifty algorithm
(http://archives.postgresql.org/pgsql-sql/2002-06/msg00301.php) for
determining the resulting date given a starting date and number of
'workdays' in the future. The trick was that weekends (Saturday and
Sunday) could not be counted.
The
Thank You Michael,
It worked when I tried it on the 3 functions that I have.
I checked the archives for any discussion on the Validator and there wasn't
anything specifically discussing it.
I really didn't find a lot of information about the Validators either, for
example where did you see that a
go wrote:
Hi
Tell me please what does it mean the next hint:
TIP 7: don't forget to increase your free space map settings
where can i read about this settings?
http://www.postgresql.org/docs/8.0/interactive/runtime-config.html
--
Igor
Miroslav
begin:vcard
fn;quoted-printable:Miroslav
On Mon, Mar 14, 2005 at 04:52:58PM +0300, go wrote:
Tell me please what does it mean the next hint:
TIP 7: don't forget to increase your free space map settings
where can i read about this settings?
See the Run-time Configuration section of the Server Run-time
Environment chapter of the
Hi,
I see 2 jdbc version in your classpath pg73jdbc3.jar and
pg74.215.jdbc3.jar.
For Tomcat you just have to drop the jdbc Jar file in
/usr/local/jakarta-tomcat-4.1.31/common/lib
No classpath to change.. Nothing.
After create an entry in Server.xml or create a Context.xml to define your
On Mon, Mar 14, 2005 at 04:08:09PM +0200, Sim Zacks wrote:
I checked the archives for any discussion on the Validator and there wasn't
anything specifically discussing it.
I really didn't find a lot of information about the Validators either, for
example where did you see that a validator
Jeff Amiel wrote:
Back in 2002, Jean-Luc Lachance gave a nifty algorithm
(http://archives.postgresql.org/pgsql-sql/2002-06/msg00301.php) for
determining the resulting date given a starting date and number of
'workdays' in the future. The trick was that weekends (Saturday and
Sunday) could not
Title: RE: [GENERAL] Convert Cursor to array
well my example was incomplete :
at the begin :
chapter_id | evolution | index
1 | 0 | 1
2 | 0 | 2
3 | 0 | 3
4 | 1 | 2
5 | 1 | 4
by using the sort function i obtain this :
chapter_id | evolution | index
1 | 0 | 1
4 | 1 | 2
2 | 0 |
That site produces some sort of php error.
I don't suppose this information is available elsewhere?
Stop now. I've not looked at your test results, and frankly there is no
point. As it ships, PG should run fine on a small corner of an old
laptop. It will not perform well with any sort of
Michael Fuhr [EMAIL PROTECTED] writes:
Are there any problems with doing this? Is a VALIDATOR function
permitted to modify the function it's validating?
Well, it's not *supposed* to, but the tuple is already stored so I
guess an UPDATE on it will work. At the moment.
This wouldn't work if
Rick Schumeyer wrote:
That site produces some sort of php error.
Hmm - was working this morning. Perhaps some maintenance going on.
I don't suppose this information is available elsewhere?
Try some slightly older notes here:
http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php
--
Richard
Well, your expected vs. actual rows are off, so analyzing might help.
Otherwise, what is your sort_mem set to?
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Mar 14,
Jeff Amiel wrote:
Back in 2002, Jean-Luc Lachance gave a nifty algorithm
(http://archives.postgresql.org/pgsql-sql/2002-06/msg00301.php) for
determining the resulting date given a starting date and number of
'workdays' in the future. The trick was that weekends (Saturday and
Sunday) could not
On Mon, Mar 14, 2005 at 10:54:22AM -0500, Tom Lane wrote:
The proposed hack seems far too simplistic to me ... what of CRs that
are deliberately included in string literals?
Yeah, I meant to mention that; I think it's been brought up before
in related threads. The programmer would need to be
I use a bash script (similar to following example) to update tables.
psql -v passed_in_var=\'some_value\' -f script_name
Is it possible to pass a value back from psql to the bash script?
Thanks,
Paul Cunningham
---(end of broadcast)---
TIP 8:
Alejandro D. Burne wrote:
Thanks Bruce, then how can I grant an user to create tmp tables and
drop then it, without gives him global drop priv (I can't grant drop
priv for the tmp table because don't exist yet)
Perhaps you need a SECURITY DEFINER function. You can set the
permissions on the
On Mon, 2005-03-14 at 05:52, Rick Schumeyer wrote:
Below are some PRELIMINARY results in comparing the performance of pgsql and
mysql.
These results are for a single process populating a table with 934k rows,
and then performing some selects. I also compared the effect of creating
indexes
Steven Verhoeven wrote:
Hi all
My table definition :
id | fref | mref
--+---+--
1 | 23| 25
2 | 24| 28
3 | 25| 31
4 | 26| 34
My problem :
i need a query that results in this :
id |ref
--+--
1
Andre Maasikas wrote:
From the looks of it, variable date seems to calculate
the first day of a week and for it to work day_of_the_week
has to start from 0 so Sunday - 0, Friday - 5
(in US at least?)
Andre
That appears to be the case (0 is sunday.)
thanks for the assist!!
On Mon, 2005-03-14 at 06:11, Net Virtual Mailing Lists wrote:
Hello,
I am sorry to bring this up again Does anyone have any idea what
might be going on here?... I'm very worried about this situation.. ;-(
It looks to me like either you're not analyzing often enough, or your
For the record, if people search the archives for solutions.
Problem:
You need the time zone in use for timestamp with time zone
when data was previously inserted/updated.
Discussion:
As others have mentioned, store timestamps on the server in UTC,
1) As long as I store them as
Ragnar Hafstað wrote:
On Sat, 2005-03-12 at 00:13 -0800, Benjamin Smith wrote:
Given the tables defined below, what's the easiest way to check for schedule
conflicts?
So far, the only way I've come up with is to create a huge, multi-dimensional
array in PHP, with a data element for every
On Mon, 14 Mar 2005, Michael Fuhr wrote:
Would we? My understanding is that code passed to PyRun_String()
and friends must be free of line-ending CRs on all platforms, and
that the code that reads a normal Python script takes care of
that (i.e., normalizes line endings to be LF only). Can
Richard Huxton dev@archonet.com writes:
Rick Schumeyer wrote:
Below are some PRELIMINARY results in comparing the performance of pgsql and
mysql.
Take 30 minutes to read through the article below. It covers the basics
of how to manage your configuration settings.
On Sun, 2005-03-13 at 15:23, Alex Adriaanse wrote:
Hi,
I'm working on an application for a client that uses PostgreSQL as its
database backend. The client wants to train their team on PostgreSQL so
that they can maintain the application and the database themselves after
it goes live
On Mon, Mar 14, 2005 at 08:14:42PM +0100, Marco Colombo wrote:
On Mon, 14 Mar 2005, Michael Fuhr wrote:
Would we? My understanding is that code passed to PyRun_String()
and friends must be free of line-ending CRs on all platforms, and
that the code that reads a normal Python script takes
Hi,
I really have a problem with a production environment (RH 9, Postgresql
7.4).
When executing a stored procedure on my computer (development
environment: 7.4 under cygwin. ) everything is oki
When I deploy on the production env the same stored procedure with the
same data (different OS and
On Mon, 2005-03-14 at 16:32 -0500, David Gagnon wrote:
Hi,
I really have a problem with a production environment (RH 9, Postgresql
7.4).
When I deploy on the production env the same stored procedure with the
same data (different OS and postgresql instance) the stored procedure
crash. I
I'm using postgresql 7.4.6 on RH9. My application includes a
long-running Java process responsible for database access. I'd like to
have this Java process initiate a daily VACUUM and, one way or
another, log VACUUM output.
- Is there some way to get VACUUM output via JDBC?
- If not, how can I
Thanks for your answer.
The ISP created the db fom me .. So I don't have this information. I
search the web to know how to get this info via PgadminIII and I haven't
found :-( Is there a way to get this information once the database have
been created ? I looked via psql .. I haven`t found
David Gagnon wrote:
Thanks for your answer.
The ISP created the db fom me .. So I don't have this information. I
search the web to know how to get this info via PgadminIII and I
haven't found :-( Is there a way to get this information once the
database have been created ? I looked via psql
[EMAIL PROTECTED] (Mark Rae) writes:
On Mon, Mar 14, 2005 at 06:52:58AM -0500, Rick Schumeyer wrote:
Below are some PRELIMINARY results in comparing the performance of pgsql and
mysql.
...
I have not yet done any testing of transactions, multiple concurrent
processes, etc.
I would say
Title: Multi Time Zone Select
Hi,
I load date information from different time zones into a single table. My columns are defined 'timestamp(0) with time zone' and I'm loading '2005-03-01 22:00:00-05:00' and '2005-03-01 23:00:00-06:00' for example. I query this table and expect rows from all
Hi
Thanks for the tips. Locale are the same ... unless I don`t look at
the right thing...
Production ENV
-
lc_collate | C
lc_ctype | C
lc_messages| C
lc_monetary| C
lc_numeric
3) If I retrieve them without at time zone I will get them with
the time zone that was stored in the first place, right ?
[...]
This would be news to me. I don't think it's possible to *not* have a
timezone set on a session. The server will have a default timezone
based either on the
On Mon, 2005-03-14 at 17:12 -0500, [EMAIL PROTECTED] wrote:
I'm using postgresql 7.4.6 on RH9. My application includes a
long-running Java process responsible for database access. I'd like to
have this Java process initiate a daily VACUUM and, one way or
another, log VACUUM output.
- Is
David Gagnon wrote:
Hi
Thanks for the tips. Locale are the same ... unless I don`t look at
the right thing...
...
Can you try to run the procedure from some other environment? It seems
you use some Java class, so I mean try psql, phpPgAdmin or something
different.
Miroslav
begin:vcard
I did tried to update the stored-procedure via PgadminIII and it
worked. The problem seems to be JDBC driver .. But all works well on my
TOMCA/POSTGRESL/WINDOWS platform.
I think it's something in the database setting .. is there other setting
that can cause this behavior ?
Thanks!
/David
On Mon, 2005-03-14 at 19:13 -0500, David Gagnon wrote:
I did tried to update the stored-procedure via PgadminIII and it
worked. The problem seems to be JDBC driver .. But all works well on my
TOMCA/POSTGRESL/WINDOWS platform.
I think it's something in the database setting .. is there
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Benjamin Smith wrote:
Given the tables defined below, what's the easiest way to check for schedule
conflicts?
Assuming you don't count more than once things with the same id, start, and
finish:
SELECT COUNT(DISTINCT
Joshua D. Drake wrote:
On Mon, 2005-03-14 at 17:12 -0500, [EMAIL PROTECTED] wrote:
I'm using postgresql 7.4.6 on RH9. My application includes a
long-running Java process responsible for database access. I'd like to
have this Java process initiate a daily VACUUM and, one way or
another, log VACUUM
On Mon, 2005-03-14 at 06:11, Net Virtual Mailing Lists wrote:
Hello,
I am sorry to bring this up again Does anyone have any idea what
might be going on here?... I'm very worried about this situation.. ;-(
It looks to me like either you're not analyzing often enough, or your
Hi all,
If I want to restrict the maximum size of one
table to 5MB, restrict the maximum size of database
file to 100MB, how can I do that restriction?
Is PostgreSQL8.0 support this function? I can't
find it in the manual of PostgreSQL.
Thanks.
On Mon, 2005-03-14 at 21:14, Net Virtual Mailing Lists wrote:
On Mon, 2005-03-14 at 06:11, Net Virtual Mailing Lists wrote:
Hello,
I am sorry to bring this up again Does anyone have any idea what
might be going on here?... I'm very worried about this situation.. ;-(
It looks
Has anyone ever used this? They have support for Postgres as
master or a slave in a heterogeneous setup.
Daffodil Replicator is a powerful Open Source data
synchronization tool that allows bi-directional data synchronization between
heterogeneous databases supporting JDBC drivers. Its
Alex Adriaanse presumably uttered the following on 03/13/05 15:23:
Hi,
I'm working on an application for a client that uses PostgreSQL as its
database backend. The client wants to train their team on PostgreSQL so
that they can maintain the application and the database themselves after
it
Yu Jie [EMAIL PROTECTED] writes:
Hi all,
If I want to restrict the maximum size of one
table to 5MB, restrict the maximum size of database
file to 100MB, how can I do that restriction?
Is PostgreSQL8.0 support this function? I can't
find it in the manual of PostgreSQL.
PG does
I don't think that this type of solution should be discussed as an official
patch.
If it was, I would recommend solving the problem in source code when the
function is passed to the translator. That way each platform could fix the
code to work with as is needed and the code would be portable.
I
I was reading through the docs today, and came across a paragraph that
indicated when plpgsql queries are executed on the server, the results are
all written to memory(or disk if necessary), and not streamed as available.
I can't find the doc page which said it, but does anyone know if this
Sim Zacks [EMAIL PROTECTED] writes:
I don't think that this type of solution should be discussed as an official
patch.
If it was, I would recommend solving the problem in source code when the
function is passed to the translator.
Indeed, but first we need to work out what the necessary
This would be news to me. I don't think it's possible to *not* have a
timezone set on a session. The server will have a default timezone
based either on the local (server) system time or the setting of the
timezone variable in postgresql.conf. Additionally, libpq
applications will, I
I load date information from different time zones into a single table.
My columns are defined 'timestamp(0) with time zone' and I'm loading
'2005-03-01 22:00:00-05:00' and '2005-03-01 23:00:00-06:00' for
example. I query this table and expect rows from all time zones and I
want to see the
71 matches
Mail list logo
