It seems not possible to suppress to_timestamp from doing daylight
saving conversion, I have GPS timeseries that looks perfect in the
'timestamp without time zone' save one value that wreck the whole time
serie, does that mean that time series cant be stored in time stamps?
/Hans-Henr
Thanx a lot for your promt respons :) You are absolutely right, its the
daylight saving that date and hour, I had it as an key in my GPS data and was
very confused!!!
Again - Thanx
/Hans-Henrik
On Dec 15, 2011, at 5:20 PM, Kevin Grittner wrote:
> wrote:
>
>> test to run: select
if you do proper migration you should try to get rid of stupid design like
this..
it is possible to stand on your head actually ... it just makes no sense if you
are waiting for the bus.
the fact that mysql has something does not implicitly mean that it makes sense
to have it as well.
a way t
ulate boolean not null ... let me not comment on
that one for social reasons ;).
regards,
hans
--
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de
--
Sent via pgsql-bugs mailing list (pgsql-b
The following bug has been logged online:
Bug reference: 5566
Logged by: Hans van Kranenburg
Email address: hans.van.kranenb...@mendix.com
PostgreSQL version: 8.3.11
Operating system: Debian GNU/Linux 5.0
Description:High levels of savepoint nesting trigger stack
The following bug has been logged online:
Bug reference: 4975
Logged by: Hans
Email address: nanjangmu...@naver.com
PostgreSQL version: 8.4.0
Operating system: Windows Server 2003 Standard Edition KN Service Pack 2
Description:Not properly installed during the
ry
Why PG check them?
can you share the PostgreSQL version you are using with us?
maybe you can compile a test case?
or maybe you are facing some sort of corruption? what happens after dump
/ reload?
many thanks,
hans
--
Cybertec Schönig & Schönig GmbH
PostgreSQL Solutions and Support
Grö
The following bug has been logged online:
Bug reference: 2834
Logged by: Hans
Email address: [EMAIL PROTECTED]
PostgreSQL version: postgresql-8.1.
Operating system: windows xp home
Description:installation problem
Details:
i was unable to install posgres after
The following bug has been logged online:
Bug reference: 2634
Logged by: Hans Postma
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Windows XP VM virtual server
Description:path requires double \\ for WAL archiving
Details:
Hi there
ther questions,
please let me know.
Regards,
Hans Guijt
TERMA B.V.
Schuttersveld 9
NL-2316 XG, Leiden
The Netherlands
Phone: +31 (0)71 52 40 835
Telefax: +31 (0)71 51 43 277
E-mail: [EMAIL PROTECTED]
- Original Message -
From: "John R Pierce" <[EMAIL PROTECTED]>
To: &quo
t touched these parameters; all the copies of Postgres are
installed with their default parameters.
I have also been able to try the same operation on another Windows 2000
machine and it completed without problems, so we know it isn't the OS perse.
Regards,
Hans Guijt
TERMA B.V.
Schuttersveld 9
NL
The following bug has been logged online:
Bug reference: 2094
Logged by: Hans Schlüper
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.0
Operating system: AIX 5.3
Description:AIX: libraries contain the symbol main
Details:
Problem:
with xlc compiler under
Michael Fuhr wrote:
On Sat, Jul 30, 2005 at 02:43:23PM +0200, Hans-Jürgen Schönig wrote:
no, this one seems to be fine now.
i have no idea what went wrong.
the code cored at some very "unlikely" place.
Are you saying that it *did* dump core, or that it *didn't*? It'
no, this one seems to be fine now.
i have no idea what went wrong.
the code cored at some very "unlikely" place.
somehow rebooting helped ... - this was very strange.
fortunately it works nicely now ...
many thanks a best regards,
hans
Michael Fuhr wrot
I have seen that.
The question is: Gcc seems to get it right ;).
In my little world two compiler should handle this the same but I have
learned that Sun is in many cases different world ...
1+1 is always 2 - on Sun it could also be 3 ;).
hans
Michael Fuhr wrote:
On Thu, Jul 07
uild on Sun Studio 9? How would GCC treat that patch?
Did anybody encounter similar problems?
Best regards,
Hans
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
i have never seen this before ...
after rebooting the box (for some other reason) it worked.
somehow there has been something else going terribly wrong ...
sorry for the confusion ...
best regards,
hans
Hans-Jürgen Schönig wrote:
Michael Fuhr wrote:
On Tue, Jul 05
Michael Fuhr wrote:
On Tue, Jul 05, 2005 at 04:37:05PM -0400, Tom Lane wrote:
Michael Fuhr <[EMAIL PROTECTED]> writes:
On Tue, Jul 05, 2005 at 09:54:52PM +0200, Hans-Jürgen Schönig wrote:
we have found a bug in CVS head using PL/Perl:
How current is your checkout? Mine'
Michael Fuhr wrote:
On Tue, Jul 05, 2005 at 09:54:52PM +0200, Hans-Jürgen Schönig wrote:
we have found a bug in CVS head using PL/Perl:
How current is your checkout? Mine's from this morning and I don't
get a crash with the example you posted:
test=> SELECT func();
NOTICE: s
ion IS NOT NULL AND pid =
pg_backend_pid() ";
elog(NOTICE, "sql: $sql");
my $rv = spi_exec_query($sql);
return 0;
' LANGUAGE 'plperlu';
SELECT func();
somehow Perl does not seem to like the SPI.
only the development code seems to be a
I've just installed v8.0.3 and tested the 'epoch' part of extract, which for
my applications is fundamental. here is the result:
jova=# select extract(epoch from timestamp '19700102')\g
date_part
---
82800
(1 row)
jova=# select extract(epoch from timestamp '19700101')\g
date_par
)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
al, it is pretty hard to track down a bug with absolutely no information.
you cannot expect an answer without a test case.
best regards,
http://developer.postgresql.org/docs/postgres/kernel-resources.html
16.5.1
"FreeBSD"
...$ systcl -w kern.ipc.shmall=32768
$ systcl -w kern.ipc.shmmax=134217728
$ systcl -w kern.ipc.semmap=256
"Linux"
...
$ systcl -w kernel.shmmax=134217728
$ systcl -w kernel.shmall=2097152
systcl is wro
te. I remeber seeing configure running for ever on
some operating system when you change the system date to 1970 or so (I
think tar xvfz would issue a warning in this case anyway).
Maybe this helps.
Regards,
Hans
---(end of broadcast)---
l occurred. Starting the same binary thing on a
different machine did not show that error ...
We stepped through it with gdb but we could not find anything strange ...
Can you reliably reproduce the problem after a arbitrary amount of
iterations on a different machine? We couldn't ...
Looking a
EMAIL PROTECTED]
Technical Support Analyst
The Gleaner Company Ltd.
7 North Street
Kingston
Tel: 922-3400
No, PostgreSQL is not pre-allocating space.
This is definitely not a bug.
If you want that you should use a separate filesystem partition which
can grow on demand.
Best regards,
Hans-Ju
had to go back to
postgresql-8.0-beta2-dev2.zip
to download a version that installed. But I do not want to
test older versions -- can you help me?
Regards, Hans Werner Borchers.
---(end of broadcast)---
TIP 8: explain analyze is your friend
I compiled on Linux with no extra options.
using the psql monitor comman line editing works but psql will abort
with signal 11 (SIGSEV) when trying to do a "real" edit by using \e
--
mfG
* Hans-Ulrich SchaeferPhone: +(0)89-289-27819 *
* LRZ Abt. Hochleistu
On Fri, 30 Jul 2004, Peter Eisentraut wrote:
> Hans Schou wrote:
> > I needed to have 36 function parameters.
> > PostgreSQL only allows 32.
>
> If you index more than three or four columns you're doing something
> wrong.
Could be.
> Please explain in more de
POSTGRESQL BUG REPORT TEMPLATE
Your name : Hans Schou
Your email address : [EMAIL
Eloy Mier Pérez wrote:
> How can i do this ?
Not possible.
Oracle works upper-case only for dictionary unless using "". Many have found
this to be "a good thing", others think it's a limitation. Not worth
debating!
Best you learn to code to the documented limits
Seems like a bug to me.
PostgreSQL 7.4 on i686-pc-linux-gnu, compiled
by GCC gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5):
my_example=# select
has_function_privilege('postgres', 'cash_cmp', 'execute');ERROR:
expected a left parenthesismy_example=# select
has_function_privilege('cash_
leted (=
declared invalid so that no other transaction can see it).
Why? Because you don't know if the data is REALLY obsolete until you commit.
Cheers,
Hans
--
Cybertec Geschwinde u Schoenig
Schoengrabern 134, A-2020 Hollabrunn, Austria
Tel: +43/2952/30706 or +43/664/233 90 75
www.c
I guess you are using pl/perl and not pl/perlU.
Using untrusted modules in trusted functions is not a good idea.
I guess you will need pl/perlU.
Cheers,
Hans
Pavel Stehule wrote:
Hello
When I try add "use" cmd into my code, I get following error:
ERROR: creation of funct
I use a debian system with:
postgresql 7.3.3-1 client and server
--
Hans-Jürgen Hay <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
rc/include/access/relscan.h:17,
from ../../../../src/include/access/hash.h:21,
from hashovfl.c:20:
Here is the code around line 350:
/* Get machine-dependent inline versions (if there are any). */
#ifdef __USE_EXTERN_INLINES
# include
#endif
Maybe this is helpful.
Poland start to when
the first full week starts.
Maybe we should verify and document this somewhere.
Regards,
Hans
[EMAIL PROTECTED] wrote:
hi,
last year (2002) the date december 31st is in week 1 of 2003.
it is not possible to get this out of a date-column using EXTRACT or
(), I get no lower letters.
With upper() it is the same problem vice verser ...
All the best from Germany,
Hans
ghl=# select version();
version
---
PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC
=
POSTGRESQL BUG REPORT TEMPLATE
=
Your name : Hans Plum
Your email address : [EMAIL PROTECTED]
System Configuration
uot;D" is a real problem. Is this already a known bug?
Hans
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Strange ...
The process continued after stopping for a while (and using no CPU time).
Sorry, no bug :)
Hans
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
ultibyte
--datadir=/tmp/pgdata/
Hans
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
)
best regards/hans
--
Hamletsgade 4 - 201, DK-2200 København N, Phone: +45 2264 8020
Schou Industries ApS http://schou.dk CVR: 26 13 44 39
--
panic("Fod fight!"); -- linux/drivers/scsi/aha1542.c
/bin/sh ./
I don't have a bug template at hand.
Within a plpgsql function, concatenating TEXT strings from tables that allow NULL
values return nil results. Please run the following. The result of the second select
is nil.
Cheers, H.P.
---
create
44 matches
Mail list logo
