Re: [GENERAL] Encountering NULLS in plpgsql

dev@archonet.com (Richard Huxton) writes: > Randy Yates wrote: >> I wrote a simple pl to compute running sums, but when it encountered a >> null on a float4 value it caused pgadminIII to crash (exited >> abruptly). Is this intended behavior? > > No, but we'll nee

Re: [GENERAL] Table Rows Not Properly Added

PostgreSQL 8.0.3 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 4.0.0 20050505 (Red Hat 4.0.0-4) -- % Randy Yates % "My Shangri-la has gone away, fading like %% Fuquay-Varina, NC% the Beatles on 'Hey Jude'&quo

[GENERAL] Table Rows Not Properly Added

edit the data. Why must I refresh the table before entering further data, and why isn't the primary key autoupdating immediately when I create a new row? -- % Randy Yates % "...the answer lies within your soul %% Fuquay-Varina, NC% &#

[GENERAL] Encountering NULLS in plpgsql

I wrote a simple pl to compute running sums, but when it encountered a null on a float4 value it caused pgadminIII to crash (exited abruptly). Is this intended behavior? -- % Randy Yates % "I met someone who looks alot like you, %% Fuquay-Varina, NC%

[GENERAL] psqlODBC Unicode 8.01.02.00 Driver "Overflows" On MS-Access Dates

and the export aborts. I traced the cause of the overflow to a column that is in MS-Access's date/time format. Is this a known bug? Is there a workaround? -- % Randy Yates % "Bird, on the wing, %% Fuquay-Varina, NC% goes floating by %%% 919-577-9882

Re: [GENERAL] postgresql documentation

Kris Jurka <[EMAIL PROTECTED]> writes: > On Sun, 26 Feb 2006, Randy Yates wrote: > >> I've noticed that the PDF version of the manuals for 8.0 and 8.1 >> are lacking bookmarks and/or TOC and document reference links. If >> this is generated via LaTeX, such

Re: [GENERAL] postgresql documentation

"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > Randy Yates wrote: >> Hi, >> >> I've noticed that the PDF version of the manuals for 8.0 and 8.1 >> are lacking bookmarks and/or TOC and document reference links. If >> this is generated via LaT

[GENERAL] postgresql documentation

Hi, I've noticed that the PDF version of the manuals for 8.0 and 8.1 are lacking bookmarks and/or TOC and document reference links. If this is generated via LaTeX, such links oculd easily be incorporated via the hyperref package. It would make the document much easier to navigate. -- %

[GENERAL] 8.0.0 RC5-2 Processes/Interfaces Under Windows

xe (GCC) 3.4.2 (mingw-special)" -- % Randy Yates % "Watching all the days go by... %% Fuquay-Varina, NC% Who are you and who am I?" %%% 919-577-9882% 'Mission (A World Record)', <[EMAIL PROTECTED]> %

[GENERAL] Report Generation

At the risk of asking an ill-formed oft-asked question that's probably in the FAQ, is there any report generation tools that are particularly suited for use with postgres databases? -- % Randy Yates % "My Shangri-la has gone away, fading like %% Fuquay-

[GENERAL] C++ Class Library for ODBC?

l. It doesn't have to include the kitchen sink! Simplificity and functionality are the prime desires. -- % Randy Yates % "And all that I can do %% Fuquay-Varina, NC% is say I'm sorry, %%% 919-577-9882% that's the way it goes..

[GENERAL] Free Unix-Like ODBC Driver Manager For Win32?

