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
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
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
Thank you for your explaination, David !
Renaud THONNART
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
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
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
> 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
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
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
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
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:
> 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
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
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,
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
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,
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
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
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
--- "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
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
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
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
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
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
> 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
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
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
28 matches
Mail list logo
