How can I tell PostgreSQL to use daylight saving time when applicable?
Times returned by the database are one hour behind.
TIA
Bayless
Bayless Kirtley wrote:
How can I tell PostgreSQL to use daylight saving time when applicable?
Times returned by the database are one hour behind.
it uses your client's specified local time zone to determine whether or
not DST is in effect.
SET TIME ZONE 'America/New York';
or
SET
postgres=# create table public.ps_test_x (x1 oid, x2 oid, x3 oid);
CREATE TABLE
postgres=# create table public.ps_test_y (y1 oid, y2 oid, y3 oid);
CREATE TABLE
postgres=# explain select * from public.ps_test_x where x1 in (select x1
from public.ps_test_y);
QUERY PLAN
On Mon, May 11, 2009 at 8:04 PM, esemba ese...@gmail.com wrote:
I've a table with tsvector column named meta_vector. Over this column there
is a gin index. When I execute query like:
select id from theses where meta_vector @@@ to_tsquery('cs', 'foo | (!bar)')
I get an errror message: query
Hello,
I have problem with 2gb limit for pg_dump on windows that was fixed in
version 8.2.4. I have a server with postgresql version 8.1.3, which
unfortunately cannot be upgraded. Is there some way how to use safely pg_dump
(and if needed pg_restore) version 8.2.4 or newer with the server
Zico wrote:
our server suddenly went down and after searching, i found
out that, the OS crashed. So, i had to re-install my OS
again. But, the problem is, I couldnot take the dump file for
my postgresql database. Now, i have the raw data, that means,
my datas are in a disk. Is it possible to
On Mon, 18 May 2009 09:14:41 +0800
Craig Ringer cr...@postnewspapers.com.au wrote:
Ivan Sergio Borgonovo wrote:
I'd like to know if:
- it is possible to load in an Excel sheet a table (view, query
result) coming from postgresql and to use those data to do
further
On Mon, May 18, 2009 at 1:24 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
Copy all the files that belong to the PostgreSQL server (everything
under the data directory) to a working machine with PostgreSQL
installed, and you should be able to start the server there.
the problem is, i don`t
Zico wrote:
[wants to restore a database without a backup]
Copy all the files that belong to the PostgreSQL server (everything
under the data directory) to a working machine with PostgreSQL
installed, and you should be able to start the server there.
the problem is, i don`t have files of
On Mon, May 18, 2009 at 4:00 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
Could you explain that in more detail?
What is a pds or docs?
PDF == Portable Document Format files
Docs == Documents
Means, i have the backup of my files only which was in that database.
--
Best,
Zico
Hello,
I can not find configuration option to set init_children_process.
Where I can do it?
--
--
--
Publicidad y Servicios http://www.pas-world.com
Directorio http://www.precioventa.com
Tienda http://informatica.precioventa.com/es/
Autoridad certificadora
On Mon, May 18, 2009 at 02:04:46PM +0200, Developer wrote:
Hello,
I can not find configuration option to set init_children_process.
Where I can do it?
postgresql doesn't have this option.
Best regards,
depesz
--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
Zico wrote:
[wants to restore a database without a backup]
Could you explain that in more detail?
What is a pds or docs?
PDF == Portable Document Format files
Docs == Documents
Means, i have the backup of my files only which was in that database.
I'm still not sure what that means, but
Hi,
why column acoltest is not found by the subselect in this select:
SELECT
acol + 100 as acoltest,
(select max(t) from mytab where anothercol=acoltest) as col2
FROM mytab2
group by somet
???
Only columns belonging to a table can be used in a subselect??? What about
calculated
Paolo Saul paolo.s...@telogis.com writes:
I just want to point out that the sub-query is using a column from the outer
query (eg. x1) without an alias from the table in the outer query.
This behavior is required by the SQL standard. It's called an outer
reference.
j...@email.cz wrote:
Hello,
I have problem with 2gb limit for pg_dump on windows that was fixed in
version 8.2.4. I have a server with postgresql version 8.1.3, which
unfortunately cannot be upgraded. Is there some way how to use safely pg_dump
(and if needed pg_restore) version 8.2.4
Alvaro Herrera alvhe...@commandprompt.com writes:
I think you should upgrade to 8.1.17 which likely contains the fix as
well.
If you are thinking of this fix:
2007-02-19 10:05 mha
* src/bin/pg_dump/: pg_backup_archiver.c, pg_backup_archiver.h,
pg_backup_custom.c,
On Mon, May 18, 2009 at 11:01:15AM +0200, Ivan Sergio Borgonovo wrote:
On Mon, 18 May 2009 09:14:41 +0800 Craig Ringer cr...@postnewspapers.com.au
wrote:
Ivan Sergio Borgonovo wrote:
I'd like to know if:
- it is possible to load in an Excel sheet a table (view, query
result) coming
On Mon, May 18, 2009 at 6:11 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
I'm still not sure what that means, but if you have the contents of
the database, but the database itself is gone without a trace,
then what else can you do but create a new database and fill it anew?
That`s what
On Mon, May 18, 2009 at 06:49:30AM -0700, Scara Maccai wrote:
why column acoltest is not found by the subselect in this select:
The acoltest identifier is only visible from outside the query, not
within its defining query or any of its sub-queries. If you're trying
to solve a problem like the
On Mon, May 18, 2009 at 09:21:41PM +0430, Zico wrote:
On Mon, May 18, 2009 at 6:11 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
then what else can you do but create a new database and fill it anew?
That`s what i am asking about. :) Fill it anew? That means, i have to
insert all 2000
- Original Message -
From: John R Pierce pie...@hogranch.com
To: Bayless Kirtley bk...@cox.net; PostgreSQL
pgsql-general@postgresql.org
Sent: Sunday, May 17, 2009 10:19 PM
Subject: Re: [GENERAL] Daylight saving time question
Bayless Kirtley wrote:
How can I tell PostgreSQL to use
Zico wrote:
On Mon, May 18, 2009 at 6:11 PM, Albe Laurenz laurenz.a...@wien.gv.at
mailto:laurenz.a...@wien.gv.at wrote:
I'm still not sure what that means, but if you have the contents of
the database, but the database itself is gone without a trace,
then what else can you do
On Mon, May 18, 2009 at 06:15:28PM +0100, Sam Mason wrote:
You need to get the contents of the database from somewhere; the obvious
choices seem to be an existing copy of the PG database directory, a
backup of the database, or the original data. Your previous messages
seem to indicate that
Bayless Kirtley bk...@cox.net writes:
For some reason I can't seem to make it work. I have tried setting the
timezone
in postgresql.conf as timezone = 'America/Chicago' and timezone =
'CST6CDT'
both of which still returned one hour behind. I also tried both of your
suggestions
as SQL
On Mon, May 18, 2009 at 11:16 AM, Bayless Kirtley bk...@cox.net wrote:
- Original Message - From: John R Pierce pie...@hogranch.com
Bayless Kirtley wrote:
How can I tell PostgreSQL to use daylight saving time when applicable?
Times returned by the database are one hour behind.
it
Thanks Tom and Scott. You got me looking in the right direction. In this
case
the client and server are on the same machine (testing/development) and psql
does return the right result. I tried all the possibilities from the java
program,
show timezone, select current_time and select
On Mon, May 18, 2009 at 9:48 PM, John R Pierce pie...@hogranch.com wrote:
we still don't understand exactly what you have to work from
Do you have a backup of the Postgres data directory,
No, I don`t have any data of Postgres data directory.
which typically is something like C:\Program
Hello all,
Is there an easy and efficient way to return a boolean false for a
query that returns no result, and true for one that does return a
result?
Currently we select the result into a temp table.
SELECT INTO temp_table id FROM ... ;
IF temp_table IS NULL THEN
resp:= 'NO';
ELSE
Hello
look on GET DIAGNOSTIC statement or FOUND variable
CREATE OR REPLACE FUNCTION foo()
RETURNS boolean AS $$
BEGIN
SELECT INTO temp_table ...
RETURN found;
END;
$$ language plpgsql;
regards
Pavel Stehule
2009/5/18 Joshua Berry yob...@gmail.com:
Hello all,
Is there an easy and
On Mon, May 18, 2009 at 03:13:56PM -0400, Joshua Berry wrote:
Hello all,
Is there an easy and efficient way to return a boolean false for a query
that returns no result, and true for one that does return a result?
Currently we select the result into a temp table.
SELECT INTO temp_table id
On Mon, May 18, 2009 at 3:13 PM, Joshua Berry yob...@gmail.com wrote:
Any hints/tips? Is our original solution okay, or is there something we can
do to improve things?
It seems as if you don't really care about the results of the query-
just whether or not it returns any rows. In that case, why
On Mon, 2009-05-18 at 15:13 -0400, Joshua Berry wrote:
Is there an easy and efficient way to return a boolean false for a
query that returns no result, and true for one that does return a
result?
Presuming that you're not using the values in temp_table, I think you
should be using PERFORM *
Bayless Kirtley bk...@cox.net writes:
Is this a flaw in the JDBC driver or is that the expected behavior?
You'd be more likely to get the correct answer on pgsql-jdbc.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
On Mon, May 18, 2009 at 11:33:03PM +0430, Zico wrote:
we still don't understand exactly what you have to work from
Do you have a backup of the Postgres data directory,
No, I don`t have any data of Postgres data directory.
Well, in that case I would suggest to IMMEDIATELY STOP
WRITING
Hello,
I have a small problem,I need to export data from a table into a csv
file.For this i am using pqxx library to work on it.I can able to retrieve the
data from the database but the only problem is I am unable to store it in a csv
file.Can you guys please help me how to do that.
I have a small problem,I need to export data from a table
into a csv file.For this i am using pqxx library to work on it.I can
able to retrieve the data from the database but the only problem is
I am unable to store it in a csv file.Can you guys please help me
how to do that.
Hello Everyone,
I'm looking at an easy real-time application using PostgreSQL.
Looking at the pg docs, I see lots of discussion about cases where
MVCC may reflect different versions of the data to different
connections. For example:
http://www.postgresql.org/docs/8.1/static/mvcc.html
while
Hello All,
I'm trying to optimize a few slow queries and helper functions, and
have found a poor performing function. To improve performance, I'd
like to create a function that does the following:
Inputs:
A: an array of integers. for example: { 1, 2, 3, 4, 7 }
B: an array of integers. for
Joshua Berry wrote:
I have a small problem,I need to export data from a table
into a csv file.For this i am using pqxx library to work on it.I can
able to retrieve the data from the database but the only problem is I
am unable to store it in a csv file.Can you guys please help me
On Mon, May 18, 2009 at 04:38:36PM -0500, Marsh Ray wrote:
The central question: So if I successfully commit an update
transaction on one connection, then instantaneously issue a select on
another previously-opened connection, under what circumstances am I
guaranteed that the select will see
On Mon, May 18, 2009 at 4:53 PM, Ben Chobot be...@silentmedia.com wrote:
On Mon, 18 May 2009, Marsh Ray wrote:
Hello Everyone,
I'm looking at an easy real-time application using PostgreSQL.
As I understand real-time applications, PostgreSQL is inherintly unsuited
for the task. There is
On Mon, May 18, 2009 at 05:18:06PM -0500, Marsh Ray wrote:
On Mon, May 18, 2009 at 4:53 PM, Ben Chobot be...@silentmedia.com wrote:
On Mon, 18 May 2009, Marsh Ray wrote:
Hello Everyone,
I'm looking at an easy real-time application using PostgreSQL.
As I understand real-time applications,
Hi,
Just installed 8.3.7 on a W2K3 machine using the pginstaller. I cannot
find contrib/tsearch2.sql - I need to import an 8.2 backup with the old
tsearch2 but cannot find the new compatibility layer sql file.
Where is it???
Thanks,
Howard Cole
www.selestial.com
--
Sent via pgsql-general
On Mon, May 18, 2009 at 5:24 PM, Sam Mason s...@samason.me.uk wrote:
Even then it's not useful to class it as real-time; nothing bad
happens if you don't get a response before timeout the user just gets an
error message. Real-time applies when if you don't get a response the
plane crashes or
On Mon, May 18, 2009 at 5:14 PM, Sam Mason s...@samason.me.uk wrote:
On Mon, May 18, 2009 at 04:38:36PM -0500, Marsh Ray wrote:
The central question: So if I successfully commit an update
transaction on one connection, then instantaneously issue a select on
another previously-opened
Hi, I'm having some pain getting Postgres 8.3 installed on windows vista 64.
The first time I tried to install it, I was using the .msi version, which
eventually hit permissions problems, and when I aborted the install, the
uninstall did not seem to take.
Then I tried the .exe version of 8.3,
Marsh Ray marsh5...@gmail.com writes:
The central question: So if I successfully commit an update
transaction on one connection, then instantaneously issue a select on
another previously-opened connection, under what circumstances am I
guaranteed that the select will see the effects of the
On Mon, May 18, 2009 at 6:20 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Marsh Ray marsh5...@gmail.com writes:
The central question: So if I successfully commit an update
transaction on one connection, then instantaneously issue a select on
another previously-opened connection, under what
Joshua Berry escribió:
Inputs:
A: an array of integers. for example: { 1, 2, 3, 4, 7 }
B: an array of integers. for example: { 1, 4, 8, 9 }
Returns
C: an array of bools the same dimensions as Array A. In this example: {
true, false, false, false, true, false }
Effectively, this function
Marsh Ray escribió:
On Mon, May 18, 2009 at 6:20 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Marsh Ray marsh5...@gmail.com writes:
The central question: So if I successfully commit an update
transaction on one connection, then instantaneously issue a select on
another previously-opened
hi,
you should use something similar to 'merge sort'
but only if your input is sorted (m_bx expects this)
if your subjects (numbers) are not going beyond a certain limit eg(65535)
take up an array and filter
you can generate a poly for array B's roots, and calculate A's points
-where it's 0,
Thank you for clearing that up.
Regards,
Paolo Saul
This behavior is required by the SQL standard. It's called an outer
reference.
regards, tom lane
2009/5/18 Joshua Berry yob...@gmail.com:
Hello All,
I'm trying to optimize a few slow queries and helper functions, and have
found a poor performing function. To improve performance, I'd like to create
a function that does the following:
Inputs:
A: an array of integers. for example: { 1,
54 matches
Mail list logo