Re: [GENERAL] Questions about indexes

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

[GENERAL] Charset and encoding

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

Re: [GENERAL] Questions about indexes

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...

Re: [GENERAL] Charset and encoding

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 obtain

Re: [GENERAL] Charset and encoding

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

RE: [GENERAL] Inheritance and Referencing troubles... (confusing problem)

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

Re: [GENERAL] Case sensitive order by

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:

Re: [GENERAL] Case sensitive order by

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

[GENERAL] MS SQL 7.0 to PostgreSQL 7.1

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

Re: [GENERAL] No reference to inherited columns?

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

[GENERAL] Oracle to Pg tool

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

[GENERAL] Getting a total hit number and a LIMIT number at the same time

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

[GENERAL] updating rows while selecting

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

[GENERAL] more-than-one-SERIAL column per table

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, data

Re: [GENERAL] more-than-one-SERIAL column per table

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

Re: [GENERAL] MS SQL 7.0 to PostgreSQL 7.1

--- 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 that the

Re: [GENERAL] Oracle to Pg tool

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

RE: [GENERAL] MS SQL 7.0 to PostgreSQL 7.1

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 your

[GENERAL] RE: MS SQL 7.0 to PostgreSQL 7.1

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 file to

[GENERAL] COPY locking

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,

Re: [GENERAL] COPY locking

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 doubt,

Re: [GENERAL] Charset and encoding

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 need

[GENERAL] Vacuudb problem

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 dbdb.archiv. But after some days it appeared again. Here is messages : NOTICE: mdopen: couldn't open pg_temp.2297.4: No such file or directory NOTICE:

Re: [GENERAL] Vacuudb problem

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 unregister

[GENERAL] Moving to 7.1.1

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

Re: [GENERAL] Oracle to Pg tool

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 tool to