PostgreSQL Database Forum

Hi, I have a column with a sequence in a table and want to allocate the first 200 for special purpose thus starting the sequence from 200. For the first 200 I have entries that will be added and removed. Is there an easy way to write a select statement that returns me the frist free number or any within the range of 200? For example if...

Hi All, Is it possible to find the size of a pgsql table. TIA -- regards, Deepa K

Hi All, Is it possible to find the size of a pgsql table. TIA -- regards, Deepa K

Hi ! We are moving to PgSql application, with 'typical' style of work. Thin client, huge database. From database is (also) generated whole website. I will use it for explain my current todo. Right now, I am before solving following problem: Someone starts (let's say) adding 'new product'. It mean, he have to add records to many tables,...

Hi, is there a way to display the table in CSV format or write a query in csv to a file ? Alex ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command

I checked the 7.4 PL/pgSQL docs but couldn't find a concise grammar description e.g. a BNF diagram...is any such thing available online ? I'm looking to possibly port a stored procedure debugger I'm writing to support Pg. (I'd prefer *not* to wade thru a lex/yacc definition) TIA, Dean Arnold Presicient Corp.

Is there a tool for designing databases(ERD to data Design) and being able to generate scripts or databases from the tool. Visio does a good job, but does not have a driver for PostgreSQL. The scripts have to be modified before executing. Thanks, Thomas LeBlanc _________________________________________________________________

Hi All, Is it possible to find the size of a pgsql table. TIA -- regards, Deepa K

Hi All, Is it possible to find the size of a pgsql table. TIA -- regards, Deepa K

Hi All, Is it possible find the size of a pgsql table. TIA -- regards, Deepa K

Hi, is there a way to display the table in CSV format or write a query in csv to a file ? Alex ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command

Hello, it seems my postgresql data has somehow become corrupted (by a forced shutdown I think): psql template1 -U shadow Password: ERROR: nodeRead: did not find '}' at end of plan node Welcome to psql 7.3.4, the PostgreSQL interactive terminal. Type: \copyright for distribution terms

Hi, everybody! Here is a weird problem I ran into with 7.3.4. This is the complete test case: rapidb=# select version (); version ------------------------------------------------------------- PostgreSQL 7.3.4 on i686-pc-linux-gnu, compiled by GCC 2.96 (1 row)

Did a pg_dumpall from my production database (7.3.2) and I tried to restore to my Dev database (7.4). I receive a data exception error during the import and was stupid enough not to write it down. Is there a log some place I can look to see what the error was? Also, what does one do when the dump file over 5 gigs? How can I possibly...

Hi, I found a strange behavior in PostgreSQL. I created a table as user pippo then I created a view based upon this tables, latter someone drops user pippo and now when I do: select from view PostgreSQL show me this: pg_aclcheck: invalid user id # I suppose it is because the user pippo the owner of this view, is any

Hello. I have a 2 files: test.h and test.pgc. In test.h, I defined: typedef struct { long curid; char curnombre; char curfecha;

In looking at top, I have noticed when doing some long queries that RAM memory is only being used at 1-3%. While, CPU often jumps to 97, 98, even 99% utilization (which is great!). Is this normal for RAM utilization? If not, how can I better utilize my RAM during queries and or general processing?

SuSE RPMs for PostgreSQL 7.4 are available at ftp://ftp.postgresql.org/pub/binary/v7.4/suse or a mirror http://www.postgresql.org/mirrors-www.html or at

Hello, it seems my postgresql data has somehow become corrupted (by a forced shutdown I think): psql template1 -U shadow Password: ERROR: nodeRead: did not find '}' at end of plan node Welcome to psql 7.3.4, the PostgreSQL interactive terminal. Type: \copyright for distribution terms

Hi, I found a strange behavior in PostgreSQL. I created a table as user pippo then I created a view based upon this tables, latter someone drops user pippo and now when I do: select from view PostgreSQL show me this: pg_aclcheck: invalid user id # I suppose it is because the user pippo the owner of this view, is any

Hello There , I hope u answer these questions: I have installed postgresql DBMS , with SQL_ASCII encoding, so far, it is working ok, I think I might have probelems when manipulating the strings(substring, lenght), but now I don't do i. Could anyone tell me , with reasons, the best encoding? Also I would like to do text search, I 'd like to...

I've two questions, they may or may not be related - 1. I copied the entire data directory from postgreSQL 7.3.2 (AIX4.3) to the installation postgreSQL 7.3.4 (AIX5.1), the same filesystem setup. I didn't do an dump/reload process since the copy process is faster. Is it OK to take this shortcut in postgreSQL? any side-effects? 2. The...

I am looking at PostgreSQL as a possible option for our backend database. I am also evaluating Oracle. What kind of paid support does PostgreSQL offer? Jason Tesser Web/Multimedia Programmer Northland Ministries Inc. (715)324-6900 x3050 ---------------------------(end of broadcast)---------------------------

Is dump-->initdb-->reload required for RC2 --> 7.4 ? Regds Mallah. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your

Hello I like to grant some permissions to the user www-data (default user for apache under debian) GRANT SELECT, UPDATE, INSERT, DELETE ON customer TO herbie, www-data; The statements throws the following error: ERROR: parser: parse error at or near "-" at character 64