RE: [GENERAL] Strange reference problem

OK, I see. The REFERENCES clause added to a column definition is a short cut if you only have one column as the foreign key, similar to the PRIMARY KEY clause, which you can add to a single column, but if you want a multi-column primary key, then you have to do it at the end. Thanks, Tom.

[GENERAL] Re: GET DIAGNOSTICS SELECT PROCESSED INTO int4_variable

On Thu, Jan 18, 2001 at 22:30:48 +1300, Dan Langille wrote: When will 7.1 leave beta (roughly)? From what I've been reading on the lists, "soon". I suspect within the next month or two. How stable is it? FWIW, I'll be using it for development, not production I've not tested it extensively

[GENERAL] Re: Errors compiling 7.0.3 on Solaris 7

El Mi 17 Ene 2001 15:49, Gareth Cantrell escribi: Hi: I've been trying in vain for over 5 hours now to compile PostgreSQL 7.0.3 on Solaris 7 (2.7). I keep getting the following error: ld -G -o libpq++.so.3.1 pgconnection.o pgdatabase.o pgtransdb.o pgcursordb.o pglobject.o

Re: [GENERAL] Re: JDBC Performance

Bruce Momjian [EMAIL PROTECTED] writes: Can you confirm that it is OK now? Your email from October 18th below seems to indicate it is not correct. Can I get a diff against the current CVS source that I can apply? Thanks. Sorry for the confusion. It wasn't okay before I left to Kenya on

Re: [GENERAL] Re: postgresql.conf ignored

