On 14 Jun 2011, at 5:51, Vikram A wrote:
> Dear Mr. Craig Ringer,
> Thank you for your response.
> I would like to crypt certain sensitive information in my applications such
> as Student register number, their marks, results etc. For this reason i done
> a study for doing encryption. Where I f
Hi
I observed some strange behaviour when adding a primary key with ALTER TABLE:
Given CREATE TABLE mytable1 (id serial, name text);
I filled it with data then did a
CREATE TABLE mytable2 AS SELECT * FROM mytable1;
ALTER TABLE mytable2 ADD PRIMARY KEY(id);
The last command reports - as usual
On 06/14/2011 08:19 AM, Tom Lane wrote:
Sim Zacks writes:
All the suggestions given are for the server OS :-(
My purpose is to be able to return a correct file path to the client
without it specifying the OS.
File path? Seems to me that even if you knew the client OS, that'd
provide next to
Dear Ringer,
My application work in a LAN. It will not with across internet. Number users
also less than 25. Only certain information to be cipher. Also I do not want
such a complicated public and private key as PGP defines. As you said, I would
like to go for simple[Symmetric] method with our
Is it possible to execute system commands in dblink connections?
I need to execute \i /tmp/test.sh in a remote connection from my psql client
prompt.
I connected with the remote db using dblink_connect.
select dblink_connect('conn_1', 'dbname=newdb');
Any help please.
On 06/13/2011 07:04 AM, Sim Zacks wrote:
I didn't see a function for this, but is there a way in a postgresql
query to determine the client OS?
A PostgreSQL client application is something that speaks a correct
protocol to the server. The server has no concept of what the client is
other tha
On 14/06/11 11:51, Vikram A wrote:
> Dear Mr. Craig Ringer,
> Thank you for your response.
> I would like to crypt certain sensitive information in my applications
> such as Student register number, their marks, results etc. For this
> reason i done a study for doing encryption. Where I found that
Sim Zacks writes:
> All the suggestions given are for the server OS :-(
> My purpose is to be able to return a correct file path to the client
> without it specifying the OS.
File path? Seems to me that even if you knew the client OS, that'd
provide next to no information about the installation
All the suggestions given are for the server OS :-(
My purpose is to be able to return a correct file path to the client
without it specifying the OS.
Thanks
Sim
On 06/13/2011 05:38 PM, Craig Ringer wrote:
On 06/13/2011 08:35 PM, hubert depesz lubaczewski wrote:
Please note that it wil
Dear Mr. Craig Ringer,
Thank you for your response.
I would like to crypt certain sensitive information in my applications such as
Student register number, their marks, results etc. For this reason i done a
study for doing encryption. Where I found that this PGP will help
the encryption/decrypt
On 14/06/11 06:53, Nabil Ictech wrote:
>
> Hello,
>
> I installed PostgreSQL 8.3, Apache and phpPgAdmin, all in one.
> I had to unistall it, in order to install Open ERP. Open ERP has to work
> with its own PostgreSQL 8.3, but after unistalling your package, there
> seem to be something th
On 06/14/2011 05:15 AM, akp geek wrote:
Dear all -
While setting up streaming I ran into issue with libpq.
To resolve it I need to recompile the source. I am issuing the following
command . I tried this before with 9.0.2 it worked. Now when issued the
same command I was getting t
Hello,
I installed PostgreSQL 8.3, Apache and phpPgAdmin, all in one.
I had to unistall it, in order to install Open ERP. Open ERP has to work with its own PostgreSQL 8.3, but after unistalling your package, there seem to be something that remained in my computer, because the PostgreSQL 8.3 fr
On 06/13/11 3:07 PM, akp geek wrote:
I am doing the work on Solaris.
then you'll likely need to build ossp-uuid and reference it in your
./configure
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-gen
On Fri, Jun 10, 2011 at 9:58 PM, Josh Berkus wrote:
> It's not 10%. We use a fixed sample size, which is configurable on the
> system, table, or column basis.
>
It seems that you are referring to "alter column set statistics" and
"default_statistics_target", which are the number of percentiles
Sorry all -
I am doing the work on Solaris.
Regards
On Mon, Jun 13, 2011 at 5:38 PM, Scott Marlowe wrote:
> On Mon, Jun 13, 2011 at 3:15 PM, akp geek wrote:
> > Dear all -
> >While setting up streaming I ran into issue with libpq. To
> > resolve it I need to reco
On Mon, Jun 13, 2011 at 3:15 PM, akp geek wrote:
> Dear all -
> While setting up streaming I ran into issue with libpq. To
> resolve it I need to recompile the source. I am issuing the following
> command . I tried this before with 9.0.2 it worked. Now when issued the same
> command
Dear all -
While setting up streaming I ran into issue with libpq. To
resolve it I need to recompile the source. I am issuing the following
command . I tried this before with 9.0.2 it worked. Now when issued the same
command I was getting the errors.
./configure --prefix=/opt/post
Hi,
I took a patch that was available under 8.0.4 for Avahi zeroconfig and adpted
it to 9.0.3.
Though publication of the service type _postgresql._tcp is successful. When I
shutdown the
Postgres server the advertised service is not removed from mDNS and is visible
though not resolvable for a
Hi everyone,
I have a database that is UTF8, and a client that is connecting using
client encoding WIN1252. There are a few records in my database that
somehow have gotten characters in them that are not viewable. When
viewing the records from the command line using UTF8 client encoding
there
Hi!
I'm not sure how to write a good $subject for this , but here it goes;
I'd like to have a multi-column index on a varchar-field and a
tsvector-field. GIN only likes tsvector-fields so I'm wondering if it's
possible to create a tsvector from a text which doesn't breake the text
up in vectors, b
On Mon, Jun 13, 2011 at 18:48, Bruno Wolff III wrote:
> The link "Download 9.1 Beta 2 source code" on
> http://www.postgresql.org/developer/beta
> points to http://www.postgresql.org/ftp/source/v9.1beta1 instead of
> http://www.postgresql.org/ftp/source/v9.1beta2 .
Thanks - fixed, will be includ
The link "Download 9.1 Beta 2 source code" on
http://www.postgresql.org/developer/beta
points to http://www.postgresql.org/ftp/source/v9.1beta1 instead of
http://www.postgresql.org/ftp/source/v9.1beta2 .
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
we're having a similar situation, where FunctionA calls FunctionB inside a
cursor. FunctionB DROPs Temp table, then creates temp table. FunctionA runs
through the cursor fine but breaks after the last loop, unable to DROP
temporary table "because it is being used by active queries in this
session."
On Mon, Jun 13, 2011 at 8:35 AM, jonathansfl wrote:
> How would I create a dynamic table name, using the loop increment as a
> parameter?
>
> DROP TABLE IF EXISTS tt_PERSONSTODEACTIVATE || v_iteration CASCADE;
>
> that doesn't work. don't think i can use a dynamic variable as a table name,
> so i
How would I create a dynamic table name, using the loop increment as a
parameter?
DROP TABLE IF EXISTS tt_PERSONSTODEACTIVATE || v_iteration CASCADE;
that doesn't work. don't think i can use a dynamic variable as a table name,
so i can't build the table name as a variable. perhaps if the entire D
On 06/13/2011 08:35 PM, hubert depesz lubaczewski wrote:
Please note that it will return os for *server*, and not *client*.
Argh, thankyou. I misread the question. Please disregard my suggestion.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
akp geek writes:
> *ldd libpqwalreceiver.so*
> * libpq.so.4 =>/usr/lib/libpq.so.4*
Looks like you need to recompile, for starters. libpq.so.4 would be 8.1
or even older.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To ma
On Mon, Jun 13, 2011 at 1:58 AM, Craig Ringer
wrote:
> On 13/06/11 09:27, Merlin Moncure wrote:
>
>> want to use the binary protocol mode (especially for postgres versions
>> that don't support hex mode)
>
> Allowing myself to get a wee bit sidetracked:
>
> I've been wondering lately why hex was c
On Mon, Jun 13, 2011 at 12:31:57PM -, Greg Sabino Mullane wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: RIPEMD160
>
>
> > Yep, or you can use a PL/Python, PL/Perl or PL/Java function that makes
> > the appropriate calls in that language. Any of these will probably
> > require the u
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> Yep, or you can use a PL/Python, PL/Perl or PL/Java function that makes
> the appropriate calls in that language. Any of these will probably
> require the use of the "untrusted" (superuser-only) version.
Nope, you can do this easily in trus
On 06/13/2011 08:21 PM, Pavel Stehule wrote:
Hello
There is no special function.
you can parse some info from version() function.
Yep, or you can use a PL/Python, PL/Perl or PL/Java function that makes
the appropriate calls in that language. Any of these will probably
require the use of the
please explain, as I have no idea what that means. thank you for your reply!!
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Can-t-drop-temp-table-in-subfunction-during-cursor-loop-being-used-by-active-queries-tp4482806p4484134.html
Sent from the PostgreSQL - general mai
Hello
There is no special function.
you can parse some info from version() function.
Regards
Pavel Stehule
2011/6/13 Sim Zacks :
> I didn't see a function for this, but is there a way in a postgresql query
> to determine the client OS?
>
>
>
> Thanks
>
> Sim
>
>
>
> --
> Sent via pgsql-general
I didn't see a function for this, but is there a way in a postgresql
query to determine the client OS?
Thanks
Sim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thanks Tom .
When I did Is there any that I can run some commands to point it
to *libpq.so.5.
I have LD_LIBRARY_PATH =/opt/postgres/9.0.2/lib. still it is pointing to
** /usr/lib .. Any suggestions? *
*ldd libpqwalreceiver.so*
* libpq.so.4 =>/usr/lib/libpq.so.4*
*libgcc_s.so
On 13/06/11 05:59, Щепкин Александр wrote:
> Hello, I have a database with which I was running Windows XP (version of
> PostgreSQL 8.3). After reinstalling the system on Windows 7 I'm having
> problems, even though you are installing on the same postgresql 8.3. Is it
> possible to connect to the
On 13/06/11 09:27, Merlin Moncure wrote:
> want to use the binary protocol mode (especially for postgres versions
> that don't support hex mode)
Allowing myself to get a wee bit sidetracked:
I've been wondering lately why hex was chosen as the new input/output
format when the bytea_output change
38 matches
Mail list logo
