Re: [SQL] lock row in table

perfectly... error handling works correctly :-) so I am waiting for an answer for my question how check that the rekord is currently edited, Greetings, Daniel > > >*** REPLY SEPARATOR *** > >On 2003-08-28 at 17:42 Yudha Setiawan wrote: > >Of course I can lo

Re: [SQL] COUNT

> "Brian" == Brian C Doyle <[EMAIL PROTECTED]> writes: Brian> Hello, You will need to do "SELECT count(attribute) FROM Brian> table;" or SELECT count(table.attribute);" You need to watch this: acspg=# create table tst ( acspg(# a integer acspg(# ); CREATE acspg=# insert into tst v

[SQL] except on nulls?

led too, giving the following error: ERROR: Unable to identify an operator '<>' for types '_text' and '_text' You will have to retype this query using an explicit cast Any idea why this is happening? Daniel

[SQL] Date Format

In MS Access is: SELECT FORMAT([field],'DD/MM/') AS new name; How I can make in pgaccess? Daniel Hentges Automação Fockink In. Eletricas Ltda. Panambi - RS - Brasil

Re: [SQL] now() with microsecond granulity needed

> "Radoslaw" == Radoslaw Stachowiak <[EMAIL PROTECTED]> writes: Radoslaw> *** Tom Lane <[EMAIL PROTECTED]> [Tuesday, Radoslaw> 20.February.2001, 11:57 -0500]: >> > using now() to init TIMESTAMP fields I got resolution of one >> second. How > can I define DEFAULT in column (TIM

[SQL] sum(bool)?

> "Olaf" == Olaf Zanger <[EMAIL PROTECTED]> writes: Olaf> hi there i'd like to add up the "true" values of a Olaf> comparison like Olaf> sum(a>b) Olaf> it just doesn't work like this Olaf> any workaround Try using a case statement: select sum(case when a > b then 1 e

[SQL] Help with 'now', now(), timestamp 'now', ...

> "edipoelder" == edipoelder <[EMAIL PROTECTED]> writes: edipoelder> times. Then I changed the function and run, at id = edipoelder> 14. Change again at id = 15. Where is underlined edipoelder> (), i tried to put, 'now', timestamp 'now', etc, edipoelder> and always

[SQL] Recursive select

> "Martin" == Martin Smetak <[EMAIL PROTECTED]> writes: Martin> Hi all! Anyone know if it's possible to make a recursive Martin> select from a table ? My problem: I got a table of "some Martin> categories" which all points to its parrent Martin> one(tree)...shown below. And

[SQL] "no wait" option for locks

t row is processed. The second task waits until the first hast commited, but it should detect the lock and continue work with next row. How can i detect this lock? Oracle returns with "no wait" option an sql error code. Any hints? best regards Daniel Stuewe

[SQL] "no wait" in locks

t row is processed. The second task waits until the first hast commited, but it should detect the lock and continue work with next row. How can i detect this lock? Oracle returns with "no wait" option an sql error code. Any hints? best regards Daniel Stuewe

[SQL] "no wait" in locks

t row is processed. The second task waits until the first hast commited, but it should detect the lock and continue work with next row. How can i detect this lock? Oracle returns with "no wait" option an sql error code. Any hints? best regard Daniel Stuewe

[SQL] fumbling for join syntax

hi- i have two tables which are used to track questions and answers in a trivia game. the structure of the tables is as follows: CREATE TABLE triv_q_r ( id VARCHAR(10) CONSTRAINT triv_q_r_pkey PRIMARY KEY, t_idVARCHAR(10) CONSTRAINT triv_q_r_t_id_fkey N

Re: [SQL] Alter table

I think 7.3 has this feature. Daniel ""Rachel.Vaudron"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:Pine.LNX.4.33.0211080811160.12232-10@;lazaret.unice.fr... > Hi, > > I wonder if it is possible to remove a field of a table ? > I haven't f

Re: [SQL] Inherancing

ROM ONLY cities -> you will get only cities who aren't centers. Daniel. "Nasair Junior da Silva" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi people, > supposing i have the tables : > > create table cities (

Re: [SQL] "function has no parameter $1" - help.

In > 7.3 you can also CREATE OR REPLACE FUNCTION xxx() RETURNS TRIGGER AS' BEGIN END'LANGUAGE plpgsql; ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] Fw:

Your ipc-daemon-version is to old. Download the newest version first. (1.13) Daniel ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[SQL] Atomicity of UPDATE, interchanging values in unique column

ACID-compliant? Doesn't MVCC require this anyway? Thanks for your time, Daniel Alvarez <[EMAIL PROTECTED]> -- +++ GMX - Mail, Messaging & more http://www.gmx.net +++ Bitte lächeln! Fotogalerie online mit GMX ohne eigene Homepage!

Re: [SQL] Atomicity of UPDATE, interchanging values in unique column

ots of work... OK. The long-term goal would then be to get rid of such oddities. But what can I do right now as a user to solve that issue for my application? There must be a better solution than the additional dummy update. Any ideas? Daniel Alvarez Arribas <[EMAIL PROTECTED]> -- +++ GMX

[SQL] lock row in table

ction can I use?   Please help me, Maybe someone have similar problem? Greetings, Daniel  

[SQL] Get x from point?

Hi all, I am wondering if we are able to extract the x-coordinate from a point-type attribute with SQL. I have been looking for this sort of functions from documents and websites but it seems the function does not exist. Or, any altnernate to do so? regards, Daniel Lau Hong Kong University of

[SQL] Get x from path/polygon?

in advance. regards, Daniel Lau On Mon, 22 Dec 2003, Michael Fuhr wrote: > On Mon, Dec 22, 2003 at 04:54:01PM +0800, Daniel Lau wrote: > > I am wondering if we are able to extract the x-coordinate from a > > point-type attribute with SQL. I have been looking for this sort of >

[SQL] Type conversion from TEXT to DOUBLE PRECISION

to CAST TEXT as CHAR[5]. It also doesnt allow me to do so. Can anyone give me some hints on this? regards, Daniel ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [SQL] Type conversion from TEXT to DOUBLE PRECISION

use to carry out the SQL: UPDATE _table SET _bbb = to_number(substring(_aaa from 1 for 5), '9') WHERE _aaa <> ' '; I guess a function checking if a string contains only numbers would be betteroff. But I find no such functions. Checking that it's not blank would be the only solution I can think of. Thanks again. regards, Daniel Lau ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[SQL] Login information in system tables

Hi, I was wondering if it is possible to query the sytem tables to get an overview of user logins in psql. I've searched the documentation but I can't find a system table that stores login information, but I might have overlooked something... With regards, Danie

Re: [SQL] [PHP] Secure DB Systems - How to

earches using a hash or encrypted value. You can also perform regex searches. Here is an example to get you started: CREATE TABLE crypto ( id SERIAL PRIMARY KEY, title VARCHAR(50), crypted_contentBYTEA ); INSERT INTO crypto VALUES (1,'test1',encrypt_

Re: [SQL] [PHP] Secure DB Systems - How to

able to get the log-file of postgresql. So one would also have to make attention that the information like sql statements don't leak that way. Are there other places where this kind of information could leak? Greetings, Daniel Struck -- Retrovirology Laboratory Luxembourg Centre Hospitalie

[SQL] Storing properties in a logical way.

Hello everybody, In a database there is a table with items, and each item can have 0 to n properties. The objective is to store information about items' properties in a mentioned database in a logical and an efficient way. Usually it is easily done by creating a validation table with a list of poss

Re: [SQL] Storing properties in a logical way.

to also set a parent property - which is probably implementable by using triggers). Though I would prefer, if it is possible, something much simpler, because there are only about 10 properties and 2 'composite' properties - it would probably be an overkill to create a tree for such a small

[SQL] predicate locking

s in all SELECT statements in a transaction " So does MSSQL (SQL Server) implement predicate locking? Regards, Daniel Roth MCSD.NET Tom Lane wrote: > Florian Weimer <[EMAIL PROTECTED]> writes: > > Is this a bug, or is SQLxx serializability defined in different terms? > &g

Re: [SQL] predicate locking

All I am trying to do is correct the help documentation - 12.2.2.1 "so far as we are aware no other production DBMS does either." Regards, Daniel Roth On 6/12/05, Tom Lane <[EMAIL PROTECTED]> wrote: > Daniel Roth <[EMAIL PROTECTED]> writes: > > But MSSQL (SQL Server) d

[SQL] int to date

d be able to produce hexa dump of it like above... Daniel ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[SQL] table listing queries

d no way of doing this in PgSQL. Is there a way, or is postgres not letting me list the tables until I have connected to the database for security reasons? Thanks in advance, D. -- Daniel Silverstone http://www.digital-scurf.org/ PGP mail accepted and encouraged.

[SQL] Multi-row update w. plpgsql function

someone help this novice from getting ulcers? Thanks for your help! Daniel ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [SQL] Multi-row update w. plpgsql function

UPDATE message_table SET status = 'A' WHERE mid IN ($query_values_here); Again, thanks for the help, Daniel ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[SQL] Executing plpgsql scripts using psql, is that possible?

= RegisterMyObject('a string', 'another string') EXECUTE AddObjectProperty(MyObjectID, 'a string'); EXECUTE AddObjectProperty(MyObjectID, 'another string'); Any idea how I can translate such a script for psql? I mean, without creating a function that wraps

Re: [SQL] Executing plpgsql scripts using psql, is that possible?

> -Message d'origine- > De : [EMAIL PROTECTED] [mailto:pgsql-sql- > [EMAIL PROTECTED] De la part de John DeSoi > Envoyé : lundi 16 janvier 2006 08:51 > À : Daniel CAUNE > Cc : pgsql-sql@postgresql.org > Objet : Re: [SQL] Executing plpgsql scripts using psql, is

Re: [SQL] Executing plpgsql scripts using psql, is that possible?

> If you want to use plpgsql it will need to be within a function. In your > reply > you mention creating user-defined functions as part of the set up > procedure. > It would not be weird to include the static data function as part of that > procedure and then call it to load the data. I see no re

[SQL] [HELP] Defining a function as a procedure

n patch my function so that it compiles but that won’t be really nice:   CREATE OR REPLACE FUNCTION foo()   RETURNS int AS $$ BEGIN     RETURN 1; END; $$ LANGUAGE 'plpgsql';   Is there any other prettier way to do that?   Thanks,     -- Daniel  

[SQL] Function with default value?

exist! J   Thanks,     Daniel

Re: [SQL] Function with default value?

> -Message d'origine- > De : Tom Lane [mailto:[EMAIL PROTECTED] > Envoyé : dimanche 29 janvier 2006 10:48 > À : Daniel CAUNE > Cc : pgsql-sql@postgresql.org > Objet : Re: [SQL] Function with default value? > > Daniel CAUNE <[EMAIL PROTECTED]> wri

[SQL] CREATE INDEX with order clause

lly, I’m not sure that is useful; perhaps PostgreSQL handles pretty well such query using an index such as:   CREATE INDEX IDX_GSLOG_EVENT_PLAYER_EVENT_TIME_DESC   ON GSLOG_EVENT(PLAYER_USERNAME, EVENT_NAME, EVENT_DATE_CREATED);   Any idea?   -- Daniel CA

[SQL] Does PostgreSQL support job?

-scripts on Linux.   Thanks (Tom Lane J)   -- Daniel CAUNE  

Re: [SQL] Does PostgreSQL support job?

> -Message d'origine- > De : [EMAIL PROTECTED] [mailto:pgsql-sql- > [EMAIL PROTECTED] De la part de Bruce Momjian > Envoyé : mercredi, février 01, 2006 17:57 > À : Daniel Caune > Cc : pgsql-sql@postgresql.org > Objet : Re: [SQL] Does PostgreSQL support jo

Re: [SQL] Does PostgreSQL support job?

> -Message d'origine- > De : Owen Jacobson [mailto:[EMAIL PROTECTED] > Envoyé : mercredi, février 01, 2006 18:00 > À : Daniel Caune; pgsql-sql@postgresql.org > Objet : RE: [SQL] Does PostgreSQL support job? > > Daniel Caune wrote: > > Hi, > >

Re: [SQL] Does PostgreSQL support job?

> -Message d'origine- > De : [EMAIL PROTECTED] [mailto:pgsql-sql- > [EMAIL PROTECTED] De la part de Alvaro Herrera > Envoyé : mercredi 1 février 2006 19:28 > À : Daniel Caune > Cc : Owen Jacobson; pgsql-sql@postgresql.org > Objet : Re: [SQL] Does PostgreSQL supp

Re: [SQL] Does PostgreSQL support job?

> > I'm not sure to understand. Why calling a function from a script is > different from executing a series of SQL commands? I mean, I can run a > script defined as follows: > > > > SELECT myjob(); > > > > where myjob is a stored procedure such as: > > > > CREATE OR REPLACE FUNCTION myjob() > >

Re: [SQL] Does PostgreSQL support job?

> Daniel Caune wrote: > >>> I'm not sure to understand. Why calling a function from a script is > >>> different from executing a series of SQL commands? > > [snip] > >>>Does that make sense? > >>It does make sense if myjob() does

[SQL] How to force PostgreSQL using an index

Hi,   Is there a way to force PostgreSQL using an index for a SELECT statement?  I just want to confirm that the index PostgreSQL decides to use is better than the index I supposed PostgreSQL would use (I already analyze the table).   Regards,   -- Daniel CAUNE Ubisoft Online

Re: [SQL] How to force PostgreSQL using an index

> On Wed, Feb 15, 2006 at 04:58:54PM -0500, Daniel Caune wrote: > > Hi, > > > > > > > > Is there a way to force PostgreSQL using an index for a SELECT > > statement? I just want to confirm that the index PostgreSQL decides to > > use is better than

Re: [SQL] How to force PostgreSQL using an index

for experimenting > with indexing schemes, but then, so is DROP INDEX. > Yes, indeed, such a feature could be badly used. However it may happen sometimes that the planner is wrong; I already encountered such situations with both Oracle 9i and SQL Server 2000, even with statistics

Re: [SQL] How to force PostgreSQL using an index

> "Owen Jacobson" <[EMAIL PROTECTED]> writes: > > On Wed, Feb 15, 2006 at 04:58:54PM -0500, Daniel Caune wrote: > >> I see, but that doesn't explain whether it is possible to specify the > >> index to use. It seems that those options just force

Re: [SQL] How to force PostgreSQL using an index

> -Message d'origine- > De : Tom Lane [mailto:[EMAIL PROTECTED] > Envoyé : mercredi, février 15, 2006 17:47 > À : Daniel Caune > Cc : Andrew Sullivan; pgsql-sql@postgresql.org > Objet : Re: [SQL] How to force PostgreSQL using an index > > "Daniel

[SQL] Sum If

', sum(sales.count)) as "Sales Some"from ...join ...where .group by customers.custid ...Thanks in advanced, and best regards,Daniel Hernández.Tijuana, BC, México."More you learn, more you earn".Join Excite! - http://www.excite.comThe most personalized portal on the Web!

Re: [SQL] Sum If

Hi Jim,   Thanks for the tip, It worked!Thanks a lot!!!Daniel Hernández.Tijuana, BC, México."More you learn, more you earn".try select ...,sum(case when sales.itemname = 'some' then sales.count else 0 end) as "Sales Candies"from your_table_heregroup by ...

[SQL] Missing fields on Query result.

Hi Guys,   I have another question, but in this time is regarding to a query that supose to return son char fields, but they don't show up, I'm using ODBC Driver 7.03.02.00 with Delphi 6.Thanks in advanced, and regards,Daniel Hernández.Tijuana, BC, México."More you learn, more

Re: [SQL] Missing fields on Query result.

Never Mind, it's solved now,Thanx any way, regards,Daniel Hernández.Tijuana, BC, México."More you learn, more you earn". --- On Fri 02/24, Daniel Hernandez < [EMAIL PROTECTED] > wrote:From: Daniel Hernandez [mailto: [EMAIL PROTECTED]To: pgsql-sql@postgresql.orgDate: Fri,

[SQL] plsql / time statement

Hi,   Is there any option to set so that psql provides the execution time of each SQL statement executed?   Regards,   -- Daniel CAUNE Ubisoft Online Technology (514) 4090 2040 ext. 5418  

[SQL] how to add primary key to existing table with multiple primary keys

Hi there,   I am trying to add another primary key to an existing table with two other primary keys.  I got the following error when I tried this command:   alter table extprobe2tissue ADD primary key (expid); ERROR:  multiple primary keys for table "extprobe2tissue" are not allowed  

Re: [SQL] pgsql aggregate: conditional max

AS tablemaxweight WHERE table.aid = tablemaxweight.aid AND table.weight = tablemaxweight.aid; There is a limit case you don't specify how to deal with, when two or more categories have the same maximum weight. The query I wrote retrieves all the categories that

Re: [SQL] Ask a PostgreSql question (about select )

> 3 a3 5 > > 4 > > 5 > > . > > . > > . > > > > > > in PostgreSql > > > > How to wirte Statement ( Rownum -> change ??) > > PostgreSQL doesn't have the Oracle ROWNUM feature. But if you were usi

[SQL] connectby documentation

3 2 6 3 7 6 Regards, -- Daniel ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [SQL] connectby documentation

> -Message d'origine- > De : Michael Fuhr [mailto:[EMAIL PROTECTED] > Envoyé : lundi, mars 13, 2006 11:12 > À : Daniel Caune > Cc : postgresql sql list > Objet : Re: [SQL] connectby documentation > > On Mon, Mar 13, 2006 at 10:37:37AM -0500, Daniel Caune wr

Re: [SQL] connectby documentation

; :-) And you'll see, that you can install newer versions than 7.4 :-) > Sorry, this is not my day: "apt-get install postgresql-contrib-8.1" works fine... Just a link on the documentation that fully explains how connectby() works would be great! :-) Thanks, --

Re: [SQL] connectby documentation

tablefunc. > You are right. The documentation is located in /usr/share/doc/postgresql-contrib-8.1/ . Wow, that was the quest for the Holy Grail! :-) -- Daniel ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [SQL] connectby documentation

