PostgreSQL Database Forum

Is it possible to alter a table to resize a varchar column? The PG docs indicate lots of uses for "alter table T alter column C..." but not one that allows the changing of the type (or same type, new size). This is possible in Oracle (provided you are increasing the column size). Is there a way to resize the column without having to drop...

I am doing asynchronous sql calls using the postgres C library. After doing two PQsendQuery() calls, I get the "another command is already in progress" error. The two calls I am doing are an update, and then an insert, in that order. I am doing this for speed, since my program can't afford to wait for the answer from the first to complete...

Dear All, I have been facing below issue when trying to export table data in CSV format only when used where condition. I dont see any issue if I dont use where condition. Eg: Succesfully copied to CSV dnsdb=> \copy domains to '/root/pgdata/mycsv.csv' csv; COPY Failing with below error when added where condition

Hi, I'll try to switch from Oracle to postgres for some small applications. Is it possible to build functions like Oracle's nvl or decode with pgplsql? How can I make a function like nvl that works for every datatype? Best regards, Christian

Hello ! ----------------------------------------------------------------------------- I would like to know why the database seems frozen. - psql can access to database on the database server - There are no error logs. There are only normal logs - pgadmin cannot connect to the database. - the webserver cannot execute any script - other...

Hi All. There is one thing which somewhat annoys me, which is that psql always prompts me for a password. That makes it difficult for use in Makefile where I want to say 'make build_db', which would run psql for each stored procedure which needs to be updated. Is there a way to specify that password somehow in a command line like isql (...

hello can anyone tell me how to create a table with 3 columns as UNIQUE KEY PraDz

Is there something in Postgres that corresponds to the rowid pseudocolumn in Oracle, which represents the unique address of the row of data in the table? If so, how would you access that in a query? -- Barbara E. Lindsey, COG RDC Phone: (352) 392-5198 ext. 314 Fax: (352) 392-8162

Is there a way to limit the size that an individual database can take up? My understanding is that all your databases go into a file system which is your 'catalog cluster'. But all the databases can grow until that filesystem is full. Is there a way to limit how big a database can be? Can you allocated space when the database is set up...

Hi, Can I call multiple functions in one trigger? Something like this: CREATE TRIGGER match_cond_name_generate BEFORE INSERT OR UPDATE ON public.predicate_index FOR EACH ROW EXECUTE PROCEDURE public.match_cond_name_generate();

I curious about the benefits of a varchar over text. Is it speed, size? If so, how much speed, size? Is a varchar(64) and a text with 64 chars the same size? I'm inclined to make all my varchars into text so I don't have to worry about inserting something to big. TIA, Michael ---------------------------(end of...

I am interested in finding out about Enterprise scale Postgres installations and clustering, especially on Linux. Essentially I would like to know the possibility that Postgres can store the database data in a central location (ex: on a SAN fiber array) and have a cluster of machines sharing processor/RAM/IO bandwidth to do the application...

My date setting is ISO with US conventions, and output from a select is in the form yyyy-mm-dd (2002-01-18, for example. When I do a select such as SELECT * FROM table WHERE date BETWEEN '2001-12-28' AND '2002-01-28' It misses the entry with date '2002-01-28' (which does exist!). Likewise,

I'm trying to drop a table and it's taking a very long time. There has been a lot of modification to the table and it has a lot of old data still being used as a result of not using the vacuum function enough. I ran an insert into and it was taking a long time (ran for about 48 hours) so I aborted it. I tried vacuuming it and that ran for...

Hi, I was wondering if PGSQL has a function similar to binary_checksum() of MS SQL Server 2000. It is pretty handy when it comes to compare rows of data instead of having to write long boolean expressions. binary_checksum() takes a list of fields and it returns an integer value which sumarize the row content. Thanks, Fed

Hi, I have a stored procedure that is causing deadlocks when called multiple times synchronously. The odd issue is that the deadlock seems to be happening on different threads waiting for locks on transactions. What exactly is this transaction lock? ERROR: deadlock detected DETAIL: Process 1740 waits for ShareLock on transaction 1488;...

i have create a table and inserted a values init. when i am getting the values it is throwing the exception "ERROR: column "dtype" of relation "xxxx" does not exist" where xxxx is table name. if any body knows the solution kindly help me Thanks in advance .. Jagan

Hi! I cannot imagine how to create db from a script file and execute other DDL statements on this new db. Currently I use 'psql -f file' to perform all needed DDL statements except of create db. Because when I insert 'CREATE DATABASE' at the beginning of the script, the server creates a db but following commands like 'CREATE TABLE' and etc...

Is there any simple way to query the most recent time of "changes" made to a table? I'm accessing my database with ODBC to a remote site thru internet. I want to eliminate some DUPLICATE long queries by evaluating whether the data has been changed since last query. What should I do? -Jason

I have to convert this script, but i didn't. This is stored procedure of sql. I need to convert to postgresql... if it is possible please help me! Thanks Fatma CREATE PROCEDURE usp_generatetable(@prm_tableID int, @prm_langID int) as

hi all i'm currently running a postgresql 8.2 server. how to change the postgresql locale permanently especially for the date time format and currency format? best regards ferry m ferdian

Hello everyone: Can anyone tell me if it is possible to connect excel or openoffice via odbc directly to a postgres backend database. Also, if that is possible does either OpenOffice or Excel support SQL queries to said database? Bob Powell

Hello all, This question is related to updating tables - is there any way to calculate or update the values in a column in a table to the values in a field produced by a query result? An example of what I'm trying to do is below: update (tbl_ind_mananas LEFT JOIN (select count(*) as count, (dubicacion || zona || manzana) as cod_manzana...

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 have to migrate a MySQL database to a PostgreSQL database without procedures. The problem is that this MySQL database uses ENUM, do you see what can I do to migrate ENUM into PostgreSQL ? Thanks in advance :-)