PostgreSQL Database Forum

I have several tables with common FKs.. the problem occurs when performing a large number of inserts on any of the tables at the same time. The first to start inserting seems to get a lock on the referenced FK tables and doesn't release them until its done, forcing the other apps to just wait... and wait..since they also seem to want a lock...

Hello. I want to query pg_stat_activity to see the current_query field. I do: mdbs=# select current_user; current_user -------------- postgres (1 row)

Hi all, Given a stored procedure that runs entirely within the database (e.g. loop through a few rows of table A, apply "some function" and create a few rows in table B) - I am wondering what the performance benefits are of implementing such a function in C using the SPI vs plpgsql. Obviously if "some function" is fairly involved then...

Hi There is question. How can I set column varchar (array) as UNIQUE (constraint)? (I need this to set foreign key, but for this to work varchar must be primary key or unique). I use pgadmin, and pgadmin answer: "Error: data type character varying has no default operator class for access method "btree". You must specify an operator class...

Hi all: Let's say I'm designing a database (Postgres 7.3) with a list of all email accounts in a certain server: CREATE TABLE emails ( clienteid INT4, direccion VARCHAR(512) PRIMARY KEY, login varchar(128) NOT NULL,

Hi! Has anyone tried exporting a database in foxpro to PostgreSql ver7.1 ? If yes, did you encounter any problems ? I need to get this info so I could make plans on how to migrate my databaseto PostgreSql ver7.1. Thank you.

Hi there, I was in troubles with a UPDATE+IN statement: The following command use to take about 5 minutes to be done: UPDATE requisicao SET conclusao='3' WHERE reg IN (SELECT reg FROM requisicao WHERE now()-data>'15 days');

Dear Sir: We have created a table with a column of composite type. how can we insert values in this table. for exemple: create table aa (a int); create tabel bb (b aa); how to insert data into bb?? Thank you!

I'm having severe performance issues with a conceptually simple database. The database has one table, containing weather observations. The table currently has about 13.5 million rows, and is being updated constantly. (The database is running on a dual 550MHz PIII with 512MB RAM. I have PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC...

Hello, I would like to ask the about the following... PostgreSQL allows tables resulting from subselects to be renamed with an optional AS keyword whereas Oracle 9 will report an error whenever a table is renamed with the AS keyword. Furthermore, in PostgreSQL when the result of a subselect is referenced in an outer select it is required...

hi, i have a table with test_field of type "TEXT". when i do: select test_field from test where id=1; the connection (with psql) hangs and no output is received, so i have to kill psql. this occurs, at first sight, if length(test_field)>32748.

Hi! Where can I find examples to accesing postgres with perl. TIA _________________________________________________________________ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.yupimsn.com/ ---------------------------(end of broadcast)---------------------------

Well, bought a new disk to my Powerbook yesterday and reinstalled Mac OS X. I'm in the middle of restoring everything now, and need to know where the database files where located. I thougt /usr/local/pgsql/data would be the appropriate place, but can't find anything there that makes sense… Regards, Victor

Hi all Can I make something linke: IF EXISTS(company_id_seq) DROP SEQUENCE company_id_seq; in a DDL where i creates all my tables? /Henrik

I haven't used PostgreSQL for nearly a year now, and when I was last using it there was some discussion on versioning control being introduced as a feature. Basically, for some data, I'd like to keep track of who changed it, when, and to what. I know I could include multiple values in the schema, and have a view to pull out the most recent,...

Hi, WHen i run pg_dumpall as the super user it asks for a password for every database. I don't know my users passwords. Is there a way to make the super user able to backup without passwords ? Thanks. Jeff.

Hi, I have a test system that is setup the same as a production system and would like to frequently copy the database over. pg_dump takes a few hours and even sometimes hangs. Are there any reasons not to simply just copy the entire data directory over to the test system? I could not find any postings on the net suggesting otherwise. Is...

List, Which of the may Perl Modules on CPAN should I use for PostgreSQL. I'd prefer the fastest/most up to date module. Which is it or do I have to dig through them all? David Busby Systems Engineer busby@pnts.com

Hi all! I want to create a table: user_id: bigserial user_name: text user_company: text password: text How do I build this table so that user_name+user_company must be unique?

I'm having severe performance issues with a conceptually simple database. The database has one table, containing weather observations. The table currently has about 13.5 million rows, and is being updated constantly. The database is running on a dual 550MHz PIII with 512MB RAM. On the whole, queries are of the form: SELECT ? FROM obs...

Hi, I'm very fresh to PostgreSQL, coming from Oracle. I want to developp web applications based on apache and postgresql. Is there an equivalent of OWA server (Oracle Web Application server) for postgresql. Shortly, OWA provides an apache module and a set of stored procedures/functions that generate html pages. A simple example could be...

v7.2.2 When an insert fails because its in violation of an index (duplicate), I get a return code 7 (PGSQL_FATAL_ERROR) in my php 4.2.3 interface. Its not really a fatal error, is it? Shouldn't it be reported as a NONFATAL_ERROR ? I have a "dumb" synchronizing task, that attempts to import a daily cumulative batch of records, relying...

I was scanning hackers - is there further info on the (possible) issues with bigint indexes and vacuuming (disk bandwidth?)? Thanks, CSN __________________________________ Do you Yahoo!? Exclusive Video Premiere - Britney Spears

Good morning, I have a contact who is looking to speak with up to five (5) individuals regarding: open-source DBMS, end users who are using PostgreSQL in applications that they are using to run their business and ISVs who have based their applications on PostgreSQL. If you are interested, please contact me off-list with the category you...