ctby | setof record | text, text, text, text, integer, text public | connectby | setof record | text, text, text, text, text, integer, text I hope that will help another PostgreSQL newbie. -- Daniel ---(end of broadcast)--- TIP 1:

Re: [SQL] connectby documentation

> -Message d'origine- > De : Michael Fuhr [mailto:[EMAIL PROTECTED] > Envoyé : lundi, mars 13, 2006 19:26 > À : Daniel Caune > Cc : [EMAIL PROTECTED]; postgresql sql list > Objet : Re: [SQL] connectby documentation > > On Mon, Mar 13, 2006 at 06:38:14PM -05

Re: [SQL] help with function

> Hello, > > I have 2 tables where each table has a column named "comments" and the > tables are related as a one to many. I want to concatenate all the > comments of the many side to the one side so I wrote the following > plpgsql function to do so. > > > CREATE OR REPLACE FUNCTION fixcomment

[SQL] Power cut and performance problem

OG: incomplete startup packet Where can I check, please? Is it more likely a hardware problem (the machine seems ok, no error detected)? Regards, -- Daniel CAUNE Ubisoft Online Technology (514) 4090 2040 ext. 5418 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [SQL] Power cut and performance problem

> I see you're running autovacuum. What's your disk subsytem look like? By > chance is it sitting on a RAID 5 that's running in degraded mode right now > while it scrubs? > Yes, that should be the problem. I will check that tomorrow morning with a Linux administrator. Thanks.

