Igor <[EMAIL PROTECTED]> writes:
> Help me please to resolve my problem.
Postgres version?
regards, tom lane
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregiste
Hi,
Help me please to resolve my problem. It is during vacuuming
database .I resolved it last time in such a way: pg_dump and
psql -e dbhttp://www.postgresql.org/search.mpl
> datname datdbaencodingdatpath
>
> courses 26 7 courses
Hum. Look ok to me.
> I have tested with LATIN1 - LATIN5 and I haven't got any result...
> I'd need the Spanish 'ñ' (that is what I insert)...
> Maybe I
John Coers <[EMAIL PROTECTED]> writes:
> I am trying to figure out what is slowing down multiple concurrent COPY
> commands to my database and all I see is lots of semops.
Are you talking about concurrent copies into the same table? That would
suffer a lot of short-term lock interference, no dou
What mode of locking is associated with a COPY to the database?
Is it a RowExclusiveLock and since it is brand new data, there should
be no conflicts?
I am trying to figure out what is slowing down multiple concurrent COPY
commands to my database and all I see is lots of semops. CPU usage,
disk
In article <08CD1781F85AD4118E0800A0C9B8580B094A74@NEZU>, "Jeff Eckermann"
<[EMAIL PROTECTED]> wrote:
> Also:
> * Watch out for embedded tabs and carriage returns in your data: these
> will cause problems during or after your COPY into PostgreSQL. * Check
> the value used in the exported
On Wed, 9 May 2001, Bruce Momjian wrote:
>
> Where do people want this. Should it be in /contrib or on its own web
> page?
This is already linked on the related page.
> I have an Xbase conversion utility too. Where should that go?
What's the URL?
>
>
> > Hi,
> >
> > As I previous searched a
Also:
* Watch out for embedded tabs and carriage returns in your data: these
will cause problems during or after your COPY into PostgreSQL.
* Check the value used in the exported file to represent NULL values
(could be an empty string, or "NULL", or something else), and use that in
you
Add on on ora2pg.
Table grant extraction is done. It is based on group/users grants.
Oracle has ROLES that I understand as groups and users associated to
these roles. So I create a group for each role and alter it by adding the
users.
And then set grants to each tables.
Let me now if I have to
--- "Ryan C. Bonham" <[EMAIL PROTECTED]> wrote:
> My question is what is the best way to import my data from MS
> SQL. I
> installed the ODBC Drivers and tried exporting using the MS
> import/export
> tool.. It successfully creates the tables, but fails to import
> any data,
> with a error stating
I see no reason why a second SERIAL column would be needed. As in the
example for creating tbl_c, when you have a SERIAL as a primary key,
the foreign keys that reference it should be int4 not SERIAL.
jeff
Jeff Daugherty
Database Systems Engineer
Great Bridge LLC
will trillich wrote:
> On
On Sun, May 06, 2001 at 02:59:31AM +0200, Morten Primdahl wrote:
> > \d tbl_c_id_seq
> >
> > if it is not there, you can create it yourself
>
> Thanks, the sequence was not there. Just puzzled me that
> when creating tbl_c, I get:
>
> test=# CREATE TABLE tbl_c
> (id SERIAL PRIMARY KEY,
> da
Hello,
I just wanted to end my day with a big THANK YOU to all the developpers.
I upgraded from 7.1RC4 to 7.1.1 today and it went without a hich!!! In
all the server was down for about 30 minutes the time to check out the
different locale, multibyte and encoding issues that had been troubling
me
Hi,
i am new to concepts of SQL and postgresql. For tutorial purpose i wrote a
little quotes database with columns:
name, quote, timestamp
a php html page should show every day another quote of the day. it works fine
and like this:
selecting a row with timestamp = today
if there is no row se
I have a table with 5,000 rows in it. I also have a query that returns
about 950 rows, but I only want items 50-60 from that match.
What I want to show the user is
- the total # of matches (950)
- the 10 rows that I want
The following works, but can it be reduced to a
Hi,
As I previous searched a tool to convert Oracle database to PostgreSQL
and really found nothing, there's now a piece of perl code I've written
that
can become a great tool to do this job.
It currently extract the database schema table definition of an Oracle
database
and output a sql script
On Wed, 9 May 2001, Christian Marschalek wrote:
> Can it be that I cannot reference to any inherited columns? Or is there
> a special way to do it? The manual doesn't seem to cover this one...
Well, if you mean reference a subtable's copy of an inherited column,
you should be able to do this as
Hi,
I am looking at PostgreSQL as an alternative to Microsoft SQL. I have a
database I would like to move to PostgreSQL to test how long it will take to
move files, how to best change our software to access Postgre, etc.. I have
PostgreSQL setup on a Test machine running Redhat 7.1. I have Postgr
> But I haven't found pg_controldata on my platform.
> Is it installed with Postgresql 7.1 RPM for Redhat 7.0 ?
Dunno. It's part of our contrib stuff. I thought there would be an RPM
for the contrib stuff for 7.1, but maybe not, or maybe you didn't
install that RPM.
If you don't have it, just
You're right !
LC_ALL=C explain the difference.
But I haven't found pg_controldata on my platform.
Is it installed with Postgresql 7.1 RPM for Redhat 7.0 ?
Thank's for your help
regards
- Original Message -
From: Tom Lane <[EMAIL PROTECTED]>
To: Michaël Fiey <[EMAIL PROTECTED]>
Sent:
Thanks for your help... Inheritance seem to be useless to me now ;)
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Can it be that I cannot reference to any inherited columns? Or is there
a special way to do it? The manual doesn't seem to cover this one...
Thx Chris
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
datname datdbaencodingdatpath
courses 26 7 courses
I have tested with LATIN1 - LATIN5 and I haven't got any result...
I'd need the Spanish 'ñ' (that is what I insert)...
Maybe I need to insert this character i
> I have defined a database with the encoding SQL_ASCII. I fill the
> database by using embedded SQL. When I insert the value "Señales", it is
> correctly inserted. I read the correct value by typing the query in
> postgres, but when I access this database from a Java program, via JDBC,
> I ob
At 11:10 AM 5/9/01 +0200, DaVinci wrote:
>On Wed, May 09, 2001 at 10:31:27AM +0200, Renaud Thonnart wrote:
>> How can I delete them in keeping integrity in the database?
>
> drop index?...
Dropping the index will not maintain the PK integrity...
http://www.ca.postgresql.org/users-lounge/docs/7.1
Hello,
I have defined a database with the encoding SQL_ASCII. I fill the
database by using embedded SQL. When I insert the value "Señales", it is
correctly inserted. I read the correct value by typing the query in
postgres, but when I access this database from a Java program, via JDBC,
I obta
Thank you for your explaination, David !
Renaud THONNART
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Wed, May 09, 2001 at 10:31:27AM +0200, Renaud Thonnart wrote:
> Does PostgreSQL create an index when a table is created?
Yes, with PK.
> Does it create index even if there is no PK for this table?
No.
> I know that indexes increase performance for SELECT but it is the
> contrary when IN
28 matches
Mail list logo
