standard SP2 (VMware Virtual Software)
The server has Postgres 9.0.3 (I believe)
They are also using a domain which I believe is causing the problem but
I dont know enough about that to say for sure.
Has anyone seen this before and know what they can do?
--
Christine Penner
Ingenious Software
250
can't seem to do that without getting
syntax errors
--
Christine Penner
Ingenious Software
250-352-9495
ch...@fp2.ca
This still gave me a sytax error. The other suggestion to multiply the
interval field by 1 year also gave me a syntax error.
ii_purchased is a timestamp without time zone
ii_expected_life is a smallint
Any other suggestions?
Christine Penner
Ingenious Software
250-352-9495
ch...@fp2.ca
This worked. Thanks
Christine Penner
Ingenious Software
250-352-9495
ch...@fp2.ca
On 06/04/2011 9:23 AM, Osvaldo Kussama wrote:
SELECT ii_purchased + ii_expected_life * '1 year'::interval FROM inventory_item;
instead of
single quotes this works.
--
Christine Penner
Ingenious Software
250-352-9495
ch...@fp2.ca
;
Display := meetType
Return;
end if;
else
Display := subj
Return;
end if;
Return;
END;
$BODY$
LANGUAGE plpgsql IMMUTABLE
COST 100;
Christine Penner
--
Sent via pgsql-general mailing
I have seen other functions (written by others) that do this. So I
assume its ok. I'm open to suggestions though. As long as it works.
At 01:54 PM 16/11/2010, you wrote:
On 16/11/2010 21:27, Christine Penner wrote:
create or replace function SubjectDisplay(IN subj varchar,IN meetCode
I am returning one value (text). Each of the selects in the function
should also return only one value.
At 02:06 PM 16/11/2010, you wrote:
On 11/16/2010 3:57 PM, Christine Penner wrote:
I have seen other functions (written by others) that do this. So I
assume its ok. I'm open to suggestions
: If you want to discard the results of a SELECT, use PERFORM instead.
Context: PL/pgSQL function subjectdisplay line 7 at SQL statement
At 02:09 PM 16/11/2010, Raymond O'Donnell wrote:
On 16/11/2010 21:57, Christine Penner wrote:
I have seen other functions (written by others) that do this. So I
I have a table column I want to change from a boolean to a smallint.
changing false to 0 and true to 1. How do I do that?
Christine Penner
Ingenious Software
250-352-9495
ch...@fp2.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
ON TRAIN_MOD.TRM_TRC_SEQ=TRAIN_COMP.TRC_SEQ_NO
where TC_PUB_ED IS TRUE OR TC_SEQ_NO IS NULL
Christine Penner
Ingenious Software
250-352-9495
christ...@ingenioussoftware.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
ON TRAIN_MOD.TRM_TRC_SEQ=TRAIN_COMP.TRC_SEQ_NO
where TC_PUB_ED IS TRUE OR TC_SEQ_NO IS NULL
Christine Penner
Ingenious Software
250-352-9495
christ...@ingenioussoftware.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
for the query.
Hope this info helps. I'm sure there is something wrong with the join
or something, I just don't see it.
Christine
At 10:22 AM 16/09/2010, you wrote:
On 16/09/2010 16:05, Christine Penner wrote:
I have a query that joins 3 tables, TRAIN_MOD,TRAIN_COMP and
TRAINING_COURSE,
There could
I decided to approach this a different way. Not worth the time to
figure out. I get all records from all tables and put them together
in the program using this.
Thanks for your help.
Christine
At 12:20 PM 16/09/2010, you wrote:
On 16/09/2010 18:33, Christine Penner wrote:
Training Course
-this gives me an error
Any other suggestions?
Christine Penner
Ingenious Software
250-352-9495
christ...@ingenioussoftware.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I have a character field I want to change to a number. The values in
that field are all numbers that may or may not be padded with spaces
or 0's. What is the best way to do that?
Christine Penner
Ingenious Software
250-352-9495
christ...@ingenioussoftware.com
--
Sent via pgsql-general
:
In response to Christine Penner christ...@ingenioussoftware.com:
I have a character field I want to change to a number. The values in
that field are all numbers that may or may not be padded with spaces
or 0's. What is the best way to do that?
Put the values in numeric fields to begin with and cast
This is what I did.
set all blank columns to '0' because they were causing errors.
alter table T alter column a type integer using a::integer
That worked perfectly.
Thanks everyone for the help.
Christine
At 12:46 PM 24/02/2010, Scott Marlowe wrote:
On Wed, Feb 24, 2010 at 1:43 PM, Tom Lane
that the port forwarding got disabled somehow so
I set that up again but still no luck.
I'm at a loss here. What else can I be missing?
Christine Penner
Ingenious Software
250-352-9495
christ...@ingenioussoftware.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
I have re started the computer (a few times) since I did all that.
Christine
At 09:08 AM 01/02/2010, you wrote:
On 02/01/2010 08:36 AM, Christine Penner wrote:
Hi,
I'm having trouble getting a connection to Postgres to work from outside
of my local network. It was working fine at one point
When we try to connect we don't get a specific error, just that it
can't connect. I'm not sure what logs to look in or on what end.
Christine
At 09:13 AM 01/02/2010, you wrote:
On 02/01/2010 09:10 AM, Christine Penner wrote:
I have re started the computer (a few times) since I did all
at the firewall settings and see.
Christine
At 09:20 AM 01/02/2010, you wrote:
Christine Penner wrote:
Hi,
I'm having trouble getting a connection to Postgres to work from
outside of my local network. It was working fine at one point. Then
I had to change IP addresses and I can't get
.
Christine Penner
Ingenious Software
250-352-9495
mailto:christ...@ingenioussoftware.comchrist...@ingenioussoftware.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thanks a lot, that worked great. Saved me a lot of time trying to
figure it out too.
Christine
It works for me:
postgres=# CREATE OR REPLACE FUNCTION countertest(integer) RETURNS
bigint AS $$ SELECT COUNT(*) FROM test WHERE nbr = $1; $$ LANGUAGE
SQL;
CREATE FUNCTION
postgres=# select
but that can change of course.
Christine Penner
Ingenious Software
250-352-9495
christ...@ingenioussoftware.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to make them faster. I have tried
restarting the Postgres service but that doesn't help.
Christine Penner
Ingenious Software
250-352-9495
christ...@ingenioussoftware.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
by your
PATH variable. Also, try giving a full path to
the data directory for your -D argument. It might not be finding one of them.
---
David Spadea
Spadea Enterprises, Inc
http://www.spadea.nethttp://www.spadea.net
On Mon, Sep 21, 2009 at 10:53 AM, Christine
Penner
mailto:christ
the data directory in a place other than the program files
directory. I have done this a few times now and I'm just not seeing
what I'm missing. When I originally installed Postgres 8.3 I didn't
use the one click installer. Since then I have upgraded to another
8.3.x without any issues.
Christine
Alban,
That was exactly what I was looking for.
Thanks
Christine
At 03:45 AM 13/06/2009, you wrote:
On Jun 13, 2009, at 12:35 AM, Christine Penner wrote:
Sam,
The problem with making it a numeric field is that I have seen
things like A123, #123a or 23-233. This is only here to make most
)
instead of ?? I need to know the position of the last numeric character.
Any suggestions would be appreciated
Christine Penner
Ingenious Software
250-352-9495
christ...@ingenioussoftware.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
stuck.
Christine
At 03:05 PM 12/06/2009, you wrote:
On Fri, Jun 12, 2009 at 12:36:27PM -0700, Christine Penner wrote:
I want to calculate a new field I added to a table but I'm not sure
how to do it. This will be a copy of another field with any non
numeric characters stripped off the end
Sam,
I get nothing. I just updated recently but the only version number I
can find is 8.3. I know its at least 8.3.4 but should be more.
Christine
At 03:58 PM 12/06/2009, you wrote:
On Fri, Jun 12, 2009 at 03:35:44PM -0700, Christine Penner wrote:
The problem with making it a numeric field
an
existing database but not always. Doesn't seem to make a difference.
The big problem with the crashes is the only way to be able to use
Postgres at that point is to restart the whole computer.
We are all using 8.3.4 on Windows XP
Christine Penner
Ingenious Software
250-352-9495
christ
.
Allan.
On Tue, Apr 28, 2009 at 5:43 PM, Christine Penner
christ...@ingenioussoftware.com wrote:
We are in the process of converting our application to use
Postgres. We have
about 5 computers in the office. We frequently create a database on one
computer and then transfer it to the other
are updated and
running. I haven't run Memtest86 on any of them. This has happened on
5 different computers including my personal laptop which is never
connected to the network at the office.
Christine
At 11:35 AM 28/04/2009, you wrote:
Christine Penner wrote:
The crashes I get are the windows
After looking closer at the log file I found something interesting:
2009-04-27 17:38:38 PDT ERROR: column f_township of relation
fire_report does not exist at character 3584. Almost every insert
got an error about a duplicate primary key. That shouldn't happen
because all these records were
When trying to upgrade Postgres I got this message:
The existing data directory (Date/time settings: floating -point
numbers) is not compatible with this server (Date/Time setting:
64-bit integers)
I saw a few posts about this but I'm still not sure how to fix it. I
think one of them said I
I am upgrading from 8.3.4 to 8.3.7. That's why I'm confused. The
notes said I wouldn't have to do that. 8.3.4 was the original install.
Christine
At 10:09 AM 22/04/2009, you wrote:
On 22/04/2009 16:57, Christine Penner wrote:
The existing data directory (Date/time settings: floating -point
all
defaults for directories because I want to keep my existing data etc.
Christine
At 10:24 AM 22/04/2009, you wrote:
On Wed, 2009-04-22 at 10:13 -0700, Christine Penner wrote:
I am upgrading from 8.3.4 to 8.3.7. That's why I'm confused. The
notes said I wouldn't have to do that. 8.3.4
It was a zip file with an msi installer in it. I tried to find a
similar one for the update but all I could find was the one click installer.
Christine
At 11:00 AM 22/04/2009, you wrote:
Joshua D. Drake wrote on 22.04.2009 19:34:
Huh, I wonder when the windows package changed its defaults.
The link below takes me to the same place I got this installer I'm
having problems with. I am pretty sure I got the original installer
from the Postgres web site just like I just did.
Christine
At 11:14 AM 22/04/2009, you wrote:
On 22/04/2009 19:05, Christine Penner wrote:
It was a zip file
got was called a binary package.
I think that will work for me.
Thanks
Christine
At 11:27 AM 22/04/2009, you wrote:
On 22/04/2009 19:21, Christine Penner wrote:
The link below takes me to the same place I got this installer I'm
having problems with. I am pretty sure I got the original
42 matches
Mail list logo