Re: [SQL] Update counter when row SELECT'd ... ?

t_url(P_Limit IN int) RETURNS SETOF table AS $$ BEGIN FOR V_Record IN SELECT * FROM table ORDER BY counter LIMIT P_Limit LOOP UPDATE table SET counter = counter + 1 WHERE name = V_Record.name /* AND url = V_Record.url */; -- if needed RETURN V_Record;

Re: [SQL] Power cut and performance problem

ole performance would be degraded when a problem occurs with RAID disks. Am I wrong? Could it be something else? Are there some tools that check the state of a PostgreSQL database? -- Daniel ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [SQL] Power cut and performance problem

the most efficient way, but it's okay because this is a data stage table. It seems that it fixes my performance problem. As you said, perhaps the problem was more related to index corruption. Truncating data and inserting new data recreate the index and therefore fix the problem. Thanks, --

[SQL] Custom type

Hi, How can I enter description for my custom types? \dT provides information such as schema, name, and description for all the registered types and custom types. I would like to provide a description for each custom type I create. Thanks, -- Daniel CAUNE Ubisoft Online Technology (514) 4090

Re: [SQL] Custom type

each custom type I create. > > > > Thanks, > > > > > > -- > > Daniel CAUNE > > Ubisoft Online Technology > > (514) 4090 2040 ext. 5418 > > > > Daniel, > > From the \h command in psql: > > rnd=# \h comment > Command: COMMENT &

