that answered my question.
Thanks everyone
Patrick Hatcher
Development Manager Analytics/MIO
Macys.com
Michael Fuhr
<[EMAIL PROTEC
Would I gain any advantage by changing to it to fire after the insert?
thanks again for the help
Patrick Hatcher
Development Manager Analytics/MIO
Macys.com
415-422-1610
Doug McNaught
ELSE
NEW.cost :=0;
NEW.owned :=0;
END IF;
RETURN NEW;
END;'
LANGUAGE 'plpgsql' VOLATILE;
Patrick Hatcher
Development Manager Analytics/MIO
Macys.com
415-422-1610
Doug McNaught
ently
about 12M.
TIA
Patrick Hatcher
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
large db, the the backup takes only 3.5hrs
The other than using the schema switch, there is no compression happening
on either dump.
Any ideas why this might be happening or where we can check for issues?
TIA
Patrick Hatcher
Development Manager Analytics/MIO
Macy
Thank you.
"select * From information_schema.columns where table_schema = 'public' and
table_name = 'mdc_products'
order by ordinal_position;"
Thanks again.
Patrick Hatcher
I need to generate a data dictionary for all my tables (name, column,
type, etc) in my database. Is there an easy to do this without having to
do a \d tablename for each table?
tia
Patrick
---(end of broadcast)---
TIP 3: Have you checked our ex
Pg 7.4.5
I'm running an update statement on about 2 million records using the
following query:
Update table_A
set F1 = b.new_data
from table_B b
where b.keyfield = table_A.keyfield
both keyfields are indexed, yet this job has been running over 3 hours. Is
this normal?
thanks
Pa
Thank you. I'll take a look at our data export function.
Tom Lane wrote:
Patrick Hatcher <[EMAIL PROTECTED]> writes:
We're testing moving our data to UNICODE from LATIN1, but when I try to
import my data, I get the following error:
DBD::Pg::st execute failed:
uot;Lladró
"Ducks in
a Basket""
What encoding should I be using for characters like this? I thought
unicode was supposed to handle these types of characters?
TIA
Patrick Hatcher
---(end of broadcast)---
TIP 7: don't forget t
We're testing moving our data to UNICODE from LATIN1, but when I try to import my data, I get the following error: DBD::Pg::st execute failed: ERROR: Unicode characters greater than or equal to0x1 are not supportedCONTEXT: COPY bcp_mdc_products, line 120, column description: "Lladró "Ducks in
runcated 64 to 64 pages
DETAIL: CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: analyzing "public.kst"
INFO: "kst": 64 pages, 919 rows sampled, 919 estimated total rows
VACUUM
# - Free Space Map -
max_fsm_pages = 300 # min max_fsm_relations*16, 6 bytes
.
Does this make a difference?
Tom Lane wrote:
Patrick Hatcher <[EMAIL PROTECTED]> writes:
Curious: Why would a DELETE FROM tablename work while a pg_dump is
occurring but a TRUNCATE tablename will stay in a lock state until the
pg_dump is complete?
TRUNCATE requires an exclusive lock
Pg 7.4.5
Curious: Why would a DELETE FROM tablename work while a pg_dump is
occurring but a TRUNCATE tablename will stay in a lock state until the
pg_dump is complete?
About 60% of our tables are refreshed daily from our Filemaker database
and we don't care if one or more of these tables are e
Will do thanks. I ended up dropping and recreating the index and that
seems to have fixed the problem.
Patrick Hatcher
Tom Lane
16560
mode | ShareUpdateExclusiveLock
granted | t
TIA
Patrick Hatcher
Thanks Alvaro. That was what I was looking
for.
Patrick Hatcher
Alvaro Herrera <[EMAIL PROTECTED]>
11/04/04 03:40 PM
To
"Thomas F.O'Connell"
<[EMAIL PROTECTED]>
cc
Patrick Hatcher <[EMAIL PROTECTED]>,
[EMAIL PROTECTED]
Subject
Re: [GENERAL]
How can I view and edit a function in
psql? I have been using PgAdmin to do this but wanted to try the
command line
TIA
Patrick Hatcher
;Year', CURRENT_DATE)
-date_part('Year', SOMEDATE)) * 12 +date_part('Month', CURRENT_DATE)-date_part('Month',SOMEDATE)
TIA
Patrick Hatcher
thank you. I thought it was correct
but just wanted to make sure.
Patrick Hatcher
Macys.Com
Tom Lane <[EMAIL PROTECTED]>
10/08/04 11:34 AM
To
Patrick Hatcher <[EMAIL PROTECTED]>
cc
[EMAIL PROTECTED]
Subject
Re: [GENERAL] Explain output
question
Patrick Hat
g (cost=0.00..1469685.99 rows=26921450
width=46)
Filter: (((fed_div)::text = 'MCE'::text) OR ((fed_div)::text
= 'MCW'::text) OR ((fed_div)::text = 'BUR'::text) OR ((fed_div)::text =
'BON'::text) OR ((fed_div)::text = 'RLG'::text))
TIA
Patrick Hatcher
Macys.Com
I'm about to update a server that is currently using 7.4.1 to 7.4.3. I see
that in the instructions for upgrading to 7.4.2 from 7.4.1 it said to
either do a dump or follow a set of special instructions. Should I still
follow these instruction when I upgrade?
TIA
Patrick Hatcher
Macy
to update any data within the
grid, I get the same error as the above. Everything works fine if I try to
SELECT, UPDATE, or DELETE.
Any ideas?
Patrick Hatcher
Macys.Com
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Thanks that did itPatrick Hatcher-Martin Marques <[EMAIL PROTECTED]> wrote: -To: "Patrick Hatcher" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]From: Martin Marques <[EMAIL PROTECTED]>Date: 2003-11-22 03:08PMSubject: Re: [GENERAL] error loading shared libraries: libpq.
directory exists.
However, if I do a find for this file, I find it in my PG directory:
/usr/local/postgresql7.4/lib
I'm not sure what to do now. Any suggestions?
TIA
Patrick Hatcher
---(end of broadcast)---
TIP 7: don't forget to inc
ut issue
Patrick Hatcher
Macys.Com
Legacy Integration Developer
415-422-1610 office
HatcherPT - AIM
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
to export only schema X from the database?
TIA
Patrick Hatcher
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
I'll assume you are on a Windows box. The answer is yes, you can use Excel
to pull back data from a Pg database on a Linux box.
If you are planning to use MS Query and If you don't have MS Query
installed, you will need to install from the disk.
You can download the Pg ODBC driver from the Pg site
Ah there in lies the problem. I have my database encoding set to LATIN1
and I have this value stored in my table and can even write SQL to search
against it:
select *
from mdc_products
where description ~* '?'
Patrick Hatcher
Macys.Com
Legacy Integration Developer
415-422-1610 office
able1 USING btree to_char(field2, 'MM-DD-');
but I get an error message error at or new to_char
TIA
Patrick Hatcher
Macys.Com
Legacy Integration Developer
415-422-1610 office
HatcherPT - AIM
---(end of broadcast)---
TIP 5: Have you checke
/bash
TIA
Patrick Hatcher
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
ion on how to remove this table? I thought maybe going through
Pg Class, but I'm terrified of mucking something else up.
TIA
Patrick Hatcher
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
32 matches
Mail list logo
