PostgreSQL Database Forum

Greetings, I was executing some queries when I discovered that 7.3.4's CAST is a little different from 7.1.2 when working with timestamps. When working with localized timestamps, I can't use CAST to convert a string for a timestamp anymore. Please take a look in the following scripts. #### PostgreSQL 7.1.2 #### bxs=# SELECT timeofday();

I am rather new to PostgreSQL.What I am looking for ist this: An example database that demonstrates the usage of all the core PostgreSQL features. It is one thing to read extensive documentation, but it is much more intuitive for me to see an example database, that demonstrates the whole thing interacting. I mean, not just the basic...

We accidentally created a table called user in our public schema. We are now trying to remove the table using DROP TABLE user and even DROP TABLE public.user. However every time we try we get an error message: ERROR: parser: parse error at or near "user" at character 12 Any suggestion on how to remove this table? I thought maybe going...

-- Petre Daniel,System & Network Administrator. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

I want to be able to generate SQL statements that will go through a list of data, effectively row by row, enquire on the database if this exists in the selected table- If it exists, then the colums must be UPDATED, if not, they must be INSERTED. Logically then, I would like to SELECT * FROM <TABLE> WHERE ....<Values entered here>, and then...

Please see the attached file for details. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

tried "US_EN", "us_EN" and "", all failed..... -- --Chris ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

Marc, I'd be interested in seeing the updated stats for this bought of virus transmission we're going through. Yesterday you had almost 1 for 1 valid email. By then I think I was getting about 3-4 per valid email but since then it's sky rocketed and it looks more like 30+ per 1 valid message. I'd just be interested if that's the same...

Is there a way to get a list of all the currently open transactions on a database? Joseph

Hi, Up until a few days ago, when I did a "Reply to List" in my MUA (Evolution 1.4.4), only pgsql-general@postgresql.org would show up in the "To:" list. Now, "Reply to List" acts like like "Reply to All". The reason I bring this up in pgsql-general@postgresql.org is that "Reply to List" still acts properly wrt...

Hi, I have a table with two column, date and data I would like to do a set of queries to generate statistics on the data, such as count(data) for month blocks and year blocks. What is the best way to accomplish this? dd/mm/yy date | data ---------------

Is it bug? CREATE TABLE base ( base INT PRIMARY KEY ); CREATE TABLE child ( val INT ) INHERITS ( base ); CREATE TABLE ref ( atr INT , base INT REFERENCES base ON UPDATE cascade ON DELETE cascade ); INSERT INTO child VALUES ( 1, 2 );

To all French speakers on the list, I am pleased to announce the start of a PostgreSQL general mailing list in French. Its name is pgsql-fr-generale. I hope many of you will join it so that we can make it an interesting place. Ever since Justin "promoted" me to French advocacy contact I received several requests for information from...

I have trouble: when client-program broke connection to Postgre I see in logs: FATAL: This connection has been terminated by the administrator. LOG: shutting down and I must start Postgre again. Postgre starting as: pg_ctl -D /usr/local/pgdata -o \"-S\" start

Hi, sometime ago I heard that there will be a native win32 version of postgresql 7.4. Is this true or will there only be a cygwin version like now? What do you think, how stable and fast is the cygwin version? Best regards, Christian

I have one process which writes a single float into 300 columns once per second. I then run 4 process, from remote computers, to query a small subset of the latest row. I have even commented out everything in the query programs, all they do is sleep, and the associated postmaster still sucks up 15% - 20% CPU. Computer is a P4 /w 1Gig...

Alright, we are testing pg_restore while restoring a 7GB database. This database has about 6GB of large objects and about 1Gb of textual data. The problem has been verified on PostgreSQL 7.3.2, PostgreSQL 7.3.3 and Mammoth PostgreSQL 7.3.4 . The command being used to backup the data is: /usr/local/pgsql/bin/pg_dump dominion -h localhost...

Greetings, I'm getting a big performance problem and I would like to ask you what would be the reason, but first I need to explain how it happens. Let's suppose I can't use sequences (it seams impossible but my boss doesn't like specific database features like this one). For sequence simulation I had created a table called...

Here's what I have (simplified) SELECT t1.fid, t1.t1_data, t2.vid, t2.t2_data, t3.t3_data FROM t1, t2, t3 WHERE t1.fid = X AND t2.vid = Y AND t3.fid = t1.fid AND t3.vid = t2.vid Now, I discover that the record in t3 may not always exist, so somehow I

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, Postgesql v7.3.2, os/2. I am using JDBC to connect to the dbms. After a few program open/close I get the message "Sorry, too many clients already". Supposedly my database class properly closes the connection when it is removed. Maybe not. How do I see who and how many connections there...

Hi all, I just received a call for presentations from the Linux Solutions 2004 conference in Paris. This seems to be quite a big thing, with IBM as a sponsor and bigwigs from IBM as speakers (see their web site: http://www.linuxsolutions.fr/EN/home/index.php?site=default). It seems that they wouldn't want a talk strictly about PostgreSQL,...

Hello everybody. Sorry for my english, it's no my native language. So I have problem with my PostgreSQL 7.3.3 server. Untill now everything works fine, but now I get lot's of errors: Warning: pg_exec() : Query failed: ERROR: cache lookup of relation 149064743 failed . in table.php on line 169 Warning: pg_exec() : Query failed: ERROR:...

I was recently running into performance problems with a query containing now()::date or CURRENT_DATE. When I went to debug, 'now'::date made efficient use of the index (on a timestamp field). The docs say that 'now' is turned into a constant right away. Is this overhead/poor planning simply because 'now' gets converted to a constant so...

I need to compute the difference of Time fields, in the format HHMM. Is it possible to do the math in the Select? Regards, BTJ -- -----------------------------------------------------------------------------------------------

Hello all, I am working on setting up a table that will append a sequence to the end of the value inserted. Example; INSERT INTO test (test) VALUES ('abcd'); And have the data in the database be; abcd0001 Now I do have things setup else where were the default value for the field