PostgreSQL Database Forum

Please follow this site's Posting Guidelines when posting questions or answers. Some highlights from the Guidelines: Make a meaningful title for your thread. "Please Help!" is not one of those. Include your code snippets into the CODE tags; use the menu icons on the GUI. Provide enough information, so others can help you. This may include...

What are the SQL commands to find who is logged on a server, what database he/she has open, etc? Where is this information in the help file or documentation? Thanks, Thomas _________________________________________________________________ FREE pop-up blocking with the new MSN Toolbar – get it now!

Hi I'm trying to restore tsearch2 featuring database like discribed in the 'tsearch-V2-intro' document. (http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html) In point '5) Restore the data for the database' I get the following Error: pg_restore: ERROR: duplicate key violates unique constraint

I am attempting an install of 7.4.3 on FreeBSD O/S 4.9, apparently remnants of 7.3.x are scattered around on the disk from (a) previous ports installation, causing mutex_lock/unlock, libpq.so and other installation problems. I want to reconfigure and reinstall. How do I know what, & where all these fragments are located or how do I uninstall...

I heard that the sql standard for escaping quotes is '', and not \'. Is this true? BTW, PHP's pg_escape_string returns \' and not ''. __________________________________ Do you Yahoo!?

unsubscribe ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

I was wondering what you'd do if you wanted to store a timestamp value that's outside of that data type's bounds (4713 BC - AD 5874897)? __________________________________ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger.

How do I contact the owner of http://pugs.postgres.org/pdx/ or http://pugs.postgres.org/ ? I'd like to talk to the pdx guy(s)/gal(s) about a speaker meeting. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to...

I have a problem on FROM subselect that i don't understand. I do two query different only for a WHERE clause in a FROM subquery . 1) explain analyze SELECT DISTINCT ON (spettacoli.teatro,spettacoli.code) spettacoli.teatro,spettacoli.code, scnf_spettacoli.scnf_gruppo ,scnf_spettacoli.scnf_client,

I'm trying to build a client program to access a database using the libpq interface on MacOS X 10.3.3 using CodeWarrior 9. PostgreSQL is at version 7.4.2. It compiles ok, but I get a link error. I have linked to libpq.a, because I got different errors before I did that. Here is the error I'm getting right now: Link Error: undefined:...

Greetings, Yesterday theres was a brief discuissions about replications software for PostgreSQL. My boss and I saw only two replications for PostgreSQL that was spoken of. We found no reviews on the internet that spoke of either or compared them and we are considering PostgreSQL as an options for a movement from our present platform of...

When trying to search the 7.4 docs at http://www.postgresql.org/docs/7.4/static/index.html, I got the following error message: An error occured! Can not connect to search daemon ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?

Hi the "insert into" syntax can degrade a performance in a table whit a big number of row? Or insert 1 row in a table whit 0 row make the same time to insert 1 row in a table whith 900000 row? tanks! D

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I've just upgraded a production database from 7.3.4 to 7.4.2. I 'sometimes' get the following error while executing a PHP code:

Sorry for the newbie question, but how do you get PostgreSQL to list the available databases? I know how to log into a certain database, but not list all of them. I know this must be possible because the phppgAdmin web site demonstrates it with their trial server. Thanks, Doug Hall ---------------------------(end of...

Hi fellow pgsql users, I am helping my university's student union get back up and running after some major server issues they had. They had serious disk issues on a server, but not on the /var partition where all of the /var/lib/postgres/data files were. I was able to recover all of it, at the file-system level. The old machine and the...

I'm looking at ways to get batches of sequence values s faster. I don't want to set cache or increment to a large number for a variety of reasons. I need to grab id's in batches of varying numbers at various times, from 1 to several thousand at once. Doing it 1 at a time works, but more time goes into it than I'd like. I tried setting cache_value...

Hi, I've been trying to cluster some large tables (more than 10 million records) and this is the error I keep getting: "ERROR: expected both swapped tables to have TOAST tables" and it just stops! Please can someone explain what this means? How do I fix it? I can find *no* reference whatsoever on the internet. Thanks!

Hi I want to be preserve a log of all SQL actions that change a database, (ie INSERT, UPDATE, DELETE, CREATE), to provide a full audit trail of the date, and to allow the recreation of a database at any time. I can achieve this wth ORACLE(recover and others) and MySQL(mysqlbinlog) quite easily. How do I achieve this with Postgres? Simon

/* I have a customer requirement to provide for flexibility on how vacation leave is calculated and am having trouble with executing the necessary SQL which is stored in the database as a text column. The employee table and a newly minted vacation leave formula table, shown below, are related and identify what vacation leave calculation is...

Hi everybody, I'm doing the following query: select * from messages order by random() limit 1; in the table messages I have more than 200 messages and a lot of times, the message retrieved is the same. Anybody knows how I could do a more "random" random?

subscribe ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

Dear Friends As Subject How to resolve, since i use with out problem on postgresql 7.3 Regards Luiz

Interesting article, notice the "never have to reboot it" line. http://www.smh.com.au/articles/2004/06/07/1086460218113.html?oneclick=true ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

I can't find where to get a list of who can do what on a database. You know: GRANT SELECT ON mydatabase FOR joe; How do I grab a list of everyone's capabilities either for a given database, or more than just one database? ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster

If I wanted a multinational database capable of many langauges,and wanted the most functionality of sorts, order bys, indexes, LIKE, etc, what is the best encooding? I would have THOUGHT it would be UTF8, but maybe C_LOCALE? Is there a chart somewhere showing the main differences between using C_LOCALE and any other encoding? A nice simple...