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
Postgres User wrote:
Hi,
I'd writing a query against a function (pg_proc) that contains 2
fields of an array type. Ideally, I'd like to select 1 row from the
table, but return a query row for each item in the array.
For example, if one row contains the array {"a", "b", "c"}
I'd like the query
---+---+--++-+--
-+---+-+---+---
(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
Hi
I have migrated a very large database from MSSQL to PG. This was a
database of +/- 400 tables. You should note the following.
- MSSQL datatypes are not always compatible with PG datatypes. If you do
this carefully PG will save you a lot of time.
- The "timestamp" datatype of MSSQL is not t
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
> AFAIK stopping the server, zipping data dir, and restarting
> the server creates a zip file which is not easily portable to
> other computers due to some ntfs file system permission problems.
>
IIRC you have to re-assign owner and change permissions after you copy your
data dir to the new serv
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
for AMD64)
>
> Can anyone explain this to me?
>
> TIA
>
> Joost
>
> ---(end of broadcast)---
> TIP 6: explain analyze is your friend
>
--
Regards,
Gevik Babakhani
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
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.
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 need administrative privileges to unre
Dear All,
Beside the documentation, which pg book would you recommend?
Which one is your personal favorite pg book?
Regards
Gevik.
Dear People,
After a long time of various timeouts, I managed to get back on track
developing the long promised PQDN website. As some of you might know. I was
working on a project called the PostgreSQL Developer Network.
The websites (which is a la MSDN) is meant to provide a knowl
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
27 matches
Mail list logo
