I was wondering if there are any schema manipulation statements which
are not allowed from within a PL/PGSQL function. (Except from
create/drop a database)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpre
d1 from convert_to_query('a,c,b,d,e,f') as
result(field1 varchar);
---
--
Regards,
Gevik
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
---+---+--++-+--
-+---+-+---+---
(0 rows)
Gevik Babakhani wrote:
How do you call this function from your code?
Does it work when you call it from PGAdmin?
select * from
How do you call this function from your code?
Does it work when you call it from PGAdmin?
select * from cerber.cerber_account_select (1);
Michal Szymanski wrote:
Hi,
We call DB procedure that select rows with given ID it works as simple
SELECT but for future changes we implement as DB procedu
I had to write a little application for migrating data. because I had
to check and modify data before I inserted them into PG. Perhaps you can
export the data to CSV and then import it in PG using the COPY command.
I hope this helps,
Regards,
Gevik.
Eugene . wrote:
Hi all,
I've been tasked
IIRC, you cannot state runservice runservice -N "." from commandline.
just try pg_ctl -D
_
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of George Younan
Sent: Wednesday, February 27, 2008 10:08 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Can't start Pos
r to the new server.
Regards,
Gevik
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
I did not follow the past threads, but have you looked at what the event
viewer has to report?
_
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dee
Sent: Thursday, February 21, 2008 8:36 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Install problem w/8.3 on w
the text column into a buffer/string Base64 decode to get your
original image/binary data.
The approach above worked for us. This was a PHP5 website and C# frontend.
Regards,
Gevik Babakhani
PostgreSQL NL http://www.postgresql.nl
TrueSoftware
Hi,
Which programming language are you using?
Regards,
Gevik Babakhani
PostgreSQL NL http://www.postgresql.nl
TrueSoftware BV http://www.truesoftware.nl
> -Original Mess
> >
> > Is there an existing Postgres group?
>
> Yes.
Humm.. It never hurts to be more popular on the net.
Regards,
Gevik Babakhani
PostgreSQL NL http://www.postgresql.nl
TrueSoftware BV http://w
Check out the docs for pg_dump utility.
http://www.postgresql.org/docs/8.3/static/app-pgdump.html
_
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of User Map
Sent: Friday, January 25, 2008 10:18 AM
To: pgsql
Subject: [GENERAL] exporting postgre data
is it posible to trans
Dear all,
I have created a group for PostgreSQL professionals at LinkedIn.com
Feel free to join if you like.
http://www.linkedin.com/e/gis/51776/760A11717C03
Regards,
Gevik Babakhani
PostgreSQL NL http://www.postgresql.nl
TrueSoftware BV
nager for
example apt-get or yum
Regards,
Gevik Babakhani
PostgreSQL NL http://www.postgresql.nl <http://www.postgresql.nl/>
TrueSoftware BV http://www.truesoftware.nl <http://www.t
Hi Joost. (hoe gaat het ermee?)
I would like to test this too. Could you please provide the data you are
inserting into the database.
Regards,
Gevik
On Wed, 2006-09-27 at 13:13 +0200, Joost Kraaijeveld wrote:
> Hi,
>
> I have a strange problem.
>
> I have 2 database, bo
could create a function that:
step1: creates a sequence (with random name)
step2: update table set field=netval('random_seq_name');
step3: drop sequence...
--
Regards,
Gevik Babakhani
---(end of broadcast)---
TIP 9: In versions b
equence as a primary key, you
should be aware that you will destroy the integrity of you data.
--
Regards,
Gevik Babakhani
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
esolve.
>
> Bob
>
> - Original Message -
> From: "Gevik Babakhani" <[EMAIL PROTECTED]>
> To: "Bob Pawley" <[EMAIL PROTECTED]>
> Cc: "Postgresql"
> Sent: Sunday, September 24, 2006 2:00 PM
> Subject: Re: [GENERAL] ser
bl
(
id SERIAL primary key
);
--
Regards,
Gevik Babakhani
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Hello Folks,
I would like to know if deleting functions from pg_catalog.pg_proc with
the following SQL statement is advisable?
I would like a way of deleting my functions without using the DROP
FUNCTION statement.
--
delete from pg_
yes you can. Read the license :)
> Hi,sorry for my English.
> I would like to know if i can use PostgreSql for my commercial software.
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
>http://www.postgresql.
check
http://archives.postgresql.org/pgsql-novice/2005-02/msg00227.php
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Thank you :)
> -Original Message-
> From: Magnus Hagander [mailto:[EMAIL PROTECTED]
> Sent: Saturday, January 14, 2006 6:16 PM
> To: Gevik
> Cc: pgsql-general@postgresql.org
> Subject: RE: [GENERAL] Unregister Windows Service pg_ctl error
>
> > > You nee
Could anyone Recommend a nice IDE for debugging and developing code for PG
on Linux or Windows.
Thanx.
---(end of broadcast)---
TIP 6: explain analyze is your friend
> You need administrative privileges to unregister a service. Can't run it
> as user postgres.
I did the same under "Administrator" but then I get an access violation
error like:
Unhandled exception at 0x77c478c0 in pg_ctl.exe: 0xC005: Access
violation reading location 0x.
What am I
When I try to unregister the windows service I get an error like:
C:\Program Files\PostgreSQL\8.1\bin>pg_ctl.exe unregister -N "pgsql-8.1"
pg_ctl: could not open service manager
This is on Windows XP and the logged user is postgres
---(end of broadcast)---
Perhaps this is not a postgresql solution, but you could;
1. first design a common data structure in postgresql.
2. then convert each type of the tab-delimited file to a basic xml
structures.
3. map the structures to the common data structure using xslt.
I hope this helps,
> This might be a bit
Dear All,
Beside the documentation, which pg book would you recommend?
Which one is your personal favorite pg book?
Regards
Gevik.
PostgreSQL 8.0.3
Please do not hesitate to share your ideas.
Kind regards,
Gevik
Yes actualy.. This is also going to be one of the items on our future FAQ
database.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Joachim Zobel
Sent: Tuesday, December 07, 2004 11:34 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] Reusable database design
We are working on a PostgresSQL KB. Soon we are going to move the FAQ and
Information as such to the KB
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alec Swan
Sent: Friday, December 03, 2004 7:02 PM
To: Tom Lane
Cc: [EMAIL PROTECTED]
Subject: Re: [G
Checkout http://www.pgadmin.org
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of Nageshwar Rao
Sent: Monday, November 29, 2004
10:20 AM
To: [EMAIL PROTECTED]
Subject: [GENERAL] tool for
postgresql
Hi,
Any tool available for Postgresql for admin activities li
32 matches
Mail list logo
