DBD::PG - any works to be compatile with 7.3 ?

Started by Oleg Bartunovover 23 years ago9 messages
#1Oleg Bartunov
oleg@sai.msu.su

Any news about new DBD::Pg ?
It's a stopper for many projects based on perl interface
to use 7.3.

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

#2Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Oleg Bartunov (#1)
Re: DBD::PG - any works to be compatile with 7.3 ?

Oleg Bartunov wrote:

Any news about new DBD::Pg ?
It's a stopper for many projects based on perl interface
to use 7.3.

I have created a gborg project for DBD::Pg and four people have
subscribed. I will work with them to improve the driver.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
#3Oleg Bartunov
oleg@sai.msu.su
In reply to: Bruce Momjian (#2)
Re: DBD::PG - any works to be compatile with 7.3 ?

On Sat, 19 Oct 2002, Bruce Momjian wrote:

Oleg Bartunov wrote:

Any news about new DBD::Pg ?
It's a stopper for many projects based on perl interface
to use 7.3.

I have created a gborg project for DBD::Pg and four people have
subscribed. I will work with them to improve the driver.

Does this means you've taken a full responsibillity for DBD::Pg ?
What's about CPAN where people used to find DBD::Pg ?

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

#4Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Oleg Bartunov (#3)
Re: DBD::PG - any works to be compatile with 7.3 ?

Oleg Bartunov wrote:

On Sat, 19 Oct 2002, Bruce Momjian wrote:

Oleg Bartunov wrote:

Any news about new DBD::Pg ?
It's a stopper for many projects based on perl interface
to use 7.3.

I have created a gborg project for DBD::Pg and four people have
subscribed. I will work with them to improve the driver.

Does this means you've taken a full responsibillity for DBD::Pg ?
What's about CPAN where people used to find DBD::Pg ?

CPAN will be updated by David Wheeler, already a member of the gborg
DBD:pg group. He has already been assigned CPAN ownership from the
previous maintainer.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
#5Oleg Bartunov
oleg@sai.msu.su
In reply to: Bruce Momjian (#4)
Re: DBD::PG - any works to be compatile with 7.3 ?

On Sun, 20 Oct 2002, Bruce Momjian wrote:

Oleg Bartunov wrote:

On Sat, 19 Oct 2002, Bruce Momjian wrote:

Oleg Bartunov wrote:

Any news about new DBD::Pg ?
It's a stopper for many projects based on perl interface
to use 7.3.

I have created a gborg project for DBD::Pg and four people have
subscribed. I will work with them to improve the driver.

Does this means you've taken a full responsibillity for DBD::Pg ?
What's about CPAN where people used to find DBD::Pg ?

CPAN will be updated by David Wheeler, already a member of the gborg
DBD:pg group. He has already been assigned CPAN ownership from the
previous maintainer.

Good. I was afraid about diverging of development. Now, I have an issue for
the driver - support of user defined types. We already have looked into sources
and think it's doable.

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

#6Ryan Mahoney
ryan@paymentalliance.net
In reply to: Oleg Bartunov (#5)
integer array, push and pop

Hi Oleg (and pgsql hackers!),

Recently I encountered a problem attempting to use the integer array
function for pushing an integer onto an integer array field.

Can you write an example of a sql statement for pushing a single value onto
an integer array and for popping a specific value off of an integer array?
I see the function in the documentation, but the actual statement syntax to
use is not clear to me.

Thanks for any help you can provide!

Ryan Mahoney

#7Teodor Sigaev
teodor@stack.net
In reply to: Oleg Bartunov (#5)
Re: integer array, push and pop

regression=# select '{124,567,66}'::int[] + 345;
?column?
------------------
{124,567,66,345}
(1 row)
regression=# select '{124,567,66}'::int[] + '{345,1}'::int[];
?column?
--------------------
{124,567,66,345,1}
(1 row)
select '{124,567,66}'::int[] - 567;
?column?
----------
{124,66}
(1 row)
regression=# select '{124,567,66}'::int[] - '{567,66}';
?column?
----------
{124}
(1 row)

Ryan Mahoney wrote:

Hi Oleg (and pgsql hackers!),

Recently I encountered a problem attempting to use the integer array
function for pushing an integer onto an integer array field.

Can you write an example of a sql statement for pushing a single value onto
an integer array and for popping a specific value off of an integer array?
I see the function in the documentation, but the actual statement syntax to
use is not clear to me.

Thanks for any help you can provide!

Ryan Mahoney

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

--
Teodor Sigaev
teodor@stack.net

#8Ryan Mahoney
ryan@paymentalliance.net
In reply to: Teodor Sigaev (#7)
Re: integer array, push and pop

This is excellent! Thanks so much!

-r

Show quoted text

On Tue, 2002-10-22 at 04:07, Teodor Sigaev wrote:

regression=# select '{124,567,66}'::int[] + 345;
?column?
------------------
{124,567,66,345}
(1 row)
regression=# select '{124,567,66}'::int[] + '{345,1}'::int[];
?column?
--------------------
{124,567,66,345,1}
(1 row)
select '{124,567,66}'::int[] - 567;
?column?
----------
{124,66}
(1 row)
regression=# select '{124,567,66}'::int[] - '{567,66}';
?column?
----------
{124}
(1 row)

Ryan Mahoney wrote:

Hi Oleg (and pgsql hackers!),

Recently I encountered a problem attempting to use the integer array
function for pushing an integer onto an integer array field.

Can you write an example of a sql statement for pushing a single value onto
an integer array and for popping a specific value off of an integer array?
I see the function in the documentation, but the actual statement syntax to
use is not clear to me.

Thanks for any help you can provide!

Ryan Mahoney

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

--
Teodor Sigaev
teodor@stack.net

#9Ryan Mahoney
ryan@paymentalliance.net
In reply to: Teodor Sigaev (#7)
Re: integer array, push and pop

What version of postgres are you using? I am using PostgreSQL 7.3b1 on
i686-pc-linux-gnu, compiled by GCC 2.96 and when I execute the following
statement:

select '{124,567,66}'::int[] + 345;

I get the error:

ERROR: cache lookup failed for type 0

Any ideas?

Thanks for your help!

-r