PostgreSQL Database Forum

Hi, is it possible to concatenate two rows (same or different data type) into one. like First Name, Last Name or ZIP City etc. Thanks Alex

Hi, I am in the process of porting a number of large MSSQL databases to Postgres. The current id generation model in SQL server is an oracle style sequence generator i wrote using a pretty simple stored proc and table structure. I now need to do the same thnig in postgres.

Hello! I'm currently testing deployment of tsearch2 on our forum table. The table is huge in itself - some 2GB of data without the indexes. I have got PostgreSQL 7.4RC2 running on a test machine, installed tsearch2 to my database, added the new column to the table and tried to update it in the recommended fashion: UPDATE...

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...

Hello, I am having problems running postmaster. I get the following error: DEBUG: invoking IpcMemoryCreate(size=1466368) PANIC: invalid checksum in control file The postmaster then exits.

Hello, i've been reading the README file in the lmgr folder (in src/backend/storage/lmgr/) and i have a couple of questions about locks: - What's the difference between the Lightweight Locks (LWLocks) and the Regular locks (Heavyweight Locks)? For example, if i do a query and it needs a lock, would it be a lightweight one or a regular one? -...

All, Is anyone else having issues installing the SuSE PostgreSQL 7.4 RPMS that was announced on the list the other day? Every time I attempt to build the srpm or install the -server rpm I get a segmentation fault.. Any help would be greatly appreciated, Jordan S. Jones --

I have a java application that pulls data off db2/400 an inserts it into a postgres(7.3.2) database. The jdbc errors out with this message: ConnectionBean: Driver not loaded Something unusual has occured to cause the driver to fail. Please report this exception: Exception: java.sql.SQLException: FATAL: The database system is starting up ...

After almost 12 months of intense development, and testing, we are proud to announce the availability of PostgreSQL v7.4. An overview of the major changes in v7.4 include: IN/NOT IN subqueries are now much more efficient Improved GROUP BY processing by using hash buckets New multikey hash join capability Queries using the explicit JOIN...

Hi list, test=# SELECT 'pg_catalog.pg_class'::regclass::oid; oid ------ 1259 (1 row) test=# SELECT '1259'::oid::regclass; regclass

Hello I need to output a timestamp attribute formatted to fixed-width, no spaces nor separators, something like test=> select to_char(timestamp '2003-10-24 15:30:59.999', 'YYYYMMDDHH24MISS'); to_char ---------------- 20031024153059

Hallo, I tried to compile PGSQL 7.4 and I got error (durring make): ar: command not found What is it? Whe I can found it? I have: $ uname -a SunOS ... 5.8 Generic_108528-03 sun4u sparc SUNW,UltraSPARC-IIi-cEngine

Hi, In 7.4, I noticed there is this ::1 and ffff: (x8 of them) for IPv6. I looked at the documentation and there is nothing that says what the ::1 is for. Commenting out that line will prevent access to PostgreSQL from psql unless I put trust for that line.

Well, now I tried to compile with tsearch2. I do in src direcotry: ../configure then change into contrib/tsearch2 and do make (as I read in manual) and I got:

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

Hallo, I tried to compile PGSQL 7.4 and I got error (durring make): ar: command not found What is it? Whe I can found it? I have: $ uname -a SunOS ... 5.8 Generic_108528-03 sun4u sparc SUNW,UltraSPARC-IIi-cEngine

Hi there, I want to use the RIPE whois server that uses MySQL by default. However I'd prefer a PostgreSQL solution. :-) Does anybody know if there exists a patch to support PostgreSQL? Thanks, Joachim

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...

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 ! 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,...

Is there an equivalent function for bytea columns that works like lo_import? Alternatively, is there a way to copy from a large object to a bytea column from SQL? Or maybe someone has another way of attacking this problem: I've got some Perl code that does this:

Hello All, How to test the "Multiuser testing" in PostgreSQL?. I used the apache bench "ab" tool for this one. The following command execute the "test.php" 50 times concurrently. $ ab -c 1 -n 50 http://127.0.0.1/test.php The test.php file contains the following contents:

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 there, I want to use the RIPE whois server that uses MySQL by default. However I'd prefer a PostgreSQL solution. :-) Does anybody know if there exists a patch to support PostgreSQL? Thanks, Joachim

We have a running server (v7.3) which, over time, seems to accumulate a bunch of "stuck" PostgreSQL instances which appear to be dead inside of a transaction. For example, "ps" reveals many of these: postgres 17683 0.0 0.4 7376 1032 ? S Nov13 0:21 postgres: bryan sourceid 127.0.0.1 idle in transaction As admin, I'd like...