Re: [pgadmin-support] automatic numbering in a new column

2011-08-24 Thread Guillaume Lelarge
A few comments before answering: 1. Don't top post. It makes it hard to read. 2. Reply to the list. 3. Choose your list more carefully. pgadmin-support is about pgAdmin support, not about SQL. This being said, I'll quickly answer your question... On Wed, 2011-08-24 at 19:47 +0100, pp...@sapo.p

Re: [pgadmin-support] automatic numbering in a new column

2011-08-24 Thread Guillaume Lelarge
On Wed, 2011-08-24 at 19:40 +0100, pp...@sapo.pt wrote: [...] > > I'm have a database with two tables, one of them is the streets. Can > anybody tell me how do i create, with a sql instruction, a new column > with automatic numbering in this table? Use the serial pseudo type for this column.

[pgadmin-support] automatic numbering in a new column

2011-08-24 Thread ppdcc
Hello to all, I'm have a database with two tables, one of them is the streets. Can anybody tell me how do i create, with a sql instruction, a new column with automatic numbering in this table? This column don?t have to be the primary key but has to be unique for each feature. can anybo

Re: [pgadmin-support] Views->Create Script + Regular Expressions

2011-08-24 Thread Richard Broersma
On Wed, Aug 24, 2011 at 8:28 AM, Guillaume Lelarge wrote: > There's not much we can do about this. The SELECT part is retrieved via > a call to pg_getviewdef. So, if you want to call this a bug, this is a > PostgreSQL bug (and I don't think this is). I agree that its probably not a bug, but it i

Re: [pgadmin-support] Views->Create Script + Regular Expressions

2011-08-24 Thread Michael Shapiro
I ran into this warning when we switched from one version of Postgres to another. It complains when the view is created, but it works fine when I select from it. But I don't mix E' and \\ My views have strings like '\\.[0-9]+\\.' Your view has both E' and \\ -- could it be that if you have E' y

Re: [pgadmin-support] Views->Create Script + Regular Expressions

