PostgreSQL Database Forum

I want to create a rule that transforms a query on one table to a query on many with table names and columns named after one of the columns in the fake table. e.g.: select a,b,c from foo where b='x.1' or b='y.1' or b='y.2'; to:

Hi, I wanted to get the primary keys' column names and data types for a particular table created. Although I only created one primary key involving 2 columns for the table, my select query below return all the column. Below is the screenshots. I'm on Linux Slackware v9.0.0 kernel v2.4.21. I'm still quite new with postgreSQL so I'll be...

Almost all of my foreign key definitions are NOT present in pg_constraint. However, they do exist as triggers. It appears that *new* foreign keys, whether defined in new tables or added on via "ALTER TABLE" commands, make it into pg_constraint, but the "old" stuff that was present from before our 7.3 upgrade, exists only as triggers. 1) Is...

Hi, I need to query each column's constraint and name of a table in postgreSQL v7.3.4 with a single SQL query but don't know how. Would appreciate any pointers! Thank you. Regards, Damon

Can anyone help me out the explanation why the new version of postgresql called peerdirect and what peerdirect exactly means? -- Bharani Posted via http://dbforums.com

Hello all, I have a table with among other things a timestamp field. To get the count of records per hour I do: select count(*) as c, date_trunc('hour', timestmp) as h from mytable

Hi I have install bin pack of PostgreSQL 7.3.1 on Windows 2000 Server, i try to run it as LocalSystem User, but dosen't work I download libpq.dll and put it on C:\Winnt\System32 but this don't help - what can I do to run this service ?? When i try to do that I have error like this: Can't find describe for id (0) in source ( PostgreSQL...

Hi, I am looking for a database engine which: 1) runs under Windows (multiple versions) 2) Can be redistributed without additional fees as part of another product Is postgresql appropriate for this?

Hello! I need a mdb 2 PostgtreSQL migration tool (something similar to pgAdmin plugin - "Database migration wizard") that don't needs M$ Windows or XWindow. It should also transfer data and relations (!) from .mdb database. I wondering anybody knows a tool with this functions? Or maybe there is another way? mdb -> txt -> pgsql??? Thanks for...

I've been hitting the DB books lately and I was wondering if anyone knows where features like "CREATE ASSERTION" and sub-selects in CHECK constraints stand in the TODO queue for production PgSQL. Are they even in development at all? Or have they been written off as too expensive? I did see somewhere that a developer version of the Pg server...

I everebody, it's possible to reinitialiser the meter of oid, after drop a database and before recreate it. I need a solution because I have negative oid, and this make problems Think for your solution, and sorry for my english writing lionel

I wrote a function that basically executes a dynamic query and returns True if there is at least one record and false in not. CREATE OR REPLACE FUNCTION RecordHasChild (table1, CHARACTER, CHARACTER) RETURNS BOOLEAN AS ' DECLARE childrec RECORD; sqlquery text; BEGIN sqlquery = ''SELECT field1 FROM '' || $2 || '' WHERE ('' || $2

Hello When we create a table, what is the difference between the REFERENCE constraint on column and the FOREIGN KEY constraint on table ? I guess that the FOREIGN KEY constraint assures us that the referenced column is a PRIMARY KEY in an another table. You can reference any colums with the REFERENCE constraint on column. Am I right?

Hello I have database: base and user: vertigo. When i log into that database from pgsql: #psql base -U pgsql and try to give user vertigo all righst: base=# GRANT ALL ON DATABASE base TO vertigo\g ERROR: parser: parse error at or near "base"

waiting for postmaster to shut down...LOG: received smart shutdown request ..LOG: shutting down ...LOG: database system is shut down done postmaster successfully shut down LOG: could not bind socket for statistics collector: Cannot assign requested address LOG: database system was shut down at 2003-11-26 14:13:05 MET LOG: checkpoint...

I'm having a problem with a table that accidently had a column added whose type is the same as the table. This is seriously creating a problem as I cannot delete the table and I really don't have the ability to destroy the database (with all the other tables) just to get rid of this. Does anyone know of a way to get the database to allow a...

Hi, I have a dump with a table with this field: "hdstart" integer which contains integer like 1042758000 1028152800 etc etc How can I convert it to a SQL Server DateTime field? Thank in advance and sorry for my bad english...

Is it reasonable to have a table with about 300 columns? There will be about 2500 rows. The data does not normalize. The alternative would be about 30 tables of about 10 columns each (all 30 tables with about 2500 rows). If I do this, about half of the selects will be against one table, but the other half will require joins of all 30. ...

Hi all, I need to filter out rows like 'A <number>' where the second character=space character. To start with I have the expression: ~* '^A' which will filter out any row starting with 'A'. Now there must be something to indicate the space character. (in Perl '\s' defines <space> but not in Postgres it seems)

Is anyone out there using PostGIS in a production environment? If so does anyone know how well if at all postgresql/postgis work with the likes of ArcSDE and so on? Also if anyone out there reading this is a contact at ESRI that knows the behind the scenes support for postgresql Id like them to contact me. I have attempted to find someone...

Hi everyone...my name is Mike MacEachern. I work with a technical search firm in Toronto - ARES Consulting A client of mine in Toronto is keen to hire a solid Postgres DBA --they're very hard to find! . If anyone would be interested please give me a call. Thanks To discuss this position further please contact Mike MacEachern at...

Hello, I have a question about pgplsql: Is it faster to execute a compact function (with minimal spaces and comments) than a function with many comments and many spaces? In others words, which one will be faster? AAAAA_function or BBBBB_function ?

Hi, I developing a program using postgres and linux like operating system. My problem is this: I have a quite complicated view with roughly 10000 record. When I execute a simple query like this "select * from myview" postgres respond after 50 - 55 minutes roughly. I hope that someone can help me with some suggestion about reason of this...

What is the most appropriate encoding for the UK when creating a database?