PostgreSQL Database Forum

Dear my friends.... I created a column with datatype bytea. The name of the column is emoicon I did like this: kv=# insert into salesreport (salesid, custid, emoicon) values('13', '4531', lo_import('/localhome/patrixlinux/arsip/proyek/qt/kv/client/images/1.png'));

This is under Windows 2000 SP4 using the beta1 installer package. If I create the following table: CREATE TABLE test1 ( idnbr int4 NOT NULL, num1 numeric(12,2), num2 numeric(12,2), text1 varchar(600), CONSTRAINT test1_idnbr_key UNIQUE (idnbr)

Hi there Pg admins, I have 2 systems, one OLD, (linux 2.4 running postgresql-7.2.1-5 with a perl web db on Apache/1.3.23 mod_perl 1.26 and dbi 1.37 with peristent db connections via apache:dbi. ) The other system is NEW (running the same web app on linux 2.6 postgresql-7.4.2-1 w/ Apache/2.0.49 & mod_perl/1.99_12 & apache:dbi. fedora...

Is it legal syntax to use <> instead of != in a Postgres query? I didn't see it listed on: http://www.postgresql.org/docs/7.4/static/sql-syntax.html but wanted to ask to make sure.

Is there a way 'within' psql to suppress output? One of our cron scripts calls a sql file which contains various database commands (ALTER TABLEs, UPDATEs, etc) and various user-defined functions. So within this sql file there are various SELECT * FROM myFunction(); which sends output to the user from cron. I can't see anyway to suppress this...

Has anyone gotten VISIO setup to see the the pg system tables? I have Visio 2003 and i am not sure of the driver version! ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Hi, I am trying to get my feet wet in SRF's I had to define a type in order to get my first attempt at a srf for an sql language function ie.. create type annual_report_type as ( category text, jan numeric(9,2),

Hi, I have a postgres instance up and running and I was using the EMS PostgresSQL datapump tool to import the data from MS Access but is there a free tool that can do the same job? (although I have to say the EMS tool is very good if you are prepared to pay). Nick

I have some processes that create data. Other processes run by cron periodically take that data and insert it into appropriate tables in a 7.4.1 database. In some cases the delay from process end to insert seems excessive so I'm trying to track the problem with a rule that creates a log record every time a record is inserted into the main...

Is it possible to build the python postgresql support library on Mac OSX 10.3.5 with the default python install? Adding "--with-python" gets an error message about libpython not being a shared library when attempting to build postgresql. (pg 7.4.5) Thanks for any pointers. Jerry

Hi, I'm using PostgreSQL 7.3.4 with phpPgAdmin 2.4.2 and the ".sql" file I'm trying to import came from a dump from a server running PostgreSQL 7.0.3. I just got this error message trying to import the PostgreSQL database file into phpPgAdmin. The error message was as follows: Error -...

Hi all, I was trying to overload '<' operator for (varchar,varchar). But in the function which handles the comparision I want to use the previous '<' operator.. but it is going into a recursion. My simplified code looks like : create or replace function orastringcmp (varchar, varchar) returns boolean as 'declare

What is the linux and/or postgres limitation for very large databases, if any? We are looking at 6T-20T. My understanding is that if the hardware supports it, then it can be done in postgres. But can hardware support that? --elein ============================================================ elein@varlena.com Varlena, LLC ...

Hi, Are there any built in or known structures I can use in Postgres to represent a family tree? The usual tree representations in SQL are for regular hierarchy of data, but on a family each node had usually 2 parents and a few child nodes. What will be the best way to represent something like this in an efficient manner? Guy. ...

We've got a table that has a definition as follows: CREATE TABLE linking_table ( fk int8 REFERENCES source_table( pk1 ), value int8, PRIMARY KEY( fk1, value ) ); I would've thought that the multicolumn primary key would behave as a multicolumn index is supposed to behave per

I tried to truncate a table and received the following error: "expected both swapped tables to have TOAST tables". Googling provided no insight. What does it mean? Version 7.4.1. Note: I can delete from the table and vacuum full to empty it, I just can't truncate it. I don't see anything special with this table and can truncate a...

Hi, I have got a table which is supposed to contain only one row. It does not have any primary keys defined. So, essentially, when a new insert happens in that table, I would like it (the insert) to fail if there is already a row existing in that table. How can I do that? Can I add any constraints? Or do I need to write a separate...

Hi, I have a question about substring(), when I run the following query: prepaid=# select substring('15148300', 0, 5); substring ----------- 1514 (1 row)

Using PG 7.4.5 on Mac OS X 10.3 ... I have a primary key that I can't destroy and can't create. One weird symptom is that when I use \d in psql to attempt to display the constraint, there is no output at all! Normally, psql either shows the constraint or reports that the constraint doesn't exist. (BTW, I know that the default clauses...

Does anyone have experiences using PostgreSQL for storing Microsoft Project data? MS Access, SQL Server and Oracle are supported according to the manual. A simple test with PostgreSQL results in an error something like 'Unknown data type "lo"'. I have been unable to find any useful info on this issue on www.google.com. Any help much...

Hello all, I met a problem about cannot start postmaster. The situation I met is that I was running postmaster, but because of the server closed all my konsole. As a result, I did not shutdown postmaster successfully. Next time, when I tried to run postmaster -D /usr/local/postgresql/data, I got the following error: FATAL: lock file...

Hi, I am not able to build the libpq for windows using the 8.0 beta1 version source code. I posted this message for couple of time by now. I did not getany responses. Is this supposed to be broken at this point ? Can you somebody please respond for this issue? Thank you very much in advance, Sagar. ---------------------------(end...

Hello everyone. Can anyone suggest if there's a way to force a plpgsql stored procedure to be recompiled every time that it's called, based on the values of the parameters that it's given? I assumed it would be possible, but unfortunately haven't been able to find any documentation on how to force a recompile at all, let alone...

We have a list of customers, some of whom have purchased feature X and some of whom have not. If a customer has paid for featurex, they can use it, and a strict relationship between cust_items.items_id and items.id, but only if they are signed up to use featurex, otherwise I want cust_items.items_id to be NULL. Currently, I have tables...

I have an existing installation of 7.3.4 that appears to have been made with "--without-readline and --without-zlib" parameters used at build time. How do I change those parms without reinstalling the whole thing. I would normally go through the archives, but they appear to be unavailable. All replies appreciated. Regards, Marshall ...