Re: [GENERAL] [HACKERS] urgent: upgraded to 8.2, getting kernel panics

"Merlin Moncure" <[EMAIL PROTECTED]> writes: > On friday we upgraded a critical backend server to postgresql 8.2 > running on fedora core 4. Umm ... why that particular choice of OS? Red Hat dropped update support for FC4 some time ago, and AFAIK the Fedora Legacy project is not getting things do

Re: [GENERAL] pg_autovacuum should allow NULL values

I wrote: > I don't find this particularly important, because we have never intended > direct update of catalog entries to be a primary way of interacting with > the system. The current pg_autovacuum setup is a stopgap until the dust > has settled enough that we know what sort of long-term API we w

Re: [HACKERS] [GENERAL] pg_autovacuum should allow NULL values

On Fri, Feb 23, 2007 at 06:47:52PM -0500, Tom Lane wrote: > I wrote: > > I don't find this particularly important, because we have never intended > > direct update of catalog entries to be a primary way of interacting with > > the system. The current pg_autovacuum setup is a stopgap until the dust

Re: [GENERAL] [HACKERS] 5 Weeks till feature freeze or (do you know where your patch is?)

"Gregory Stark" <[EMAIL PROTECTED]> writes: > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > >> Greg Stark: WITH/Recursive Queries? > > Uhm, I posted two weeks ago saying I had to shelve that temporarily. > > On the other hand I've submitted a patch to reduce the storage overhead of > varlenas u

Re: [GENERAL] [HACKERS] urgent: upgraded to 8.2, getting kernel panics

On 2/23/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Merlin Moncure" <[EMAIL PROTECTED]> writes: > On friday we upgraded a critical backend server to postgresql 8.2 > running on fedora core 4. Umm ... why that particular choice of OS? Red Hat dropped update support for FC4 some time ago, and AFAIK

[GENERAL] General Ledger db design

I hope this isn't too far off topic. I've noticed some discussion about referential integrity, the use of nulls, and database design recently here. This is a real world situation where referential integrity needs to be broken in theory, I believe. Does anybody have any experience or knowledge

Re: [GENERAL] General Ledger db design

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/23/07 20:35, Martin Winsler wrote: > I hope this isn't too far off topic. I've noticed some > discussion about referential integrity, the use of nulls, and > database design recently here. This is a real world situation > where referential inte

Re: [GENERAL] Triggers inherited?

Hi, Am Freitag, 23. Feb 2007, 07:10:06 + schrieb Richard Huxton: > Bertram Scharpf wrote: > >it is very inconvenient for me that triggers aren't inherited: > > Foreign keys too (which are a special type of trigger of course). > > >Is this behaviour to be implemented at any point of time in >

Re: [GENERAL] Installing PGSQL Client

Windows XP Richard Huxton wrote: > > RPK wrote: >> I have installed PGSQL on server. How to install PGSQL client to connect >> to >> the PGSQL database server. > > You've installed on what? Windows? Solaris? FreeBSD? RedHat Enterprise?... > > -- >Richard Huxton >Archonet Ltd > > ---

[GENERAL] Composite Keys

First, can a primary key field be only one? I mean can I define a primary containing two fields. I have a table called "Payments" where there are two fields, "ReceiptNo" and "PaymentDate". If I take "ReceiptNo" only as a primary key then chances are of "primary key violation". Because in some pl

Re: [GENERAL] postgresql vs mysql

On Thu, Feb 22, 2007 at 01:08:04PM +1100, Chris wrote: > In postgres, to stop an empty blank string: > > create table a(a text not null check (char_length(a) > 0)); What's wrrong with using a <> '' sd the check? Or is this just a flavour thing? -- "To the extent that we overreact, we prof

[GENERAL] how to tell if using unnamed paramaterized queries?

I'm using version 8.2.3 and noticed that certain queries take a very long time even though I have partial indexes that it should be using. It uses them and performs very quickly if I hard code the constants and do an explain. I noticed this in the changelog and figured it was the problem but want

[GENERAL] problem installing NPGSQL and pgOLEDB with .NET

I have PostgreSQL 8.2 installed on Windows XP. I installed NPGSQL driver for .NET and tried to register it's dll with following command: regsvr32 c:\windows\system32\npgsql.dll It displays error: "Could not be registered, entry point not found". I copied the NPGSQL driver files in application f

Re: [GENERAL] Composite Keys

RPK wrote: > First, can a primary key field be only one? I mean can I define a primary > containing two fields. As many as you like :) > > I have a table called "Payments" where there are two fields, "ReceiptNo" and > "PaymentDate". If I take "ReceiptNo" only as a primary key then chances are >

Re: [GENERAL] problem installing NPGSQL and pgOLEDB with .NET

RPK wrote: > I have PostgreSQL 8.2 installed on Windows XP. I installed NPGSQL driver for > .NET and tried to register it's dll with following command: > > regsvr32 c:\windows\system32\npgsql.dll > > It displays error: "Could not be registered, entry point not found". regsvr32 is not used for .n

Re: [GENERAL] 5 Weeks till feature freeze or (do you know where your patch is?)

Joshua D. Drake wrote: > Magnus Hagander: VC++ support (thank goodness) I would much appreciate more people testing and commenting on this one, from the version in CVS head. //Magnus ---(end of broadcast)--- TIP 3: Have you checked our extensi

<    1   2