Forum: PostgreSQL / PGSQL

On Thu, Jan 20, 2005 at 02:48:40PM +0100, Alban Hertroys wrote: My guess is that the \0x00 is being expanded to a null. If you want a circumflex,...

Hi, How to set such variable after (during?) client connection (PHP)? I want to use it in view - so view could depends on it: If I could set...

Hi, i have a unique index on a table over multiple columns. If now one of the records has a null value in one of the indexed columns i can insert...

Are there any 'pen tests' that one could run that checks the security of your Postgresql instance? I don't think postgresql has any default...

Hello, I am an Oracle DBA and I want do a Postgresql 'proof of concept' at the large corporation where I work to test the benefits of using...

It depends how you have your Oracle instance configured. If you have it set up so that the total SGA and UGA ammount consume around 80%-90% of...

On Thu, 20 Jan 2005 simon@2ndquadrant.com wrote: I may add that using the right tool for the right task should be a priority. It's easy to...

Server Box (): Pentium 3 FreeBSD 5.3 Samba 3.0.7 connection to a windows 2000 LAN Samba on the freebsd side has the following smb.conf: ...

Hello all, I wrote a function which counts price of product from retail price and discount. It works. But I need to count price with tax of same...

Hello, is there a way to easily configure postgresql to auth with pam on debian? thanx a lot! Bruno ---------------------------(end of...

I've got a question about how PL/PgSQL passes things to the planner based on statement logging. E.g., I have a statement like this in PL/PgSQL: ...

Hi Often I find myself working in a query where I need to select one or two fields from source table A as renamed objects ( usually to prevent...

I recall this being discussed before, but I couldn't manage to find it in the archives. Is there any way to see how many rows a running...

Hi all; I have recently contributed a wiki to another open source project (SQL-Ledger) and have received a fair bit of positive feedback and...

Hi, I have a small data base ~ 10 tables. each table get insert/update/delete few times a day. postgresql is running for a month. The load will...

I have a table where one of the columns is a library of congress number. I would like to be able to ORDER BY this column. Currently, the...

Opps... resending to list as well. Perhaps someone can add more insight below. And check the documentation at...

I am seeing some unexpected results for an ORDER BY in a query. It looks to me as if the sorting is confused about how to handle the slash or...

Hi all, I just installed pg 8.0 on freeBSD 5.3. All is ok, but if I try to increase max_connections to 256 (or more) pg do not starts. ...

We had a significant production outage with a box running 8.0 Beta 4, 140GB data, 190GB index. We think it was a bad RAID controller card. Our...