PostgreSQL Database Forum

I have the following view definition Column | Type | Modifiers ----------------+-----------------------+----------- bcode | character varying(15) | subhead | text | sc_description | character varying(60) | Budget | numeric | expenditure | numeric ...

Hi, How can i draw the results of a SELECT in to a file in the filesystem ? Warm Regards, Mário Gamito ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, I wasn't able to get a usable answer by googling: Is there a way to create a view on a table that converts rows to columns ? Example: I have a table

Hi, I'm not able to compile libpq for Windows environment using the 8.0.0 beta 1 source tree. I got the following errors (The entire compilation output is listed below): C:\temp\postgresql-8.0.0beta1\src>nmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights...

Hi, I would like to stop the postmaster every night and run vacuum pg_dump reindex in the stand alone backend.

I think this is just a bad case of "nested loops are costed wrong". But it's a really really bad case. Like, even without any overlap in records looked up in the nested loop I cannot imagine it ever being the wrong plan for these stats. And Postgres is insistent on avoiding it, I have to disable both merge and hash joins to get the 5ms nested...

Are there any python drivers that work with the version 8 beta? The version seven ones didn't. Thanks, Tim ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

Hi! I have a debian woody with postgresql 7.4.2. When i try to use pg_dump i get the next error: pg_dump: saving encoding pg_dump: saving database definition pg_dump: SQL command failed pg_dump: Error message from server: ERROR: relation "pg_user" does not exist pg_dump: The command was: SELECT (SELECT usename FROM pg_user WHERE...

hi! i need a list of all primary keys in my database! for this reson i build these sql-statement: /SELECT pg_class.relname AS tableName, pg_constraint.conname AS pkName, pg_constraint.conkey AS columns FROM pg_catalog.pg_constraint INNER JOIN pg_catalog.pg_class ON pg_constraint.conrelid = pg_class.oid

ERROR: duplicate key violates unique constraint "pg_class_oid_index" I found a post earlier but wanted to post up my info as the other persons did not look like the same type of error: I tried to cluster the isbn_table cluster isbn_index_code on isbn_table; ERROR: duplicate key violates unique constraint "pg_class_oid_index" The...

Hello List, I'm having this issue with beta 8.0 C:\pgsql\bin>pg_dump -U postgres farmacia > xfar.sql Password: C:\pgsql\bin>psql -U postgres farmacia2 < xfar.sql Password: psql: FATAL: Password authentication failed for user "postgres" C:\pgsql\bin>psql -U postgres -W farmacia2 < xfar.sql

Hi, I recently downloaded source code for 8.0.0 beta1. When I tried building the libpq for windows, I got some compilation errors. Following the compilation output: C:\temp\postgresql-8.0.0beta1\src>nmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights...

We're having a lot of trouble with one of our new servers. It's an AMD64 dual cpu system, running on Gentoo Linux, with kernel 2.6.7. Data is stored on a JFS partition. Before we installed the server, memory was fully tested and no problems were found. Postgres is version 7.4.3. We've had a number of different errors. One of the most...

Hi, For various reasons (parallel structure with existing code, commonality of concepts, etc), we have C language functions implemented that use libpq to make a new connection to the same Postgres server. Yes, I realize libpq is meant for clients and SPI for backends. The question is, are there any technical problems with this? Will using...

I expected Postgresql to use an indexed access method, but in certain cases it is using a sequential scan. Details are below: Table: P1_NRN_ROAD ( sobjid int8 primary key, v int8 not null, ord int2 not null)

Hi everyone, I'm trying to calculate an output column which is the difference of two other columns in the query output; the first column is an aggregate of items in stock, while the second column is an aggregate of items which have been used. The third column should should be the difference of the two values so I can then output all three...

As far as I can tell, Postgres has no equivalent to greatest and least functions in Oracle. Yes, you can do the same thing with a case statement, but at the expense of writing MUCH longer SQL statements. Is this something that is on or can be added to the 'to do' list? I could write a series of user-defined functions to do specific...

Hi list, My boss would like to convert from MySQL to PostgreSQL, but there are a few things that hold us back. We'd like to have the databases in several physical servers, with referential integrity between the tables. Reading from Oracle articles, their referential integrity can be done using their dblink and triggers. What I'd like...

Hello ! I've installed the Beta 1 on Win XP Pro, it seem working correctly. I load a database from Linux 7.4.3 with pgdumpall, it works too. But I can't connect from other PC over the LAN (I modified pg_hba.conf for the hosts). If I write in postgresql.conf : tcpip_socket = true port = 5432 I can't connect from the LAN, NEITHER from the...

Hiya I am writing a daemon in C which monitors a table stored in postgres. I would ideally like the daemon to be able to withstand things such as the db connection going away or the db being shutdown, and simply keep trying to connect rather than just fall on it's face. Is there a way that I can catch a server shutdown/connection loss...

hi, how can i show all the columns and its data types? i create the following sql-statement but it only gets me a reference of the data types, how can i replace the reference? /SELECT pg_class.relname, pg_attribute.attname, pg_attribute.atttypid FROM pg_catalog.pg_attribute, pg_catalog.pg_class WHERE

Hi, I have a table where in lot of triggers were included in that as shown below. How to view/access triggers and procedures from postgresql. I am using postgresql 7.4.1 on solaris. regds -raju

Hello all, I am testing PostgreSQL 8.0 beta on a windows xp professional. In the time when I did the install I have been working with pgadmin and so on... But after a few days, when I tried to continue with my tests. I cannot start the postgresql service. I always get this message windown when I try to start the service:

I've probably asked this question before, but what do people do when they need to restore a table that has been dumped but as a different table name? That doesn't appear to be an option in pg_restore. (Is that just a front end to psql?) I need both the old table and the live one in the same database so that I can compare a set of values...

Hello all, I have a question about "date" & "timestamp" types in PostgreSQL. I want to setup the default value '0000-00-00' and "0000-00-00 00:00:00" for them. However, it seems that PostgreSQL does not support it. Could someone helps me please? The example table: T1 (col1 varchar(7) not null,