On Wed, Jan 17, 2001 at 11:46:11PM -0500, Lamar Owen wrote: Have you added the required lines to /etc/syslog.conf? (Yes, I know I haven't thoroughly documented that. Working on it.). It _is_ documented in the archives -- do a search on '/etc/syslog.conf'. Ah, no I hadn't, thanks. I'd

[GENERAL] RE: Why is there so much MySQL bashing???

Agree 100% -Original Message- From: Philip Hallstrom [mailto:[EMAIL PROTECTED]] Sent: 17 January 2001 10:05 To: PostgreSQL General Subject: Why is there so much MySQL bashing??? What are my impressions going to be of PostgreSQL (and now Great Bridge since their name will pop up as

[GENERAL] nested table

Hi I'm sure it has been already discused milion times but i can't find it from list archives. Whats the syntax for inserting and quering tables with nested tables. For example: CREATE TABLEfoo (attr1 int2, attr2 int2); CREATE TABLE foo1 (idint4, name text,attr1 foo); Now, how can i

[GENERAL] referential integrity

Title: referential integrity Please could someone help me my database does not have referential integrity. I want to be able to delete a primary key in one table and for it to delete anything relating to it below ( same with update). i.e table product primary key product_name table

[GENERAL] View table relationship

Hi. I have a big problem with postgres because I need to know how I can see the relations among the table like foreign-key. It' s possible use some commands or graphic tool from wich I can see that relations? Do you know some sites where i can found more information about this! Thank you very

[GENERAL] permissions on user-defined functions

I am new to PostgreSQL... I've created a table (table1) and database user (dbuser). dbuser has only SELECT permission on table1. Next I created a function insert_table1 that inserts a new row into table1. I want to give dbuser the ability to invoke the insert_table1 function without granting

[GENERAL] Query question

How can I make query SELECT * FROM my_table WHERE my_field = 'A*'; Meaning that I want to get all rows from my_table where my_field value begins with alphabet "A"

RE: [GENERAL] Query question

SELECT * FROM my_table WHERE my_field LIKE 'A%'; Should do it! -Original Message- From: Jorch [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 5:40 PM To: [EMAIL PROTECTED] Subject: [GENERAL] Query question How can I make query SELECT * FROM my_table WHERE my_field

[GENERAL] Re: Query question

SELECT * FROM my_table WHERE my_field LIKE 'A%'; Greg - Original Message - From: "Jorch" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 16, 2001 12:39 PM Subject: Query question How can I make query SELECT * FROM my_table WHERE my_field = 'A*'; Meaning that I

[GENERAL] RE: Why is there so much MySQL bashing???

That can't be good for PostgreSQL, can it? Neither can not being able to do rpm -Uvh and have it work first time... Nor not finding a Dreamweaver Ultradev database connection for Postgresql in the live data menu when there is a Mysql one... Nor not being able to find somewhere to get a

[GENERAL] Tuning queries and distinct behaviour

Is there a way to tune queries? I'm doing queries that join around 5-6 tables. All join fields are indexed either in hash (where tables are small enough and join is done on "="), or btree (big tables, not joined on "="). The tables have between several hundred and several tens of millions of

Re: [GENERAL] RE: Why is there so much MySQL bashing???

Tony Grant wrote: That can't be good for PostgreSQL, can it? Neither can not being able to do rpm -Uvh and have it work first time... H... When was the last time you tried? Thanks to the 'Do No Harm' principle, it would be foolhardy to do what has to be done to upgrade between

Re: [GENERAL] RE: Why is there so much MySQL bashing???

On 2001.01.18 17:31:29 +0100 Lamar Owen wrote: Tony Grant wrote: That can't be good for PostgreSQL, can it? Neither can not being able to do rpm -Uvh and have it work first time... H... When was the last time you tried? Yesterday... The RedHat 6.2 rpms are broken if

Re: [GENERAL] nested table

"Peeter Smitt" wrote: I'm sure it has been already discused milion times but i can't find it from= list archives. Whats the syntax for inserting and quering tables with nested tables. For example: CREATE TABLE foo (attr1 int2, attr2 int2); CREATE TABLE foo1 (id int4, name

Re: [GENERAL] referential integrity

"Michelle Anderson" wrote: I get a message to screen that says NOTICE: CREATE TABLE/FOREIGN KEY clause ignored; not yet implemented You need to upgrade to PostgreSQL 7.0.3; referential inegrity is not implemented in 6.5.3 and earlier. -- Oliver Elphick

[GENERAL] Another optimizer question

I am not sure if this is a bug, an oversight or something else entirely, but it would appear that if there are two tables, Table1 and Table2, which are joined using INNER JOIN, specifying WHERE = one of the join fields doesn't automatically get equalised to the other field. For example: SELECT

Re: [GENERAL] Tuning queries and distinct behaviour

On Thu, 18 Jan 2001, Gordan Bobic wrote: Is there a way to tune queries? I'm doing queries that join around 5-6 tables. All join fields are indexed either in hash (where tables are small enough and join is done on "="), or btree (big tables, not joined on "="). The tables have between

Re: [GENERAL] Re: JDBC Performance

Thanks you so much. I am sorry for the mixup. We will get it in there ASAP when it arrives. Bruce Momjian [EMAIL PROTECTED] writes: Can you confirm that it is OK now? Your email from October 18th below seems to indicate it is not correct. Can I get a diff against the current CVS

[GENERAL] Re: View tables relationship

Have you tried PGAdmin? You can use this graphical tool from windows. It's very good and it's also free! "riccardo" [EMAIL PROTECTED] wrote in message news:941d3q$fqm$[EMAIL PROTECTED]... Hi. I have a big problem with postgres because I need to know how I can see the relations among the table

[GENERAL] consistency check ?

Hi to all, I am considering to use PostgreSQL. But I need some more information about some features: Is there a consistency check? Online or Offline? Thanks Toni

[GENERAL] Troubles with performances

Hi, I use PostGreSQL with a Web server which receive 200 HTTP simultaneous queries. For each HTTP query, I have about 5 SELECT queries and 3 UPDATE ones. Queries have been optimized, I have INDEX on my tables... The biggest table has more than 500 000 records. And I have big troubles,

[GENERAL] Re: Query question

select * from my_table where my_field like 'A%'; "Jorch" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... How can I make query SELECT * FROM my_table WHERE my_field = 'A*'; Meaning that I want to get all rows from my_table where my_field value begins with

[GENERAL] initdb failing

Hello, I am going throught the pains of initdb failing again. I know that usually this is a permissions problem but can't remember how I fixed it 18 months ago (yes we should all have a notebook to document such things...) I had a working 6.5.x on RedHat 6.2 and (stupidly) decided to upgrade to

[GENERAL] ltsWriteBlock: failed to write block xxx of temporary file

I have a database and a table with 7 records (which i dont think it's too much) I join this table with another of about the same size and put a record restriction (WHERE) and everything works out fine, but when I put two SUMs over a couple of fields and add a GROUP BY I keep getting this

Re: [GENERAL] Re: MySQL file system

On Wed, Jan 17, 2001 at 02:21:01PM +0100, Fausto Guzzetti wrote: Hello, I have what I think is a trivial problem. But I wasn't able to find a solution in the FAQ or in the docs I have. It has to do with case sensitivity. I am working with an application of PostrreSQL (7.02) and PHP4.

Re: [GENERAL] character sets

hi all, Does postgres support other character sets? We've been thinking in porting an application to chinesse, but we don't know if it's possible to store chinesse characters in postgres I don't know what kind of Chinese are talking about, but PostgreSQL does support both tradional Chinese

Re: [GENERAL] initdb doesn not create template1 database

"mike" [EMAIL PROTECTED] writes: Tom thanks for the heads up on the bug earlier, thngs worked much better ui= ng the currnet snapshot, though fomr some reason initdb seems to do its job= though its not creating database template1. That's an interesting definition of "doing its job" :-(. How

[GENERAL] Re: Query question

SELECT * FROM my_table WHERE my_field LIKE 'A%'; --rob - Original Message - From: "Jorch" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 16, 2001 12:39 PM Subject: Query question How can I make query SELECT * FROM my_table WHERE my_field = 'A*'; Meaning that I

Re: [GENERAL] Performance of a single (big) select and Multiprocessor Machines

Konstantinos Agouros [EMAIL PROTECTED] writes: Is there a way in postgres to make use of the extra cpu(s) the machine has for the single tasks of importing the data and doing the somewhat intensive selects that result from the sheer amount of data. Maybe I'm missing something, but it seems

Re: [GENERAL] Problems building 7.1beta3 on WinNT under cygwin

Barry Lind [EMAIL PROTECTED] writes: dllwrap -o plpgsql.dll --dllname plpgsql.dll --def plpgsql.def pl_parse.o pl_handler.o pl_comp.o pl_exec.o pl_funcs.o ../../../../src/utils/dllinit.o -L/usr/local/lib -L/usr/local/lib -L../../../../src/backend -lpostgres -lcygipc -lcygwin -lcrypt

Re: [GENERAL] child table doesn't inherit PRIMARY KEY?

Does this bug still exist? [ Charset ISO-8859-1 unsupported, converting... ] Louis-David Mitterrand writes: When creating a child (through CREATE TABLE ... INHERIT (parent)) it seems the child gets all of the parent's contraints _except_ its PRIMARY KEY. Is this normal? It's kind of

[GENERAL] Re: Help with query. (*)

Read the docs on "exists" that should be what you are looking for. --rob - Original Message - From: "Diehl, Jeffrey" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: "Diehl, Jeffrey" [EMAIL PROTECTED] Sent: Tuesday, January 16, 2001 3:42 PM Subject: Help with query. (*)