Hello,
I have a VARCHAR column containing mostly ip addresses, with an
occasional piece of junk, and would like to transfer this data to an
INET column. The UPDATE (SET inet_col = CAST(vc_col AS INET)) aborts
as soon as it hits an invalid datum. I'm looking for a way to add
something like WHERE IS
On Sat, Jul 23, 2005 at 11:31:23AM +0200, Roman Neuhauser wrote:
>
> I have a VARCHAR column containing mostly ip addresses, with an
> occasional piece of junk, and would like to transfer this data to an
> INET column. The UPDATE (SET inet_col = CAST(vc_col AS INET)) aborts
> as soon as it hits an
# [EMAIL PROTECTED] / 2005-07-23 06:04:55 -0600:
> On Sat, Jul 23, 2005 at 11:31:23AM +0200, Roman Neuhauser wrote:
> >
> > I have a VARCHAR column containing mostly ip addresses, with an
> > occasional piece of junk, and would like to transfer this data to an
> > INET column. The UPDATE (SET inet
Leonel Nunez said:
>
> I hope this helps
Leonel,
Worked perfectly...thanks. I'll do the same thing via Java for my future
use (can't guarantee Perl will be available on all of our target
machines).
I appreciate the help!
John
---(end of broadcast)-
> With the U.S. Government poised to tinker with Daylight
> Saving Time, I have a couple questions.
>
> 0) Does PG rely on system-level TZ info or will specific
> updates to PG be required? I'm interested in *nix but the
> Windows folks are probably interested, too.
Pre-8.0 relies on the syst
[EMAIL PROTECTED] (Leonel Nunez) writes:
> John Wells wrote:
>
> >Guys,
> >
> >I have a number of jpegs and tiffs that are stored in a bytea field in a
> >PostgreSQL database by a Java program using Hibernate.
> >
> >I need to copy these out to a flat file via pgsql for viewing, etc. I've
> >tri
All,
I've a query:
SELECT
c.code, c.pc_no, jl.event_no, jl.order_number, jl.location, s.status,
cs.commercial_status
FROM
((codes as c JOIN job_list as jl ON c.id = jl.code_id) JOIN status as s
ON jl.event_no = s.event_no)
JOIN commercial_status AS cs on jl.event_no = cs.event_n
After some more digging I found there was an index:
CREATE INDEX job_list_status_idx
ON job_list
USING btree
(status(event_no));
I had previously created. I must have changed the function from IMMUTABLE
to STABLE after creating the index or I assume I wouldn't have been able to
create th
Hi,
Does anyone have a Solaris 10 SMF script for managing a postgres install?
Mark
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hi
Im new to postgres and I have just installed version 8.0.3. I used
darwinports on os x (10.4.2)... Having looked in the manual to start
the server:
$ postmaster -D /pgsql/data
Im not sure where i can find this data folder I have searched but
dont seem to have one...
Also, are there d
I don't know, OS x; on linux the local directory is
/usr/local/pgsql/data for 8.0 version, and used to be
/var/lib/pgsql/data on older versions for linux redhat.
You should have the default superuser account postgres and the
database
template1 (don't change it, just login and create you own o
Thanks Roberto,
I found a dev aritcle at apple explaining it... you have to create
the dir... So ive done that and im all up and running.
Thanks
Eoghan
On 23 Jul 2005, at 18:54, Ropel wrote:
I don't know, OS x; on linux the local directory is /usr/local/
pgsql/data for 8.0 version, and used
Unsubscribe
If I'm using Tsearch2 to search a public online forum, do you think
it's okay to update on every forum entry?
Put another way: is to_tsvector() resource intensive when used in this
way?
---(end of broadcast)---
TIP 6: explain analyze is your
I've password protected the 'postgres' account (to enable secure remote
access) and I don't want to store the password on the local file system.
I therefore want to create a separate account for use by pg_autovacuum
(locked down in pg_hba.conf and perhaps with a password). What are the
minimum set
On Sat, Jul 23, 2005 at 02:37:42PM -0400, Matthew Terenzio wrote:
> If I'm using Tsearch2 to search a public online forum, do you think
> it's okay to update on every forum entry?
>
> Put another way: is to_tsvector() resource intensive when used in this
> way?
Depends on the update rate, I su
What is the influence on database growing in comparrison to permanent table
frequently inserted/deleted rows ?
- Original Message -
From: "Sean Davis" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc: "pgsql list"
Sent: Friday, July 22, 2005 8:06 PM
Subject: Re: [GENERAL]
What is the influence on database growing in comparrison to permanent
table frequently inserted/deleted rows ?
The tables are dropped automatically after the connection is closed. The
database doesn't grow because of temporary tables. As for comparison to a
frequently inserted/deleted ta
Peter Fein wrote:
> I've password protected the 'postgres' account (to enable secure remote
> access) and I don't want to store the password on the local file system.
> I therefore want to create a separate account for use by pg_autovacuum
> (locked down in pg_hba.conf and perhaps with a password).
Quoth [EMAIL PROTECTED] (Alex Stapleton):
> On 21 Jul 2005, at 17:02, Scott Marlowe wrote:
>
>> On Thu, 2005-07-21 at 02:43, vinita bansal wrote:
>>
>>> Hi,
>>>
>>> My application is database intensive. I am using 4 processes since
>>> I have 4
>>> processeors on my box. There are times when all th
On Sat, Jul 23, 2005 at 06:43:20PM -0500, Peter Fein wrote:
> I suppose this issue will go away when autovacuum is integrated into the
> server itself in 8.1?
Yes, it already did.
--
Alvaro Herrera ()
"Hoy es el primer día del resto de mi vida"
---(end of broadcast)
If I'm using Tsearch2 to search a public online forum, do you think
it's okay to update on every forum entry?
Put another way: is to_tsvector() resource intensive when used in this
way?
---(end of broadcast)---
TIP 1: if posting/reading through
22 matches
Mail list logo