[SQL] OUT parameter

, b2 OUT int) AS $$ V_b1 int; V_b2 int; BEGIN FOR (...) LOOP V_b1 = (...); V_b2 = (...); END LOOP; b1 = V_b1; b2 = V_b2; END; $$ LANGUAGE PLPGSQL; Thanks, -- Daniel CAUNE Ubisoft Online Technology (514) 4090 2040 ext. 5418

Re: [SQL] OUT parameter

support pass-by-reference > > parameters and are unlikely to start doing so. There isn't any way > > that you can affect locals of a calling procedure before you return. > > Then I've misunderstood the semantics of OUT and more importantly INOUT > parameters. Th

[SQL] Index on nullable column

Hi, Is an index on a nullable column useful for retrieving rows having that column null? SELECT PlayerID FROM PlayerLoginSession WHERE EndTime IS NULL; Regards, -- Daniel CAUNE Ubisoft Online Technology (514) 4090 2040 ext. 5418 ---(end of broadcast

Re: [SQL] Index on nullable column

index fooi on foo(f2) where f1 is null > > but it's still a very specialized index. > Thanks Tom. I will use such an index even if it's very specialized; OLAP world is somewhat full of specialized index anyway... :-) -- Daniel ---(end of broadcast)--- TIP 6: explain analyze is your friend

