First thanks to all for your immediate help!
2006/9/3, Tom Lane <[EMAIL PROTECTED]>:
"Peter Bauer" <[EMAIL PROTECTED]> writes:
> - OS: Debian Sarge with postgresql-7.4.7-6sarge1
You do know that we're up to 7.4.13 in that branch? There were some
pretty serious bugs found in 7.4 since 7.4.7, so
On Sun, Sep 03, 2006 at 12:59:08AM -0400, Tom Lane wrote:
> Michael Fuhr <[EMAIL PROTECTED]> writes:
> > test=> SELECT ARRAY[1, 2, 3, 4] @ ARRAY[1, 3];
> > ?column?
> > --
> > t
> > (1 row)
>
> > In 8.2 the above example will work in the stock installation for
> > arrays of any type (i.
Joshua D. Drake wrote:
Training I agree with, but certifications can go either way.
Guys, a multiple perspective is important. Your perspective is valid,
but doesn't address the true purpose of these easy certs. They are
designed to give the companies involved larger mind space among
p
I have a column that I wish to use to designate loop
numbers.
A loop number is composed of a letter (F for flow, T for
temperatures etc.) followed by a sequence number starting at one and ending with
the last loop.
The loop numbers will appear as F-1, T-2 and so
on.
I seem to have no p
Hi all,I have a question about how a certain function would look. Basically, what I want to do is having something that would take in a 'from' date (day, month, year) and a 'to' date (also day, month and year) and then spit back a series of records whose timestamps fall between those two dates. How
Hi,
I need your help.
Here is my case: I would like to integrate postgresql
(binaries-no-installer) into my own installer for an python-based web
application in window systems (window xp, window 2000 etc). My own
installer needs to create some postgresql users, a database and tables
for the
Hi,
I have a program which uses Postgresql as a database for persistence.
The application uses IzPack to install.
Ideally I would like to also install Postgresql in the same wizard
conversation, plus get it up and running as a windows service (or
daemon on 'nix).
Is all of that possible - has an
I'm currently getting:
"PgFoundry Could Not Connect to Database"
when I try to visit http://pgfoundry.org
Regards,
Ben
---(end of broadcast)---
TIP 6: explain analyze is your friend
In article <[EMAIL PROTECTED]>,
Rafael Barrera Oro <[EMAIL PROTECTED]> wrote:
% Hello everyone! i am checking a database due to some inconsintencies and
% i was wandering if its possible to find out the creation date of a
% record (using the oid, whatever...). Maybe i am saying something stupid
Is there any plans (or somebody already working on) to see compressed
protocol in 8.2 ?
zac
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
In article <[EMAIL PROTECTED]>, Florian G. Pflug <[EMAIL PROTECTED]> wrote:
% You could try doing:
%
% begin;
% select 1;
% select 1;
% ...
% rollback;
Yes, I tried that, but each select is on the order of 100ms.
% off. If that doesn't reveal a possible cause, then I'd suggest that
% you strace
On Sunday 03 September 2006 02:24 pm, Bob Pawley wrote:
> I have a column that I wish to use to designate loop numbers.
>
> A loop number is composed of a letter (F for flow, T for temperatures etc.)
> followed by a sequence number starting at one and ending with the last
> loop.
>
> The loop numbe
I am trying to create a view based on this query
'select *, "timestamp"::timestamp from ccmanager_log'
This is the error I get to below, how do I use the time zone syntax
error: cannot cast tupe double precision to timestamp without time zone
What is the right syntax?
The column to be conve
On Sep 4, 2006, at 7:57 , Frank Church wrote:
I am trying to create a view based on this query
'select *, "timestamp"::timestamp from ccmanager_log'
What is the right syntax?
Try this:
select *, to_timestamp("timestamp") from ccmanager_log
http://www.postgresql.org/docs/current/intera
Frank Church wrote:
> error: cannot cast tupe double precision to timestamp without time
> zone
>
> What is the right syntax?
It's not clear what the meaning of a double precision as a timestamp
would be. How about you make that explicit:
"timestamp" * interval '1 second' + timestamp '1900-01-0
zeljko <[EMAIL PROTECTED]> writes:
> Is there any plans (or somebody already working on) to see compressed
> protocol in 8.2 ?
Why bother? Run your session through an ssh tunnel and ask it to
compress.
regards, tom lane
---(end of broadcast)--
Please reply to the list so that others may contribute to and learn
from the discussion.
On Sep 4, 2006, at 8:34 , Frank Church wrote:
ERROR: function to_timestamp(double precision) does not exist
HINT: No function matches the given name and argument types. You may
need to add explicit ty
On 9/4/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
Frank Church wrote:
> error: cannot cast tupe double precision to timestamp without time
> zone
>
> What is the right syntax?
It's not clear what the meaning of a double precision as a timestamp
would be. How about you make that explicit:
Peter's suggestion did not work.
On 9/4/06, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
Please reply to the list so that others may contribute to and learn
from the discussion.
I am now getting familiar with google mail
On Sep 4, 2006, at 8:34 , Frank Church wrote:
> ERROR: function to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
> zeljko <[EMAIL PROTECTED]> writes:
>> Is there any plans (or somebody already working on) to see compressed
>> protocol in 8.2 ?
>
> Why bother? Run your session through an ssh tunnel and ask it to
> compress.
Wouldn't that add ext
Ron Johnson <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> zeljko <[EMAIL PROTECTED]> writes:
>>> Is there any plans (or somebody already working on) to see compressed
>>> protocol in 8.2 ?
>>
>> Why bother? Run your session through an ssh tunnel and ask it to
>> compress.
> Wouldn't that add
"Frank Church" <[EMAIL PROTECTED]> writes:
> I tried the query in this form:
> select *, "timestamp" * interval '1 second' + timestamp '1900-01-01
> 00:00:00' from ccmanager_log
Try timestamp plus interval, instead of the other way. (We did add the
operator in this direction in 8.0 though ... pe
[EMAIL PROTECTED] wrote:
Hi,
I have a program which uses Postgresql as a database for persistence.
The application uses IzPack to install.
Ideally I would like to also install Postgresql in the same wizard
conversation, plus get it up and running as a windows service (or
daemon on 'nix).
Is al
"Sean O'Loughlin" <[EMAIL PROTECTED]> writes:
> Hi all,
> I have a question about how a certain function would look. Basically, what I
> want to do is
> having something that would take in a 'from' date (day, month, year) and a
> 'to' date (also day,
> month and year) and then spit back a series
am Sun, dem 03.09.2006, um 14:24:41 -0700 mailte Bob Pawley folgendes:
> I have a column that I wish to use to designate loop numbers.
>
> A loop number is composed of a letter (F for flow, T for temperatures etc.)
> followed by a sequence number starting at one and ending with the last loop.
>
25 matches
Mail list logo
