"Anton Pikhteryev" <[EMAIL PROTECTED]> writes:
> There is that part and doesn't have any errors:
> CREATE TABLE clap_file_info (
> fileid integer DEFAULT
> nextval('public.clap_file_info_fileid_seq'::text) NOT NULL,
> filename text NOT NULL,
> created timestamp with time zone DEFAULT ('
Zoomby Woof <[EMAIL PROTECTED]> writes:
> I'm using slony1 version 1.2.1 and I'm trying to figure out what the
> actual default of the 'sync_interval' parameter is. The manual says
> 100 ms in one place, and 10 seconds on another...some other places on
> the net says 60 seconds, I have even seen 2
There is that part and doesn't have any errors:
CREATE TABLE clap_file_info (
fileid integer DEFAULT
nextval('public.clap_file_info_fileid_seq'::text) NOT NULL,
filename text NOT NULL,
created timestamp with time zone DEFAULT ('now'::text)::timestamp(6)
with time zone NOT NULL,
"ow
unsubscribe
-
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta).
Probalo ya!
"Anton Pikhteryev" <[EMAIL PROTECTED]> writes:
> COPY clap_file_info (fileid, filename, created, "owner") FROM stdin;
> ERROR: type "char" is not a domain
> CONTEXT: COPY clap_file_info, line 1, column owner: "mfgtest"
You have removed the parts of the dump that show the creation of
this table.
I was following migration document
http://www.postgresql.org/docs/8.2/interactive/migration.html and hit
the problem I can't solve.
Basically my goal is to migrate data from 8.0.3 to 8.2.3
The error I am getting is:
ERROR: type "char" is not a domain
Doing:
pg_dumpall -p 5432 | psql -d postg
-
Finding fabulous fares is fun.
Let Yahoo! FareChase search your favorite travel sites to find flight and hotel
bargains.
---(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
On Fri, 16 Mar 2007, Jeff Frost wrote:
On Fri, 16 Mar 2007, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
... Interestingly, when you
strace the backend, it doesn't appear to be doing too much...here's some
sample output:
select(0, NULL, NULL, NULL, {0, 1000}) = 0 (Timeout)
semop
On Fri, 16 Mar 2007, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
... Interestingly, when you
strace the backend, it doesn't appear to be doing too much...here's some
sample output:
select(0, NULL, NULL, NULL, {0, 1000}) = 0 (Timeout)
semop(3932217, 0x7fbfffd150, 1) = 0
se
Jeff Frost <[EMAIL PROTECTED]> writes:
> ... Interestingly, when you
> strace the backend, it doesn't appear to be doing too much...here's some
> sample output:
> select(0, NULL, NULL, NULL, {0, 1000}) = 0 (Timeout)
> semop(3932217, 0x7fbfffd150, 1) = 0
> semop(3932217, 0x7fbfffd150, 1)
Everything else except the one postmaster process hum along just fine. I.e.
nothing else appears to take much system resources at all. Autovac is set with
the 8.2.x default settings. Oh, and the data was ANALYZE'd after it got moved
to the new server. Here's the code in case we have something
Adam Radlowski wrote:
> gunartha.nyoman napisał(a):
>> hi,
>> I am new comer in this millis...
>> i have a poblem, how to add a field/column in existing table without
>> oids.
>> if i create new table i can add field oids
More important, you shouldn't be doing this. OIDs are not for user
consumpt
gunartha.nyoman napisał(a):
hi,
I am new comer in this millis...
i have a poblem, how to add a field/column in existing table without oids.
if i create new table i can add field oids
Thank alot before
regrads
Nyoman/bali
So - create a new table with this same structure, but with oids, copy
Are the stat collector and autovacuum processes in good shape?
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 3/16/07, Jeff Frost <[EMAIL PROTECTED]> wrote:
I've got a client that has a function in a db which had been humming along
quite nicely on 2xOpteron 275, PG 8.1.5, 8GB of RAM. No
I've got a client that has a function in a db which had been humming along
quite nicely on 2xOpteron 275, PG 8.1.5, 8GB of RAM. Now suddenly many of the
functions in the DB if called will spike the CPU to 100%. These are functions
that used to finish in 7ms, now run for 20-40 mins. Interestin
16 matches
Mail list logo