Hi Walid,
Well how are u connecting to the database?
What client interface are u using?
is it libpq?
What code are u using to connect to the database?
ECPG means embedded sql in C. You can write sql in ur C program using ECPG
On 8/11/06, Walid Haider <[EMAIL PROTECTED]> wrote:
Hi Jas,
Wh
Hi all,
I have just discovered that in postgres database
file the data are not encrypted. If I open with a text editor these files I can
read the records values.
I'd like to know if there is a way in order to
encrypt these data.
PS. for example in mysql the database file are not
reada
On Fri, Aug 11, 2006 at 09:47:49AM +0200, Stefano B. wrote:
> Hi all,
>
> I have just discovered that in postgres database file the data are
> not encrypted. If I open with a text editor these files I can read
> the records values.
>
> I'd like to know if there is a way in order to encrypt these
Junkone wrote:
CREATE TABLE "SYMBOL"
(
"SYMBOL_ID" int4 NOT NULL,
"SYMBOL2EXCHANGE" int2 NOT NULL,
"SYMBOL_ALIAS" text[],
"RELATED_SYMBOLS_OTHER_EXCHANGES" int8[],
"SYMBOL_NAME" text,
"COMPANY_NAME" text,
"SYMBOL2SECTOR" int2,
"SYMBOL2INDUSTRY" int4,
"STOCK_SUMMARY" text
)
I
On Thu, Aug 10, 2006 at 11:57:14AM -0400, Harpreet Dhaliwal wrote:
> This is a simple code snippet that i've written to check if i can connect to
> the postgres database server residing at IP 192.168.0.123. DB name is xyz
> Also, user account jsb has the access to the database xyz.
> --
Junkone wrote:
HI
I have a simple table created using PGAdmin III. How do i do a auto
numbering on a column SYMBOL_ID?
My table is
CREATE TABLE "SYMBOL"
(
"SYMBOL_ID" int4 NOT NULL,
"SYMBOL2EXCHANGE" int2 NOT NULL,
"SYMBOL_ALIAS" text[],
"RELATED_SYMBOLS_OTHER_EXCHANGES" int8[],
"SYMBOL
I'd like to truncate varchar field befor insert and update.
Any example of trigger to perform this action?
Thank you.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On Fri, Aug 11, 2006 at 11:58:16AM +0200, Michael Meskes wrote:
> > EXEC SQL CONNECT TO 'tcp:postgresql://192.168.0.123/xyz' USER jsb
>
> The correct syntax would be:
>
> EXEC SQL CONNECT TO tcp:postgresql://192.168.0.123/xyz USER jsb;
The ECPG "Connecting to the Database Server" documenta
Martha Stewart called it a Good Thing when kleptog@svana.org (Martijn van
Oosterhout) wrote:
> On Fri, Aug 11, 2006 at 09:47:49AM +0200, Stefano B. wrote:
>> Hi all,
>>
>> I have just discovered that in postgres database file the data are
>> not encrypted. If I open with a text editor these files
[EMAIL PROTECTED] wrote:
I'd like to truncate varchar field befor insert and update.
Any example of trigger to perform this action?
For something as simple as that a RULE using the trim(text) function
should work well. If that's what you're looking for.
--
Alban Hertroys
[EMAIL PROTECTED]
Hello,
I'm trying to solve a little issue: I wish to redirect my cron
jobs'output to log files. STDOUT redirection is done inside the crontab,
but VACUUM still yields its messages[1] through, onto STDERR, I guess.
I wouldn't like to '2>&1' also: I wish I could keep STDERR (what if an
error conditi
On Fri, Aug 11, 2006 at 08:52:32AM -0400, Christopher Browne wrote:
> >> I'd like to know if there is a way in order to encrypt these data.
> >
> > Sure, run postgres over an encrypted filesystem.
>
> Actually, that may not work the way you think it does...
>
> As long as the encrypted filesystem
Merlin,
The problem is disk. I've got a WD Caviar. hdparm says it does 44MB/sec
(I ran that in single user mode so there was nothing interfering). A WD
Caviar SE SATA in one of my servers at home gets 56MB/sec on a quiescent
system at runlevel 3. What kind of values does hdparm give for a SATA
On 8/11/06, Tom Laudeman <[EMAIL PROTECTED]> wrote:
Merlin,
The problem is disk. I've got a WD Caviar. hdparm says it does 44MB/sec
(I ran that in single user mode so there was nothing interfering). A WD
Caviar SE SATA in one of my servers at home gets 56MB/sec on a quiescent
system at runlevel 3
On Fri, 11 Aug 2006 15:49:56 +0200
Francis GUDIN <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I'm trying to solve a little issue: I wish to redirect my cron
> jobs'output to log files. STDOUT redirection is done inside the
> crontab, but VACUUM still yields its messages[1] through, onto
> STDERR, I gu
# [EMAIL PROTECTED] / 2006-08-11 10:12:40 -0400:
> I think my Dell Precision 650 has SATA on the motherboard. The boss says
> I can order one drive, so what should I get? How much faster is RAID 0+1
> than a single drive?
You need 4 disks for 0+1 (or 1+0, also called 10).
--
How many Viet
On Fri, 11 Aug 2006 08:05:44 -0700
John Purser <[EMAIL PROTECTED]> wrote:
> Take a look at the "tee" command that takes stdin and writes it to
> stdout AND a file. If I understand you correctly you DO want to keep
> stdout and stderr as two separate streams, write (at least) std err to
> a log fi
Chris wrote:
You need to install & setup tsearch2.
I have a small article about how to do that here:
http://www.designmagick.com/article/27/
Nice article, very clear and concise, however one small nit. At the end
of page I don't think you need the vacuum full, vacuum may or may not be
use
Chris wrote:
aBBISh wrote:
You need to install & setup tsearch2.
I have a small article about how to do that here:
http://www.designmagick.com/article/27/
Also on page 3 you say, "(normal indexes will only index the first 255
characters of a 'text' field)."
Is that true?
-
Am 2006-07-06 19:25:38, schrieb Ron Johnson:
> SQL was used 20 years ago, why not 20 years from now?
>
> I can't see needing data from 10 years ago, but you never know.
I have a Database (currently around 370 GByte of historical data,
exactly the last 14600 years, but most from the last 100 year
Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2006-08-11 10:12:40 -0400:
I think my Dell Precision 650 has SATA on the motherboard. The boss says
I can order one drive, so what should I get? How much faster is RAID 0+1
than a single drive?
If you can order one drive, get a drive that is twice
Hi, there is a feature that I would be glad if it was supported by
PostgreSQL:
I want to add a new column (attribute) to a pre-existed table, but instead
of filling the values of this column with a default value (e.g. null) I
would like to copy them from a file stored in my filesystem.
I didn't
Hello *,
I am searching for a weired error... Since all users are working fine,
I was now root and done a 'su - postgresql' to create a new user with
createuser --password devel.debian
Shall the new user be allowed to create databases? (y/n) n
Shall the new user be allowed to create more new use
On Fri, Aug 11, 2006 at 06:10:48PM +0200, Francis GUDIN wrote:
> On Fri, 11 Aug 2006 08:05:44 -0700
> John Purser <[EMAIL PROTECTED]> wrote:
>
> > Take a look at the "tee" command that takes stdin and writes it to
> > stdout AND a file. If I understand you correctly you DO want to keep
> > stdout
On Fri, Aug 11, 2006 at 07:35:29PM +0300, Ioannis Theoharis wrote:
>
>
> Hi, there is a feature that I would be glad if it was supported by
> PostgreSQL:
>
> I want to add a new column (attribute) to a pre-existed table, but instead
> of filling the values of this column with a default value (e.
Matthew T. O'Connor wrote:
Chris wrote:
aBBISh wrote:
You need to install & setup tsearch2.
I have a small article about how to do that here:
http://www.designmagick.com/article/27/
Also on page 3 you say, "(normal indexes will only index the first 255
characters of a 'text' field)."
Is t
kleptog@svana.org (Martijn van Oosterhout) writes:
> On Fri, Aug 11, 2006 at 08:52:32AM -0400, Christopher Browne wrote:
>> >> I'd like to know if there is a way in order to encrypt these data.
>> >
>> > Sure, run postgres over an encrypted filesystem.
>>
>> Actually, that may not work the way you
On Fri, Aug 11, 2006 at 07:01:55AM -0600, Michael Fuhr wrote:
> The ECPG "Connecting to the Database Server" documentation does
> have an example for Unix sockets with quotes:
>
> EXEC SQL CONNECT TO 'unix:postgresql://sql.mydomain.com/mydb' AS
> myconnection USER john;
>
> Should that be chang
Joshua D. Drake wrote:
> Matthew T. O'Connor wrote:
> >Chris wrote:
> >>aBBISh wrote:
> >>You need to install & setup tsearch2.
> >>
> >>I have a small article about how to do that here:
> >>
> >>http://www.designmagick.com/article/27/
> >
> >Also on page 3 you say, "(normal indexes will only index
Hi all
there any way to isolate the transaction log for some
tables?
the temporary tables generate transaction's log's i
want to islotate this , for backups propouses, any
sugestion are welcomed.
best regards
MDC
__
LOl..that ';' is quite obvious. Though i forgot to include that in the mail.
Sorry about that.
Also, do u think that while starting the postgresql server using 'pg_ctl start', there is some -i option that needs to be included with it so that the DB server accepts tcp connections?
One of the guys in
Harpreet Dhaliwal wrote:
> LOl..that ';' is quite obvious. Though i forgot to include that in the mail.
> Sorry about that.
> Also, do u think that while starting the postgresql server using 'pg_ctl
> start', there is some -i option that needs to be included with it so that
> the DB server accepts
On Fri, Aug 11, 2006 at 06:09:16PM +0200, Michael Meskes wrote:
> On Fri, Aug 11, 2006 at 07:01:55AM -0600, Michael Fuhr wrote:
> > The ECPG "Connecting to the Database Server" documentation does
> > have an example for Unix sockets with quotes:
> >
> > EXEC SQL CONNECT TO 'unix:postgresql://sql.
Hi!
I was trying to solve a problem on an old system and realized that there might
be some better approach for doing what I need.
We have some documents that need to be ordered sequentially and without gaps.
I could use a sequence, but if the transaction fails then when I rollback the
sequence
Folks,
I'm looking for user experiences with Jasper Reports with PostgreSQL
so I can give $client the low-down on this system, especially in
comparison to Business Objects. Please let me know if you're using it
or have assessed it in some systematic way.
Cheers,
D
--
David Fetter <[EMAIL PROTEC
35 matches
Mail list logo
