PostgreSQL Database Forum

So, I'm recording the timestamp from some unix files. Any opinions as to whether it's best to use a "bigint" (which matches the file system data) or a "timestamp" (which might be easier to manipulate in the database)? TIA! Mark --

I'm looking for a better way to make use of foreign keys. Here is a sample setup: -- TESTING Foreign Keys create table mod ( mod_id int not null primary key, name varchar(32) not null default '' );

Hi everyone at the list, Some months ago i asked you some questions about 7.2 - 7.4.3 migration. Then i switched to the performance list to complain about postgres 7.2 poor performance and discussed about different ways to improbe performances. Two days ago we started our first production server 7.4.2 migration at our biggest customer, a...

Hi friends, I am loading Potsgresql in shared hard disks. The Disk cluster is shared by two nodes. The nodes can access the disks asynchronously, i.e, the node coming up first gets disk. I have loaded the postgresql in local disk of one node and issued initdb command to put the datapath in shared disk and then created database. Right now...

Hello ! Why can't I update data when I use a VIEW instead of a TABLE ? How can I do similar action ? Thanks. Luc

Hello, I have a backup make with pg_dump and I want to restore only a table definition. I run pg_restore -s -t table_name ./backup_file > script.sql and it runs ok but in the script generated there aren't any alter table statment. So, I haven't primary key, and foreign keys in the script. Is this correct? Thanks in advance,

Hi, In my database, I created a lot of tables before I found out about schemas. It's a mess! Suppose I want to get organised, and create a couple of schemas. How do I move existing tables into my newly created schemas? e.g.

Hi, I am having trouble checking the existence of a temporary table. Neither of pg_tables or pg_class list the temporary tables. Is there any way to get the list of temporary tables? Thanks, Vikas

This question may seem trivial but how do I rebuild a database with the wal logs? ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Hi, I've been running postgres on my server for over a year now and the tables have become huge. I have 3 tables that have data over 10GB each and these tables are read very very frequently. In fact, heavy searches on these tables are expected every 2 to 3 minutes. This unfortunately gives a very poor response time to the end user and so...

"Chris Gamache" <cgg007@yahoo.com> wrote: > When I reload and attempt to access the database I find this > in the logs: > > ERROR: cache lookup failed for function 75769893 You should be OK as long as you have the dump file. If you haven't modifed any of the tsearch2 pg_ts_* tables, try and load tsearch2.sql first before loading the...

Is there a spec/posting somewhere that more or less reflects how tablespaces are supposed to work in 7.5? I've found a lot of info on it by searching the archives, but I haven't found the posting that describes the basic functionality. Thanks. - DAP ====================================================== David Parker Tazz Networks ...

Hi, I've asked this question a couple of times before on this forum but no one seems to be nice enough to point me to the right direction or help me out with any information, if possible. Please help me out with this because this is a very serious issue for me and I need to learn more about this. And here it is again: I've been running...

I have 2 questions. 1. What is the best way to back up a production box running Postgres nightly? 2. I thought the best way was to create a script that would use pg_dump to create a dump every night and then use restore if I need to. I did this but I am having a problem. Apparently there were a few Primary key Big

I have 2 questions. 1. What is the best way to back up a production box running Postgres nightly? 2. I thought the best way was to create a script that would use pg_dump to create a dump every night and then use restore if I need to. I did this but

Hi all, I've a Java application using postgresql-7.4.3. I'd like to not allow same user open 2 concurrent database sessions, because multiple sessions one user always cause trouble. how to do it ?? Thanks. Elie Nacache

Hi, I want to get some information on monitoring database activity for tuning. What are the tables which store performance related details. Is there any table for open cursors etc.. rgds Antony Paul ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an...

Hello, I created a plpgsql function which returns a table filled up with the items of an array. It works well, but if the array size exceed 10000 items, the query is too slow. This is my function: create or replace function dati.prova(text) returns setof integer as ' declare ids parole.vettori.id_testi%type; ar_low integer;

Dear my friends... I am using SuSE Linux 9.1 and postgres. I am a beginner in postgres, usually I use MySQL. I have 3 tables : appointment, appointment0 and appointment1. the fields of table "appointment" are as follows: noapp* (int4):ID Number of appointment (PK)

Dear my friends... I am using postgres 7.4 and SuSE 9.1. I want to use auto_increment as on MySQL. I look up the documentation on www.postgres.com and I found "serial" . But I don't know how to create auto_increment. here is my try:

Hello. This section works fine: CREATE TABLE torder ( id INT8 NOT NULL PRIMARY KEY ); CREATE TABLE torder_row ( id INT8 NOT NULL PRIMARY KEY,

hello, I am attempting to convert a oracle database to postgresql and I am having some problems creating a constraint across multiple columns which are a mixture of case insensitive and case sensitive. The original oracle database created an index with: CREATE UNIQUE INDEX hatidx ON hats (upper(name), upper(server), login); However...

i've found it about you ----------- Trend GateLock ¯f¬r¨¾Å@³qª¾ (¥D¾÷¡Ghigp5.gatelock.com.tw) ** ¤¤¬rÀÉ®× misc.zip ¤w§R°£¡C --------------------------------------------------------- ----------- Trend GateLock ¯f¬r¨¾Å@³qª¾ (¥D¾÷¡Ghigp5.gatelock.com.tw)

Hi Postgressers! I really like Postgres. Thanks for all your work on it. I just have a problem with the way it's handling my flat file's timestamp columns. I have a flat file with a column with dates formatted like this: 2004-04-15 18:04:26 PM It's a bit strange, I know, but I didn't create the file. My idea of Postgres's proper...

hi people, i have been trying to connect to the database using php. but i am not able to do so .i am getting the following errors *Warning*: pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user "jay" . in */var/www/proj/psql_results.php* on line *37*