[GENERAL] Tr: CHECK CONSTRAINT

-Message d'origine- De : Stéphane FILLON <[EMAIL PROTECTED]> À : pgsql sql <[EMAIL PROTECTED]>; pgsql admin <[EMAIL PROTECTED]> Date : dimanche 1 août 1999 18:15 Objet : CHECK CONSTRAINT >I have 2 tables ART and MTF as follow: > >create table art( >artidint4 primary key, >mtfidi

[GENERAL] Tr: Cache lookup failed with FUNCTION + TRIGGER

-Message d'origine- De : Stéphane FILLON <[EMAIL PROTECTED]> À : pgsql sql <[EMAIL PROTECTED]>; pgsql admin <[EMAIL PROTECTED]> Date : mercredi 4 août 1999 14:21 Objet : Cache lookup failed with FUNCTION + TRIGGER >I have one table client : > >create table client( > nocli int4, >

[GENERAL] Tr: DUMP database for sample

-Message d'origine- De : Stéphane FILLON <[EMAIL PROTECTED]> À : [EMAIL PROTECTED] <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date : dimanche 1 août 1999 09:13 Objet : Tr: DUMP database for sample > > >>Hi ! >> >>I am trying a big commercial database application with Pos

[GENERAL] Tr: UNIQUE

-Message d'origine- De : Stéphane FILLON <[EMAIL PROTECTED]> À : [EMAIL PROTECTED] <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date : dimanche 1 août 1999 09:12 Objet : Tr: UNIQUE >>Hi ! >> >>I have a table with a primary key id to have a unique tuple and >> >>I want to c

[GENERAL] Tr: DOMAIN DEFINITION

>Hi again, > >I would like to know how we can define a new domain definition (type). > >I explain what I want: > >I would like to create a type 'address' as char(10) and use address when I >define a type in my database. > > >

[GENERAL] Selecting duplicates

Somehow, I've managed to get duplicate entries in my soon-to-be primary key field. How can I select for duplicates in a field? I know how to select for blank and NULL, but duplicates escape me. Thanks, Gary ** * Gary B. Hoff

Re: [GENERAL] Two questions about join performance

Well maybe now is a good time to take a look at your design and see why you have to do this. There just happens to be a number of great DBAs on this list as well. :-) Rudy On 6 Aug 99, at 2:14, Roberto Moreda wrote: > Sorry for being so reiterative :) > > The planifier isn't perfect for many q

[GENERAL] Two questions about join performance

Sorry for being so reiterative :) The planifier isn't perfect for many queries... Is there any way (without touch C code) to tell explicitly the plan of a query to Postgres? How can I manage the problem of select a few rows with a boolean atribute when they are 5 rows in a table of 10 rows?

[GENERAL] table does not exist

Hello, I have installed postgresql version 6.4.2 on a Red Hat Linux 6.0 box. I have it up and running. I have used pgaccess to create some tables, and enter some data into them, but when i run a query I get the following message: : Table does not exist. my table name is COMPANIES I am using

[GENERAL] eqsel ?

I'm digging into obtain the way to explicit the use of index in a where clause and I found that the proc eqsel can help me... ? Any clue? TIA Roberto -- Roberto Moreda Resp. Dpto. Informática Handem/San Luis Tlf +34 981 779000 Fax +34 981 779022 Pol. Piadela Sur, Autovía A6 Sal.567 1

Re: [GENERAL] Slow joins

On Thu, 5 Aug 1999, Roberto Moreda wrote: Have you vacuumed? Can you post your actual explain? BTW, I would strongly encourage you to use boolean for this. I've seen tables that used CHAR for such things and code that had to check for one of the following values: yYtT1 or nNfF

[GENERAL] Slow joins

I have a speed problem with a query that involves 3 tables. I focused the problem in a scan in a big table (7 rows) using a indexed field. The field is a "flag" field which values only can be 'Y' or 'N'. In the query I look for the values 'N' (average value = 10 rows over the 7). Postgres

Re: [GENERAL] Problem with pgaccess

"Christopher A. Stewart" wrote: > Héctor Morales wrote: > > > Thanks for the command xhost the problem terminate. > > > > Now when i run pgaccess result: > > Error in startup script: coudn't load file "libpgtcl.so": > > /usr/lib/libpgtcl.so: undefined symbol: crypt > > while executing "load libpg

Re: [GENERAL] "group, by", problem, when, combined, with, "insert, into"

On Thu, Aug 05, 1999 at 01:19:10PM -0400, Brett W. McCoy wrote: > On Wed, 4 Aug 1999, sam smith wrote: > > > select loser,count(*) from moves group by loser; > > > > but when i combine it with an insert into - > > insert into losses select loser,count(*) from moves group by loser; > > > > I get

Re: [GENERAL] "group, by", problem, when, combined, with, "insert, into"

I believe previous versions actually allowed you to (if memory serves), but the developers currently disabled this statement because it could sometimes cause incorrect results. At: http://www.postgresql.org/docs/todo.html you'll find several references to this problem: * -INSERT ... SELECT

Re: [GENERAL] "group, by", problem, when, combined, with, "insert, into"

On Wed, 4 Aug 1999, sam smith wrote: > select loser,count(*) from moves group by loser; > > but when i combine it with an insert into - > insert into losses select loser,count(*) from moves group by loser; > > I get > ERROR: Illegal use of aggregates or non-group column in target list I think