PostgreSQL Database Forum

I am building a photo album webpage and am not sure exactly how I should organize the database. Here's where Im at so far... I have one table called 'images' which contains the columns 'albumID', 'url', 'title', and 'description'. Then another table called 'albums' which contains the column 'name'. The part where I am having the most...

Hi, I'm using pgadmin III for administrating the pgsql-databases. I heard about pgaccess, people are telling me it is the couterpart of ms-access for pgsql. Is this true? Is the pgsql supporting the pgaccess project? Marc ---------------------------(end of broadcast)---------------------------

Hi all. I am using Visual FoxPro via ODBC to update records on a 7.3.4 PostgreSql server and it appears that it always uses delete/insert instead of updating the current record. Can this be changed to update the existing record instead? -- Eugene Vital Any technology indistinguishable from magic is insufficiently advanced.

Hi, I'm in the process of converting an Oracle database into postgresql. One thing I've noticed is that postgresql functions keep the entire function body in a string, e.g.: CREATE OR REPLACE FUNCTION f_do_something(varchar, numeric, varchar) RETURNS varchar AS ' .... ' LANGUAGE 'plpgsql' VOLATILE;

I have two Linux servers, one is test and one is production. I run Postgres7.3.3 on both of them. I added a feature to my product that requires sorting like strcmp. So, I did an initdb as follows: export LC_COLLATE=C initdb It fixed the sorting problem. I have tried to do the same on my production server, and when I do the initdb, it...

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 all I need to transfer a database installation from one host to another. I need to dump all users, databases, schemas, stored procedures, triggers, etc. but no actual data at all. What I try to achieve is a fresh clone ready to run. I tried pg_dump -s and pg_dumpall, but somewhere I'm missing something, so: what is the procedure to...

Hi, I am interested in migrating Microsoft Access database to Postgres database. But I do not have idea of like initiating. Maybe some tool exists for this problem. Thanks you. Bernardo

Hello, I'm using inheritance in my DB with PostgreSQL 7.3.4, and a friend of my told me that there is a bug in that type of table. To resume, the problem is: - a table A have a primary key - a table B references the primary key of A - a table C inherits the A fields - when I insert a tuple in table B that references something inserted at

I have found that when I use the RETURN NEXT command in recursive function, not all records are returned. The only records I can obtain from function are records from the highest level of recursion. Does exist some work-around? Thanks Petr Bravenec example: create table foo (

Sites selling full up, low end server boxes? redundant supplies, raid arrays (SCSI or IDE) lots of PCI slots singel and dual proc's 1+ gb mem capability other concerns? This is for telephony, but it really is similar to DB's, and will have one also on it.

Hello, sometimes I get a strange error from postgresql when I try to connect using ssl to the server: LOG: parse_hba: invalid syntax in pg_hba.conf file at line 46, token "hostssl" FATAL: Missing or erroneous pg_hba.conf file, see postmaster log for details The contents of the pg_hba.conf file are

Hello, Anyone know if it is safe to do a pg_dump on a database while other programs might be making changes to the data? Is the integrity of the dumped data guaranteed? Does pg_dump lock the whole database when reading from it? Thanks for all your help. Hisham

Howdy: Running PostgreSQL 7.3.3 on RedHat Linux 7.2 I'm trying to dump a table out with the insert statements imbedded and I'm not having any success. The man page for pg_dump says to use: -d / -D to add the inserts (and values)

I run the following script to export some data from my development database and then update or insert the records into to the quality assurance testing database, but I get a warning notice that I don't understand. Aside from that notice, the script appears to work as intended, i.e., updating existing report definitions and adding any new ones...

My situation is that I am interacting PHP 4.1.2 to PostgreSQL 7.2.2 I have no difficulty inserting and managing BLOBs into the Large Object system table, and I have a user table called images which maintains the relationship between the BLOB loid and the identity that relates to it in my user tables. So far so good. When I RTFM obout...

All... I have a query that calculates various using variables from a survey database. As with any survey, there are many instantces of null values. I'm wondering if there is any way to escape the error caused by dividing by zero or null values. The specific message i get is: ERROR: floating point exception! The last floating point...

Hi, I am trying to access PostgreSQL remotely with psql, and I am having some trouble. I am running the server with the -i option to allow Tcp-sockets and the pg_hba.conf is configed to let my subnet access it. I can access the server locally and with the pgAdmin III on Win2K. What is even stranger is that psql works remotely with the -l...

Hello all, I may be going about this all wrong but... I have a view that selects data from multiple tables(naturally). The trick i would like to see happen is to have a rule or something rune on the select of that view to set a bool field to true (t); Is this even do able? I noticed that triggers only work on INSERT,UPDATE,DELETE. I...

Hello, Since it's not possible to do a function with a variable number of arguments, I am wondering if it is possible to use an array as an argument in a PL/PGSQL function ? CREATE OR REPLACE FUNCTION myownfunction(members.id%TYPE, events.id%TYPE) RETURNS BOOLEAN AS ' BEGIN ...several sql queries that are OK... RETURN TRUE; END; '...

Thanks Tom, when I go down all files linked to libpq.so.3 end with a "statically linked" comment. I assume this is the desired result. However, I did find another libpq.so.3 in a different directory. When I ldd it I get "no such file or directory. Maybe the original installation by rpm put it there first. Could this problem be the...

Hi @ all, I think thats a bug: SELECT '#' || '#' will work but SELECT '#' || CAST(NULL AS VARCHAR)

Hi, Is there is a way to get the real curren_time inside a transaction (not the time when the transaction stated) Daniel ---------------------------(end of broadcast)---------------------------

hey guys..need your help on this.. i have a plpgsql function where in i compute numeric values for my php scripts.. my problem is my function just won't round some numbers properly.. what i want it to do is like this. example:

i have the following function: declare prim_col_name Alias for $1; prim_col_val Alias for $2; my_column Alias for $3; link_table Alias for $4; link_col Alias for $5; data_table alias for $6; my_record Record;