work under such an environment in win32? If not, is there something that will? -- % Randy Yates % "And all that I can do %% Fuquay-Varina, NC% is say I'm sorry, %%% 919-577-9882% that's the way it goes..." <[EMAIL PROTECTE

Re: [GENERAL] Foreign key order evaluation

[EMAIL PROTECTED] (Stephan Szabo) writes: > On Tue, 28 Sep 2004, Randy Yates wrote: > >> Michael Fuhr <[EMAIL PROTECTED]> writes: >> >> > On Tue, Sep 28, 2004 at 01:30:08PM +0000, Randy Yates wrote: >> >> Randy Yates <[EMAIL PROTECTED]> writes:

Re: [GENERAL] Foreign key order evaluation

Michael, Thank you for your responses. Further questions below. Michael Fuhr <[EMAIL PROTECTED]> writes: > On Tue, Sep 28, 2004 at 01:30:08PM +0000, Randy Yates wrote: >> Randy Yates <[EMAIL PROTECTED]> writes: >> > >> > I'm confused. Where is the lo

Re: [GENERAL] Foreign key order evaluation

Randy Yates <[EMAIL PROTECTED]> writes: > Mike, > > I'm confused. Where is the lock? Is it on the 1 record in the model table? > If so, why is that record locked? Is it possible in Postgresql to update > the primary key of a record? Let me also ask why this is a

Re: [GENERAL] Foreign key order evaluation

mebody > else's suggestion for a shared lock on the foreign key, but as far > as I can tell, no such solution has been implemented as of 8.0.0beta3. > > -- > Michael Fuhr > http://www.fuhr.org/~mfuhr/ > > ---(end of broadcast)---

Re: [GENERAL] One Database per Data File?

Christopher Browne <[EMAIL PROTECTED]> writes: > Oops! Randy Yates <[EMAIL PROTECTED]> was seen spray-painting on a wall: >> I'm a complete newbie to postgres so please look the other way if >> these questions are really stupid. >> >> Is it legiti

[GENERAL] Access MDB Schema Import Tool?

Is there a tool that allows the tables and relationships of an Access database to be moved into postgresql (7.4.5)? Sorry if this has been asked before. There also may be new tools that have recently come out. -- % Randy Yates % "Watching all the days go by... %% F

[GENERAL] One Database per Data File?

e.g., that postmaster must have multiple instances going simultaneously? I'm thinking the answer is NO because, for one, the TCPIP connection seems to be to ONE instance of postmaster which then sorts out which database objects are in its container. Am I close? -- % Randy Yates

[GENERAL] Firewall Security Requirements for Postgresql Access

Is opening up port 5432 (R/W both directions) all that is required of a firewall in order to access a postgres database outside the firewall? -- % Randy Yates % "My Shangri-la has gone away, fading like %% Fuquay-Varina, NC% the Beatles on 'Hey Jude'

[GENERAL] Datatypes Documentation

) and the user is left wondering why these datatypes aren't further defined. -- % Randy Yates % "Remember the good old 1980's, when %% Fuquay-Varina, NC% things were so uncomplicated?" %%% 919-577-9882% 'Ticket To The Moon

[GENERAL] initdb crashes under Windows

.. FATAL: lock file "/Gauss/rr/data/postmaster.pid" already exists HINT: Is another postgres (PID 1672) running in data directory "/Gauss/rr/data"? initdb: failed [EMAIL PROTECTED] ~ -- % Randy Yates % "Rollin' and riding and slippin' and

[GENERAL] cygserver -S crashes under Windows 2000/cygwin

$ /usr/sbin/cygserver -S Segmentation fault (core dumped) [EMAIL PROTECTED] ~ $ -- % Randy Yates % "...the answer lies within your soul %% Fuquay-Varina, NC% 'cause no one knows which side %%% 919-577-9882% the coin

[GENERAL] building postgres for windows 2000?

Has anyone successfully done this? I've got cygwin and the very first step crashes - bash-2.05$ pwd pwd /cygdrive/e bash-2.05$ cd postgresql-7.4.5 cd postgresql-7.4.5 bash-2.05$ ./configure ./configure bash: ./configure: bad interpreter: No such file or directory bash-2.05$ -- % Randy

[GENERAL] Another Security Question: User-based Roles vs. Application Business Rules

Is this a good approach? Is there better way to do this? Is there an altnerate way to consider? -- % Randy Yates % "My Shangri-la has gone away, fading like %% Fuquay-Varina, NC% the Beatles on 'Hey Jude'" %%% 919-577-9882%

Re: [GENERAL] Postgres and Tools Intro?

Hi Jeff, THANKS for the pointers - much appreciated! --Randy Jeff Eckermann <[EMAIL PROTECTED]> writes: > --- Randy Yates <[EMAIL PROTECTED]> wrote: > >> Hi Richard, >> >> Thanks for writing. Basically I'd like to know what >> the core >&