I am trying to track down a method of determining what a sequence name is for a SERIAL is in postgresql. For example, CREATE TABLE foo (id SERIAL...

Robby Russell

10-28-2004 08:40 PM
Alvaro Herrera

Just wondering - does PG support derived tables? I'm not really sure what the difference is between them and...

CSN

10-28-2004 06:39 PM
Tom Lane

I have 2 existing tables in my db: iss=> \d pollgrpinfo Table "public.pollgrpinfo" Column | Type |...

George Woodring

10-28-2004 04:59 PM
Edmund Bacon

Hi all, I am wandering about the pros and cons of creating a separate serial field for a primary key when I already have a single unique field. This...

Sally Sally

10-28-2004 03:13 PM
Sally Sally

Hi, My boss wants to add a special type of logging to some of our tables on update/delete/insert. I need to log who, when, table_name, field...

Tim Vadnais

10-28-2004 01:35 PM
Michael Fuhr

Hello everyone: I'm a PostgreSQL newbie, working now with dates, times, timestamps and intervals. I have three questions about the...

Ricardo Perez Lopez

10-28-2004 01:20 PM
Bruno Wolff III

Background Info: I have a table with a approx 2.5 million rows. The table often gets 200-300 inserts per second. We are see that the database...

Brian Maguire

10-28-2004 11:47 AM
Tom Lane

I seem to remember reading a post on this, but searching marc does not seem to bring it up immediately. Company BBS is on postgresql, but it's still...

Joel

10-28-2004 10:37 AM
Andrew Sullivan

Hi guys, Is there a way I can separate things in PostgreSQL? Putting tables in a disk partition and indexes in another one????? Regards, MaRcELo...

MaRCeLO PeReiRA

10-28-2004 10:25 AM
MaRCeLO PeReiRA

I just did a dump and restore of my database and one of my views did not recreate. The error received was : pg_restore.exe: could not execute...

Sim Zacks

10-28-2004 02:54 AM
Sim Zacks

Mariusz =?iso-8859-2?q?Czu=B3ada?= <manieq (AT) idea (DOT) net.pl> writes: AFAICS this would require a code body approximately as...

Tom Lane

10-27-2004 09:34 PM
Tom Lane

On 7.4.6, is there any problem with defining one column of a view to be a string literal? For example ... $ psql -c "create view fooview as select...

Ed L.

10-27-2004 07:36 PM
Ed L.

How can I calculate the number of second in some interval? Neither the secods part, nor the seconds after midnight... Just the full quantity of the...

Denis Zaitsev

10-27-2004 06:52 PM
Michael Fuhr

On Tue, Oct 26, 2004 at 06:21:23PM +0200, Thomas Hallgren wrote: The problem is that in DELETE, there is no FROM clause in the sense there is with...

Philip Hofstetter

10-27-2004 05:26 PM
Tom Lane

Is there a way to define a foreign key for the values of an array? For example, if table T1 is having a colum A which is defined as integer can I...

Daniel Savard

10-27-2004 03:44 PM
Daniel Savard

Ok, I have a query that runs fine in oracle: select driver_id, 'GREEN' as color, pos_date, pos_lat, pos_lon from driver_pos where driver_id =...

Naeem Bari

10-27-2004 02:09 PM
Alvaro Herrera

Can too many btree indexes cause page level locking? I read this... http://www.postgresql.org/docs/7.4/static/locking-indexes.html

Brian Maguire

10-27-2004 01:59 PM
Alvaro Herrera

I have a simple function defined thusly: CREATE OR REPLACE FUNCTION datemath(timestamp with time zone, int4, varchar) RETURNS timestamp...

Naeem Bari

10-27-2004 11:56 AM
Thomas F.O'Connell

Psycopg and probably PySQL seem to have decided to return a "float" type when libpq returns a string tagged with the "numeric" property. This can...

Jerry LeVan

10-27-2004 11:40 AM
Jerry LeVan

Hi. i have table like this: create table my_data ( cond_1 int8,cond_2 varchar(),cond_3 .... cond_n whatrver ,data text) This table represents a...

NTPT

10-27-2004 11:33 AM
NTPT

Hi Forum, Is there a way to change the database access permissions for different IP addresses without having to re-start PostgreSQL? I often want...

Carlos

10-27-2004 10:05 AM
Carlos Oliva

---------------------------- Original Message ---------------------------- Subject: Abrupt close of pgsql backend From: "Deepa K" <kdeepa (AT)...

Deepa K

10-27-2004 08:56 AM
Andrew Sullivan

Hi, is it possible to write a trigger, using pl/pgSQL, that updates tables in a different database than the one the trigger is called from? If it...

Henriksen, Jonas F

10-27-2004 08:04 AM
Karsten Hilbert

hi, I need info on the caracteristics of object relational databases and their advantages as well as disdvantages in comparison to relational...

mayra

10-27-2004 03:43 AM
Thomas Hallgren

Hi, the restoration of a dump stops at the line above. The dump was created with pgsql 7.3.2 and I need to pump it into a 7.4.3 one. Should anybody...

Együd Csaba

10-27-2004 03:02 AM
Együd Csaba

Is there a simple way to list fieldnames in a table, from PHP? When on the command-line, I just do \d tablename But how to get the fieldnames from...

Miles Keaton

10-27-2004 12:02 AM
GreyGeek

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 - --------------------------------------------------------------------- PostgreSQL RPM Set...

Devrim GUNDUZ

10-26-2004 07:48 PM
Gaetano Mendola

Hi folks, 8.0beta3 has pg_autovacuum included, when I want to run this as a Windows service, it says you can use the -I and -R options. When I do...

Leen Besselink

10-26-2004 06:20 PM
Leen Besselink

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, (S)RPMs for new point releases...

Devrim GUNDUZ

10-26-2004 06:15 PM
Devrim GUNDUZ

I'm attempting to debug a script that should perform a simple INSERT of values, but for some reason doesn't. The insert appears to occur...

Scott Frankel

10-26-2004 05:33 PM
Scott Frankel

I'm trying to properly tag the types of the parameters I'm passing into PQexecParams, as it seems to be the right thing to do, and it's not that big...

Dan Sugalski

10-26-2004 03:59 PM
Dan Sugalski

When trying to connect to database via the pgAdmin3 GUI it asks for a password. I use the same passworrd as I did when I connect to the DB...

Philip Pinkerton

10-26-2004 03:54 PM
Jaime Casanova

Hello Harrison Fisk from MySQL claims in this thread: http://forums.mysql.com/read.php?35,3981,4245#msg-4245 That there are no major differences...

nd02tsk@student.hig.se

10-26-2004 12:10 PM
Andrew Sullivan

Hi Posgres users/developers, Can anyone explain why PosgreSQL (version 7.4.5 on Linux) does a full table scan to compute a count(*) on a base table...

Henk Ernst Blok

10-26-2004 11:04 AM
Henk Ernst Blok

Valentin Militaru wrote: Well, that's an argument for surrogate keys, which will invoke a philosophical war amongst purists that I won't...

Mike Mascari

10-26-2004 10:55 AM
Stephan Szabo

We are running Postgres 8.0 beta (ver 3), and are running into the following message while accessing the table through ODBC from PC-SAS: CLI...

Taber, Mark

10-26-2004 10:37 AM
Taber, Mark

On 10/25/2004 3:33 PM, Franco Bruno Borghesi wrote: Because the internal variable for NEW is initialize to NULL and returning NULL from a BEFORE...

Naeem Bari

10-26-2004 08:56 AM
Richard_D_Levine@raytheon.com

hi, can anyone give me some info on the caracteristics of object relational databases and their advantages as well as disdvantages! thanx in...

Mayra

10-26-2004 05:55 AM
Jeff Davis

Hello ! To kill a session i used KILL -INT <PID>. This command wasn't successfull. The processus is still here when an 'ps ax' or a 'select * from...

HM

10-26-2004 04:26 AM
HM

Hi, I am using postgresql 7.1.3 in RedHatLinux 7.2. Can anyone tell me how to connect with postmaster through TCP socket (it is started with...

Deepa K

10-25-2004 09:02 PM
Neil Conway

After 4 weeks of work, involving alot of bug fixes, and documentation improvements, to the source tree, we have just released our 4th Beta of 8.0.0. ...

Marc G. Fournier

10-25-2004 08:13 PM
Marc G. Fournier

Hi: I'm trying to dump tableA and restore it to tableB: $ ./pg_dump -Fc -t tableA databaseA -f tableA.dump -v $ ./pg_restore -t tableB -d databaseA...

ruben

10-25-2004 07:45 PM
Tom Lane

I have a process that hangs doing a "drop schema cascade delete". This happens in a slonik command, which runs fine if I run it directly from the...

David Parker

10-25-2004 07:15 PM
Tom Lane

i installed mandrake 10 on my pc, and i choose postgresql as db, i installed it before in windows, but in linux i dont have idea what happends,...

Rick

10-25-2004 07:10 PM
Uwe C. Schroeder

Use python's (or another language) CSV reader module which will parse the quotes for you and write the values in a tab-delimited file. Don't...

Pierre-Frédéric Caillaud

10-25-2004 06:55 PM
Pierre-Frédéric Caillaud

ok, this is what's going on. i have this VB.NET <http://www.experts-exchange.com/Databases/PostgreSQL/Q_21177281.html> application with...

Vassilev, Lubomir G.

10-25-2004 05:54 PM
Oliver Elphick

Hi, In the 7.4.5 version, the code is now trying to use a much larger value for shared_buffers. I can certainly set this to a lower number with the...

Glenn Sullivan

10-25-2004 05:08 PM
Tom Lane

I'm running into some problems with arrays in my SQL which're giving me fits. I've got some SQL statements that I'm issuing from my app using...

Dan Sugalski

10-25-2004 03:45 PM
Tom Lane

How can I combine these two queries? # select viewerid,count(*) from viewer_movies group by viewerid order by viewerid; viewerid |...

Mark Harrison

10-25-2004 03:18 PM
Jeffrey Melloy

Hello, As the amount of simultaneous users of my database grows (25 users sometimes, PGSQL 7.4.5), deadlocks are unfortunately more and...

Philippe Lang

10-25-2004 12:57 PM
Tom Lane