PostgreSQL Database Forum

While this function works when hard coded, the following will not when trying the same thing with a argument. Can someone point to me what I'm doing wrong? CREATE OR REPLACE FUNCTION "public"."test" () RETURNS varchar AS' DECLARE var1 varchar; BEGIN var1 = chr( (ascii(''a'') + 1) );

Hi guys. I have just had some problems resolved while building PostgreSQL 7.4.2 on Tru64 UNIX 5.1B. File "./src/backend/utils/adt/float.c" uses "NAN" on two spots. It ahs a fall-back definition of NAN as: #define NAN 0.0/0.0

This is a really trivial question, but I'm curious. Why do subselects in target lists behave differently than simple queries? Ex: create temporary table bar (key varchar(32) not null); CREATE TABLE insert into bar select ''; INSERT 1319585 1 insert into bar select (select '') as key;

Hi all, What are the characters which requires an escape sequence when used in the query. I am writing an application using JDBC. rgds Antony Paul ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

Hello Sir, I like to know in postgresql, how many connections are established in the system?. how many connections can be made?. We are using linux. Thanks Regards

Dear PostgreSQL people, I thought that some of you might be interested to know about Decimail, a new IMAP mail server that I've written that uses PostgreSQL to implement its message store. Decimail's unique feature is that mailboxes are defined using SQL queries. So for example you can match all messages to this list with this query:

Hi, I know that 7.2, 7.3, and 7.4 are not compatible. But I'm wondering if the client lib (libpq.so) is compatible across those versions. The thing is, my old database is 7.2. I upgrade my system using Redhat Enterprise, which shipped with 7.3 and use the client of the PHP-pgsql module (PHP compiled with --with-pgsql flag). So I assume the...

I ready somewhere that PostgreSQL is able to optimize SQL functions, the same way it does with views. For example if you do: select * from cv_customers() order by customer_id; When customers is an SQL function the optimizer/planner will be able to actually use the customer_id index. >From some tests I made it doesn't seem true.. Yet I...

I have one table with columns that are used as foreign-keys from several other tables. Sometimes deletion from this table takes +5 seconds for a single row. Are there any utilities that can be used to figure out why the deletion takes so long? "ANALYZE DELETE FROM foo WHERE bar=gazonk" doesn't really help as it only explains how the where...

If max_fsm_pages is too small and I have space not reclaimed by vacuum, if I increase max_fsm_pages and restart postmaster, will the next VACUUM ANALYZE relcaim all overlooked pages or must I do a VACUUM FULL? Wes ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to...

Hi, I have a problem restoring a database from Postgresql 7.3 ( backup created with 'pg_dump -Ft -b > test.tar' ) to a new database on PostgreSQL 7.4.3 on Cygwin. I get the following error: pg_restore: executing SEQUENCE SET t_tab_kurs_template_id_seq pg_restore: could not execute query: ERROR: relation "t_tab_kur s_template_id_seq"...

Hello! I have accidentaly deleted about 1,000,000 records from one table (about 80%). Is there any possibility to recover them? I found two files: xlog and a file which I assume contains all the data from the table (including the deleted rows). But I cannot read from it - I don't know the format of the data. Can anyone help me? Private...

Hello ! I'm writing a DB app using Delphi 7. The PostGres Delphi components we are using are PostGreDAC from MicroOLAP, the latest ODBC drivers (from postgre.org)and PostGres 7.2.2. The certificates are installed and running (postmaster starts fine). When I try to connect I get the following Error Message PostGreSQL Error Code(1):...

I am using PGADMIN III v1.1.0 Windows to set up PostgreSQL tables on a Linux Server, RedHat 9. Every time I create a character field, even just one character wide, the PGADMIN uses EXTENDED as the default storage type. Is this normal? I can't find anything about why this would be done in the PostgreSQL documentation or the Internet. It seems...

Hello, Sorry for this newbish question. Briefly, my problem: ------------------ I expect the database I'm working on to reach something in the order of 12-16 Gigabytes, and I am interested in understanding as much as I can about how I can make this go as fast as possible on a linux system. I haven't run such a large database before. The...

Hi, We just experienced this bug: http://tinyurl.com/28gkh on 7.4.1 (freebsd and os x). Is there any chance this is on the list for 7.5? culley

I was wandering how I can add a user to a specific db. There are several databases but I want to add the user to only one of them. It seems when I add a new user, it is entered in the pg_user table and I can log in to any one of the other dbs (ofcourse I won't be able to do anything until I grant permission still I don't even want to be able...

Hi, Below is my VB6 code that writes data from an Access 2000 table to a PG table. The " & "" " on the right of each line should prevent nulls from being passed to PG. For some reason I still get nulls in any field without data. Even the secondary part number which is set to "".

Hi, I tried to install phpopenchat but I can't create this table: poc=> CREATE TABLE poc_user_account ( poc(> USER varchar(255) NOT NULL, poc(> PASSWORD varchar(255), poc(> CONFIRM_CODE char(32), poc(> DISABLED int NOT NULL DEFAULT '0', poc(> KICKED int NOT NULL DEFAULT '0',

I accidentaly deleted over 1.000.000 records from one table in my database. Is there any way to recover them? Please help me as soon as possible... After the records were deleted, no other operation was made on the database. In fact, all the postgres services were shut down. I found a xlog file containing those records but I don't know the...

This bug? feature? caused a bit of havoc for us yesterday...A reproducible example follows. Essentially, if you have a table with a primary key called "id", and you create a temp table (via a "select into") containing a subset of the data from the table but where the primary key field is renamed (in the example below, it is called "not_id"),...

I know the following java instructions for connecting a DB (oracle in this case): import java.sql...... try { Class.forName("oracle.jdbc.driver.OracleDriver"); String dbUrl ="jdbc:oracle:thin:@"+host+":"+port+":"+sid; Connection m_connection = DriverManager.getConnection(dbUrl,user,passwd);

I'm thrilled by the news that nested transactions will make it into 7.5 after all, and trying to learn how this will work. The question is what will be the syntax to start / commit / rollback a subtransaction. Leaking a bit from pgsql-hackers I see this very subject was the subject of some lively discussion as recently as 3 days ago. ...

Gentle people, I don't get it. I have a table where one of the columns is of type 'TIMESTAMP' How can I do a query to filter on the TIMESTAMP value, e.g. to obtain all rows earlier than a certain time stamp? Regards,

I attempted to compile 7.4.3 with enable-thread-safety but it fails and says it's not supported. My configure command was: ../configure --enable-thread-safety and the result: checking pthread.h usability... yes checking pthread.h presence... yes checking for pthread.h... yes