PostgreSQL Database Forum

hi, I work on a tool that generates a creat script for an existing table. My problem is to find out if a column is a constraint. For example, I have the following creat script create table abc( xyz serial primary key ) The metadata say that xyz is an int4 and not nullable.

Hi , i'm doing the planification of the courses in a university. I have definned the following tables: 1- Table DAY representing a day (day_id,year,month ...) 2- Table PERIODE representing an hour of a day (periode_id,starting,ending,periode_number) 3- Table TEACHER representing a teacher (teacher_id,name,phone,address ...) 4- Table ROOM...

Hello Anyone have theses? Regards Agostinho Sousa cpis@sapo.pt

> Yes, the mod_auth_pgsql series for Apache 2 is broken as you > describe. It does not release the connection, but the change > is intentional. Looking at the Changelog I see: > > - now we reuse database connection, 2x speedup !! > > Perhaps this is a good thing with different MPMs, but the > standard prefork module can exhaust the...

Howdy: Running PostgreSQL 7.3.3 on RedHat Linux 7.2 I'm trying to load data from a text file that has an odd character in it (^@). From what I could tell, it's a NULL character. How can I load that into the database via the command line? I've done the following:

Hi everybody, i need a free tutorial on database design can any help ?? thx --------------------------------- Do you Yahoo!? The New Yahoo! Shopping - with improved product search

Hi All, Is it possible to insert n rows with 1 or 2 invalid rows using copy command. I used it, it rollbacks everything even if 1 row gets an error. Is their any other way to do it. TIA -- regards, Deepa K.

Anyone got links to good db server boxes, not rackmount though? Include any for HP, Gateway, etc. -- "You are behaving like a man", is an insult from some women, a compliment from a good woman.

There are a bunch of these in PG's log: ERROR: Invalid page header in block 14 of start_items_key What does it mean? PG seems to be working fine - anything I need to fix/adjust/worry about? TIA, CSN

On Mon, 2003-08-25 at 16:28, Gregory S. Williamson wrote: > One of our sysads sent this link ... wondering if there is any comment on it from the world of actual users of linux and a database. > > <http://story.news.yahoo.com/news?tmpl=story&cid=1738&ncid=738&e=9&u=/zd/20030825/tc_zd/55311> "Weak points include lack of available tools, ease...

Hi All, I'm in the process of moving a rather complicated plpgsql stored procedure to a C module and I'm curious about how to implement the for each row syntax in C. My understanding is that if you perform an SPI_exec whilst looping through the results of another exec the allocated SPITupleTable will be automatically unallocated. Is this...

Hi, I have a table, where one of the columns "extradata" is a gob of XML. I'd like to be able to create an index on this function.. so i tried this CREATE INDEX actitemsXML_idx ON act_items (pgxml_xpath(extradata,'//RequestInfo/refund_id/text()','',''));

As your new PostgreSQL "Master of Ceremonies", I will be posting occasional opportunities for speakers and presenters. In an effort to ensure quick placement for these positions, I would like to endeavour to create a database of available individuals --and remember, we need people from all parts of the globe! If you fancy yourself the...

Hi, I use pg_restore to load a previously dumped database. (10mil records). the load of the data runs quite fast but when starting creating the triggers for foreign keys it takes forever. Isnt there are a faster way. after all the triggers in the source db already made sure the data was clean. Thanks Alex

Hi, I have a table, where one of the columns "extradata" is a gob of XML. I'd like to be able to create an index on this function.. so i tried this CREATE INDEX actitemsXML_idx ON act_items (pgxml_xpath(extradata,'//RequestInfo/refund_id/text()','',''));

First i want to say that i just subscribed to this mailing list and this is my first post. :) im new to postgresql and i installed it recently on linux redhat 9 system following the instructions from administrators tutorial. then i attempted to create "my first database" following the instructions from tutorial, but i get this message: ...

> Hello > > I have a problem, I want to migrate the data of a postgres' database to a > mysql's database, this because i need to move to a windows. > > I tried making a postgres' backup using pg_dump, but this file doesn't have > the insert in Transac-sql. > > Any help is welcome

Hello, I am in the process to define if our product can use PostgreSQL. Do you know what type of application use PostgreSQL, and also what is the size of the database for these projects? Our application has a table with more than 300000 rows. There are complexe query with many joins. And we must respect some time constraints. Also the...

I'm working on some TRIGGERS and functions, and say that when a function is called from a trigger it sets some nice variables like TG_RELNAME, but there is no variable with the name of the schma. Will this change in 7.4? -- 10:17:01 up 3 days, 19:54, 3 users, load average: 0.43, 0.46, 0.50...

Hello, I want to know if in PostgreSQL, there is a command equivalent to START WITH... CONNECT BY from Orcale? This command is used to traverse a tree. Thank you, Jean-Marc _________________________________________________________________

If you want to see the upcoming release PostgreSQL 7.4 speak your favorite language, you are invited to contribute to the translation of the message strings in PostgreSQL. After the latest beta release of PostgreSQL (7.4 beta 4), a string freeze has been called, which means that the developers will from now on try to avoid changing any...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I guess I'm not the first asking this, however googling gave no results. Is it possible to insert a row based on a rowtype variable ? Thx UC

Are there any books out there that are fairly current, but go into the more advanced aspects of Postgresql, such as internals and advanced programming? I'd rather avoid the whole intro to SQL with a few extra chapters on Postgresql if I could help it. Thanks, John

Hi, I notices a weird thing here. version 7.2.1 on Solaris table "test", has a field "state". There are 4 "state" values, 1, 2, 3, 4.