Re: [GENERAL] Proper entry of polygon type data

consultant NIWA, Wellington New Zealand Peter Willis pet...@borstad.com 03/24/09 10:35 AM Hello, I would like to use 'polygon' type data and am wondering about the entry format of the vertex coordinates. Are the coordinates of the polygon type to be entered one entry per polygon vertex, or one entry per

Re: [GENERAL] Proper entry of polygon type data

Mark Cave-Ayland wrote: Peter Willis wrote: Incidentally, PostGIS uses PostgreSQL polygon, point, and path data types. Errr... no it doesn't. PostGIS uses its own internal types to represent all the different geometries, although it does provide a cast between the existing PostgreSQL types

[GENERAL] Proper entry of polygon type data

Hello, I would like to use 'polygon' type data and am wondering about the entry format of the vertex coordinates. Are the coordinates of the polygon type to be entered one entry per polygon vertex, or one entry per polygon edge segment? For example: I have a triangle with vertex corners A, B,

Re: [GENERAL] Question about accessing current row data inside trigger

Hello, This issue is resolved. I was using the wrong struct. Peter Tom Lane wrote: peter Willis [EMAIL PROTECTED] writes: I have a trigger function written in C. ... Since the trigger is called after each row update the actual row data should be available in some way to the trigger

Re: [GENERAL] Question about accessing current row data inside trigger

Hello, I resolved this issue already. The trigger now works fine. I was looking at the wrong structure. Thanks, Peter Michael Fuhr wrote: On Tue, Mar 08, 2005 at 11:37:14AM -0800, peter Willis wrote: I have a trigger function written in C. The trigger function is called via: CREATE TRIGGER

[GENERAL] Question about accessing current row data inside trigger

Hello, I have a trigger function written in C. The trigger function is called via: CREATE TRIGGER after_update AFTER UPDATE ON some_table FOR EACH ROW EXECUTE PROCEDURE my_trigger_function(); Since the trigger is called after each row update the actual row data should be available in some

[GENERAL] How do I recover from pg_xlog/0000000000000000 (log file 0, segment 0) failed: No such file or directory

Hello, Is there a way to recover from the following error? I have (had) an existing database and wish not to lose the data tables. Thanks for any help, Pete [EMAIL PROTECTED] /]$ pg_ctl start postmaster successfully started [EMAIL PROTECTED] /]$ LOG: database system shutdown was interrupted at