PostgreSQL Database Forum

Is there any way to determine the last time statistics were analyzed on a given table? -- Jim C. Nasby, Database Consultant decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys...

I was a little surprised today when I tried to move a production database on to my test server. The test server already had a copy of the database so I did psql -Uadmin template1 drop database admin; create database admin; When I tried to reload the production database dump, I got a series of errors relating to functions. I repeated...

Hi, First I'm trying to move a MySQL database to Postgres. I have to emulate a MySQL sql statement - ''Describe tablename' which in general is '\d tablename' from psql. If I use '-E' my 7.3.x provides three sql statements and by 7.4.x produces four statements. But what I want is a single SQL statement that produces the following: ...

The Postgres manual says: The AT TIME ZONE construct allows conversions of time stamps to different time zones. I'd guess most people would think what's meant here is something like "unit conversion", and that the timestamp value stays the same (much like 2 feet becomes 24 inches when it's being "converted"). But: # SELECT NOW() =...

hi, what do u do if the DB become big and u have to spread it into two or more computers. Links and Docs are ok too ? For example what if u do if u want to split the DB on two servers (at desing stage), but u have common data such as user info,address etc... if u decide to do it that way u need to syncronize common data in some way, what...

Hi everyone, When importing a bunch of data (> 85000 rows) I get an error I can't explain. The table into which I'm importing has a unique clause on (code, bedrijf). The rows in the source-table are unique in this aspect, yet when I do the import I get this "ERROR: duplicate key violates unique constraint "werknemer_bedrijf_key". I...

Hi. i would like to log every single query coming in to the database into a table. i would like the log to include the entire query and execution time and execution cost, and if possible the user that executed the query. A trigger is what i was thinking of, but how can i find out the actual query, the time it took to execute it, etc.? ...

hi, what do u do if the DB become big and u have to spread it into two or more computers. Links and Docs are ok too ? For example what if u do if u want to split the DB on two servers (at desing stage), but u have common data such as user info,address etc... if u decide to do it that way u need to syncronize common data in some way, what...

The Postgres manual says: The AT TIME ZONE construct allows conversions of time stamps to different time zones. I'd guess most people would think what's meant here is something like "unit conversion", and that the timestamp value stays the same (much like 2 feet becomes 24 inches when it's being "converted"). But: # SELECT NOW() =...

Did you know what is the maximum character length for a name of : a database or schema ? a table or a view ? a column ? a constraint ? an index ? thanks -- Frédéric BROUARD, MVP SQL Server. Expert SQL / spécialiste Delphi, web Livre SQL - col. Référence : http://sqlpro.developpez.com/bookSQL.html

Hi All, I hope this is the correct mailing list for this question. But neither postgresql.org nor google could help me out on this subject. I did find one disturbing topic on the mailing list archives (http://archives.postgresql.org/pgsql-admin/2000-05/msg00032.php), but since it was quite old I'm posting my question anyway. I'm writing...

Hallo List! I just found this old posting on google. Now my question is how can I read an integer value from the PGresult using the binary format? Can someone plz gimme a code example? (please mail to me, because I have not subscribed to the list) Thanks a bunch! Now here's the old posting: On Monday 27 October 2003 09:15, Tomasz...

I was a little surprised today when I tried to move a production database on to my test server. The test server already had a copy of the database so I did psql -Uadmin template1 drop database admin; create database admin; When I tried to reload the production database dump, I got a series of errors relating to functions. I repeated...

Hi everyone From time to time i get the following error: could not fork new process for connection: Resource temporarily unavailable im using Postgres 7.4.5, with kernel 2.6.2 my conf is: max_connections = 400

I export data from a table that contains a varchar field that stores whole names in it. Some of the names include the apostrophe character.... O'Neal, etc... When I attempt to import the data (using the copy command the apostrophe kills the import. If I export the data with quotes around the varchar field the quotes get stored inside the...

Hi. Is it possible to dump a database on a 7.4.6 server and then restore it on a 7.4.1 server? should i use the 7.4.1 pg_dump or the 7.4.6 pg_dump? should i use any switches? thanks

Hi! Can I use postgresql on windows without cygwin?

Hello! I have a couple of final ( I hope, for your sake ) questions regarding PostgreSQL. I understand PostgreSQL uses processes rather than threads. I found this statement in the archives: "The developers agree that multiple processes provide more benefits (mostly in stability and robustness) than costs (more

I am going to sync a schema in postgres with one in an oracle db. The tables are simple, but there are 200 of them. I would like to try to keep the sync lag < 1 minute. Here is my idea. Please critique/suggest. 1. Set up stored proc on oracle that records a INSERT, UPDATE, DELETE SQL action taken on a table into a log table. 2. Program...

Hallo List! I just found this old posting on google. Now my question is how can I read an integer value from the PGresult using the binary format? Can someone plz gimme a code example? (please mail to me, because I have not subscribed to the list) Thanks a bunch! Now here's the old posting: On Monday 27 October 2003 09:15, Tomasz...

Hello, i'm etablishing a naming convention for a new project under postgresql. For tables, sequences, views, that's ok! I used good naming conventions for this in the past and i'll keep these rules for the new project. but, i plan to use a lot of triggers and functions in this project, but I'm confused! I know that triggers call already...

Hi all, Question: is there any way to use environment variables (or something similar) in my saved SQL code, and have them expanded at runtime? I can't see a way to do this in the manuals, and a colleague tells me it can't be done, but I wanted to check, because if this _can_ be done it will make my life significantly more optimal. In...

Hi, In 7.4.6 there is only plpgsql under pl where as 7.4.5 includes it in the main distribution can anyone tell from where plperl for 7.4.6 can be got?

Hello, i'm etablishing a naming convention for a new project under postgresql. For tables, sequences, views, that's ok! I used good naming conventions for this in the past and i'll keep these rules for the new project. but, i plan to use a lot of triggers and functions in this project, but I'm confused! I know that triggers call already...

Hello I know it is possible to time isolated queries through the settting of the \timing option in psql. This makes PgSQL report the time it took to perform one operation. I would like to know how one can get a time summary of many operations, if it is at all possible. Thank you.