Re: [GENERAL] psql's \d display of unique index vs. constraint

2010-04-11 Thread Peter Eisentraut
On fre, 2010-04-09 at 18:01 -0400, Josh Kupershmidt wrote: > I often come across tables with either a unique index or a unique > constraint on them, and psql isn't helpful at showing the difference > between the two. Normally, I don't care which is which, except for > when I have to manually drop a

Re: [GENERAL] Unable to uninstall postgres from Add/Remove programs

2010-04-11 Thread Jeffrey Ottery
On Apr 9, 12:47 pm, cr...@postnewspapers.com.au (Craig Ringer) wrote: > On 8/04/2010 2:01 PM, JeffreyOtterywrote: > > > Running Windows XP Pro. Have been successfully using and deploying > > postgres for 2 years. > > > When I try to Uninstall PostgreSQL 8.3 using Windows Add/Remove > > Programs I g

[GENERAL] Displaying the output of a query over a web interface.

2010-04-11 Thread ckarthic
Hi all, I imported a table into pgAdmin II and I'm able to query the table for information using the SQL editor in the pgAdmin II i.e. I used queries like 'select * from table_name; likewise'. The executed queries are shown in the output pane of the SQL editor. Now all I want is to show the same

[GENERAL] Creating a read/write virtual table?

2010-04-11 Thread Ben Martin
Hi, I'm the author of the libferris virtual filesystem. Last year I created the ability to expose a ferris filesystem as a virtual table in SQLite [1] and would like to do much the same for PostgreSQL if possible. I was digging into where to get the whole libferris-as-vtable thing to happen wi

Re: [GENERAL] Creating a read/write virtual table?

2010-04-11 Thread Craig Ringer
On 12/04/10 11:34, Ben Martin wrote: In my SQLite vtable both of the above restrictions don't apply. To mitigate (1) I was hopeful that there was a way to get the connection to PG on the server to fork/setuid The pg backends are designed to run as one user. You might have issues setting it