PostgreSQL Database Forum

Hello everyone, I have received any error message in my Postgres error log as follows: "The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory. I have rolled back the current transaction and am going to terminate your database system connection and exit. Please reconnect to the...

Hello, 2 questions ! Question 1 Iam trying to load binary data from sql server to postges. Do i have to write a script .. ?? Question 2 How i do load text data with newlines into postgres database .. (as

Someone posted this official proposal to create comp.databases.postgresql.general again. He wrote his own charter. As far as I know, he did not consult any of the postgresql groups first. There may be an upcoming vote on this, so please stay informed and read news.newgroups.announce for updates. Also see message...

Hi Everybody, I am having problems while installing pgbench program. I followed the below procedure to install according to the docs: (1) Configure and build the standard Postgres distribution. You can get away with just running configure at the top level and doing "make all" in src/interfaces/libpq.

(re-post) Dear list, Please let me know if this is not the list to ask this kind of question. I am trying to optimize a query that joins two relatively large (750000 rows in each) tables. If I do it using a subselect, I can "force" the planner to choose the fastest path. Now, my question is:

Hi all. I'm working (well, rather, reworking) a database schema that, in part, models a company organizational structure. For example: group company division head office department

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Here's a question for the SQL guru's out there, which I've been trying to solve for the last couple of hours. There's got to be a solution to this, but somehow I can't find it. Tables:

* We in Calicut UNIversity using posgresql in our examination wing. Now we can not use our database. It gives some message as follows. XLogFlush : request 0/D8949278 IS NOT SATISFIED. --FLUSHED ONLY TO 0/D1702530 What is this. Why this message comes. And how to overcome this problem? Madhu VT System Administrator

How can I view and edit a function in psql? I have been using PgAdmin to do this but wanted to try the command line TIA Patrick Hatcher

i am currently migrating a db from Oracle to Pg and in some of my triggers i use variables, i.e. i have some thing like this: CREATE OR REPLACE TRIGGER "USERACTION_VIEW" INSTEAD OF INSERT ON

Hi all, I have to develop an embedded database with PostgreSQL. I have a Linux Distribuction that works only in single user mode as root. The postmaster daemon starts only if I 'm not root user. Do you have a solution for this problem ?? Thanks.

ALERT There is a person by the name of Mike Cox who's trying to turn this mailing list into a Big-8 newsgroup. Many of you know that this and most of the other postresql mailing lists are already gated to Google Groups and a small number of private news servers. If Mike Cox succeeds, this list will be available as a newsgroup on a great...

At the risk of asking an ill-formed oft-asked question that's probably in the FAQ, is there any report generation tools that are particularly suited for use with postgres databases? -- % Randy Yates % "My Shangri-la has gone away, fading like %% Fuquay-Varina, NC % the Beatles on 'Hey Jude'" %%% 919-577-9882 ...

Hello, I have a table with a rule that goes something like this: CREATE OR REPLACE RULE sometable_delete ON DELETE DO delete FROM cache WHERE tablename='sometable'; CREATE OR REPLACE RULE sometable_insert ON INSERT DO delete FROM cache WHERE tablename='sometable'; CREATE OR REPLACE RULE sometable_update ON UPDATE DO delete FROM cache...

Hello, Lets say I have data like this: value1|value2|value3|value4|....|value(N) ------|------|------|------|----|-------- 100 | 200 | 300 | 400 | | 10 | 20 | | 40 | | | 15 | | 16 | |

Iam trying to import data from ms-sql server to postgres. I export the data which has datetime columns in sql server using BCP. I use the following to import back into postgres. copy tablename from 'c:\\bcpdata\\mcfa\\tablename.txt' with delimiter as '\t' I get the following error !! invalid input syntax for type timestamp: ""

I have a CSV file with 400,000 lines of email mailing list information that I need to migrate to a new PostgreSQL database. Each line has all the info I need except a PK (I usually use an int4 column for a PK). If the file were smaller I would probably just use Excel to pop in a PK and then just load into the table... Since Excel...

I'd like to have a DB client connect using a username ('psuedodba') different from the creator/owner ('dba') of the DB and its tables, but still have that username be able to do everything the creator/owner can do (alter tables, drop databases, etc). It appears that "createuser -d -a psuedodba" works for this purpose. Are there...

I don't seem to be able to connect to gborg.postgresql.org this evening... Jerry ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster

Hi, How can i get the Client Host name/IP Address for the current connection(session). Is there any function or system table(view) which will these details. Thank

I searched through the net quickly and the list archives, but could not find anything doing this. Is it possible? There is a Perl module for doing this, but I guess cannot use modules for security reasons. -- Robert ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with...

Is there some clear reason why I can't using EXECUTE of a PREPAREd query as I can a SELECT statement in CREATE TABLE AS, INSERT, FROM clause, sub-selects, etc.? If not, wouldn't this be a very useful change? (Or is there some special syntax to do this that I can't find?) Andrew Lazarus andrew@pillette.com ...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, Are there any people in this community who keep blogs of their PostgreSQL lives? We are working on a "planet" project (like planetapache.org) and I'd like

Hi. anybody know how to sen a parameter an a trigger. thank for your help Mario Soto

Andy M wrote: > ALERT > > There is a person by the name of Mike Cox who's trying > to turn this mailing list into a Big-8 newsgroup. No, I'm trying to get teh postgresql groups which are already ON usenet to follow proper usenet guidelines. In order to be under the comp.* hierarchy the server MUST go through RFD and CFV. Otherwise it...