[GENERAL] COPY failure

Hi. I'm trying to run a script that executes multiple \copy commands in order to import some 5 GB of data. All the input files are computer generated, simple (5 numeric columns and "\N" for NULL in some cases), use default delimiters, and _should_ be error free. But I keep getting error messag

[GENERAL] Postgre and XML

Hi, I´m interested in running xml with postgre. I use postgre version 8.2 and windows xp. I would like to know how can i enable the xml in the postgresql. Did you know if its secure to use this xml function of postgre in commercial applications? How much trustable its this module? Can anyo

Re: [GENERAL] Postgre and XML

rote: > > Am Montag, 19. November 2007 schrieb x asasaxax: > > >I?m interested in running xml with postgre. I use postgre version > 8.2 > > > and windows xp. I would like to know how can i enable the xml in the > > > postgresql. > > > > That depends o

[GENERAL] Transaction problem

Hi everyone, I would like to know how can i do a simple transaction for this situation: I have n products in certain row of a table. When the user buys a product, the quantity of this product will be decreased. The user can only buy a product that has a quantity n > 0. This means that when the

Re: [GENERAL] Transaction problem

Its just use a constraint then? there´s no problem id two sessions decrease the number, and this number goes to less then or equals as zero? I´m programming with php. Thanks 2007/12/3, Cesar Alvarez <[EMAIL PROTECTED]>: > > What are you programing with?. > are you using npgsql? > > Regards Cesa

[GENERAL] Problems with acessing xml functions on other database

Hi everyone, I had the folowing problem: when i try to execute a xml_string function on a database 'a' it works, but when i try this in database 'b' it doesen´t works. Did anyone knows what its going on? Is that some kind of permission? Thanks a lot

[GENERAL] XML path function

) How can i select all element5 that have element3 with attribute name="x"? Thanks very much. :)

Re: [GENERAL] XML path function

My Postgre version its the 8.2. I´ve reached to do the path i wanted, but when i do a explain analyze on the select it return 500 miliseconds. Is this a good search? Is there a way to slow down this time with postgre 8.3? What is a good time for xml xpath´s? Thanks 2008/1/8, x asasaxax <[EM

Re: [GENERAL] XML path function

Can you tell me, in how much time did the query will take with indexes + tsearch2? How much time take a satisfactory query? Can you show me some examples with tsearch2 and xml indexes? Thanks

[GENERAL] Satisfactory Query Time

Hi, I have a query that takes 0.450 ms. Its a xml query. Is that a good time for a query? If a have multiple connections on the database, will this time makes my db slow? How much time is good for a xml query? Thanks

[GENERAL] Primary Key with serial

Hi, I have the following tablecreate table product(cod serial, user_cod bigint, constraint product_fk Foreign Key(user_cod) references user(cod), constraint product_pk Primary Key(cod, user_cod)); What i want to happend is that: user_codcod 1 1 1

Re: [GENERAL] Primary Key with serial

can anyone do a example for me.. an explain how it works? Thanks a lot 2008/3/29, Berend Tober <[EMAIL PROTECTED]>: > > x asasaxax wrote: > >I have the following tablecreate table product(cod serial, > user_cod > > bigint, constraint product_fk Foreign Key(

Re: [GENERAL] Primary Key with serial the solution?

d to use a sequence anymore. Is that correct? Thanks you all. 2008/3/31, x asasaxax <[EMAIL PROTECTED]>: > > can anyone do a example for me.. an explain how it works? > > Thanks a lot > > > 2008/3/29, Berend Tober <[EMAIL PROTECTED]>: > > > > x asasax

[GENERAL] Primary Key with auto increment field

I would like to increment one field, depending of the value of the other. here´s an example: id variable 1 1 2 1 1 2 2 2 can i do that with the following commands? SELECT setval('sequence',(SELECT max(id) FROM table)) INTO variable; insert into table values(variable, ...,

[GENERAL] SQL error

HI everyone, I´m trying to capture all the possible errors that a statement can have. And, if there´s any error i will do a rollback; What i´m trying to do its: BEGIN insert into temp values(1, 2, 3); IF ANY_ERROR_OCCURED THEN ROLLBACK; RETURN FALSE; END IF; END; Did anyone knows

[GENERAL] Problems with postgresql 8.3 installation

Hi, I´m using windows vista 64 bits. And i tried to install the postgresql 8.3, but it show this error: "cannot run initdb 1!". I don´t know whats going on... help-me please Thanks

[GENERAL] appending items to record variable

Hi all In plpgsql, is there a way to append rows to a record variable? Each time a query like SELECT mycolumn INTO myrecordvariable FROM ... is executed, myrecordvariable seems to be reseted and previous entries are lost. What I want to do is collect values throughout several conditionals and th

[GENERAL] Table X its full, what can i do now?

Hi everyone, I have the following sql script: CREATE SEQUENCE "public"."teste_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 32767 START 1 CACHE 1 CYCLE; CREATE TABLE "public"."teste" ( "id" SMALLINT DEFAULT nextval('teste_seq'::regclass) NOT NULL, CONSTRAINT "id_pk" PRIMARY KEY("id") )

[GENERAL] Update tsvector trigger

Hi, i´m trying to do a trigger that its called when update or insert, that update the tsvectors, for text-search. Here´s my code: create table x( cod serial, texto text, vectors tsvector, constraint pk primary key(cod) ); CREATE OR REPLACE FUNCTION atualiza_vectors() RETURNS trigger AS

[GENERAL] Doubt on query

Hi everyone, I have this table: create table cat( cod integer, cod_super integer, constraint cod_super_fk Foreign Key(cod_super) references cat(cod), constraint cod_pk Primary Key(cod) ); insert into cat values(0, 1); insert into cat values(1, 0); insert into cat values(2, 0); insert into

[GENERAL] Multiple querys

Hi everyone, I have multiple query´s, and i´m trying to optimize my queries by creating a temporary table x(contains the field id_product). The queries that utilize the temp table x, must use the order of the rows at x. My problem: I have a query that do a limit and offset on table x. I

[GENERAL] Problem with sql

Hi everyone, I have two tables: table_1: product_code, atualization_date table_2: id, date, value I need to get the value of table 2 that has the greatest date that is minor that atualization_date. The select should return something like that: unique product_code´s, with their atualization_d

[GENERAL] Problem with selecting the first day of the the week

Hi, I need a function to select the first day of the week. For example giving today´s date(29/10/2008). Can anyone help´s me? Thanks!

[GENERAL] Re: "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records)

this message : there is no parameter $1 I don't understand how we can using the parameter $1 in an sql request. Thank you for your response and sorry for my English. Geo-x -- View this message in context: http://postgresql.1045698.n5.nabble.com/OLD-myColumnNameVar-How-to-generically-access

[GENERAL] RE: [PORTS] AIX-4.2.1 binaries ? more info

Here is the exact error I got when I compiled it on my IBM PowerPC running AIX-4.2.1. ./configure --prefix=/usr/local/pgsql_6_4 --with-template=aix_42 : -- gmake -C tcop all gmake[2]: Entering directory `/usr/local/src/postgresql-6.4

RE: [GENERAL] RE: [PORTS] AIX-4.2.1 binaries ? more info. PLEASE !

all] Error 2 Thanks and still waiting for some help. Nishi > Quick question, but did you doa 'make distclean' before you various > ./configure's? > > > > On Tue, 1 Jun 1999, Kapoor, Nishikant X wrote: > > > I have used following different configura

[GENERAL] unsubscribe pgsql-genera

unsubscribe pgsql-genera