> 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 th
> > 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
"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
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
applies
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 ra
"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.
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 goes
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
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..
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 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 yo
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 o
-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 (s1.event_id||s1.start||s1.
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
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
--
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
fn;quo
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.
>
> - I
>> 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
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 |
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
[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.
>>
>
>
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 ..
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 eit
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 ge
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
> cr
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, 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
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 liv
Richard Huxton 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.
>http://www.powerpostgresql.com/P
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 anybo
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 minute
For the record, if people search the archives for solutions.
Problem:
You need the time zone in use for
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 I should
> > not need to
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
stati
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!!
-
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 |
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
> in
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
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: ex
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
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
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, 2005
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
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
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 se
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 so
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 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
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
datasou
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
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 =C5=A0
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
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 a
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
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'
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
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
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 = PQexec(pobj->connect
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
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
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 ju
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=> ex
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").
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,
> 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
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
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 |
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
wrote:
> Alejandro D
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
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
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 colu
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 e
71 matches
Mail list logo