[SQL] Modeling trees with Nested Sets and Nested Intervals

ee, or connect by. Other resources that have been helpful: http://troels.arvin.dk/db/rdbms/links/#hierarchical http://groups.google.com/group/comp.databases.theory/msg/7b772060322df739 Maybe all this would make a good project on pgfoundry. -- Daniel Browning - Kavod Technologies. Random

[SQL] "could not open file" issue

rver 8.1.3 -- Daniel CAUNE Ubisoft Online Technology (514) 4090 2040 ext. 5418 ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [SQL] "could not open file" issue

> De : Alvaro Herrera [mailto:[EMAIL PROTECTED] > > Daniel Caune wrote: > > Hi, > > > > Is there any way to solve the following issue without dropping the > > table? > > > > select count(*) from eventplayerleaveroom; > > ERROR: could not a

Re: [SQL] "could not open file" issue

> De : Alvaro Herrera [mailto:[EMAIL PROTECTED] > > Daniel Caune wrote: > > > > > De : Alvaro Herrera [mailto:[EMAIL PROTECTED] > > > > > > Daniel Caune wrote: > > > > > > > > select count(*) from eventplayerleaveroom; &

Re: [SQL] "could not open file" issue

> De : [EMAIL PROTECTED] [mailto:pgsql-sql- > [EMAIL PROTECTED] De la part de Andrew Sullivan > > On Mon, Apr 24, 2006 at 12:17:07PM -0400, Daniel Caune wrote: > > Hi, > > > > Is there any way to solve the following issue without dropping the > > table? >

Re: [SQL] keeping last 30 entries of a log table

your method when the number of records to be deleted is huge. -- Daniel ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [SQL] keeping last 30 entries of a log table

log > > WHERE account_id = 1 > >AND id < ( > > SELECT MIN(id) > >FROM log > >WHERE account_id = 1 > >ORDER BY timestamp DESC > > LIMIT 30); > > > > I think there will be a performance difference with your me

[SQL] Documentation Generator for pl/pgsql

?   Thanks,   -- Daniel CAUNE Ubisoft Online Technology (514) 490 2040 ext. 3613  

[SQL] Constraint UNIQUE on a column not case sensitive

in MyTable. Is there better and more efficient way to do that? Regards, -- Daniel ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [SQL] Constraint UNIQUE on a column not case sensitive

> -Message d'origine- > De : Michael Glaesemann [mailto:[EMAIL PROTECTED] > Envoyé : samedi 1 juillet 2006 10:01 > À : Daniel CAUNE > Cc : pgsql-sql@postgresql.org > Objet : Re: [SQL] Constraint UNIQUE on a column not case sensitive > > > On Jul 1, 200

[SQL] Local variable and column name conflict

; For instance, Ingres suggests prefixing local variable/parameter with ":" in the query: UPDATE bar SET i = :i; I can continue using the de facto Oracle's naming convention (P_parameter and V_local_variable) anyway. That's not a big deal. Regards, -- Daniel

[SQL] Invalid memory alloc request size

earched for some similar cases in the pgsql-sql archive but nothing really similar. Any idea? Regards, P.S.: I don't have this problem on other tables containing less data. -- Daniel CAUNE Ubisoft Online Technology (514) 490 2040 ext. 3613 ---(end of broadcast)-

[SQL] Trigger, record "old" is not assigned yet

,     -- Daniel CAUNE Ubisoft Online Technology (514) 490 2040 ext. 3613  

[SQL] PostgreSQL server terminated by signal 11

dy dropped the table, inserted data, and tried to create all the indexes.  The server systematically crashed when creating some specific indexes.  The only idea I have for the moment would be to setup another machine with the same database environment.  Other idea(s)?   Thanks     -- Daniel CAUNE Ubisoft Online Technology (514) 490 2040 ext. 3613  

Re: [SQL] PostgreSQL server terminated by signal 11

> De : Tom Lane [mailto:[EMAIL PROTECTED] > Envoyé : jeudi, juillet 27, 2006 16:06 > À : Daniel Caune > Cc : pgsql-sql@postgresql.org > Objet : Re: [SQL] PostgreSQL server terminated by signal 11 > > "Daniel Caune" <[EMAIL PROTECTED]> writes: > > My Post

Re: [SQL] PostgreSQL server terminated by signal 11

> -Message d'origine- > De : Tom Lane [mailto:[EMAIL PROTECTED] > Envoyé : jeudi, juillet 27, 2006 16:06 > À : Daniel Caune > Cc : pgsql-sql@postgresql.org > Objet : Re: [SQL] PostgreSQL server terminated by signal 11 > > "Daniel Caune" <[E

Re: [SQL] PostgreSQL server terminated by signal 11

> -Message d'origine- > De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > De la part de Tom Lane > Envoyé : jeudi 27 juillet 2006 19:26 > À : Daniel Caune > Cc : pgsql-admin@postgresql.org; pgsql-sql@postgresql.org > Objet : Re: [SQL] PostgreSQL server terminated

Re: [SQL] PostgreSQL server terminated by signal 11

> -Message d'origine- > De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > De la part de D'Arcy J.M. Cain > Envoyé : jeudi 27 juillet 2006 19:49 > À : Daniel Caune > Cc : [EMAIL PROTECTED]; pgsql-admin@postgresql.org; pgsql- > [EMAIL PROTECTED] > O

Re: [SQL] PostgreSQL server terminated by signal 11

> -Message d'origine- > De : Tom Lane [mailto:[EMAIL PROTECTED] > Envoyé : jeudi, juillet 27, 2006 19:26 > À : Daniel Caune > Cc : pgsql-admin@postgresql.org; pgsql-sql@postgresql.org > Objet : Re: [SQL] PostgreSQL server terminated by signal 11 > > &qu

Re: [SQL] PostgreSQL server terminated by signal 11

> De : Tom Lane [mailto:[EMAIL PROTECTED] > Envoyé : vendredi, juillet 28, 2006 09:38 > À : Daniel Caune > Cc : pgsql-admin@postgresql.org; pgsql-sql@postgresql.org > Objet : Re: [SQL] PostgreSQL server terminated by signal 11 > > "Daniel Caune" <[EMAIL PROTEC

[SQL] Recording how a table is used

I'm trying to record the results of a select statement into a separate table. I need the information selected, the column it was stored in, the table it was stored in, and the query that selected it. Everything I've read so far says that triggers can't trigger from select statements, and they don

[SQL] Remove my e-mail

Hi!, I don't want to receive more emails from postgresql. Please remove my email from your delivery list. Thanks -- Daniel Guedes

  1   2   >