2011-08-24 Thread Guillaume Lelarge
On Wed, 2011-08-24 at 08:04 -0700, Richard Broersma wrote: > On Tue, Aug 23, 2011 at 11:18 PM, Guillaume Lelarge > wrote: > > It would be great if you could provide us a complete example. > > Here is a sample view. > > --* > CREATE VIEW TestView AS select cmpnt_name, regexp_matches(c

Re: [pgadmin-support] Views->Create Script + Regular Expressions

2011-08-24 Thread Richard Broersma
On Tue, Aug 23, 2011 at 11:18 PM, Guillaume Lelarge wrote: > It would be great if you could provide us a complete example. Here is a sample view. --* CREATE VIEW TestView AS select cmpnt_name, regexp_matches(cmpnt_name, E'(^\\d{1,2})-([A-Z]+) *- ?(\\d{3,4})-?([A-Z]*)?') from compone

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Giuseppe Sacco
Il giorno mer, 24/08/2011 alle 16.00 +0530, Ashesh Vashi ha scritto: > Giuseppe, > What is the output of 'ldd /usr/lib/i686/cmov/libcrypto.so.1.0.0'? $ ldd /usr/lib/i686/cmov/libcrypto.so.1.0.0 linux-gate.so.1 => (0xb772) libdl.so.2 => /lib/i386-linux-gnu/i686/cmov/libdl.so.2

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Giuseppe Sacco
Il giorno mer, 24/08/2011 alle 11.24 +0100, Dave Page ha scritto: > On Wed, Aug 24, 2011 at 11:18 AM, Giuseppe Sacco [...] > >liblber-2.4.so.2 => /usr/lib/i386-linux-gnu/liblber-2.4.so.2 > > (0xb729) > >libsasl2.so.2 => /usr/lib/i386-linux-gnu/libsasl2.so.2 (0xb7274000) > >

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Ashesh Vashi
Giuseppe, What is the output of 'ldd /usr/lib/i686/cmov/libcrypto.so.1.0.0'? -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company *http://www.linkedin.com/in/asheshvashi* On Wed, Aug 24, 20

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Dave Page
On Wed, Aug 24, 2011 at 11:18 AM, Giuseppe Sacco wrote: > Il giorno mer, 24/08/2011 alle 11.00 +0100, Dave Page ha scritto: >> On Wed, Aug 24, 2011 at 10:40 AM, Giuseppe Sacco > [...] >> > configure:5403: checking for SSL_library_init in -lssl >> > configure:5428: gcc -o conftest -g -O2   conftest

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Giuseppe Sacco
Il giorno mer, 24/08/2011 alle 12.15 +0200, Guillaume Lelarge ha scritto: [...] > And ldd on libssl gives me this: > root@debian:~# ldd /usr/lib/libssl.so.1.0.0 > linux-vdso.so.1 => (0x7fffcf3ff000) > libcrypto.so.1.0.0 => /usr/lib/libcrypto.so.1.0.0 (0x7ffccd12a000) > li

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Giuseppe Sacco
Il giorno mer, 24/08/2011 alle 11.00 +0100, Dave Page ha scritto: > On Wed, Aug 24, 2011 at 10:40 AM, Giuseppe Sacco [...] > > configure:5403: checking for SSL_library_init in -lssl > > configure:5428: gcc -o conftest -g -O2 conftest.c -lssl >&5 > > /usr/lib/libssl.so: undefined reference to `B

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Guillaume Lelarge
On Wed, 2011-08-24 at 11:00 +0100, Dave Page wrote: > On Wed, Aug 24, 2011 at 10:40 AM, Giuseppe Sacco > wrote: > > Il giorno mer, 24/08/2011 alle 10.04 +0100, Dave Page ha scritto: > >> On Wed, Aug 24, 2011 at 9:54 AM, Giuseppe Sacco > > [...] > >> > Config log show something about ssl: it seems

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Guillaume Lelarge
On Wed, 2011-08-24 at 10:19 +0200, Giuseppe Sacco wrote: > Hi Guillaume, > thanks for spending your time on this topic. I was really missing both > packages postgresql-server-dev-{8.4,9.0}, but even after installing > them, I still get the same error: > > $ ./configure --prefix=/usr/local/pgadmin3

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Dave Page
On Wed, Aug 24, 2011 at 10:40 AM, Giuseppe Sacco wrote: > Il giorno mer, 24/08/2011 alle 10.04 +0100, Dave Page ha scritto: >> On Wed, Aug 24, 2011 at 9:54 AM, Giuseppe Sacco > [...] >> > Config log show something about ssl: it seems libpq is detected but not >> > usable since configure cannot com

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Giuseppe Sacco
Il giorno mer, 24/08/2011 alle 10.04 +0100, Dave Page ha scritto: > On Wed, Aug 24, 2011 at 9:54 AM, Giuseppe Sacco [...] > > Config log show something about ssl: it seems libpq is detected but not > > usable since configure cannot compile with it. libpq require ssl, and I > > have openssl 1.0.0d i

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Dave Page
On Wed, Aug 24, 2011 at 9:54 AM, Giuseppe Sacco wrote: > Il giorno mer, 24/08/2011 alle 09.26 +0100, Dave Page ha scritto: > [...] >> > I did not have much time for finding a solution. I will try to work it >> > out today or tomorrow. >> >> There are almost certainly some clues in config.log... >

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Giuseppe Sacco
Il giorno mer, 24/08/2011 alle 09.26 +0100, Dave Page ha scritto: [...] > > I did not have much time for finding a solution. I will try to work it > > out today or tomorrow. > > There are almost certainly some clues in config.log... Config log show something about ssl: it seems libpq is detected

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Dave Page
On Wed, Aug 24, 2011 at 9:19 AM, Giuseppe Sacco wrote: > Hi Guillaume, > thanks for spending your time on this topic. I was really missing both > packages postgresql-server-dev-{8.4,9.0}, but even after installing > them, I still get the same error: ... > I read that you tried on debian 6, while

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Giuseppe Sacco
Hi Guillaume, thanks for spending your time on this topic. I was really missing both packages postgresql-server-dev-{8.4,9.0}, but even after installing them, I still get the same error: $ ./configure --prefix=/usr/local/pgadmin3-1.14 checking build system type... i686-pc-linux-gnu checking host s

Re: [pgadmin-support] compiling on debian does not find a valid PostgreSQL 8.4+ installati

2011-08-24 Thread Guillaume Lelarge
On Tue, 2011-08-16 at 11:58 +0200, Giuseppe Sacco wrote: > Il giorno mar, 16/08/2011 alle 09.32 +0200, Guillaume Lelarge ha > scritto: > > On Tue, 2011-08-16 at 09:14 +0200, Giuseppe Sacco wrote: > > > Il giorno mar, 16/08/2011 alle 09.09 +0200, Guillaume Lelarge ha > > > scritto: > > > > On Tue, 2